private void GridView_SalaryProcess_CustomColumnDisplayText(object sender, CustomColumnDisplayTextEventArgs e)
{
if (e.Column.FieldName == "OT_Time")
{
if (e.Value != DBNull.Value)
{
}
}
if (e.Column.FieldName == "DeductionTime")
{
if (e.Value != DBNull.Value)
{
//e.DisplayText = ConvertTo.MinutesToHours(e.Value, EmptyReturn.DbNull) + "";
}
}
if (e.Column.FieldName == "EmpSalary")
{
if (e.Value != DBNull.Value)
{
if (ConvertTo.DecimalVal(e.Value) == 0)
{
e.DisplayText = string.Empty;
}
//e.DisplayText = ConvertTo.MinutesToHours(e.Value, EmptyReturn.DbNull) + "";
}
}
}
private void SaveEmployeeData()
{
string sql = string.Empty;
if (ValidateData())
{
using (var sqlcon = new SqlConnection(ProjectFunctions.GetConnection()))
{
sqlcon.Open();
var sqlcom = sqlcon.CreateCommand();
var transaction = sqlcon.BeginTransaction("SaveTransaction");
sqlcom.Connection = sqlcon;
sqlcom.Transaction = transaction;
sqlcom.CommandType = CommandType.Text;
try
{
if (S1 == "&Add")
{
string empCode_SQL = "(SELECT RIGHT('0000' + CAST((ISNULL(MAX(CAST(EmpCode AS INT)), 0) + 1) AS VARCHAR(4)), 4) FROM EmpMst)";// SQL_QUERIES._frmEmployeeMstAddEdit._GetNewEmpCode(hasRtnCol:false);
sql = " SET TRANSACTION ISOLATION LEVEL SERIALIZABLE Begin Transaction "
+ " Insert into EmpMst"
+ " (EmpCode,EmpName,EmpFHRelationTag,EmpFHName, UnitCode, EmpDeptCode,EmpDesgCode,EmpCategory,"
+ " EmpSex,EmpDOJ,EmpDOL,EmpPFDTag,"
+ " EmpESIDTag,EmpPFno,EmpESIno,EmpBasic,EmpHRA,EmpConv,"
+ " EmpPET,EmpTDS,EmpLeft,EmpRemarks,EmpMotherNm,"
+ " EmpNationality,EmpEmail,EmpDoB,EmpPanNo,"
+ " EmpPassportNo ,"
+ " EmpSplAlw,EmpReligion,EmpMaritalStatus,EmpPymtMode,EmpBankIFSCode,"
+ " EmpBankAcNo,EmpBankName,EmpNominee,EmpNomineeRelation,EmpNomineeDOB,EmpAdharCardNo,EmpGHISDed,EmpFPFDTag,EmpMscD1,EmpAddress1,EmpAddress2,EmpAddress3,EmpDistCity,EmpState,EmpCountry,EmpUANNo,EmpBankBranchCode," +
string.Empty +
" TimeInFirst, TimeOutFirst, TimeInLast, TimeOutLast, WorkingHours, EmpImage, DailyWage, DailyWageRate, DailyWageMinutes, TeaBreak, TeaBreakTime,EmpTeaTag)"
+ " values(" + empCode_SQL + ",@EmpName,@EmpFHRelationTag,@EmpFHName, @UnitCode, @EmpDeptCode,@EmpDesgCode,@EmpCategory,"
+ " @EmpSex,@EmpDOJ,@EmpDOL,@EmpPFDTag,"
+ " @EmpESIDTag,@EmpPFno,@EmpESIno,@EmpBasic,@EmpHRA,@EmpConv,"
+ " @EmpPET,@EmpTDS,@EmpLeft,@EmpRemarks,@EmpMotherNm,"
+ " @EmpNationality,@EmpEmail,@EmpDoB,@EmpPanNo,"
+ " @EmpPassportNo,"
+ " @EmpSplAlw,@EmpReligion,@EmpMaritalStatus,@EmpPymtMode,@EmpBankIFSCode,"
+ " @EmpBankAcNo,@EmpBankName,@EmpNominee,@EmpNomineeRelation,@EmpNomineeDOB,@EmpAdharCardNo,@EmpGHISDed,@EmpFPFDTag,@EmpMscD1,@EmpAddress1,@EmpAddress2,@EmpAddress3,@EmpDistCity,@EmpState,@EmpCountry,@EmpUANNo,@EmpBankBranchCode," +
"@TimeInFirst, @TimeOutFirst, @TimeInLast, @TimeOutLast, @WorkingHours, @EmpImage, @DailyWage, @DailyWageRate, @DailyWageMinutes, @TeaBreak, @TeaBreakTime,@EmpTeaTag)"
+ " Commit ";
sqlcom.CommandText = sql;
PrintLogWin.PrintLog(sql);
}
if (S1 == "Edit")
{
sql = " UPDATE EmpMst SET "
+ " EmpFHRelationTag=@EmpFHRelationTag,EmpFHName=@EmpFHName, UnitCode=@UnitCode, EmpDeptCode=@EmpDeptCode,EmpDesgCode=@EmpDesgCode,EmpCategory=@EmpCategory, "
+ " EmpSex=@EmpSex,EmpDOJ=@EmpDOJ,EmpDOL=@EmpDOL,EmpPFDTag=@EmpPFDTag, "
+ " EmpESIDTag=@EmpESIDTag,EmpPFno=@EmpPFno,EmpESIno=@EmpESIno,EmpBasic=@EmpBasic,EmpHRA=@EmpHRA,EmpConv=@EmpConv, "
+ " EmpPET=@EmpPET,EmpTDS=@EmpTDS,EmpLeft=@EmpLeft,EmpRemarks=@EmpRemarks,EmpMotherNm=@EmpMotherNm,EmpNationality=@EmpNationality, "
+ " EmpEmail=@EmpEmail,EmpDoB=@EmpDoB,EmpPanNo=@EmpPanNo,EmpPassportNo=@EmpPassportNo,EmpSplAlw=@EmpSplAlw,"
+ " EmpReligion=@EmpReligion,EmpMaritalStatus=@EmpMaritalStatus,EmpPymtMode=@EmpPymtMode,EmpBankIFSCode=@EmpBankIFSCode, "
+ " EmpBankAcNo=@EmpBankAcNo,EmpBankName=@EmpBankName,EmpNominee=@EmpNominee,EmpNomineeRelation=@EmpNomineeRelation,EmpNomineeDOB=@EmpNomineeDOB, "
+ " EmpAdharCardNo=@EmpAdharCardNo,EmpGHISDed=@EmpGHISDed,EmpFPFDTag=@EmpFPFDTag,EmpMscD1=@EmpMscD1,EmpAddress1=@EmpAddress1,EmpAddress2=@EmpAddress2,EmpAddress3=@EmpAddress3,EmpDistCity=@EmpDistCity,EmpState=@EmpState,EmpCountry=@EmpCountry ,EmpUANNo=@EmpUANNo,EmpBankBranchCode=@EmpBankBranchCode, " +
" TimeInFirst = @TimeInFirst," +
" TimeOutFirst = @TimeOutFirst," +
" TimeInLast = @TimeInLast," +
" TimeOutLast = @TimeOutLast," +
" WorkingHours = @WorkingHours, " +
" EmpImage = @EmpImage," +
" DailyWage = @DailyWage," +
" DailyWageRate = @DailyWageRate," +
" DailyWageMinutes = @DailyWageMinutes," +
" TeaBreak = @TeaBreak," +
" TeaBreakTime = @TeaBreakTime,EmpTeaTag=@EmpTeaTag" +
" Where EmpCode=@EmpCode";
sqlcom.CommandText = sql;
PrintLogWin.PrintLog(sql);
}
sqlcom.Parameters.AddWithValue("@EmpCode", txtEmpCode.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpName", txtEmpName.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpFHRelationTag", txtRelationTag.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpFHName", txtFHName.Text.Trim());
sqlcom.Parameters.AddWithValue("@UnitCode", txtUnitCode.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpDeptCode", txtDeptCode.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpDesgCode", txtDesgCode.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpCategory", txtCategoryCode.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpSex", txtEmpSex.Text.Trim());
if (txtDOJ.Text.Length == 0)
{
sqlcom.Parameters.AddWithValue("@EmpDOJ", System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
sqlcom.Parameters.AddWithValue("@EmpDOJ", ConvertTo.DateTimeVal(txtDOJ.Text));
}
if (txtDOL.Text.Length == 0)
{
sqlcom.Parameters.AddWithValue("@EmpDOL", System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
sqlcom.Parameters.AddWithValue("@EmpDOL", ConvertTo.DateTimeVal(txtDOL.Text));
}
sqlcom.Parameters.AddWithValue("@EmpPFDTag", txtEPFTag.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpESIDTag", txtESIDTag.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpPFno", txtEPFNo.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpESIno", txtESICNo.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpBasic", 0);
sqlcom.Parameters.AddWithValue("@EmpHRA", 0);
sqlcom.Parameters.AddWithValue("@EmpConv", 0);
sqlcom.Parameters.AddWithValue("@EmpPET", 0);
sqlcom.Parameters.AddWithValue("@EmpTDS", ConvertTo.DecimalVal(txtTDS.Text));
sqlcom.Parameters.AddWithValue("@EmpLeft", txtEmpLeft.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpRemarks", txtRemarks.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpMotherNm", txtMotherName.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpNationality", txtNationality.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpEmail", txtEmail.Text.Trim());
if (txtDOB.Text.Length == 0)
{
sqlcom.Parameters.AddWithValue("@EmpDoB", ConvertTo.DateTimeVal(txtDOB.Text));
}
else
{
sqlcom.Parameters.AddWithValue("@EmpDoB", ConvertTo.DateTimeVal(txtDOB.Text));
}
sqlcom.Parameters.AddWithValue("@EmpPanNo", txtPanNo.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpPassportNo", txtPassPortNo.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpSplAlw", 0);
sqlcom.Parameters.AddWithValue("@EmpReligion", txtEmployeeReligion.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpMaritalStatus", txtMaritalStatus.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpPymtMode", txtPaymentMode.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpBankIFSCode", txtIfscCode.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpBankAcNo", txtBankAccountNo.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpBankName", txtBankName.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpNominee", txtNomineeName.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpNomineeRelation", txtNomineeRelation.Text.Trim());
if (txtNomineeDOB.Text.Length == 0)
{
sqlcom.Parameters.AddWithValue("@EmpNomineeDOB", System.Data.SqlTypes.SqlDateTime.Null);
}
else
{
sqlcom.Parameters.AddWithValue("@EmpNomineeDOB", ConvertTo.DateTimeVal(txtNomineeDOB.Text));
}
sqlcom.Parameters.AddWithValue("@EmpAdharCardNo", txtAdharCardNo.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpGHISDed", ConvertTo.DecimalVal(txtHealthInsurance.Text));
sqlcom.Parameters.AddWithValue("@EmpFPFDTag", txtEFPFTag.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpMscD1", ConvertTo.DecimalVal(txtMiscDed.Text));
sqlcom.Parameters.AddWithValue("@EmpAddress1", txtAddress1.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpAddress2", txtAddress2.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpAddress3", txtAddress3.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpDistCity", string.Empty);
sqlcom.Parameters.AddWithValue("@EmpState", txtState.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpCountry", txtCountry.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpUANNo", txtUANNo.Text.Trim());
sqlcom.Parameters.AddWithValue("@EmpBankBranchCode", txtBankBranchCode.Text.Trim());
sqlcom.Parameters.AddWithValue("@TimeInFirst", ConvertTo.DateTimeVal(timeEdit_Time_In_First.Text.ToString().Trim()));
sqlcom.Parameters.AddWithValue("@TimeOutFirst", ConvertTo.DateTimeVal(timeEdit_Time_Out_First.Text.ToString().Trim()));
sqlcom.Parameters.AddWithValue("@TimeInLast", ConvertTo.DateTimeVal(timeEdit_Time_In_Last.Text.ToString().Trim()));
sqlcom.Parameters.AddWithValue("@TimeOutLast", ConvertTo.DateTimeVal(timeEdit_Time_Out_Last.Text.ToString().Trim()));
sqlcom.Parameters.AddWithValue("@WorkingHours", ConvertTo.IntVal(totalWorkingHours_Text.Text.ToString().Trim()));
if (ComparisonUtilsWin.PictureBox_IsNullOrEmpty(pictureBox1))
{
byte[] byteEmpty = ConvertImageToBinary(WindowsFormsApplication1.Properties.Resources.profile_icon);
sqlcom.Parameters.AddWithValue("@EmpImage", byteEmpty);
PrintLogWin.PrintLog("================== 1");
}
else
{
sqlcom.Parameters.AddWithValue("@EmpImage", ConvertImageToBinary(pictureBox1.Image));
PrintLogWin.PrintLog("================== 2");
}
sqlcom.Parameters.AddWithValue("@DailyWage", chkDailyWage.Checked);
sqlcom.Parameters.AddWithValue("@DailyWageRate", (txtDailyWageRate.Text.Length == 0) ? 0 : txtDailyWageRate.EditValue);
sqlcom.Parameters.AddWithValue("@DailyWageMinutes", (txtDailyWageMinutes.Text.Length == 0) ? 0 : txtDailyWageMinutes.EditValue);
sqlcom.Parameters.AddWithValue("@TeaBreak", (chkTeaBreak.Checked) ? 1 : 0);
sqlcom.Parameters.AddWithValue("@TeaBreakTime", (txtTeaBreakTime.EditValue == null) ? 0 : txtTeaBreakTime.EditValue);
sqlcom.Parameters.AddWithValue("@EmpTeaTag", chTeaTag.Checked ? "Y" : "N");
sqlcom.ExecuteNonQuery();
transaction.Commit();
sqlcon.Close();
//XtraMessageBox.Show("Data Saved Successfully");
ProjectFunctions.SpeakError("Data Saved Successfully");
Close();
}
catch (Exception ex)
{
PrintLogWin.PrintLog(sql);
PrintLogWin.PrintLog("Line 663 : " + ex);
XtraMessageBox.Show("Something Wrong. \n I am going to Roll Back." + ex.Message, ex.GetType().ToString());
try
{
transaction.Rollback();
}
catch (Exception ex2)
{
XtraMessageBox.Show("Something Wrong. \n Roll Back Failed." + ex2.Message, ex2.GetType().ToString());
}
}
}
}
}
private void BtnProcessSalary_Click(object sender, EventArgs e)
{
DateTime salaryMonth = ConvertTo.DateTimeVal(DtStartDate.EditValue);
if (ProjectFunctions.SpeakConfirmation("Do you want to process Salary for month [ " + salaryMonth.ToString("MMMM yyyy") + " ]", "Confirmation", MessageBoxButtons.YesNo) != DialogResult.No)
{
try
{
DataTable dtProcessSalary = new DataTable();
dtProcessSalary.Columns.Add("EmpCode", typeof(string));
dtProcessSalary.Columns.Add("SalaryMonth", typeof(DateTime));
dtProcessSalary.Columns.Add("SalaryPaid", typeof(decimal));
dtProcessSalary.Columns.Add("LoanInstallment", typeof(decimal));
dtProcessSalary.Columns.Add("SalaryCalculated", typeof(decimal));
dtProcessSalary.Columns.Add("TeaRate", typeof(decimal));
dtProcessSalary.Columns.Add("NoOfCups", typeof(decimal));
dtProcessSalary.Columns.Add("TotalTeaAmount", typeof(decimal));
for (int rowIndex = 0; rowIndex != gridView_SalaryProcess.RowCount; rowIndex++)
{
int intRow = gridView_SalaryProcess.GetVisibleRowHandle(rowIndex);
string strSalaryMonth = gridView_SalaryProcess.GetRowCellValue(intRow, "SalaryMonth").ToString();
string strEmpCode = gridView_SalaryProcess.GetRowCellValue(intRow, "EmpCode").ToString();
string strSalaryPaid = gridView_SalaryProcess.GetRowCellValue(intRow, "SalaryPaid").ToString();
string strLoanInstallment = gridView_SalaryProcess.GetRowCellValue(intRow, "Loan").ToString();
string strSalaryCalculated = gridView_SalaryProcess.GetRowCellValue(intRow, "SalaryCalculated").ToString();
string strTeaRate = gridView_SalaryProcess.GetRowCellValue(intRow, "TeaRate").ToString();
string strNoOfCups = gridView_SalaryProcess.GetRowCellValue(intRow, "NoOfCups").ToString();
string strTotalTeaAmount = gridView_SalaryProcess.GetRowCellValue(intRow, "TotalTeaAmount").ToString();
PrintLogWin.PrintLog("----- btnProcessSalary_Click => strSalaryMonth: " + strSalaryMonth);
PrintLogWin.PrintLog("----- btnProcessSalary_Click => strEmpCode: " + strEmpCode);
//if (strSalaryPaid != null && strEmpCode.Equals("0030") && ConvertTo.DateTimeVal(strSalaryMonth).Month == 6)
if (strSalaryPaid != null)
{
if (ConvertTo.DecimalVal(strSalaryPaid) > 0)
{
PrintLogWin.PrintLog("strSalaryMonth => " + strSalaryMonth);
PrintLogWin.PrintLog("strEmpCode => " + strEmpCode);
PrintLogWin.PrintLog("strSalaryPaid => " + strSalaryPaid);
PrintLogWin.PrintLog("strLoanInstallment => " + strLoanInstallment);
PrintLogWin.PrintLog("strSalaryCalculated => " + strSalaryCalculated);
PrintLogWin.PrintLog("------------------------------");
//dt.Rows.Add(strEmpCode, ConvertTo.DateTimeVal(strSalaryMonth), ConvertTo.DecimalVal(strSalaryPaid));
dtProcessSalary.Rows.Add(
strEmpCode,
ConvertTo.DateFormatDb(strSalaryMonth),
ConvertTo.DecimalVal(strSalaryPaid),
ConvertTo.DecimalVal(strLoanInstallment),
ConvertTo.DecimalVal(strSalaryCalculated),
ConvertTo.DecimalVal(strTeaRate),
ConvertTo.DecimalVal(strNoOfCups),
ConvertTo.DecimalVal(strTotalTeaAmount)
);
PrintLogWin.PrintLog("***** btnProcessSalary_Click => strSalaryMonth: " + strSalaryMonth);
PrintLogWin.PrintLog("***** btnProcessSalary_Click => strEmpCode: " + strEmpCode);
}
}
//cn.Execute(@"Insert INTO #routineUpdatedRecords VALUES('" + strEmpCode + "', '" + strSalaryMonth + "', " + strSalaryPaid + ")");
}
PrintLogWin.PrintLog("*******************************" + string.Empty);
using (SqlConnection con = new SqlConnection(ProjectFunctionsUtils.ConnectionString))
{
con.Open();
using (SqlCommand com = new SqlCommand("sp_UpdateSalaryPaid", con))
{
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@TableParam", dtProcessSalary);
com.ExecuteNonQuery();
ProjectFunctions.SpeakError("Salary Has Been Processed");
FillGrid();
}
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog(ex);
}
}
}
private void GridView_SalaryProcess_ValidatingEditor(object sender, DevExpress.XtraEditors.Controls.BaseContainerValidateEditorEventArgs e)
{
GridView view = sender as GridView;
var focusRowView = (DataRowView)view.GetFocusedRow();
if (view.FocusedColumn.FieldName.ToUpper() == "NOOFCUPS")
{
int salary_locked = ConvertTo.IntVal(focusRowView["SalaryLocked"]);
if (salary_locked == 0)
{
decimal noofcups = ConvertTo.DecimalVal(e.Value);
decimal tearate = Convert.ToDecimal(txtteatrate.Text);
decimal totalteaamount = noofcups * tearate;
decimal salary_calculated = ConvertTo.DecimalVal(focusRowView["SalaryCalculated_1"]);
decimal salary_calculated_new = salary_calculated - totalteaamount;
view.SetRowCellValue(view.FocusedRowHandle, view.Columns["TotalTeaAmount"], totalteaamount);
if (totalteaamount > 0)
{
view.SetRowCellValue(view.FocusedRowHandle, view.Columns["SalaryCalculated"], salary_calculated_new);
}
else
{
view.SetRowCellValue(view.FocusedRowHandle, view.Columns["SalaryCalculated"], salary_calculated);
}
ProjectFunctions.GetDataTable(" update tbl_Process_Salary Set NoOfCups = '" + noofcups + "' Where MONTH(SalaryMonth)= '" + Convert.ToDateTime(DtStartDate.EditValue).Month + "' and YEAR(SalaryMonth) = '" + Convert.ToDateTime(DtStartDate.EditValue).Year + "' and EmpCode = '" + ConvertTo.StringVal(focusRowView["EmpCode"]) + "'");
}
else
{
}
}
if (view.FocusedColumn.FieldName == "SalaryPaid")
{
int salary_locked = ConvertTo.IntVal(focusRowView["SalaryLocked"]);
if (salary_locked == 0)
{
decimal salary_paying = ConvertTo.DecimalVal(e.Value);
decimal salary_calculated = ConvertTo.DecimalVal(focusRowView["SalaryCalculated"]);
decimal salary_calculated_and_paying_difference = salary_calculated - salary_paying;
decimal balance_new = salary_calculated_and_paying_difference;
//PrintLogWin.PrintLog("******* balance_old A " + balance_old);
PrintLogWin.PrintLog("******* balance_old B " + focusRowView["Balance"]);
PrintLogWin.PrintLog("******* salary_paying " + salary_paying);
PrintLogWin.PrintLog("******* salary_calculated " + salary_calculated);
PrintLogWin.PrintLog("******* salary_calculated_and_paying_difference " + salary_calculated_and_paying_difference);
PrintLogWin.PrintLog("******* balance_new " + balance_new);
view.SetRowCellValue(view.FocusedRowHandle, view.Columns["Balance"], balance_new);
}
else
{
//view.SetRowCellValue(view.FocusedRowHandle, view.Columns["SalaryPaid"], balance_new);
}
}
if (view.FocusedColumn.FieldName == "Loan")
{
decimal salary_paid = ConvertTo.DecimalVal(focusRowView["SalaryPaid"]);
decimal loan_old = ConvertTo.DecimalVal(focusRowView["Loan_1"]);
decimal loan_paying = ConvertTo.DecimalVal(e.Value);
decimal salary_calculated_1 = ConvertTo.DecimalVal(focusRowView["SalaryCalculated_1"]);
decimal new_salary_calculated = (salary_calculated_1 + loan_old) - loan_paying;
PrintLogWin.PrintLog("******* loan_old " + loan_old);
PrintLogWin.PrintLog("******* loan_paying " + loan_paying);
PrintLogWin.PrintLog("******* salary_calculated_1 " + salary_calculated_1);
PrintLogWin.PrintLog("******* new_salary_calculated " + new_salary_calculated);
view.SetRowCellValue(view.FocusedRowHandle, view.Columns["SalaryCalculated"], new_salary_calculated);
/////////////////////////////////////////////////////////////
if (salary_paid > 0)
{
decimal salary_paying = ConvertTo.DecimalVal(focusRowView["SalaryPaid"]);
decimal salary_calculated = ConvertTo.DecimalVal(focusRowView["SalaryCalculated"]);
decimal salary_calculated_and_paying_difference = salary_calculated - salary_paying;
decimal balance_new = salary_calculated_and_paying_difference;
//PrintLogWin.PrintLog("******* balance_old A " + balance_old);
PrintLogWin.PrintLog("******* balance_old B " + focusRowView["Balance"]);
PrintLogWin.PrintLog("******* salary_paying " + salary_paying);
PrintLogWin.PrintLog("******* salary_calculated " + salary_calculated);
PrintLogWin.PrintLog("******* salary_calculated_and_paying_difference " + salary_calculated_and_paying_difference);
PrintLogWin.PrintLog("******* balance_new " + balance_new);
view.SetRowCellValue(view.FocusedRowHandle, view.Columns["Balance"], balance_new);
}
}
}
