//private void SalaryDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e) //{ // try // { // SelectedSalary = SalaryDataGrid.SelectedItem as dhSalary; // ChangeSalary(SelectedSalary); // } // catch (Exception ex) // { // Globalized.setException(ex, lblErrorMsg, MsgType.Error); // } //} private void ChangeSalary(dhSalary dhsal) { try { this.SalleryBox.DataContext = dhsal; if (dhsal.bIsPaid == true) { txtIAbsentdays.IsEnabled = false; txtIOverTimeAmount.IsEnabled = false; txtiDeduction.IsEnabled = false; dddEndDate.IsEnabled = false; CalculateSallary(); this.gnrtSalary.Content = "Paid"; } else { txtIAbsentdays.IsReadOnly = true; txtIOverTimeAmount.IsReadOnly = true; txtiDeduction.IsReadOnly = true; dddEndDate.IsEnabled = true; CalculateSallary(); this.gnrtSalary.Content = "Pay Salary"; } } catch (Exception ex) { Globalized.setException(ex, lblErrorMsg, MsgType.Error); } }
private void CalculateDays() { dhSalary OBjSalaryUpdate = new dhSalary(); OBjSalaryUpdate = (dhSalary)this.SalleryBox.DataContext; if (OBjSalaryUpdate != null) { DateTime StartDate; if (OBjSalaryUpdate.dSrtDate != null) { StartDate = (DateTime)OBjSalaryUpdate.dSrtDate; } else { return; } DateTime EndDate; if (OBjSalaryUpdate.dSrtDate != null) { EndDate = (DateTime)OBjSalaryUpdate.dEndDate; } else { return; } OBjSalaryUpdate.iDays = (Int32)(EndDate - StartDate).TotalDays; CalculateSallary(); } }
public DataSet InsertUpdateSalary(dhDBnames objDBNames, dhSalary objSalary) { DataSet ds; ds = objDALGeneral.InsertUpdateSalary(objDBNames, objSalary); return(ds); }
public dsGeneral.dtSalaryDataTable GetSalary(dhDBnames objDBName, dhSalary objSalary) { dsGeneral ds = new dsGeneral(); DataSet dsreturn = objDatabase.GetDataSet(objDBName, objSalary, "xmlGetSalary", (DataSet)ds, "dtSalary"); dsGeneral.dtSalaryDataTable retdt = ((dsGeneral)dsreturn).dtSalary; return(retdt); }
public static dsGeneral.dtSalaryDataTable GetSalary(dhDBnames objDBNames, dhSalary objSalary) { try { dsGeneral.dtSalaryDataTable var_ret; if (objBLSalary == null) { objBLSalary = new blSalary(); } var_ret = objBLSalary.GetSalary(objDBNames, objSalary); return(var_ret); } catch (Exception ex) { throw ex; } }
public static DataSet InsertUpdateSalary(dhDBnames objDBNames, dhSalary objSalary) { try { DataSet var_ret; if (objBLSalary == null) { objBLSalary = new blSalary(); } var_ret = objBLSalary.InsertUpdateSalary(objDBNames, objSalary); return(var_ret); } catch (Exception ex) { throw ex; } }
private void PaySalary() { dhSalary ObjSalaryInsert = new dhSalary(); ObjSalaryInsert = (dhSalary)this.SalleryBox.DataContext; ObjSalaryInsert.iEmpId = GlobalObjEmployee.IEmpid; ObjSalaryInsert.IUpdate = 1; ObjSalaryInsert.bIsPaid = true; DataSet ds = iFacede.InsertUpdateSalary(Globalized.ObjDbName, ObjSalaryInsert); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { Globalized.setException("Select Salary is Marked As Paid.", lblSalarymsg, DataHolders.MsgType.Info); return; } } }
private void BindSalary() { dhSalary objSalry = new dhSalary(); // SalaryDataGrid.DataContext = new dhSalary(); objSalry.iEmpId = GlobalObjEmployee.IEmpid; dsGeneral.dtSalaryDataTable SalaryDataTable; SalaryDataTable = iFacede.GetSalary(Globalized.ObjDbName, objSalry); ObservableCollection <dhSalary> ListObjSalary = ReflectionUtility.DataTableToObservableCollection <dhSalary>(SalaryDataTable); //this.SalaryDataGrid.ItemsSource = ListObjSalary; // setup for new salary //if (ListObjSalary.Count > 0) //{ // dhSalary NSalary = new dhSalary(); // GenrateSallary(ListObjSalary[0]); // CalculateSallary(); //} }
private void CalculateSallary() { dhSalary OBjSalaryUpdate = new dhSalary(); OBjSalaryUpdate = (dhSalary)this.SalleryBox.DataContext; if (OBjSalaryUpdate != null) { // per day salary DateTime Dend = (DateTime)OBjSalaryUpdate.dEndDate; //objNewSalary.dEndDate = Dend; //objNewSalary.iDays = Globalized.ObjPrefernce.ISalaryDays; //objNewSalary.IAbsentdays = 0; int DaysToWork = (DateTime.DaysInMonth(Dend.Year, Dend.Month)); double PerDay = (double)(GlobalObjEmployee.IBasicSalary / DaysToWork); // salary of working days double?SalaryForWorkingDays = (double)(((PerDay * OBjSalaryUpdate.iDays) - ((PerDay * OBjSalaryUpdate.IAbsentdays) + OBjSalaryUpdate.iDeduction)) + OBjSalaryUpdate.FOverTime); OBjSalaryUpdate.iAmount = SalaryForWorkingDays; this.SalleryBox.DataContext = OBjSalaryUpdate; } }
private void SaveSalary() { dhSalary ObjSalaryInsert = new dhSalary(); ObjSalaryInsert = (dhSalary)this.SalleryBox.DataContext; ObjSalaryInsert.iEmpId = GlobalObjEmployee.IEmpid; ObjSalaryInsert.bIsPaid = null; ObjSalaryInsert.IUpdate = 0; DataSet ds = iFacede.InsertUpdateSalary(Globalized.ObjDbName, ObjSalaryInsert); if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { this.SalleryBox.DataContext = new dhSalary(); this.gnrtSalary.Content = "Calculate"; BindSalary(); return; } } }
private void GenrateSallary(dhSalary objPassed = null) { dhSalary objSalry = new dhSalary(); objSalry.iEmpId = GlobalObjEmployee.IEmpid; dsGeneral.dtSalaryDataTable SalaryDataTable; SalaryDataTable = iFacede.GetSalary(Globalized.ObjDbName, objSalry); ObservableCollection <dhSalary> objSalary = ReflectionUtility.DataTableToObservableCollection <dhSalary>(SalaryDataTable); dhSalary NSalary; //if ((objPassed != null)&& (objPassed!= (new dhSalary()))) //{ // NSalary = objPassed ;//new dhSalary(); // NSalary.dSrtDate = ((DateTime)(objPassed.dEndDate)).AddDays(1); // this.dddSrtDate.DisplayDateStart = (DateTime)NSalary.dSrtDate; // NSalary.dEndDate = ((DateTime)(NSalary.dSrtDate)).AddDays(Convert.ToDouble(Globalized.ObjPrefernce.ISalaryDays)) > DateTime.Now ? DateTime.Now : ((DateTime)(NSalary.dSrtDate)).AddDays(Convert.ToDouble(Globalized.ObjPrefernce.ISalaryDays)); // this.dddSrtDate.DisplayDateStart = NSalary.dSrtDate; // this.dddEndDate.DisplayDateStart = NSalary.dEndDate; // NSalary.iDays = (((DateTime)(NSalary.dEndDate)) - ((DateTime)(NSalary.dSrtDate))).Days;//Globalized.ObjPrefernce.ISalaryDays; // NSalary.IAbsentdays = 0; // NSalary.iDeduction = 0; // NSalary.iAmount = 0; // NSalary.FOverTime = 0; // this.SalleryBox.DataContext = NSalary; //} //else //{ DateTime StartDate = DateTime.Now; if (objSalary.Count > 0) { NSalary = objSalary[0]; StartDate = ((DateTime)NSalary.dEndDate).AddDays(1); } else { NSalary = new dhSalary(); StartDate = GlobalObjEmployee.DDateOfJoining == null ? DateTime.Now : (DateTime)GlobalObjEmployee.DDateOfJoining; } this.dddSrtDate.DisplayDateStart = StartDate; this.dddEndDate.DisplayDateStart = StartDate; NSalary.dSrtDate = StartDate;//GlobalObjEmployee.DDateOfJoining; DateTime Dend = StartDate.AddDays(Globalized.ObjPrefernce.ISalaryDays); NSalary.dEndDate = Dend; //NSalary.dSrtDate = GlobalObjEmployee.DDateOfJoining == null ? DateTime.Now : (DateTime)GlobalObjEmployee.DDateOfJoining; // GlobalObjEmployee.DDateOfJoining; //DateTime StartDate = GlobalObjEmployee.DDateOfJoining == null ? DateTime.Now : (DateTime)GlobalObjEmployee.DDateOfJoining; // NSalary.dSrtDate = ((DateTime)(objPassed.dEndDate)).AddDays(1); // NSalary.dEndDate = ((DateTime)(NSalary.dSrtDate)).AddDays(Convert.ToDouble(Globalized.ObjPrefernce.ISalaryDays)) > DateTime.Now ? DateTime.Now : ((DateTime)(NSalary.dSrtDate)).AddDays(Convert.ToDouble(Globalized.ObjPrefernce.ISalaryDays)); NSalary.iDays = (((DateTime)(NSalary.dEndDate)) - ((DateTime)(NSalary.dSrtDate))).Days;//Globalized.ObjPrefernce.ISalaryDays; NSalary.IAbsentdays = 0; NSalary.iDeduction = 0; NSalary.iAmount = 0; NSalary.FOverTime = 0; this.SalleryBox.DataContext = NSalary; //if (objSalary.Count > 0) //{ // dhSalary objNewSalary = new dhSalary(); // objNewSalary.dSrtDate = objSalary[0].dEndDate; // DateTime StartDate = (DateTime)objNewSalary.dSrtDate;//GlobalObjEmployee.DDateOfJoining == null ? DateTime.Now : (DateTime)GlobalObjEmployee.DDateOfJoining; // DateTime Dend = StartDate.AddDays(Globalized.ObjPrefernce.ISalaryDays); // objNewSalary.dEndDate = Dend; // objNewSalary.iDays = Globalized.ObjPrefernce.ISalaryDays; // objNewSalary.IAbsentdays = 0; // objNewSalary.iDeduction = 0; // objNewSalary.iAmount = 0; // objNewSalary.FOverTime = 0; // this.SalleryBox.DataContext = objNewSalary; // //CalculateSallary(); //} //else //{ // dhSalary objNewSalary = new dhSalary(); // objNewSalary.dSrtDate = GlobalObjEmployee.DDateOfJoining; // DateTime StartDate = GlobalObjEmployee.DDateOfJoining == null ? DateTime.Now : (DateTime)GlobalObjEmployee.DDateOfJoining; // DateTime Dend = StartDate.AddDays(Globalized.ObjPrefernce.ISalaryDays); // objNewSalary.dEndDate = Dend; // objNewSalary.iDays = Globalized.ObjPrefernce.ISalaryDays; // objNewSalary.IAbsentdays = 0; // objNewSalary.iDeduction = 0; // objNewSalary.iAmount = 0; // objNewSalary.FOverTime = 0; // //objNewSalary. // // int DaysToWork = (DateTime.DaysInMonth(Dend.Year, Dend.Month)); // // objNewSalary.iAmount = (GlobalObjEmployee.IBasicSalary / DaysToWork) * Globalized.ObjPrefernce.ISalaryDays; // this.SalleryBox.DataContext = objNewSalary; //} // } CalculateSallary(); gnrtSalary.Content = "Save"; Globalized.setException("Salary is calculated for the period click to Save to save.", lblSalarymsg, DataHolders.MsgType.Info); }
public dsGeneral.dtSalaryDataTable GetSalarySheetHrEmployee(dhDBnames objDBNames, dhSalary objSalary) { dsGeneral.dtSalaryDataTable dt = objDALGeneral.GetSalarySheetHrEmployee(objDBNames, objSalary); return(dt); }
public dsGeneral.dtSalaryDataTable GetSalaryMonthlyReportSheet(dhDBnames objDBNames, dhSalary objSalary) { dsGeneral.dtSalaryDataTable dt = objDALGeneral.GetSalaryMonthlyReportSheet(objDBNames, objSalary); return(dt); }
// insert Sallary On the Singel Person public DataSet InsertUpdateSalary(dhDBnames objDBName, dhSalary objSalary) { DataSet dsreturn = objDatabase.GetDataSet(objDBName, objSalary, "xmlInsertUpdateSalary"); return(dsreturn); }