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