HRDataManupulation clsData = new HRDataManupulation();
1. Data retrieve
public DataTable Select_SalaryProcess_Group(int CKy) { DataTable rsResult = new DataTable(); SqlParameter[] sqlParam = new SqlParameter[1]; sqlParam[0] = new SqlParameter("@CKy", CKy); rsResult = clsData.HRRetrieveToDataSet("SalProGrp_Lookup", sqlParam).Tables[0];
return rsResult; }
2.Insert Data
public string InsertAttProData(int AttDtKy, int intAttProId, int EmpKy, int CdKy, DateTime AttDate,TimeSpan tstotalWorkingHours, TimeSpan Ot, TimeSpan deduct, int intEntBy, string strMode) { string iOutput; SqlParameter[] sqlParam = new SqlParameter[10]; sqlParam[0] = new SqlParameter("@AttDtKy", AttDtKy); sqlParam[1] = new SqlParameter("@intAttProId", intAttProId); sqlParam[2] = new SqlParameter("@EmpKy", EmpKy); sqlParam[3] = new SqlParameter("@CdKy", CdKy); sqlParam[4] = new SqlParameter("@AttDate", AttDate); sqlParam[5] = new SqlParameter("@tstotalWorkingHours", tstotalWorkingHours); sqlParam[6] = new SqlParameter("@Ot", Ot); sqlParam[7] = new SqlParameter("@deduct", deduct); sqlParam[8] = new SqlParameter("@intEnteredBy", intEntBy); sqlParam[9] = new SqlParameter("@Mode", strMode); try { iOutput = clsData.InsertUpdateDataHR("spInsertAttProData", sqlParam); } catch (Exception ex) { iOutput = "Error"; }
return iOutput; }