public int InsertEmployeeLeave(HRM_LEAVE_EMPLOYEE obj)
{
int result = 0;
using (var _context = new ERPSSLHBEntities())
{
var PRM_EMP_ID = new SqlParameter("EMP_ID", obj.EMP_ID);
var PRM_EID = new SqlParameter("EID", obj.EID);
var PRM_LEV_TYPE_ID = new SqlParameter("LEV_TYPE_ID", obj.LEV_TYPE_ID);
var PRM_TOTAL_LEV_DAYS = new SqlParameter("TOTAL_LEV_DAYS", obj.TOTAL_LEV_DAYS);
var PRM_REMARKS = new SqlParameter("REMARKS", obj.REMARKS);
var PRM_EDIT_USER = new SqlParameter("EDIT_USER", obj.EDIT_USER);
var PRM_EDIT_DATE = new SqlParameter("EDIT_DATE", obj.EDIT_DATE);
var PRM_OCODE = new SqlParameter("OCODE", obj.OCODE);
string SP_SQL = "ENTER_EMPLOYEE_LEAVE @EMP_ID,@EID,@LEV_TYPE_ID,@TOTAL_LEV_DAYS,@REMARKS,@EDIT_USER,@EDIT_DATE,@OCODE";
//int return_value = _context.ExecuteStoreQuery<int>(SP_SQL, PRM_EMP_ID, PRM_EID, PRM_LEV_TYPE_ID, PRM_TOTAL_LEV_DAYS, PRM_REMARKS, PRM_EDIT_USER, PRM_EDIT_DATE, PRM_OCODE);
int return_value = _context.ExecuteStoreQuery <int>(SP_SQL, PRM_EMP_ID, PRM_EID, PRM_LEV_TYPE_ID, PRM_TOTAL_LEV_DAYS, PRM_REMARKS, PRM_EDIT_USER, PRM_EDIT_DATE, PRM_OCODE).FirstOrDefault();
if (return_value == 1)
{
result = 1;
}
else if (return_value == 2)
{
result = 2;
}
else
{
result = 0;
}
return(result);
}
}
public int InsertEmployeeLeave(HRM_LEAVE_EMPLOYEE obj)
{
return(objCtx_DAL.InsertEmployeeLeave(obj));
}
