public ActionResult Delete(int HolidayListID, bool?Confirm) { HolidayListsModel hm = new HolidayListsModel(); if (Confirm == true) { SqlCommand cmd = new SqlCommand("Delete From HolidayLists where holidaylistid=@HolidayListID"); cmd.Parameters.Add("@HolidayListID", SqlDbType.Int).Value = HolidayListID; cmd.Connection = traincoreCon; try { traincoreCon.Open(); cmd.ExecuteNonQuery(); ViewBag.Feedback = $"Item with {HolidayListID} deleted"; } catch (SqlException ex) { ViewBag.Feedback = $"{ex.ErrorCode}, {ex.Message} occurred"; } catch (Exception ex) { ViewBag.Feedback = $"{ex.Message} occurred"; } finally { if (cmd.Connection.State == ConnectionState.Open) { traincoreCon.Close(); } } } else { hm.HolidayListID = HolidayListID; } return(View("~/Areas/admin/Views/HolidayLists/Delete.cshtml", hm)); }
public ActionResult Edit(HolidayListsModel hlm) { //Retrieve the Holiday, we are supposed to Edit and Send it on the same create Page //We will use SQL Reader to get the Holiday List from DB SqlCommand listHolidayList = new SqlCommand("UPDATE HolidayLists SET HolidayListName=@HolidayListName, HolidayListDetails=@HolidayListDetails where HolidayListID=@HolidayListID", traincoreCon); listHolidayList.Parameters.AddWithValue("@HolidayListID", hlm.HolidayListID); listHolidayList.Parameters.AddWithValue("@HolidayListName", hlm.HolidayListName); listHolidayList.Parameters.AddWithValue("@HolidayListDetails", hlm.HolidayListDetails); try { traincoreCon.Open(); listHolidayList.Connection = traincoreCon; int result = listHolidayList.ExecuteNonQuery(); ViewBag.Feedback = "The record updated successfully"; } catch (SqlException ex) { ViewBag.Feedback = $"{ex.ErrorCode}, {ex.Message} occurred"; } catch (Exception ex) { ViewBag.Feedback = $"{ex.Message} occurred"; } finally { if (listHolidayList.Connection.State == ConnectionState.Open) { traincoreCon.Close(); } } return(View("~/Areas/admin/Views/HolidayLists/Edit.cshtml")); }
public ActionResult Create(HolidayListsModel hlm) { List <HolidayListsModel> hl = new List <HolidayListsModel>(); SqlCommand listHolidayList = new SqlCommand("Select HolidayListID,HolidayListName from HolidayLists", traincoreCon); try { traincoreCon.Open(); listHolidayList.Connection = traincoreCon; SqlDataReader rdr = listHolidayList.ExecuteReader(); while (rdr.Read()) { HolidayListsModel hm = new HolidayListsModel(); hm.HolidayListID = (int)rdr["HolidayListID"]; hm.HolidayListName = rdr["HolidayListName"].ToString(); hl.Add(hm); } } catch (SqlException ex) { ViewBag.Feedback = $"{ex.ErrorCode}, {ex.Message} occurred"; } catch (Exception ex) { ViewBag.Feedback = $"{ex.Message} occurred"; } finally { if (listHolidayList.Connection.State == ConnectionState.Open) { traincoreCon.Close(); } } return(View("~/Areas/admin/Views/Holidays/Create.cshtml", hl)); }
public ActionResult List() { List <HolidayListsModel> hl = new List <HolidayListsModel>(); SqlCommand listHolidayList = new SqlCommand("Select * from HolidayLists", traincoreCon); try { traincoreCon.Open(); listHolidayList.Connection = traincoreCon; SqlDataReader rdr = listHolidayList.ExecuteReader(); while (rdr.Read()) { HolidayListsModel hm = new HolidayListsModel(); hm.HolidayListID = (int)rdr["HolidayListID"]; hm.HolidayListName = rdr["HolidayListName"].ToString(); hm.HolidayListDetails = rdr["HolidayListDetails"].ToString(); hm.HolidayListImageName = rdr["HolidayListImageName"].ToString(); if (rdr["HolidayListImage"] != DBNull.Value) { hm.HolidayListImage = (byte[])rdr["HolidayListImage"]; } hl.Add(hm); } ViewBag.Feedback = "Save Successfully"; } catch (SqlException ex) { ViewBag.Feedback = $"{ex.ErrorCode}, {ex.Message} occurred"; } catch (Exception ex) { ViewBag.Feedback = $"{ex.Message} occurred"; } finally { if (listHolidayList.Connection.State == ConnectionState.Open) { traincoreCon.Close(); } } return(View("~/Areas/admin/Views/HolidayLists/Index.cshtml", hl)); }
public ActionResult Edit(int HolidayListID) { //Retrieve the Holiday, we are supposed to Edit and Send it on the same create Page //We will use SQL Reader to get the Holiday List from DB SqlCommand listHolidayList = new SqlCommand("Select * from HolidayLists where HolidayListID=@HolidayListID", traincoreCon); listHolidayList.Parameters.AddWithValue("@HolidayListID", HolidayListID); HolidayListsModel hm = new HolidayListsModel(); try { traincoreCon.Open(); listHolidayList.Connection = traincoreCon; SqlDataReader rdr = listHolidayList.ExecuteReader(); while (rdr.Read()) { hm.HolidayListID = (int)rdr["HolidayListID"]; hm.HolidayListName = rdr["HolidayListName"].ToString(); hm.HolidayListDetails = rdr["HolidayListDetails"].ToString(); hm.HolidayListImageName = rdr["HolidayListImageName"].ToString(); if (rdr["HolidayListImage"] != DBNull.Value) { hm.HolidayListImage = (byte[])rdr["HolidayListImage"]; } } } catch (SqlException ex) { ViewBag.Feedback = $"{ex.ErrorCode}, {ex.Message} occurred"; } catch (Exception ex) { ViewBag.Feedback = $"{ex.Message} occurred"; } finally { if (listHolidayList.Connection.State == ConnectionState.Open) { traincoreCon.Close(); } } return(View("~/Areas/admin/Views/HolidayLists/Edit.cshtml", hm)); }