//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);
}
