public void ReloadDataGrid(object sender, ThresholdReachedEventArgs e)
        {
            if (ConvertTo.DateTimeVal(DtStartDate.EditValue) == e.AttendanceDate && IsString.IsEqualTo(txtEmpCode.EditValue, e.EmpCode))
            {
            }
            else
            {
                DtStartDate.EditValue = e.AttendanceDate;
                txtEmpCode.EditValue  = e.EmpCode;


                var ds = ProjectFunctions.GetDataSet("SELECT     empmst.EmpCode, empmst.EmpName, DeptMst.DeptDesc FROM         empmst LEFT OUTER JOIN DeptMst ON empmst.EmpDeptCode = DeptMst.DeptCode Where EmpCode='" + txtEmpCode.Text.Trim() + "'");
                if (ds.Tables[0].Rows.Count > 0)
                {
                    txtEmpCode.Text = ds.Tables[0].Rows[0]["EmpCode"].ToString();
                    txtEmpName.Text = ds.Tables[0].Rows[0]["EmpName"].ToString();

                    lblemp.Text = ds.Tables[0].Rows[0]["EmpName"].ToString();



                    //Thread.Sleep(1000);

                    btnLoad_Data.PerformClick();//.Focus();
                }
            }


            //LoadAttendanceDataGrid();
            PrintLogWin.PrintLog("---------------------------------");
        }
        private void OnClickRow()
        {
            try
            {
                //DataRow CurrentRow = gridView_AttendanceData.GetDataRow(gridView_AttendanceData.FocusedRowHandle);
                int        row                 = (gridControl_AttendanceData.FocusedView as ColumnView).FocusedRowHandle;
                ColumnView detailView          = (ColumnView)gridControl_AttendanceData.FocusedView;
                int        cellValue_serial_id = ConvertTo.IntVal(detailView.GetFocusedRowCellValue("SerialId")); //.GetRowCellValue(row, "Edit_Link").ToString();
                                                                                                                  //
                string employee_code   = detailView.GetFocusedRowCellValue("EmployeeCode").ToString();
                string attendance_date = ConvertTo.DateFormatDb(detailView.GetFocusedRowCellValue("AttendanceDate").ToString());

                PrintLogWin.PrintLog("%%%%%%%%%%%%%%%%" + cellValue_serial_id);
                PrintLogWin.PrintLog("%%%%%%%%%%%%%%%%" + row);

                //MessageBox.Show(CurrentRow[0] + "");


                OpenAttendanceForm(cellValue_serial_id, employee_code, attendance_date);
            }
            catch (Exception ex)
            {
                PrintLogWin.PrintLog("%%%%%%%%%%%%%%%% => Exception : " + ex);
            }
        }
Пример #3
0
        //Convert image to binary
        byte[] ConvertImageToBinary(Image img)
        {
            try
            {
                if (img != null)
                {
                    using (MemoryStream ms = new MemoryStream())
                    {
                        img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
                        return(ms.ToArray());
                    }
                }
            }
            catch (Exception ex)
            {
                PrintLogWin.PrintLog(ex);
            }

            try
            {
                using (MemoryStream ms = new MemoryStream())
                {
                    Properties.Resources.profile_icon.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg);
                    return(ms.ToArray());
                }
            }
            catch (Exception ex)
            {
                PrintLogWin.PrintLog(ex);
            }

            return(null);
        }
Пример #4
0
        public XtraReportGatePass(
            string _employee_code,
            int _serial_id,
            string _employee_code_desc,
            string _employee_dept,
            string _employee_unit,
            string _employee_contact,
            string _employee_status,
            string _time_out,
            string _time_in,
            Image image)
        {
            InitializeComponent();

            PrintLogWin.PrintLog("employee_code : " + _employee_code);
            PrintLogWin.PrintLog("serial_id : " + _serial_id + "");

            rptEmpCode.Text           = _employee_code;
            rptEmpCodeDesc.Text       = _employee_code_desc;
            rptEmpDept.Text           = _employee_dept;
            rptEmpUnit.Text           = _employee_unit;
            rptEmpContact.Text        = _employee_contact;
            rptStatus.Text            = _employee_status;
            rptTimeOut.Text           = _time_out;
            rptTimeIn.Text            = _time_in;
            rptPictureBox.ImageSource = new DevExpress.XtraPrinting.Drawing.ImageSource(image);
        }
