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());
}
}
