private void SetFormValues(int rowIndex, string _employee_code, string _attendance_date, int _serial_id)
{
try
{
string str = "sp_GatePassData_Single '" + _employee_code + "', '" + ConvertTo.DateFormatDb(ConvertTo.DateTimeVal(_attendance_date)) + "', " + _serial_id + string.Empty;
PrintLogWin.PrintLog(str);
DataSet _ds = ProjectFunctionsUtils.GetDataSet(str);
if (ComparisonUtils.IsNotNull_DataSet(_ds))
{
DataRow dr = _ds.Tables[0].Rows[rowIndex];
DtDate.EditValue = Convert.ToDateTime(dr["AttendanceDate"]);
txtEmpCode.Text = dr["EmpCode"].ToString();
txtEmpCode.Tag = dr["SerialId"].ToString();
txtEmpCodeDesc.Text = dr["EmpName"].ToString();
txtEmpCodeDesc.Tag = dr["DeptDesc"].ToString();
txtStatusCode.Text = dr["StatusCode"].ToString();
txtStatusCode.Tag = dr["UnitName"].ToString();
txtStatusCodeDesc.Text = dr["Status"].ToString();
timeEdit_Time_Out.EditValue = dr["TimeOut"].ToString();
timeEdit_Time_In.EditValue = dr["TimeIn"].ToString();
pictureBox1.Image = ImageUtils.ConvertBinaryToImage((byte[])dr["EmpImage"]);
PrintLogWin.PrintLog("TimeOut " + dr["TimeOut"].ToString());
PrintLogWin.PrintLog("TimeIn " + dr["TimeIn"].ToString());
////////////////////////
/*XtraReportGatePass report = new XtraReportGatePass(
* dr["EmpCode"].ToString(),
* ConvertTo.IntVal(dr["SerialId"].ToString()),
* dr["EmpName"].ToString(),
* dr["DeptDesc"].ToString() + "",
* dr["UnitName"].ToString() + "",
* "",
* dr["Status"].ToString(),
* timeEdit_Time_Out.EditValue + "",
* timeEdit_Time_In.EditValue + "",
* pictureBox1.Image
* );*/
}
else
{
//clear();
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog(ex);
// clear();
}
}
public byte[] GetVerifiedSharedPart(byte[] securePart)
{
if (securePart.Length < 4)
{
throw new ArgumentException("Signed part was too short");
}
// Read lengths
ushort publicLength = (ushort)(((ushort)securePart[0]) | ((ushort)securePart[1] << 8));
ushort proofLength = (ushort)(((ushort)securePart[2]) | ((ushort)securePart[3] << 8));
if (securePart.Length != publicLength + proofLength + (sizeof(ushort) * 2))
{
throw new CryptographicException("Part lengths did not match");
}
// Alloc parts
byte[] publicPart = new byte[publicLength];
byte[] proofPart = new byte[proofLength];
// Copy parts
Buffer.BlockCopy(securePart, sizeof(ushort) * 2, publicPart, 0, publicLength);
Buffer.BlockCopy(securePart, sizeof(ushort) * 2 + publicLength, proofPart, 0, proofLength);
if (_isSigner)
{
using (SHA256Managed sha = new SHA256Managed())
{
byte[] claimedHash = _rsa.Decrypt(proofPart, false);
byte[] realHash = sha.ComputeHash(publicPart);
// Prevent timing attacks by using constant time
if (ComparisonUtils.ConstTimeArrayEqual(claimedHash, realHash))
{
return(_diffieHellanInstance.GetSharedSecretRaw(publicPart));
}
else
{
throw new CryptographicException("Hash did not match the signed hash");
}
}
}
else
{
using (SHA256Managed sha = new SHA256Managed())
{
if (_rsa.VerifyData(publicPart, sha, proofPart))
{
return(_diffieHellanInstance.GetSharedSecretRaw(publicPart));
}
else
{
throw new CryptographicException("Signature was invalid");
}
}
}
}
private void BtnPrintReport_Click(object sender, EventArgs e)
{
if (ComparisonUtils.IsEmpty(DtStartDate.EditValue))
{
ProjectFunctions.SpeakError("Enter Salary Month");
DtStartDate.Focus();
}
else
{
Report_Print_Preview("print");
}
}
private void BtnPrint_Click(object sender, EventArgs e)
{
if (ComparisonUtils.IsEmpty(DtStartDate.EditValue) || ComparisonUtils.IsEmpty(txtEmpCode.EditValue))
{
ProjectFunctions.SpeakError("Enter Attendance Month and Employee Code");
txtEmpCode.Focus();
}
else
{
Report_Print_Preview("print");
}
}
public void LoadGatePassDataGrid_Obsoulete()
{
PrintLogWin.PrintLog("LoadGatePassDataGrid => GlobalVariables.ProgCode ******************** " + GlobalVariables.ProgCode);
gridView_AttendanceData.Columns.Clear();
string _params = "'" + txtEmpCode.EditValue + "', '" + ConvertTo.DateTimeVal(DtStartDate.EditValue).ToString("yyyy-MM-dd") + "'";
DataSet att_ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params);
if (ComparisonUtils.IsNotNull_DataSet(att_ds))
{
gridControl_AttendanceData.DataSource = att_ds;
}
}
private void BtnExportXsls_Click(object sender, EventArgs e)
{
if (ComparisonUtils.IsEmpty(DtStartDate.EditValue) || ComparisonUtils.IsEmpty(txtEmpCode.EditValue))
{
ProjectFunctions.SpeakError("Enter Attendance Month and Employee Code");
txtEmpCode.Focus();
}
else
{
string path = txtEmpCode.EditValue + "_Attendance_For_Month_" + ConvertTo.DateFormatDb(DtStartDate.EditValue) + ".xlsx";
gridControl_AttendanceData.ExportToXlsx(path);
// Open the created XLSX file with the default application.
Process.Start(path);
}
}
private void BtnExportXsls_Click(object sender, EventArgs e)
{
if (ComparisonUtils.IsEmpty(DtStartDate.EditValue))
{
ProjectFunctions.SpeakError("Enter Salary Month");
DtStartDate.Focus();
}
else
{
string path = Application.StartupPath + @"\Salary\" + "Salary_For_Month_" + ConvertTo.DateFormatDb(DtStartDate.EditValue) + ".xlsx";
XlsxExportOptionsEx options = new XlsxExportOptionsEx();
options.CustomizeCell += Options_CustomizeCell;
gridControl_SalaryProcess.ExportToXlsx(path, options);
ProjectFunctions.Speak("XLS GENERATED");
Process.Start(path);
}
}
private void BtnAdd_Click(object sender, EventArgs e)
{
if (btnAdd.Enabled)
{
if (ComparisonUtils.IsEqualTo_String(GlobalVariables.ProgCode, WIN_APP_TABS._frmUserDetails))
{
FrmUserDetails frm = new FrmUserDetails()
{
S1 = btnAdd.Text, Text = "User Addition"
};
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog(Parent);
}
}
FillDataToGrid();
}
private void GridView_AttendanceData_RowStyle(object sender, DevExpress.XtraGrid.Views.Grid.RowStyleEventArgs e)
{
try
{
GridView View = sender as GridView;
if (e.RowHandle >= 0)
{
GridColumn clumn = View.Columns["RowStyle"];
if (clumn != null)
{
string row_style = View.GetRowCellDisplayText(e.RowHandle, clumn);
if (ComparisonUtils.IsNotEmpty(row_style))
{
string[] arr = row_style.Split('-');
if (arr.Length == 1)
{
Color color_1 = System.Drawing.ColorTranslator.FromHtml(arr[0]);
e.Appearance.BackColor = color_1;
}
if (arr.Length == 2)
{
Color color_1 = System.Drawing.ColorTranslator.FromHtml(arr[0]);
Color color_2 = System.Drawing.ColorTranslator.FromHtml(arr[1]);
e.Appearance.BackColor = color_1;
e.Appearance.BackColor2 = color_2;
}
e.HighPriority = true;
}
}
}
}
catch (Exception ex)
{
ProjectFunctions.SpeakError(ex.Message);
}
}
private void BtnEdit_Click(object sender, EventArgs e)
{
if (btnEdit.Enabled)
{
if (ComparisonUtils.IsEqualTo_String(GlobalVariables.ProgCode, WIN_APP_TABS._frmUserDetails))
{
//DataRow CurrentRow = gridView_UserMaster.GetDataRow(gridView_UserMaster.FocusedRowHandle);
//gridControl_UserMaster.Ge
//ColumnView detailView = (ColumnView)gridControl_UserMaster.FocusedView;
//
//int foundIndex = detailView.GetDataSourceRowIndex(detailView.FocusedRowHandle);
//DataRow CurrentRow = detailView.GetDataRow(detailView.FocusedRowHandle);
int row = (gridControl_UserMaster.FocusedView as ColumnView).FocusedRowHandle;
ColumnView detailView = (ColumnView)gridControl_UserMaster.FocusedView;
string cellValue_UserName = detailView.GetRowCellValue(row, "UserName").ToString();
PrintLogWin.PrintLog(cellValue_UserName
);
//int foundIndex = userMasterBindingSource.Find("clients_id", cellValue);
//userMasterBindingSource.Position = foundIndex;
FrmUserDetails frm = new FrmUserDetails()
{
S1 = btnEdit.Text, Text = "User Editing", UserName = cellValue_UserName
};
frm.StartPosition = FormStartPosition.CenterScreen;
frm.ShowDialog(Parent);
}
}
FillDataToGrid();
}
private void TxtUserName_KeyDown(object sender, KeyEventArgs e)
{
//if (e.KeyCode == Keys.Enter || e.KeyCode == Keys.Tab)
{
DataSet dsGetUser = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_USERMASTER_BY_USER(txtUserName.Text.Trim()));
if (ComparisonUtils.IsNotNull_DataSet(dsGetUser))
{
GlobalVariables.CurrentUser = txtUserName.Text;
DataSet dsUnit = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_UNITS_BY_USER(txtUserName.Text));
if (ComparisonUtils.IsNotNull_DataSet(dsUnit))
{
txtUnit.DataSource = dsUnit.Tables[0];
txtUnit.ValueMember = SQL_COLUMNS.UNITS._UNITID;
txtUnit.DisplayMember = SQL_COLUMNS.UNITS._UNITNAME;
}
DataSet dsFNYear = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_USER_FN_ACCESS_BY_USER(txtUserName.Text));
if (ComparisonUtils.IsNotNull_DataSet(dsFNYear))
{
txtFNYear.DataSource = dsFNYear.Tables[0];
txtFNYear.ValueMember = SQL_COLUMNS.FN_YEAR._FNYearCode;
txtFNYear.DisplayMember = SQL_COLUMNS.FN_YEAR._FNYearCode;
}
DataSet dsFNYear2 = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_FN_YEAR_ACTIVE("Y"));
if (ComparisonUtils.IsNotNull_DataSet(dsFNYear2))
{
txtFNYear.SelectedValue = dsFNYear2.Tables[0].Rows[0]["FNYearCode"].ToString();
//txtFNYear.ValueMember = SQL_COLUMNS.FN_YEAR._FNYearCode;
//txtFNYear.DisplayMember = SQL_COLUMNS.FN_YEAR._FNYearCode;
}
}
else
{
ProjectFunctions.SpeakError("Invalid UserName");
}
}
}
private bool ValidateData()
{
if (txtEmpCode.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Invalid Emp Code", "Invalid value", MessageBoxButtons.OK, MessageBoxIcon.Hand);
txtEmpCode.Focus();
return(false);
}
if (txtEmpName.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Invalid Emp Name", "Invalid value", MessageBoxButtons.OK, MessageBoxIcon.Hand);
txtEmpName.Focus();
return(false);
}
if (txtDeptCode.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Invalid Department Code", "Invalid value", MessageBoxButtons.OK, MessageBoxIcon.Hand);
txtDeptCode.Focus();
return(false);
}
if (txtDeptDesc.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Invalid Department Description", "Invalid value", MessageBoxButtons.OK, MessageBoxIcon.Hand);
txtDeptCode.Focus();
return(false);
}
if (txtDesgCode.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Invalid Designation Code", "Invalid value", MessageBoxButtons.OK, MessageBoxIcon.Hand);
txtDesgCode.Focus();
return(false);
}
if (txtDesgDesc.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Invalid Designation Description", "Invalid value", MessageBoxButtons.OK, MessageBoxIcon.Hand);
txtDesgCode.Focus();
return(false);
}
if (txtUnitCode.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Invalid Unit Code", "Invalid value", MessageBoxButtons.OK, MessageBoxIcon.Hand);
txtUnitCode.Focus();
return(false);
}
if (txtUnitDesc.Text.Trim().Length == 0)
{
XtraMessageBox.Show("Invalid Unit Name", "Invalid value", MessageBoxButtons.OK, MessageBoxIcon.Hand);
txtUnitDesc.Focus();
return(false);
}
if (chkDailyWage.Checked)
{
if (txtDailyWageRate.Text.Trim().Length == 0)
{
ProjectFunctions.SpeakError("Please Enter Daily Wage Rates");
txtDailyWageRate.Focus();
return(false);
}
else
{
if (!ComparisonUtils.IsDecimal(txtDailyWageRate.Text))
{
ProjectFunctions.SpeakError("Daily Wage Rates Should be Numbers");
txtDailyWageRate.Focus();
return(false);
}
}
//if (txtDailyWageHours.Text.Trim().Length == 0)
//{
// ProjectFunctions.SpeakError("Please Enter Daily Wager Working Hours");
// txtDailyWageHours.Focus();
// return false;
//}
//else
//{
// if (!ComparisonUtils.IsNumeric(txtDailyWageHours.Text))
// {
// ProjectFunctions.SpeakError("Daily Wage Working Hours Should be Numbers");
// txtDailyWageHours.Focus();
// return false;
// }
//}
}
if (chkTeaBreak.Checked)
{
if (txtTeaBreakTime.Text.Trim().Length == 0)
{
ProjectFunctions.SpeakError("Please Enter Tea Break Time");
txtTeaBreakTime.Focus();
return(false);
}
else
{
if (!ComparisonUtils.IsNumeric(txtTeaBreakTime.Text))
{
ProjectFunctions.SpeakError("Daily Tea Break Time Should be Numbers");
txtTeaBreakTime.Focus();
return(false);
}
}
}
if (txtHealthInsurance.Text.Trim().Length == 0)
{
txtHealthInsurance.Text = "0";
}
if (txtTDS.Text.Trim().Length == 0)
{
txtTDS.Text = "0";
}
if (txtMiscDed.Text.Trim().Length == 0)
{
txtMiscDed.Text = "0";
}
return(true);
}
private void SetGridViewStyle()
{
gridView_Style_List = ProjectFunctionsUtils.GridView_Style("frmProcessSalary", "gridControl_SalaryProcess");
if (gridView_Style_List != null)
{
int rowIndex = 0;
foreach (GridColumn Col in gridView_SalaryProcess.Columns)
{
try
{
if (gridView_Style_List.Exists(x => x.column_name.Equals(Col.FieldName)))
{
GridView_Style_Model item = gridView_Style_List.Single <GridView_Style_Model>(x => x.column_name.Equals(Col.FieldName));
bool colShow = true;
try
{
if (ComparisonUtils.IsNotEmpty(item.column_show))
{
if (item.column_show == 0)
{
colShow = false;
Col.Visible = false;
//gridView_SalaryProcess.Columns[Col.FieldName].Visible = false;
}
else
{
colShow = true;
Col.Visible = true;
//gridView_SalaryProcess.Columns[Col.FieldName].Visible = true;
}
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog("SetGridViewStyle => Color => Exception => " + ex);
}
if (colShow)
{
try
{
if (ComparisonUtils.IsNotEmpty(item.color_code))
{
string hex = item.color_code;
Color color = System.Drawing.ColorTranslator.FromHtml(hex);
Col.AppearanceCell.BackColor = color;
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog("SetGridViewStyle => Color => Exception => " + ex);
}
try
{
if (ComparisonUtils.IsNotEmpty(item.font_style))
{
if (item.font_style.ToLower().Equals("bold"))
{
Col.AppearanceCell.FontStyleDelta = FontStyle.Bold;
}
if (item.font_style.ToLower().Equals("Italic"))
{
Col.AppearanceCell.FontStyleDelta = FontStyle.Italic;
}
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog("SetGridViewStyle => FontStyle => Exception => " + ex);
}
}
}
}
catch (Exception ex)
{
PrintLogWin.PrintLog("SetGridViewStyle => Exception => " + ex);
}
if (Col.FieldName == "SalaryLocked")
{
}
rowIndex++;
}
}
}
public void LoadAttendanceDataGrid()
{
//ProgramMasterModel programMaster = ProgramMasterData.GetProgramMasterModel(GlobalVariables.ProgCode);
//DataSet ds = ProjectFunctions.GetDataSet("Select ProgProcName,ProgDesc from ProgramMaster Where ProgCode='" + GlobalVariables.ProgCode + "'");
//string ProcedureName = ds.Tables[0].Rows[0]["ProgProcName"].ToString();
PrintLogWin.PrintLog("LoadAttendanceDataGrid => GlobalVariables.ProgCode ******************** " + GlobalVariables.ProgCode);
//PrintLogWin.PrintLog("LoadAttendanceDataGrid => ProcedureName Dapper ******************** " + programMaster.ProgProcName);
//PrintLogWin.PrintLog("LoadAttendanceDataGrid => ProcedureName B ******************** " + ProcedureName);
//List<AttendanceModel> att = ProgramMasterData.GetData<AttendanceModel>(GlobalVariables.ProgCode);
//PrintLogWin.PrintLog("LoadAttendanceDataGrid => att ******************** " + att.Count);
gridView_AttendanceData.Columns.Clear();
string _params = "'" + txtEmpCode.EditValue + "', '" + ConvertTo.DateTimeVal(DtStartDate.EditValue).ToString("yyyy-MM-dd") + "'";
DataSet att_ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params, "_v2");
if (ComparisonUtils.IsNotNull_DataSet(att_ds))
{
BindingList <object> binding_list = new BindingList <object>();
foreach (DataRow dr in att_ds.Tables[0].Rows)
{
var employeeAttendance = new
{
SerialId = dr[Col.EmployeeAttendance.serial_id],
//EntryDate = dr[Col.EmployeeAttendance.entry_date],
AttendanceDate = ConvertTo.DateFormatApp(dr[Col.EmployeeAttendance.attendance_date]),
EmployeeCode = dr[Col.EmployeeAttendance.employee_code],
//Shift = dr[Col.DailyShifts.shift_name],
Status = dr[Col.AttendanceStatus.status],
TimeIn_First = ConvertTo.TimeSpanString(dr[Col.EmployeeAttendance.attendance_in_first]),
TimeOut_First = ConvertTo.TimeSpanString(dr[Col.EmployeeAttendance.attendance_out_first]),
TimeIn_Last = ConvertTo.TimeSpanString(dr[Col.EmployeeAttendance.attendance_in_last]),
TimeOut_Last = ConvertTo.TimeSpanString(dr[Col.EmployeeAttendance.attendance_out_last]),
WorkingHours = dr[Col.EmployeeAttendance.working_hours],
OverTime = dr[Col.EmployeeAttendance.ot_deducton_time],
OverTime_1 = ConvertTo.IntVal(dr[Col.EmployeeAttendance.ot_deducton_time_1]),
GatePassTime = dr[Col.EmployeeAttendance.gate_pass_time],
Source = dr[Col.AttendanceSource.source_name],
RowStyle = dr[Col.GridStyle.Row_Style]
};
//ConvertTo.DateTimeVal(dr[Col.EmployeeAttendance.attendance_in_first]).ToString("hh:mm tt")
binding_list.Add(employeeAttendance);
}
gridControl_AttendanceData.DataSource = binding_list;
if (gridView_AttendanceData.Columns["SerialId"] != null)
{
gridView_AttendanceData.Columns["SerialId"].Visible = false;
}
if (gridView_AttendanceData.Columns["EmployeeCode"] != null)
{
gridView_AttendanceData.Columns["EmployeeCode"].Visible = false;
}
if (gridView_AttendanceData.Columns["RowStyle"] != null)
{
gridView_AttendanceData.Columns["RowStyle"].Visible = false;
}
if (gridView_AttendanceData.Columns["OverTime_1"] != null)
{
gridView_AttendanceData.Columns["OverTime_1"].Visible = false;
}
if (binding_list.Count > 0)
{
//GridColumnSummaryItem item1 = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "GatePassTime", "MAX GatePassTime={0}");
//GridColumnSummaryItem item2 = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Min, "GatePassTime", "MIN GatePassTime={0}");
//gridView_AttendanceData.Columns["GatePassTime"].Summary.Add(item1);
//gridView_AttendanceData.Columns["GatePassTime"].Summary.Add(item2);
//gridView_AttendanceData.Columns["WorkingHours"].Summary.Add(DevExpress.Data.SummaryItemType.Average, "WorkingHours", "Avg={0:n2}");
//gridView_AttendanceData.Columns["WorkingHours"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "WorkingHours", "Sum={0}");
//GridColumnSummaryItem item = new GridColumnSummaryItem(DevExpress.Data.SummaryItemType.Max, "WorkingHours", "Max={0}");
//gridView_AttendanceData.Columns["WorkingHours"].Summary.Add(item);
//gridView_AttendanceData.Columns["OverTime"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "OverTime_1", "Total OverTime={0}",);
/*
* GridColumnSummaryItem item = new GridColumnSummaryItem();
* item.SummaryType = DevExpress.Data.SummaryItemType.Custom;
*
* item.Tag = "OverTime_Summary";
* gridView_AttendanceData.Columns["OverTime"].Summary.Add(item);
*/
//item = new GridColumnSummaryItem();
//item.SummaryType = DevExpress.Data.SummaryItemType.Custom;
//item.Tag = "2";
//gridView_AttendanceData.Columns["OverTime"].Summary.Add(item);
gridView_AttendanceData.Columns["OverTime_1"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "OverTime_1", string.Empty);
gridView_AttendanceData.Columns["OverTime"].Summary.Add(DevExpress.Data.SummaryItemType.Custom);
gridView_AttendanceData.UpdateTotalSummary();
}
}
}
public static bool operator !=(ValueObject <T>?left, ValueObject <T>?right) => ComparisonUtils.NullSafeNotEquals(left, right);
public override int GetHashCode() => ComparisonUtils.GetHashCode(GetEqualityComponents());
private void FillGrid()
{
ClearGrid();
//DECLARE @Salary_Month DATETIME = '2020-06-01 00:00:00';
var str = "sp_Salary_Process '','" + ConvertTo.DateFormatDb(ConvertTo.DateTimeVal(DtStartDate.EditValue)) + "', 1, 1,'1','" + txtteatrate.Text + "','0'";
PrintLogWin.PrintLog(str);
DataSet ds = ProjectFunctionsUtils.GetDataSet(str);
ds.Tables[0].Columns.Add(new DataColumn("Balance_1", typeof(double)));
ds.Tables[0].Columns.Add(new DataColumn("Arrears_1", typeof(double)));
ds.Tables[0].Columns.Add(new DataColumn("Loan_1", typeof(double)));
ds.Tables[0].Columns.Add(new DataColumn("SalaryCalculated_1", typeof(double)));
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
ds.Tables[0].Rows[i]["Balance_1"] = ConvertTo.DoubleVal(ds.Tables[0].Rows[i]["Balance"]);
ds.Tables[0].Rows[i]["Arrears_1"] = ds.Tables[0].Rows[i]["Arrears"];
ds.Tables[0].Rows[i]["Loan_1"] = ds.Tables[0].Rows[i]["Loan"];
ds.Tables[0].Rows[i]["SalaryCalculated_1"] = ds.Tables[0].Rows[i]["SalaryCalculated"];
}
if (ComparisonUtils.IsNotNull_DataSet(ds))
{
if (ds.Tables[0].Rows.Count > 0)
{
gridControl_SalaryProcess.DataSource = ds.Tables[0];
gridView_SalaryProcess.BestFitColumns();
gridView_SalaryProcess.Columns["EmpSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "EmpSalary", string.Empty);
gridView_SalaryProcess.Columns["SalaryEarned"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryEarned", string.Empty);
gridView_SalaryProcess.Columns["OT_Salary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "OT_Salary", string.Empty);
gridView_SalaryProcess.Columns["DeductionSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "DeductionSalary", string.Empty);
gridView_SalaryProcess.Columns["SalaryGenerateBasic"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryGenerateBasic", string.Empty);
gridView_SalaryProcess.Columns["AdvanceSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "AdvanceSalary", string.Empty);
object p = gridView_SalaryProcess.Columns["Loan"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Loan", string.Empty);
gridView_SalaryProcess.Columns["SalaryCalculated"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryCalculated", string.Empty);
gridView_SalaryProcess.Columns["SalaryPaid"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "SalaryPaid", string.Empty);
gridView_SalaryProcess.Columns["Balance"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Balance", string.Empty);
gridView_SalaryProcess.Columns["Arrears"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "Arrears", string.Empty);
gridView_SalaryProcess.Columns["TotalTeaAmount"].Summary.Add(DevExpress.Data.SummaryItemType.Sum, "TotalTeaAmount", string.Empty);
//gridView_SalaryProcess.Columns["EmpSalary"].Summary.Add(DevExpress.Data.SummaryItemType.Custom);
gridView_SalaryProcess.UpdateTotalSummary();
}
}
else
{
}
gridView_SalaryProcess.OptionsBehavior.Editable = true;
foreach (DevExpress.XtraGrid.Columns.GridColumn Col in gridView_SalaryProcess.Columns)
{
if (Col.FieldName == "LoanIntsallment" || Col.FieldName == "SalaryPaid" || Col.FieldName == "Loan" || Col.FieldName == "NoOfCups")
{
}
else
{
Col.OptionsColumn.AllowEdit = false;
}
}
SetGridViewStyle();
}
private void FrmLogincs_Load(object sender, EventArgs e)
{
if (System.IO.Directory.Exists("C:\\Application"))
{
}
else
{
System.IO.Directory.CreateDirectory("C:\\Application");
}
if (System.IO.Directory.Exists("C:\\Temp"))
{
}
else
{
System.IO.Directory.CreateDirectory("C:\\Temp");
}
if (System.IO.Directory.Exists("C:\\ERP To Busy"))
{
}
else
{
System.IO.Directory.CreateDirectory("C:\\ERP To Busy");
}
if (System.IO.Directory.Exists(Application.StartupPath + "\\PTFile"))
{
}
else
{
System.IO.Directory.CreateDirectory(Application.StartupPath + "\\PTFile");
}
if (System.IO.Directory.Exists(Application.StartupPath + "\\EWAY"))
{
}
else
{
System.IO.Directory.CreateDirectory(Application.StartupPath + "\\EWAY");
}
if (System.IO.Directory.Exists(Application.StartupPath + "\\EWayDetailed"))
{
}
else
{
System.IO.Directory.CreateDirectory(Application.StartupPath + "\\EWayDetailed");
}
if (System.IO.Directory.Exists(Application.StartupPath + "\\LABEL"))
{
}
else
{
System.IO.Directory.CreateDirectory(Application.StartupPath + "\\LABEL");
}
if (System.IO.Directory.Exists(Application.StartupPath + "\\PI"))
{
}
else
{
System.IO.Directory.CreateDirectory(Application.StartupPath + "\\PI");
}
if (System.IO.Directory.Exists(Application.StartupPath + "\\Salary"))
{
}
else
{
System.IO.Directory.CreateDirectory(Application.StartupPath + "\\salary");
}
if (System.IO.Directory.Exists("C:\\Temp\\GST"))
{
}
else
{
System.IO.Directory.CreateDirectory("C:\\Temp\\GST");
}
defaultLookAndFeel1.LookAndFeel.SkinName = "McSkin";
ProjectFunctions.TextBoxVisualize(this);
ProjectFunctions.ButtonVisualize(this);
SqlConnection cnn = new SqlConnection(ProjectFunctions.ConnectionString);
try
{
cnn.Open();
cnn.Close();
}
catch (Exception)
{
Master.FrmServer frm = new Master.FrmServer();
this.Hide();
frm.ShowDialog();
frm.BringToFront();
return;
}
DataSet dsCompany = ProjectFunctionsUtils.GetDataSet(SQL_QUERIES.SQL_COMCONF());
if (ComparisonUtils.IsNotNull_DataSet(dsCompany))
{
txtCompany.DataSource = dsCompany.Tables[0];
txtCompany.ValueMember = SQL_COLUMNS.COMCONF._COMSYSID; // "COMSYSID";
txtCompany.DisplayMember = SQL_COLUMNS.COMCONF._COMNAME; // "COMNAME";
}
if (isDebug)
{
//MessageBox.Show(dsFNYear.Tables[0].Rows.Count.ToString());
txtPassword.Text = "123";
txtUserName.Text = "HAPPY";
SendKeys.Send("{Enter}");
txtUserName.Focus();
TxtUserName_KeyDown(null, null);
BtnLogin_Click(null, null);
}
}