Пример #5
0
        public void LoadGatePassDataGrid()
        {
            PrintLogWin.PrintLog("LoadGatePassDataGrid => GlobalVariables.ProgCode ******************** : " + GlobalVariables.ProgCode);
            try
            {
                gridView_GatePassData.Columns.Clear();

                string _storedProcedre = SQL_QUERIES.Sp_GatePassData_Daily_List() + " '" + txtEmpCode.EditValue + "', '" + ConvertTo.DateFormatDb(DtDate.EditValue) + "'";
                //DataSet ds = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params);
                DataSet _ds = ProjectFunctionsUtils.GetDataSet(_storedProcedre);

                if (_ds.Tables[0].Rows.Count > 0)
                {
                    gridControl_GatePassData.DataSource = _ds.Tables[0];
                    gridView_GatePassData.BestFitColumns();

                    ////////////////////


                    PrintPrivewButton.Enabled = true;
                    PrintButton.Enabled       = true;
                }
                else
                {
                    gridControl_GatePassData.DataSource = null;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString().Trim());
            }
        }
        public void LoadGatePassDataGrid(bool onFormLoad)
        {
            PrintLogWin.PrintLog("LoadGatePassDataGrid => GlobalVariables.ProgCode ******************** : " + GlobalVariables.ProgCode);
            try
            {
                gridView_AttendanceData.Columns.Clear();

                string  _params = "'" + txtEmpCode.EditValue + "', '" + ConvertTo.DateTimeVal(DtStartDate.EditValue).ToString("yyyy-MM-dd") + "'";
                DataSet ds      = ProgramMasterData.GetData(GlobalVariables.ProgCode, _params);

                if (ds.Tables[0].Rows.Count > 0)
                {
                    gridControl_AttendanceData.DataSource = ds.Tables[0];
                    gridView_AttendanceData.BestFitColumns();
                }
                else
                {
                    gridControl_AttendanceData.DataSource = null;

                    if (!onFormLoad)
                    {
                        ProjectFunctions.SpeakError("There is no data in this Query");
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message.ToString().Trim());
            }
        }
Пример #7
0
        private void Button_delete_ButtonClick(object sender, ButtonPressedEventArgs e)
        {
            BtnEdit_Click(null, e);

            PrintLogWin.PrintLog("================= button_delete_ButtonClick" +
                                 string.Empty);
        }
Пример #8
0
        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();
            }
        }
        private void GridEvents()
        {
            PrintLogWin.PrintLog("*[ GridEvents ]*");

            gridView_AttendanceData.ShowingEditor += GridView_UserMaster_ShowingEditor;

            gridView_AttendanceData.DoubleClick += GridControl_AttendanceData_DoubleClick;
        }
        private void FrmGatePassLaoding_Load(object sender, EventArgs e)
        {
            PrintLogWin.PrintLog("*[ frmGatePassLaoding_Load ]*");

            SetMyControls2();

            LoadGatePassDataGrid(true);
        }
        private void FrmExcelDataLoading_Load(object sender, EventArgs e)
        {
            PrintLogWin.PrintLog("*[ frmExcelDataLoading_Load ]*");
            //SetMyControls();
            SetMyControls2();

            LoadAttendanceDataGrid();
        }
        private void GridControl_AttendanceData_DoubleClick(object sender, EventArgs e)
        {
            gridView_AttendanceData.SetMasterRowExpanded(0, false);
            gridView_AttendanceData.SetMasterRowExpanded(1, true);
            DevExpress.Utils.DXMouseEventArgs.GetMouseArgs(gridControl_AttendanceData, e).Handled = true;

            PrintLogWin.PrintLog("*[ gridControl_AttendanceData_DoubleClick ]*");

            OnClickRow();
        }
Пример #13
0
        //private DataSet dsMain;
        private void FrmGatePassTimeAddEdit_Load(object sender, EventArgs e)
        {
            securityPassword = ProjectFunctionsUtils.GetDateChangePassword();
            PrintLogWin.PrintLog(securityPassword);

            PrintPrivewButton.Enabled = false;
            PrintButton.Enabled       = false;


            SetMyControls();
            if (S1 == "Add")
            {
                //DtDate.Enabled = false;
                DtDate.EditValue = DateTime.Now;
                //DtDateforMonth.EditValue = DateTime.Now;
                //txtAdvanceNo.Text = getNewLoanPassNo().PadLeft(6, '0');
                //txtStatusCode.Text = "A";
                txtEmpCode.Focus();
            }
            if (S1 == "Edit")
            {
                //DtDateforMonth.Enabled = false;
                DtDate.Enabled     = false;
                txtEmpCode.Enabled = false;

                DtDate.EditValue     = Attendance_date;
                txtEmpCode.EditValue = Employee_code;

                try
                {
                    SetFormValues(0, Employee_code, Attendance_date, 0);
                    //if (ComparisonUtils.IsNotNull_DataSet(dsMain))
                    //{
                    //gridControl_GatePassData.DataSource = dsMain.Tables[0];
                    //gridView_GatePassData.BestFitColumns();


                    //DtDate.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["AttendanceDate"]);
                    //txtEmpCode.Text = ds.Tables[0].Rows[0]["EmpCode"].ToString();
                    //txtEmpCodeDesc.Text = ds.Tables[0].Rows[0]["EmpName"].ToString();
                    //txtStatusCode.Text = ds.Tables[0].Rows[0]["StatusCode"].ToString();
                    //txtStatusCodeDesc.Text = ds.Tables[0].Rows[0]["Status"].ToString();
                    //}
                }
                catch (Exception ex)
                {
                    PrintLogWin.PrintLog(ex);
                }
            }
        }
        private void GridEvents()
        {
            PrintLogWin.PrintLog("*[ GridEvents ]*");


            //Disableed

            //gridControl_AttendanceData.Load += gridControl_AttendanceData_Load;
            //In Non-Editable Mode
            gridView_AttendanceData.ShowingEditor += GridView_UserMaster_ShowingEditor;
            //gridView_UserMaster.DoubleClick += gridView_DoubleClick;

            //gridControl_AttendanceData.DoubleClick += gridControl_AttendanceData_DoubleClick;
            gridView_AttendanceData.DoubleClick += GridControl_AttendanceData_DoubleClick;
        }
        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;
            }
        }
