public void FillEMPLOYEEAttendanceTranDetails() { try { DataTable Dt = new DataTable(); Dt = EMP_MASLogicLayer.GetAllEmployeeSalDetailsForAttenMas(Session["COMP_CODE"].ToString(), Convert.ToDateTime(TxtAttendanceDate.Text.Trim())); GvEmployeeAttendanceTransaction.DataSource = Dt; GvEmployeeAttendanceTransaction.DataBind(); } catch (Exception) { throw; } }
private void SetInitialRowEmpTransaction() { DataTable table = new DataTable(); DataRow dr = null; table.Columns.Add("COMP_CODE", typeof(string)); table.Columns.Add("TRAN_DATE", typeof(string)); table.Columns.Add("TRAN_NO", typeof(string)); table.Columns.Add("EMP_CODE", typeof(string)); table.Columns.Add("ATTN_FLAG", typeof(string)); table.Columns.Add("PAY_AMT", typeof(string)); table.Columns.Add("OT_HOURS", typeof(string)); table.Columns.Add("INS_USERID", typeof(string)); table.Columns.Add("INS_TERMINAL", typeof(string)); table.Columns.Add("INS_DATE", typeof(string)); table.Columns.Add("UPD_USERID", typeof(string)); table.Columns.Add("UPD_TERMINAL", typeof(string)); table.Columns.Add("UPD_DATE", typeof(string)); table.Columns.Add("EMP_NAME", typeof(string)); dr = table.NewRow(); dr["COMP_CODE"] = string.Empty; dr["TRAN_DATE"] = string.Empty; dr["TRAN_NO"] = string.Empty; dr["EMP_CODE"] = string.Empty; dr["ATTN_FLAG"] = "P"; dr["PAY_AMT"] = string.Empty; dr["OT_HOURS"] = string.Empty; dr["INS_USERID"] = string.Empty; dr["INS_TERMINAL"] = string.Empty; dr["INS_DATE"] = string.Empty; dr["UPD_USERID"] = string.Empty; dr["UPD_TERMINAL"] = string.Empty; dr["UPD_DATE"] = string.Empty; dr["EMP_NAME"] = string.Empty; table.Rows.Add(dr); ViewState["CurrentTable"] = table; GvEmployeeAttendanceTransaction.DataSource = table; GvEmployeeAttendanceTransaction.DataBind(); }
protected void GvEmployeeAttendanceMaster_RowCommand(object sender, GridViewCommandEventArgs e) { try { if (e.CommandName == "Deletea") { #region DELETE // clear(); int id = int.Parse(e.CommandArgument.ToString()); Control ctrl = e.CommandSource as Control; if (ctrl != null) { GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow; HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; DataSet ds = ATTN_MASLogicLayer.GetAllIDWiseATTENDANCE_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); DataTable dt = ds.Tables[0]; DataTable DtDetails = ds.Tables[1]; if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); TxtAttendanceDate.Text = Convert.ToDateTime(dt.Rows[0]["ATTN_DATE"].ToString()).ToString("dd-MM-yyyy"); DdlHolidayFlag.SelectedValue = dt.Rows[0]["HOLIDAY"].ToString(); TxtRemark.Text = dt.Rows[0]["REMARK"].ToString(); } if (DtDetails.Rows.Count > 0) { GvEmployeeAttendanceTransaction.DataSource = DtDetails; GvEmployeeAttendanceTransaction.DataBind(); } btnSave.Visible = false; btnDelete.Visible = true; Btncalldel.Visible = true; BtncallUpd.Visible = false; ControllerDisable(); } #endregion } if (e.CommandName == "Edita") { #region EDIT // clear(); int id = int.Parse(e.CommandArgument.ToString()); Control ctrl = e.CommandSource as Control; if (ctrl != null) { GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow; HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; DataSet ds = ATTN_MASLogicLayer.GetAllIDWiseATTENDANCE_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); DataTable dt = ds.Tables[0]; DataTable DtDetails = ds.Tables[1]; if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); TxtAttendanceDate.Text = Convert.ToDateTime(dt.Rows[0]["ATTN_DATE"].ToString()).ToString("dd-MM-yyyy"); DdlHolidayFlag.SelectedValue = dt.Rows[0]["HOLIDAY"].ToString(); TxtRemark.Text = dt.Rows[0]["REMARK"].ToString(); } if (DtDetails.Rows.Count > 0) { GvEmployeeAttendanceTransaction.DataSource = DtDetails; GvEmployeeAttendanceTransaction.DataBind(); } BtncallUpd.Text = "UPDATE"; #endregion } #region CHECK UPDATE RIGHTS if (Session["UPDATE"] != null) { if (Session["UPDATE"].ToString() == "Y") { ControllerEnable(); } else { ControllerDisable(); } } #endregion Btncalldel.Visible = false; BtncallUpd.Visible = true; btnSave.Visible = true; UserRights(); } if (e.CommandName == "Viewa") { #region SET TEXT ON VIEW // clear(); int id = int.Parse(e.CommandArgument.ToString()); Control ctrl = e.CommandSource as Control; if (ctrl != null) { GridViewRow row = ctrl.Parent.NamingContainer as GridViewRow; HiddenField HfTranDateGrid = (row.FindControl("HfTranDateGrid")) as HiddenField; DataSet ds = ATTN_MASLogicLayer.GetAllIDWiseATTENDANCE_MASDetials(e.CommandArgument.ToString(), Convert.ToDateTime(HfTranDateGrid.Value.ToString())); DataTable dt = ds.Tables[0]; DataTable DtDetails = ds.Tables[1]; if (dt.Rows.Count > 0) { DivEntry.Visible = true; DivView.Visible = false; HfCompCode.Value = dt.Rows[0]["COMP_CODE"].ToString(); HfTranDate.Value = dt.Rows[0]["TRAN_DATE"].ToString(); HfTranNo.Value = dt.Rows[0]["TRAN_NO"].ToString(); TxtAttendanceDate.Text = Convert.ToDateTime(dt.Rows[0]["ATTN_DATE"].ToString()).ToString("dd-MM-yyyy"); DdlHolidayFlag.SelectedValue = dt.Rows[0]["HOLIDAY"].ToString(); TxtRemark.Text = dt.Rows[0]["REMARK"].ToString(); } if (DtDetails.Rows.Count > 0) { GvEmployeeAttendanceTransaction.DataSource = DtDetails; GvEmployeeAttendanceTransaction.DataBind(); } #endregion ControllerDisable(); btnSave.Visible = false; Btncalldel.Visible = false; BtncallUpd.Visible = false; UserRights(); } } } catch (Exception EX) { EX.ToString(); } }