PROC [dbo].[Sp_DATA1] ( @schemecode nvarchar(10), @month nvarchar(10) ) AS BEGIN DECLARE @totalnoofemployees int , . . . . . . . Savings int, remarks nvarchar(500) ) select @totalnoofemployees=count(employeedetails.name_of_employee) from employeedetails where schemecode=schemecode and month=@month select . . . . . select @remark =remark from saving_details where schemecode=@schemecode and month=@month insert into @tab([Number_of_employees], . . . . , Other_saving_due_to_process_improvement,savings,remarks) values (@totalnoofemployees, . . . . @savingamount , @remark ) SELECT * from @tab END
public class EmployeesController : ApiController { public IEnumerable<beneficiarydetail> Get([ModelBinder]List<int> id) { emp_misEntities entities = new emp_misEntities(); return entities.beneficiarydetails.ToList(); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)