public string SaveAllowanceByDesGroup(Payroll_AllowanceByDesGroup objAllowanceByDesGroup)
{
string rv = "";
try
{
Insert_Update_AllowanceByDesGroup("sp_Insert_AllowanceByDesGroup", "saveAllowanceByDesGroupinfo", objAllowanceByDesGroup);
rv = Operation.Success.ToString();
}
catch (Exception ex)
{
rv = ex.Message;
}
return(rv);
}
public DataTable Insert_Update_AllowanceByDesGroup(string procedure, string callname, Payroll_AllowanceByDesGroup objAllowanceByDesGroup)
{
dbConn = new SqlConnection(ConnectionString);
dbConn.Open();
cmd = new SqlCommand(procedure, dbConn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@call_name", callname));
cmd.Parameters.Add(new SqlParameter("@p_AllowanceByDesGroupID", objAllowanceByDesGroup.AllowanceByDesGroupID));
cmd.Parameters.Add(new SqlParameter("@p_DesGroupID", objAllowanceByDesGroup.DesGroupID));
cmd.Parameters.Add(new SqlParameter("@p_LunchPayRate", objAllowanceByDesGroup.LunchPayRate));
cmd.Parameters.Add(new SqlParameter("@p_TiffinPayRate", objAllowanceByDesGroup.TiffinPayRate));
cmd.Parameters.Add(new SqlParameter("@p_IftarPayRate", objAllowanceByDesGroup.IftarPayRate));
cmd.Parameters.Add(new SqlParameter("@p_NightPayRate", objAllowanceByDesGroup.NightPayRate));
cmd.Parameters.Add(new SqlParameter("@p_HolidayPayRate", objAllowanceByDesGroup.HolidayPayRate));
cmd.Parameters.Add(new SqlParameter("@p_EffectDate", objAllowanceByDesGroup.EffectDate));
da = new SqlDataAdapter(cmd);
dt = new DataTable();
da.Fill(dt);
dbConn.Close();
return(dt);
}
public string SaveAllowanceByDesGroup(Payroll_AllowanceByDesGroup objAllowanceByDesGroup)
{
return(_AllowanceByDesGroupDataService.SaveAllowanceByDesGroup(objAllowanceByDesGroup));
}
