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