protected void gvHoliday_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "DeleteRecord") { if (e.CommandArgument != null) { HolidayBAL balHoliday = new HolidayBAL(); if (balHoliday.Delete(Convert.ToInt32(e.CommandArgument.ToString().Trim()))) { FillGridViewHoliday(); } else { PanelErrorMesseage.Visible = true; lblErrorMesseage.Text = balHoliday.Message; } } } else if (e.CommandName == "EditRecord") { if (e.CommandArgument != null) { Response.Redirect(e.CommandArgument.ToString().Trim()); } } }
private void fillGridViewHoliday() { DataTable dtHoliday = new DataTable(); HolidayBAL balHoliday = new HolidayBAL(); HolidayENT entHoliday = new HolidayENT(); dtHoliday = balHoliday.SelectAll(); if (dtHoliday != null && dtHoliday.Rows.Count > 0) { gvHoliday.DataSource = dtHoliday; gvHoliday.DataBind(); } else if (dtHoliday.Rows.Count < 1) { gvHoliday.DataSource = null; gvHoliday.DataBind(); PanelGV.Visible = false; } else { PanelErrorMesseage.Visible = true; lblErrorMesseage.Text = balHoliday.Message; } }
private void upcomingHoliday() { HolidayBAL balHoliday = new HolidayBAL(); HolidayENT entHoliday = new HolidayENT(); DataTable dtHoliday = new DataTable(); DateTime today = DateTime.Today; string strDate = ""; string upcomingHoliday = ""; string[] dateString; DateTime startdate; dtHoliday = balHoliday.SelectHolidayDate(); foreach (DataRow row in dtHoliday.Rows) { strDate = row[0].ToString(); dateString = strDate.Split('-'); startdate = Convert.ToDateTime(dateString[0] + "-" + dateString[1] + "-" + dateString[2]); if (startdate > today) { upcomingHoliday = strDate; break; } } entHoliday = balHoliday.SelectByHolidayDate(upcomingHoliday); lblUpcomingHoliday.Text = entHoliday.Name.ToString() + " On " + entHoliday.Day.ToString() + " " + entHoliday.Date.ToString(); }
private void FillGridViewHoliday() { HolidayBAL balHoliday = new HolidayBAL(); DataTable dtHoliday = new DataTable(); dtHoliday = balHoliday.SelectAll(); if (dtHoliday != null && dtHoliday.Rows.Count > 0) { gvHoliday.DataSource = dtHoliday; gvHoliday.DataBind(); } }
private void fillControls(SqlInt32 DepartmentID) { HolidayBAL balHoliday = new HolidayBAL(); HolidayENT entHoliday = new HolidayENT(); entHoliday = balHoliday.SelectByPK(DepartmentID); if (!entHoliday.Name.IsNull) { txtHoliday.Text = entHoliday.Name.Value.ToString(); } if (!entHoliday.Date.IsNull) { txtDate.Text = entHoliday.Date.Value.ToString(); } if (!entHoliday.Day.IsNull) { txtDay.Text = entHoliday.Day.Value.ToString(); } }
protected void btnSave_Click(object sender, EventArgs e) { #region Server Side Validation String strError = ""; if (txtHoliday.Text.Trim() == "") { strError += "Enter Holiday +</br>"; } if (strError.Trim() != "") { PanelErrorMesseage.Visible = true; lblErrorMessage.Text = strError; return; } #endregion Server Side Validation #region Collect Data HolidayENT entHoliday = new HolidayENT(); if (txtHoliday.Text.Trim() != "") { entHoliday.Name = txtHoliday.Text.Trim(); } if (txtDay.Text.Trim() != "") { entHoliday.Day = txtDay.Text.Trim(); } if (txtDate.Text.Trim() != "") { entHoliday.Date = txtDate.Text.Trim(); } #endregion Collect Data HolidayBAL balHoliday = new HolidayBAL(); if (Request.QueryString["HolidayID"] == null) { if (balHoliday.Insert(entHoliday)) { clearSelection(); PanelSuccess.Visible = true; lblSuccess.Text = "Data Inserted Successfully"; } else { PanelErrorMesseage.Visible = true; lblErrorMessage.Text = balHoliday.Message; } } else { entHoliday.HolidayID = Convert.ToInt32(Request.QueryString["HolidayID"].ToString().Trim()); if (balHoliday.Update(entHoliday)) { Response.Redirect("~/Content/Holiday/HolidayList.aspx"); } else { PanelErrorMesseage.Visible = true; lblErrorMessage.Text = balHoliday.Message; } } }