Пример #16
0
        private void BtnSave_Click(object sender, EventArgs e)
        {
            try
            {
                int serial_id = ConvertTo.IntVal(txtEmpCode.Tag);

                var               str      = "sp_GatePassData_AddEdit";
                RepGen            reposGen = new RepGen();
                DynamicParameters param    = new DynamicParameters();
                param.Add("@serial_id", serial_id);
                param.Add("@entry_date", ConvertTo.DateFormatDb(DateTime.Now));//Convert.ToDateTime(DateTime.Now).ToString("yyyy-MM-dd")
                param.Add("@status_id", txtStatusCode.Text);
                param.Add("@employee_code", txtEmpCode.Text);
                param.Add("@attendance_date", ConvertTo.DateFormatDb(ConvertTo.DateTimeVal(DtDate.Text)));//Convert.ToDateTime(DtDate.Text).ToString("yyyy-MM-dd")
                param.Add("@attendance_out", timeEdit_Time_Out.Text);
                param.Add("@attendance_in", timeEdit_Time_In.Text);

                param.Add("@output", dbType: DbType.Int32, direction: ParameterDirection.Output);
                param.Add("@Returnvalue", dbType: DbType.Int32, direction: ParameterDirection.ReturnValue);

                string intResult = reposGen.ExecuteNonQuery_SP(str, param);
                if (intResult.Equals("0"))
                {
                    int outputVal = param.Get <int>("@output");
                    int returnVal = param.Get <int>("@Returnvalue");

                    PrintLogWin.PrintLog("outputVal => " + outputVal);
                    PrintLogWin.PrintLog("returnVal => " + returnVal);

                    txtEmpCode.Tag = outputVal;
                    ProjectFunctions.SpeakError("Record has been saved");
                    LoadGatePassDataGrid();
                }
                else
                {
                    ProjectFunctions.SpeakError("Error in save record.");
                    PrintLogWin.PrintLog(intResult);
                }
                //this.Close();
            }
            catch (Exception ex)
            {
                ProjectFunctions.SpeakError("Error in save record.");
                PrintLogWin.PrintLog(ex);
            }
        }
        private void OnClickRow()
        {
            int        row        = (gridControl_AttendanceData.FocusedView as ColumnView).FocusedRowHandle;
            ColumnView detailView = (ColumnView)gridControl_AttendanceData.FocusedView;

            string employee_code  = detailView.GetFocusedRowCellValue("EmpCode").ToString();
            string gate_pass_date = detailView.GetFocusedRowCellValue("GatePassDate").ToString();

            PrintLogWin.PrintLog("%%%%%%%%%%%%%%%%" + row);

            PrintLogWin.PrintLog("%%%%%%%%%%%%%%%% employee_code " + employee_code);
            PrintLogWin.PrintLog("%%%%%%%%%%%%%%%% gate_pass_date " + gate_pass_date);



            OpenAttendanceForm("Edit", employee_code, gate_pass_date);
        }
Пример #18
0
 //Convert binary to image
 Image ConvertBinaryToImage(byte[] data)
 {
     try
     {
         if (data != null)
         {
             using (MemoryStream ms = new MemoryStream(data))
             {
                 return(Image.FromStream(ms));
             }
         }
     }
     catch (Exception ex)
     {
         PrintLogWin.PrintLog(ex);
     }
     return(null);
 }
Пример #19
0
 //https://supportcenter.devexpress.com/ticket/details/a2934/how-to-handle-a-double-click-on-a-grid-row-or-cell
 void GridView_UserMaster_ShowingEditor(object sender, CancelEventArgs e)
 {
     if (gridView_UserMaster.FocusedColumn == gridView_UserMaster.Columns["Action"])
     {
         PrintLogWin.PrintLog("********************* A ");
         return;
     }
     if (gridView_UserMaster.FocusedRowHandle == GridControl.NewItemRowHandle)
     {
         PrintLogWin.PrintLog("********************* B ");
         e.Cancel = false;
     }
     else
     {
         PrintLogWin.PrintLog("********************* C ");
         e.Cancel = true;
     }
 }
