public DataSet GetSalaryComponents(BE_Salary_Components_Master ObjBE_Salary_Components_Master) { SqlHelper objSqlHelper = new SqlHelper("TLPayrollConfig"); objSqlHelper.ClearParameters(); return(objSqlHelper.ExecuteQuery("SP_GET_SALARY_COMPONENTS")); }
public DataSet SalaryComponents_Insert(BE_Salary_Components_Master ObjBE_Salary_Components_Master) { SqlHelper objSqlHelper = new SqlHelper("TLPayrollConfig"); objSqlHelper.ClearParameters(); objSqlHelper.CreateInParameter("@CM_NAME", ObjBE_Salary_Components_Master.CM_NAME); objSqlHelper.CreateInParameter("@CM_DESCRIPTION", ObjBE_Salary_Components_Master.CM_DESC); objSqlHelper.CreateInParameter("@CM_TYPE", ObjBE_Salary_Components_Master.CM_TYPE); objSqlHelper.CreateInParameter("@CM_VALUE_TYPE", ObjBE_Salary_Components_Master.CM_VALUE_TYPE); objSqlHelper.CreateInParameter("@CM_APPLICABLE", ObjBE_Salary_Components_Master.CM_APPLICABLE); objSqlHelper.CreateInParameter("@CM_FC", ObjBE_Salary_Components_Master.CM_FC); objSqlHelper.CreateInParameter("@CM_CF_COMP", ObjBE_Salary_Components_Master.CM_CF_COMP); objSqlHelper.CreateInParameter("@CM_PRORATED_CO", ObjBE_Salary_Components_Master.CM_PRORATED_COMP); objSqlHelper.CreateInParameter("@CM_ARREARS", ObjBE_Salary_Components_Master.CM_ARREARS); objSqlHelper.CreateInParameter("@CM_PF", ObjBE_Salary_Components_Master.CM_PF); objSqlHelper.CreateInParameter("@CM_ESIC", ObjBE_Salary_Components_Master.CM_ESIC); objSqlHelper.CreateInParameter("@CM_PT", ObjBE_Salary_Components_Master.CM_PT); objSqlHelper.CreateInParameter("@CM_TDS_GROSS", ObjBE_Salary_Components_Master.CM_TDS_GROSS); objSqlHelper.CreateInParameter("@CM_ADHOC", ObjBE_Salary_Components_Master.CM_ADHOC); objSqlHelper.CreateInParameter("@CM_PROFIT", ObjBE_Salary_Components_Master.CM_PROFIT); objSqlHelper.CreateInParameter("@CM_CREATED_BY", ObjBE_Salary_Components_Master.CM_CREATED_BY); objSqlHelper.CreateInParameter("@CM_TDS_EST", ObjBE_Salary_Components_Master.CM_TDS_EST); return(objSqlHelper.ExecuteQuery("SP_SALARYCOMPONENTS_INSERT")); }
public DataSet BindSpecificComponents(BE_Salary_Components_Master ObjBE_Salary_Components_Master) { SqlHelper objSqlHelper = new SqlHelper("TLPayrollConfig"); objSqlHelper.ClearParameters(); objSqlHelper.CreateInParameter("@CM_ID", ObjBE_Salary_Components_Master.CM_ID); objSqlHelper.CreateInParameter("@CM_NAME", ObjBE_Salary_Components_Master.CM_NAME); return(objSqlHelper.ExecuteQuery("SP_GET_SALARY_SPECIFIC_COMPONENTS")); }
//Added by Deepak ----for Mass Insert Salary Components public DataSet SalaryComponents_MassInsert(BE_Salary_Components_Master ObjBE_Salary_Components_Master_Mass_Insert) { SqlHelper objSqlHelper = new SqlHelper("TLPayrollConfig"); //objSqlHelper.CreateInParameter("@CM_CREATEDBY", ObjBE_Salary_Components_Master_Mass_Insert.CM_CREATED_BY); //objSqlHelper.CreateStructureParameter("@SALARYTYPE", ObjBE_Salary_Components_Master_Mass_Insert.SALARYTYPE); //return objSqlHelper.ExecuteQuery("PROC_SALARYCOMPONENT_MASS_INSERT"); objSqlHelper.ClearParameters(); objSqlHelper.CreateInParameter("@FILEPATH", ObjBE_Salary_Components_Master_Mass_Insert.CM_FilePath); objSqlHelper.CreateInParameter("@CREATED_BY", ObjBE_Salary_Components_Master_Mass_Insert.CM_CREATED_BY); return(objSqlHelper.ExecuteQuery("SP_SALARY_COMPONENT_MASS_INSERT")); }