protected void btnSubmitEdit_Click(object sender, EventArgs e) { lblErrorEdit.Text = ""; try { clsHoliday objHoliday = new clsHoliday(); objHoliday.HOLIDAY_ID = txtHolidayIDEdit.Text.Trim(); objHoliday.HOLIDAY_DESCRIPTION = txtDescriptionEdit.Text.Trim(); objHoliday.HOLIDAY_TYPE = ddlHolidayTypeEdit.SelectedValue; objHoliday.HOLIDAY_DATE = txtHolidayDateEdit.Text.Trim(); objHoliday.HOLIDAY_SWAP = txtSwapDateEdit.Text.Trim(); objHoliday.HOLIDAY_LOCATION = chkSelectLocationEdit.SelectedValue; objHoliday.CreatedBy = Session["uid"].ToString(); clsHolidayHandler.InsertUpdateHolidayDetails(objHoliday, "Update", HolidayLocation(gvHolidayLocationsEdit, txtHolidayIDEdit.Text.Trim()).ToString(), ViewState["OldLocation"].ToString(), ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName()); if (strErrMsg.Trim().Length >= 1) { lblErrorEdit.Text = strErrMsg; lblErrorEdit.Visible = true; mpeEditHolidays.Show(); return; } else { lblMessages.Text = strSuccMsg; bindDataGrid(); mpeEditHolidays.Hide(); } } catch (Exception ex) { lblErrorEdit.Text = ex.Message; lblErrorEdit.Visible = true; UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, "HolidayView"); } }
protected void btnSubmitAdd_Click(object sender, EventArgs e) { lblErrorAdd.Text = ""; try { clsHoliday objHoliday = new clsHoliday(); objHoliday.HOLIDAY_ID = txtHolidayIDAdd.Text.Trim(); objHoliday.HOLIDAY_DESCRIPTION = txtDescriptionAdd.Text.Trim(); objHoliday.HOLIDAY_TYPE = ddlHolidayTypeAdd.SelectedValue; objHoliday.HOLIDAY_DATE = txtHolidayDateAdd.Text.Trim(); objHoliday.HOLIDAY_SWAP = txtSwapDateAdd.Text.Trim(); objHoliday.HOLIDAY_LOCATION = chkSelectLocation.SelectedValue; objHoliday.CreatedBy = Session["uid"].ToString(); clsHolidayHandler.InsertUpdateHolidayDetails(objHoliday, "Insert", HolidayLocation(gvHolidayLocationsAdd, txtHolidayIDAdd.Text.Trim()).ToString(), "", ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName()); if (strErrMsg.Trim().Length >= 1) { lblErrorAdd.Text = strErrMsg; lblErrorAdd.Visible = true; mpeAddHolidays.Show(); } else { lblErrorAdd.Text = strSuccMsg; lblErrorAdd.Visible = true; txtHolidayIDAdd.Text = ""; txtDescriptionAdd.Text = ""; txtHolidayDateAdd.Text = ""; txtSwapDateAdd.Text = ""; ddlHolidayTypeAdd.SelectedValue = "0"; chkSelectLocation.SelectedIndex = 0; bindDataGrid(); divgvHolidayLocationsAdd.Attributes.Add("class", "divHide"); mpeAddHolidays.Show(); txtHolidayIDAdd.Focus(); } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
protected void btnDelete_Click(object sender, EventArgs e) { StringBuilder strXML = new StringBuilder(); try { clsHoliday objHoliday = new clsHoliday(); objHoliday.CreatedBy = Session["uid"].ToString(); strXML.Append("<ENT_HOLIDAY>"); for (int i = 0; i <= gvHoliday.Rows.Count - 1; i++) { CheckBox chk = (CheckBox)gvHoliday.Rows[i].FindControl("DeleteRows"); if (chk.Checked) { strXML.Append("<HOLIDAY>"); strXML.Append("<HOLIDAY_ID>" + gvHoliday.Rows[i].Cells[2].Text + "</HOLIDAY_ID>"); strXML.Append("</HOLIDAY>"); } } strXML.Append("</ENT_HOLIDAY>"); clsHolidayHandler.InsertUpdateHolidayDetails(objHoliday, "Delete", strXML.ToString(), "", ref strErrMsg, ref strSuccMsg, clsCommonHandler.PageName()); if (strErrMsg.Trim().Length >= 1) { lblMessages.Text = strErrMsg; lblMessages.Visible = true; } else { lblMessages.Text = strSuccMsg; lblMessages.Visible = true; bindDataGrid(); } } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }
protected void gvHoliday_RowCommand(object sender, GridViewCommandEventArgs e) { try { lblErrorEdit.Text = ""; if (e.CommandName == "Modify") { clsHoliday objHoliday = new clsHoliday(); string HolidayID = e.CommandArgument.ToString(); DataTable dtLocation = clsHolidayHandler.GetHolidayLocationDetails(HolidayID, "HolidayLoc", ref objHoliday); if (dtLocation.Rows.Count != 0) { chkSelectLocationEdit.SelectedIndex = 1; } else { chkSelectLocationEdit.SelectedIndex = 0; } if (chkSelectLocationEdit.SelectedIndex == 1) { divgvHolidayLocationsEdit.Attributes.Add("class", "divOverflow"); } else { divgvHolidayLocationsEdit.Attributes.Add("class", "divHide"); } for (int i = 0; i < gvHolidayLocationsEdit.Rows.Count; i++) { CheckBox chkDeletebox = (CheckBox)gvHolidayLocationsEdit.Rows[i].FindControl("DeleteRows"); CheckBox EditOptChk = (CheckBox)gvHolidayLocationsEdit.Rows[i].FindControl("optionalChk"); string strHolidayLocID = gvHolidayLocationsEdit.Rows[i].Cells[1].Text; string strfilter = " holiday_loc_id= '" + strHolidayLocID + "'"; DataRow[] drholiday = dtLocation.Select(strfilter); if (drholiday.Length > 0) { chkDeletebox.Checked = true; if (drholiday[0][2].ToString().ToLower() == "true") { EditOptChk.Checked = true; } else { EditOptChk.Checked = false; } } else { chkDeletebox.Checked = false; } } txtHolidayIDEdit.Text = objHoliday.HOLIDAY_ID; txtDescriptionEdit.Text = objHoliday.HOLIDAY_DESCRIPTION; ddlHolidayTypeEdit.SelectedValue = objHoliday.HOLIDAY_TYPE; txtHolidayDateEdit.Text = objHoliday.HOLIDAY_DATE; txtSwapDateEdit.Text = objHoliday.HOLIDAY_SWAP; chkSelectLocationEdit.SelectedValue = objHoliday.HOLIDAY_LOCATION; ViewState["OldLocation"] = HolidayLocation(gvHolidayLocationsEdit, txtHolidayIDEdit.Text.Trim()).ToString(); } if (ddlHolidayTypeEdit.SelectedValue.ToLower() == "n") { chkSelectLocationEdit.Enabled = false; } else { chkSelectLocationEdit.Enabled = true; } txtHolidayIDEdit.Enabled = false; mpeEditHolidays.Show(); } catch (Exception ex) { UNOException.UNO_DBErrorLog(ex.Message, ex.StackTrace, clsCommonHandler.PageName()); } }