The data reader returned by the store data provider does not have enough columns for the query requested.
Line 1553: }
Line 1554:
Line 1555: return base.ExecuteFunction<Nullable<global::System.Int32>>("SalaryMonthly", employeeIdParameter);
Line 1556: }
Line 1557:
my store procedere
ALTER PROCEDURE [dbo].[SalaryMonthly]
@EmployeeId int
AS
declare @i int,@presentday int,@OneDaySalary int, @totalDay int,@NetSalary int,@Month int,@year int
set @totalDay=(select datediff(day, GETDATE(), dateadd(month, 1, GETDATE())))
set @presentday =(select PresentDay from TblAttendeceMonthly where EmployeeId=@EmployeeId)
set @OneDaySalary =(select salary from TblSalary where EmploeeId=@EmployeeId)/@totalDay
set @NetSalary=@presentday * @OneDaySalary
set @Month=(SELECT DATEPART(MM, GETDATE()))
set @year=(SELECT DATEPART(YY, GETDATE()))
BEGIN
if @presentday is not null
begin
insert into TblSalaryMonthly values (@EmployeeId,@NetSalary,@Month,@year,@presentday,1,0,GETDATE(),null )
end
end
exec SalaryMonthly 41