Пример #20
0
        private void GridControl_GatePassData_DoubleClick(object sender, EventArgs e)
        {
            try
            {
                //int rowIndex = (gridControl_GatePassData.FocusedView as ColumnView).FocusedRowHandle;

                ColumnView detailView = (ColumnView)gridControl_GatePassData.FocusedView;

                int    cellValue_serial_id = ConvertTo.IntVal(detailView.GetFocusedRowCellValue("SerialId"));
                string date_value          = detailView.GetFocusedRowCellValue("Date") + string.Empty;


                SetFormValues(0, Employee_code, date_value, cellValue_serial_id);
            }
            catch (Exception ex)
            {
                PrintLogWin.PrintLog(ex);
            }
        }
Пример #21
0
        private void FillDataToGrid()
        {
            PrintLogWin.PrintLog("FillGrid ******************** " + GlobalVariables.ProgCode);
            try
            {
                DataSet ds            = ProjectFunctions.GetDataSet("Select ProgProcName,ProgDesc from ProgramMaster Where ProgCode='" + GlobalVariables.ProgCode + "'");
                string  ProcedureName = ds.Tables[0].Rows[0]["ProgProcName"].ToString();

                PrintLogWin.PrintLog("FillGrid => ProcedureName ******************** " + ProcedureName);

                //ProjectFunctions.BindMasterFormToGrid(ProcedureName, gridControl_UserMaster, gridView_UserMaster);

                DataSet dsMaster = ProjectFunctionsUtils.GetDataSet(ProcedureName);
                FillTable(dsMaster);
                AddUnboundColumn();
                AddButtonToGrid();

                //userMasterBindingSource.DataSource = Binding_DataHelper.GetData(dsMaster);

                //RepositoryItemPictureEdit pictureEdit = new RepositoryItemPictureEdit();
                //pictureEdit.SizeMode = PictureSizeMode.Zoom;
                //pictureEdit.NullText = " ";
                //pictureEdit.Padding = new Padding(1);

                //pictureEdit.Click += gridControl_UserMaster_Click
                //    ;
                //gridControl_UserMaster.DataSource = CreateData(dsMaster);
                //gridView_UserMaster.Columns["Edit_Link"].ColumnEdit = pictureEdit                    ;
                //gridView_UserMaster.Columns["Edit_Link"].Visible = false;
                //GridColumn col = gridView_UserMaster.Columns.AddVisible("Edit", "Edit_Link");
                //col.UnboundType = DevExpress.Data.UnboundColumnType.Object;
                //col.ColumnEdit = pictureEdit;// repositoryItemPictureEdit1;

                //gridView_UserMaster.CustomUnboundColumnData += gridView1_CustomUnboundColumnData;

                toolStrip_lbl.Text = ds.Tables[0].Rows[0]["ProgDesc"].ToString();
            }
            catch (Exception ex)
            {
                MessageBox_Debug.ShowBox("frmMaster => FillGrid() => " + ex);
            }
        }
Пример #22
0
        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();
        }
Пример #23
0
        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);
                }
            }
        }
Пример #24
0
        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());
                        }
                    }
                }
            }
        }
