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