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()
{
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;
}
}
public Boolean Update(HolidayENT entHoliday)
{
HolidayDAL dalHoliday = new HolidayDAL();
if (dalHoliday.Update(entHoliday))
{
return(true);
}
else
{
Message = dalHoliday.Message;
return(false);
}
}
public Boolean Update(HolidayENT entHoliday)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Holiday_UpdateByPK";
objCmd.Parameters.Add("@HolidayID", SqlDbType.Int).Value = entHoliday.HolidayID;
objCmd.Parameters.Add("@Name", SqlDbType.VarChar).Value = entHoliday.Name;
objCmd.Parameters.Add("@Date", SqlDbType.VarChar).Value = entHoliday.Date;
objCmd.Parameters.Add("@Day", SqlDbType.VarChar).Value = entHoliday.Day;
#endregion Prepare Command
objCmd.ExecuteNonQuery();
return(true);
}
catch (SqlException ex)
{
Message = ex.InnerException.Message;
return(false);
}
catch (Exception ex)
{
Message = ex.InnerException.Message;
return(false);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
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;
}
}
}
public HolidayENT SelectByHolidayDate(SqlString Date)
{
using (SqlConnection objConn = new SqlConnection(ConnectionString))
{
objConn.Open();
using (SqlCommand objCmd = objConn.CreateCommand())
{
try
{
#region Prepare Command
objCmd.CommandType = CommandType.StoredProcedure;
objCmd.CommandText = "PR_Holiday_SelectByHolidayDate";
objCmd.Parameters.Add("@Date", SqlDbType.VarChar).Value = Date;
#endregion Prepare Command
#region Read Data and Set Controls
HolidayENT entHoliday = new HolidayENT();
using (SqlDataReader objSDR = objCmd.ExecuteReader())
{
while (objSDR.Read())
{
if (!objSDR["Name"].Equals(DBNull.Value))
{
entHoliday.Name = Convert.ToString(objSDR["Name"]);
}
if (!objSDR["Day"].Equals(DBNull.Value))
{
entHoliday.Day = Convert.ToString(objSDR["Day"]);
}
if (!objSDR["Date"].Equals(DBNull.Value))
{
entHoliday.Date = Convert.ToString(objSDR["Date"]);
}
}
}
return(entHoliday);
#endregion Read Data and Set Controls
}
catch (SqlException ex)
{
Message = ex.Message;
return(null);
}
catch (Exception ex)
{
Message = ex.Message;
return(null);
}
finally
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
}
}
}