Пример #25
0
        private void CalculateDUtyHours()
        {
            //DateTime.ParseExact(Eval("aeStart").ToString(), "HH:mm:ss", System.Globalization.CultureInfo.InvariantCulture).ToShortTimeString()
            //int shift_id = 1;

            PrintLogWin.PrintLog("************* CalculateDUtyHours => CalculateDUtyHours");

            try
            {
                PrintLogWin.PrintLog("************* form_loaded => " + form_loaded + string.Empty);

                PrintLogWin.PrintLog("************* timeEdit_Time_In_First.EditValue => " + timeEdit_Time_In_First.EditValue + string.Empty);
                PrintLogWin.PrintLog("************* timeEdit_Time_Out_First.EditValue => " + timeEdit_Time_Out_First.EditValue + string.Empty);
                PrintLogWin.PrintLog("************* timeEdit_Time_In_Last.EditValue => " + timeEdit_Time_In_Last.EditValue + string.Empty);
                PrintLogWin.PrintLog("************* timeEdit_Time_Out_Last.EditValue => " + timeEdit_Time_Out_Last.EditValue + string.Empty);


                if (!form_loaded)
                {
                }
                else
                {
                    double totalHrs_First = 0;
                    double totalHrs_Last  = 0;

                    if (timeEdit_Time_In_First.EditValue != null && timeEdit_Time_Out_First.EditValue != null)
                    {
                        DateTime dateTime_In_2  = ConvertTo.TimeToDate(timeEdit_Time_In_First.Text + string.Empty);
                        DateTime dateTime_Out_2 = ConvertTo.TimeToDate(timeEdit_Time_Out_First.Text + string.Empty);

                        if (dateTime_Out_2 < dateTime_In_2)
                        {
                            if (S1 == "Edit")
                            {
                                ProjectFunctions.SpeakError("Time Out First cannot be less than Time In First in Day Shift");
                                timeEdit_Time_Out_First.EditValue = null;
                            }
                        }
                        else
                        {
                            totalHrs_First = (dateTime_Out_2 - dateTime_In_2).TotalHours;
                            if (totalHrs_First < 0)
                            {
                                totalHrs_First *= -1;
                            }
                        }
                    }

                    if (timeEdit_Time_In_Last.EditValue != null && timeEdit_Time_Out_Last.EditValue != null)
                    {
                        DateTime dateTime_In_Last  = ConvertTo.TimeToDate(timeEdit_Time_In_Last.Text + string.Empty);
                        DateTime dateTime_Out_Last = ConvertTo.TimeToDate(timeEdit_Time_Out_Last.Text + string.Empty);
                        if (timeEdit_Time_Out_First.EditValue != null)
                        {
                            DateTime dateTime_Out_1 = ConvertTo.TimeToDate(timeEdit_Time_Out_First.Text + string.Empty);

                            if (dateTime_In_Last < dateTime_Out_1)
                            {
                                if (S1 == "Edit")
                                {
                                    ProjectFunctions.SpeakError("Time In Last cannot be less than Time Out First in Day Shift");
                                    timeEdit_Time_In_Last.EditValue = null;
                                }
                            }
                            else
                            {
                                if (dateTime_Out_Last < dateTime_In_Last)
                                {
                                    if (S1 == "Edit")
                                    {
                                        ProjectFunctions.SpeakError("Time Out Last cannot be less than Time In Last in Day Shift");
                                        timeEdit_Time_Out_Last.EditValue = null;
                                    }
                                }
                                else
                                {
                                    totalHrs_Last = (dateTime_Out_Last - dateTime_In_Last).TotalHours;
                                    if (totalHrs_Last < 0)
                                    {
                                        totalHrs_Last *= -1;
                                    }
                                }
                            }
                        }
                        else
                        {
                            if (dateTime_Out_Last < dateTime_In_Last)
                            {
                                if (S1 == "Edit")
                                {
                                    ProjectFunctions.SpeakError("Time Out Last cannot be less than Time In Last in Day Shift");
                                    timeEdit_Time_Out_Last.EditValue = null;
                                }
                            }
                            else
                            {
                                totalHrs_Last = (dateTime_Out_Last - dateTime_In_Last).TotalHours;
                                if (totalHrs_Last < 0)
                                {
                                    totalHrs_Last *= -1;
                                }
                            }
                        }
                    }

                    double totalHrs_FullDay = totalHrs_First + totalHrs_Last;

                    totalWorkingHours_Text.Text = (totalHrs_FullDay).ToString();
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(timeEdit_Time_In_First.EditValue + "\n\n" + ex + string.Empty);
            }
        }
Пример #26
0
        private void EmployeeFormData_Load()
        {
            SetMyControls();
            if (S1 == "&Add")
            {
                chkDailyWage.Checked = true;
                chkDailyWage.Checked = false;

                chkTeaBreak.Checked = true;
                chkTeaBreak.Checked = false;

                txtEmpName.Select();
                txtEmpCode.Text = ProjectFunctionsUtils.GetNewEmpCode();//.PadLeft(5, '0');
                form_loaded     = true;
            }
            if (S1 == "Edit")
            {
                RepList <EmployeeMasterModel> lista = new RepList <EmployeeMasterModel>();
                DynamicParameters             param = new DynamicParameters();
                param.Add("@EmpCode", EmpCode);

                EmployeeMasterModel empData = lista.returnClass_SP(SQL_QUERIES._frmEmployeeMstAddEdit.sp_LoadEmpMstFEditing(), param);


                //PrintLogWin.PrintLog("**************** =========> Line 120 => listData => " + listData.Count + "");
                if (empData != null)
                {
                    if (empData.EmpTeaTag == "Y")
                    {
                        chTeaTag.Checked = true;
                    }
                    else
                    {
                        chTeaTag.Checked = false;
                    }


                    txtEmpCode.Text     = empData.EmpCode;          // ds.Tables[0].Rows[0]["EmpCode"].ToString();
                    txtEmpName.Text     = empData.EmpName;
                    txtRelationTag.Text = empData.EmpFHRelationTag; //ds.Tables[0].Rows[0]["EmpFHRelationTag"].ToString();
                    txtFHName.Text      = empData.EmpFHName;        //ds.Tables[0].Rows[0]["EmpFHName"].ToString();
                    txtDeptCode.Text    = empData.EmpDeptCode;      //ds.Tables[0].Rows[0]["EmpDeptCode"].ToString();
                    txtDeptDesc.Text    = empData.DeptDesc;         //ds.Tables[0].Rows[0]["DeptDesc"].ToString();
                    txtDesgCode.Text    = empData.EmpDesgCode;      //ds.Tables[0].Rows[0]["EmpDesgCode"].ToString();
                    txtDesgDesc.Text    = empData.DesgDesc;         //ds.Tables[0].Rows[0]["DesgDesc"].ToString();

                    txtUnitCode.Text = empData.UnitCode;            //ds.Tables[0].Rows[0]["EmpDesgCode"].ToString();
                    txtUnitDesc.Text = empData.UnitName;            //ds.Tables[0].Rows[0]["DesgDesc"].ToString();

                    txtEmpSex.Text = empData.EmpSex;                //ds.Tables[0].Rows[0]["EmpSex"].ToString();
                    if (empData.EmpDOJ.ToString() == string.Empty)
                    {
                    }
                    else
                    {
                        txtDOJ.EditValue = Convert.ToDateTime(empData.EmpDOJ);
                    }
                    if (empData.EmpDOL.ToString() == string.Empty)
                    {
                    }
                    else
                    {
                        txtDOL.EditValue = Convert.ToDateTime(empData.EmpDOL);
                    }

                    txtEPFTag.Text  = empData.EmpPFDTag;            //ds.Tables[0].Rows[0]["EmpPFDTag"].ToString();
                    txtESIDTag.Text = empData.EmpESIDTag;           //ds.Tables[0].Rows[0]["EmpESIDTag"].ToString();
                    txtEPFNo.Text   = empData.EmpPFno;              //ds.Tables[0].Rows[0]["EmpPFno"].ToString();
                    txtESICNo.Text  = empData.EmpESIno;             //ds.Tables[0].Rows[0]["EmpESIno"].ToString();

                    txtTDS.Text        = empData.EmpTDS.ToString(); //ds.Tables[0].Rows[0]["EmpTDS"].ToString();
                    txtEmpLeft.Text    = empData.EmpLeft;           //ds.Tables[0].Rows[0]["EmpLeft"].ToString();
                    txtRemarks.Text    = empData.EmpRemarks;        //ds.Tables[0].Rows[0]["EmpRemarks"].ToString();
                    txtMotherName.Text = empData.EmpMotherNm;       //ds.Tables[0].Rows[0]["EmpMotherNm"].ToString();

                    txtState.Text = empData.EmpPerState;            //ds.Tables[0].Rows[0]["EmpPerState"].ToString();
                    txtState.Text = empData.EmpPerCountry;          //ds.Tables[0].Rows[0]["EmpPerCountry"].ToString();

                    txtNationality.Text  = empData.EmpNationality;  //ds.Tables[0].Rows[0]["EmpNationality"].ToString();
                    txtEmail.Text        = empData.EmpEmail;        //ds.Tables[0].Rows[0]["EmpEmail"].ToString();
                    txtCategoryCode.Text = empData.EmpCategory;     //ds.Tables[0].Rows[0]["EmpCategory"].ToString();

                    txtCategoryDesc.Text = empData.CatgDesc;        //ds.Tables[0].Rows[0]["CatgDesc"].ToString();

                    txtDOB.EditValue   = Convert.ToDateTime(empData.EmpDoB);
                    txtPanNo.Text      = empData.EmpPanNo;      //ds.Tables[0].Rows[0]["EmpPanNo"].ToString();
                    txtPassPortNo.Text = empData.EmpPassportNo; //ds.Tables[0].Rows[0]["EmpPassportNo"].ToString();


                    txtEmployeeReligion.Text = empData.EmpReligion;        //ds.Tables[0].Rows[0]["EmpReligion"].ToString();
                    txtMaritalStatus.Text    = empData.EmpMaritalStatus;   //ds.Tables[0].Rows[0]["EmpMaritalStatus"].ToString();
                    txtPaymentMode.Text      = empData.EmpPymtMode;        //ds.Tables[0].Rows[0]["EmpPymtMode"].ToString();
                    txtIfscCode.Text         = empData.EmpBankIFSCode;     //ds.Tables[0].Rows[0]["EmpBankIFSCode"].ToString();
                    txtBankAccountNo.Text    = empData.EmpBankAcNo;        //ds.Tables[0].Rows[0]["EmpBankAcNo"].ToString();
                    txtBankName.Text         = empData.EmpBankName;        //ds.Tables[0].Rows[0]["EmpBankName"].ToString();
                    txtNomineeName.Text      = empData.EmpNominee;         //ds.Tables[0].Rows[0]["EmpNominee"].ToString();
                    txtNomineeRelation.Text  = empData.EmpNomineeRelation; //ds.Tables[0].Rows[0]["EmpNomineeRelation"].ToString();
                    if (empData.EmpNomineeDOB.ToString() == string.Empty)
                    {
                    }
                    else
                    {
                        txtNomineeDOB.EditValue = Convert.ToDateTime(empData.EmpNomineeDOB);
                    }



                    txtAdharCardNo.Text = empData.EmpAdharCardNo;            //ds.Tables[0].Rows[0]["EmpAdharCardNo"].ToString();

                    txtHealthInsurance.Text = empData.EmpGHISDed.ToString(); //ds.Tables[0].Rows[0]["EmpGHISDed"].ToString();

                    txtMiscDed.Text = empData.EmpMscD1.ToString();           //ds.Tables[0].Rows[0]["EmpMscD1"].ToString();

                    txtAddress1.Text = empData.EmpAddress1;                  //ds.Tables[0].Rows[0]["EmpAddress1"].ToString();
                    txtAddress2.Text = empData.EmpAddress2;                  //ds.Tables[0].Rows[0]["EmpAddress2"].ToString();
                    txtAddress3.Text = empData.EmpAddress3;                  //ds.Tables[0].Rows[0]["EmpAddress3"].ToString();

                    txtState.Text   = empData.EmpState;                      //ds.Tables[0].Rows[0]["EmpState"].ToString();
                    txtCountry.Text = empData.EmpCountry;                    //ds.Tables[0].Rows[0]["EmpCountry"].ToString();

                    txtEFPFTag.Text = empData.EmpFpfDTag;                    //ds.Tables[0].Rows[0]["EmpFpfDTag"].ToString();

                    //NULL Exception
                    //txtUANNo.Text = ds.Tables[0].Rows[0]["EmpUANNo"].ToString();
                    //txtUnitCode.Text = ds.Tables[0].Rows[0]["UnitCode"].ToString();
                    //txtUnitName.Text = ds.Tables[0].Rows[0]["UnitName"].ToString();
                    //txtAccCode.Text = ds.Tables[0].Rows[0]["EmpPartyCode"].ToString();
                    //txtBankBranchCode.Text = ds.Tables[0].Rows[0]["EmpBankBranchCode"].ToString();
                    txtCategoryCode.Focus();

                    timeEdit_Time_In_First.EditValue  = empData.TimeInFirst.ToString();
                    timeEdit_Time_Out_First.EditValue = empData.TimeOutFirst.ToString();
                    timeEdit_Time_In_Last.EditValue   = empData.TimeInLast.ToString();
                    timeEdit_Time_Out_Last.EditValue  = empData.TimeOutLast.ToString();
                    totalWorkingHours_Text.EditValue  = empData.WorkingHours;
                    pictureBox1.Image = ConvertBinaryToImage(empData.EmpImage);

                    chkTeaBreak.Checked       = (empData.TeaBreak == 1) ? true : false;
                    txtTeaBreakTime.EditValue = empData.TeaBreakTime;
                    PrintLogWin.PrintLog("chkTeaBreak.Checked =========> " + chkTeaBreak.Checked + string.Empty);
                    PrintLogWin.PrintLog("empData.TeaBreak =========> " + empData.TeaBreak + string.Empty);

                    chkDailyWage.Checked = empData.DailyWage;
                    PrintLogWin.PrintLog("chkDailyWage.Checked =========> " + chkDailyWage.Checked + string.Empty);
                    PrintLogWin.PrintLog("empData.DailyWage =========> " + empData.DailyWage + string.Empty);

                    //DAILY WAGER//////////////////////////////
                    if (chkDailyWage.Checked)
                    {
                        if (empData.DailyWageRate != null && empData.DailyWageRate != 0)
                        {
                            txtDailyWageRate.EditValue = empData.DailyWageRate;
                            txtDailyWageRate.Tag       = empData.DailyWageRate;
                        }
                        else
                        {
                            txtDailyWageRate.EditValue = null;
                        }

                        if (empData.DailyWageMinutes != null && empData.DailyWageMinutes != 0)
                        {
                            txtDailyWageHours.EditValue = empData.DailyWageMinutes / 60;
                            txtDailyWageHours.Tag       = empData.DailyWageMinutes / 60;
                        }
                        else
                        {
                            txtDailyWageHours.EditValue = null;
                        }
                    }
                    else
                    {
                        txtDailyWageRate.Enabled   = false;
                        txtDailyWageRate.EditValue = null;

                        txtDailyWageHours.Enabled   = false;
                        txtDailyWageHours.EditValue = null;
                    }

                    //TEA BREAK//////////////////////////////
                    if (chkTeaBreak.Checked)
                    {
                        if (empData.TeaBreakTime != null && empData.TeaBreakTime != 0)
                        {
                            txtTeaBreakTime.EditValue = empData.TeaBreakTime;
                            txtTeaBreakTime.Tag       = empData.TeaBreakTime;
                        }
                        else
                        {
                            txtTeaBreakTime.EditValue = null;
                        }
                    }
                    else
                    {
                        txtTeaBreakTime.Enabled   = false;
                        txtTeaBreakTime.EditValue = null;
                    }
                }

                form_loaded = true;

                txtEmpName.Enabled = false;
                PrintLogWin.PrintLog("frmEmployeeMstAddEdit_Load =========> Line 131 => sp_LoadEmpMstFEditing '" + EmpCode + "'");
            }
        }
Пример #27
0
        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);
                }
            }
        }
