protected void dgSchedule_DeleteCommand(object source, DataGridCommandEventArgs e) { try { DataTable tblCart = ViewState["Cart"] as DataTable; //test = tblCart.Rows[e.Item.ItemIndex].Field<Int64>("JournalDCode").ToString(); using (EmployeeJournalDetails objEmployeeJournalDetails = new EmployeeJournalDetails()) { objEmployeeJournalDetails.EmployeeJournalDetailsCode = Convert.ToInt16(tblCart.Rows[e.Item.ItemIndex].Field <Int64>("JournalDCode")); objEmployeeJournalDetails.IsEnabled = "0"; if (objEmployeeJournalDetails.UpdateEnabled() > 0) { tblCart.Rows[e.Item.ItemIndex].Delete(); ViewState["Cart"] = tblCart; dgSchedule.DataSource = tblCart; dgSchedule.DataBind(); } } } catch { Response.Redirect("JournalEncodingM.aspx?JournalCode=" + ViewState["JournalCode"].ToString()); } }
protected void MakeCart() { DataTable tblCart = new DataTable("Cart"); tblCart.Columns.Add("JournalDCode", System.Type.GetType("System.String")); tblCart.Columns.Add("JournalCode", System.Type.GetType("System.String")); tblCart.Columns.Add("ItemNumber", System.Type.GetType("System.String")); tblCart.Columns.Add("Contents", System.Type.GetType("System.String")); tblCart = EmployeeJournalDetails.GetDSGCart(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString())); ViewState["Cart"] = tblCart; LoadGrid(); }
protected void MakeCart() { DataTable tblCart = new DataTable("Cart"); tblCart.Columns.Add("JournalDCode", System.Type.GetType("System.String")); tblCart.Columns.Add("JournalCode", System.Type.GetType("System.String")); tblCart.Columns.Add("ItemNumber", System.Type.GetType("System.String")); tblCart.Columns.Add("Contents", System.Type.GetType("System.String")); tblCart = EmployeeJournalDetails.GetDSGCart(Convert.ToInt16(Request.QueryString["JournalCode"])); ViewState["Cart"] = tblCart; LoadGrid(); }
protected void UpdateJournalDetails(object sender, GridViewUpdateEventArgs e) { string JournalDetailCode = ((HiddenField)dgSchedule.Rows[e.RowIndex].FindControl("hdnJournalDCode")).Value; string Contents = ((TextBox)dgSchedule.Rows[e.RowIndex].FindControl("txtContents")).Text; using (EmployeeJournalDetails objEmployeeJournalDetails = new EmployeeJournalDetails()) { objEmployeeJournalDetails.EmployeeJournalDetailsCode = Convert.ToInt16(JournalDetailCode); objEmployeeJournalDetails.Contents = Contents; if (objEmployeeJournalDetails.UpdateContent() > 0) { dgSchedule.EditIndex = -1; this.MakeCart(); this.LoadDSLs(); } } dgSchedule.EditIndex = -1; this.MakeCart(); this.LoadDSLs(); }
protected void btnSave_Click(object sender, EventArgs e) { using (EmployeeJournalDetails objEmployeeJournalDetails = new EmployeeJournalDetails()) { objEmployeeJournalDetails.EmployeeJournalCode = EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString()); objEmployeeJournalDetails.Contents = txtContents.Text; objEmployeeJournalDetails.ItemNumber = EmployeeJournalDetails.GetTotalRecords(EmployeeJournal.GetLastJournalCode(Convert.ToInt16(WeekYear.GetActiveWeekCode()), Request.Cookies["Speedo"]["UserName"].ToString())) + 1; objEmployeeJournalDetails.JournalDate = DateTime.Now; objEmployeeJournalDetails.CreatedOn = DateTime.Now; objEmployeeJournalDetails.EndorsedBy = "NA"; objEmployeeJournalDetails.EndorsedOn = DateTime.Now; objEmployeeJournalDetails.EndoredRemarks = "NA"; objEmployeeJournalDetails.ApprovedBy = "NA"; objEmployeeJournalDetails.ApprovedOn = DateTime.Now; objEmployeeJournalDetails.ApprovedRemarks = "NA"; objEmployeeJournalDetails.JournalStatus = "F"; objEmployeeJournalDetails.IsEnabled = "1"; if (objEmployeeJournalDetails.Insert() > 0) { Response.Redirect("JournalEncodingM.aspx?JournalCode=" + ViewState["JournalCode"].ToString()); } } }
protected void DeleteJournalDetails(object sender, EventArgs e) { try { DataTable tblCart = ViewState["Cart"] as DataTable; using (EmployeeJournalDetails objEmployeeJournalDetails = new EmployeeJournalDetails()) { LinkButton lnkRemove = (LinkButton)sender; objEmployeeJournalDetails.EmployeeJournalDetailsCode = Convert.ToInt16(lnkRemove.CommandArgument); objEmployeeJournalDetails.IsEnabled = "0"; if (objEmployeeJournalDetails.UpdateEnabled() > 0) { dgSchedule.EditIndex = -1; this.MakeCart(); this.LoadDSLs(); } } } catch { Response.Redirect("JournalEncoding.aspx"); } }