Пример #28
0
        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++;
                }
            }
        }
Пример #29
0
        private void FrmAdvanceAddEdit_Load(object sender, EventArgs e)
        {
            SetMyControls();
            if (S1 == "Add")
            {
                DtDate.Enabled           = true;
                DtDate.EditValue         = DateTime.Now;
                DtDateforMonth.EditValue = DateTime.Now;
                txtAdvanceNo.Text        = GetNewLoanPassNo().PadLeft(6, '0');
                txtType.Text             = "A";
                DtDate.Focus();
            }
            if (S1 == "Edit")
            {
                DtDateforMonth.Enabled = false;
                DtDate.Enabled         = false;
                txtType.Enabled        = false;


                string str = "SELECT "
                             + " ExMst.ExPostHead, "
                             + " ExMst.ExVoucherType, "
                             + " ExMst.ExVoucherNo, "
                             + " ExMst.ExVoucherDt, "
                             + " ExMst.ExNo, "
                             + " ExMst.ExId, "
                             + " ExMst.ExDate, "
                             + " ExMst.ExEmpCode, "
                             + " ExMst.ExAmt, "
                             + " ExMst.ExTag, "
                             + " ExMst.ExDatePost, "
                             + " ExMst.ExLoadTag, "
                             + " ExMst.ExEmpCCode, "
                             + " ExMst.ExFedDate, "
                             + " ExMst.ExLoadedDate, "
                             + " empmst.EmpName, "
                             + " actmst.AccName "
                             + " FROM ExMst "
                             + " LEFT OUTER JOIN EmpMST ON ExMst.ExEmpCode = empmst.EmpCode "
                             + " LEFT OUTER JOIN ActMst ON ExMst.ExPostHead = actmst.AccCode "
                             + " WHERE ExId='" + ExId + "';" +
                             string.Empty;

                //var qr = " SELECT     ExMst.ExPostHead, ExMst.ExVoucherType, ExMst.ExVoucherNo, ExMst.ExVoucherDt, ExMst.ExNo, ExMst.ExId, ExMst.ExDate, ExMst.ExEmpCode, ExMst.ExAmt, ExMst.ExTag, ExMst.ExDatePost, ";
                //qr = qr + " ExMst.ExLoadTag, ExMst.ExEmpCCode, ExMst.ExFedDate, ExMst.ExLoadedDate, empmst.EmpName, EmpEmplrRef.ERMDesc, actmst.AccName ";
                //qr = qr + " FROM         ExMst LEFT OUTER JOIN ";
                //qr = qr + "      empmst ON ExMst.ExEmpCode = empmst.EmpCode LEFT OUTER JOIN ";
                //qr = qr + "      EmpEmplrRef ON ExMst.ExEmpCCode = EmpEmplrRef.ERMCode LEFT OUTER JOIN ";
                //qr = qr + "      actmst ON ExMst.ExPostHead = actmst.AccCode ";
                //qr = qr + " WHERE ExId='" + ExId + "'";

                PrintLogWin.PrintLog(str);

                var ds = ProjectFunctionsUtils.GetDataSet(str);

                try
                {
                    txtAdvanceNo.Text        = ds.Tables[0].Rows[0]["ExNo"].ToString();
                    DtDate.EditValue         = Convert.ToDateTime(ds.Tables[0].Rows[0]["ExDate"]);
                    DtDateforMonth.EditValue = Convert.ToDateTime(ds.Tables[0].Rows[0]["ExDatePost"]);
                    txtEmpCode.Text          = ds.Tables[0].Rows[0]["ExEmpCode"].ToString();
                    txtEmpCodeDesc.Text      = ds.Tables[0].Rows[0]["EmpName"].ToString();
                    txtType.Text             = ds.Tables[0].Rows[0]["ExTag"].ToString();
                    txtAmount.Text           = ds.Tables[0].Rows[0]["ExAmt"].ToString();
                }
                catch (Exception ex)
                {
                    PrintLogWin.PrintLog(ex);
                }

                //GetBasicDetail();
            }
        }
Пример #30
0
        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();
        }