// GET: Wedding/Edit/5
public ActionResult Edit(int id)
{
wedding1 weddingmodel = new wedding1();
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(connectionstring))
{
con.Open();
string query = "Select * from wedding1 where HallId = @HallId";
SqlDataAdapter ada = new SqlDataAdapter(query, con);
ada.SelectCommand.Parameters.AddWithValue("@HallId", id);
ada.Fill(dt);
con.Close();
}
if (dt.Rows.Count == 1)
{
weddingmodel.HallId = Convert.ToInt32(dt.Rows[0][0].ToString());
weddingmodel.CityName = dt.Rows[0][1].ToString();
weddingmodel.HallName = dt.Rows[0][2].ToString();
weddingmodel.facilities = dt.Rows[0][3].ToString();
weddingmodel.capacity = Convert.ToInt32(dt.Rows[0][6].ToString());
weddingmodel.budget = Convert.ToInt32(dt.Rows[0][9].ToString());
weddingmodel.address = dt.Rows[0][10].ToString();
return(View(weddingmodel));
}
else
{
return(RedirectToAction("Index"));
}
}
public ActionResult SHOW_WEDDING_HALL(int id)
{
//DataTable dt = new DataTable();
//using (SqlConnection con = new SqlConnection(connectionstring))
//{
// con.Open();
// string query = "Select * from hotel where CityId = @id";
// SqlDataAdapter ada = new SqlDataAdapter(query, con);
// ada.Fill(dt);
// con.Close();
//}
wedding1 conferencemodel = new wedding1();
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection(connectionstring))
{
con.Open();
string query = "Select * from wedding1 where HotelId = @HotelId";
SqlDataAdapter ada = new SqlDataAdapter(query, con);
ada.SelectCommand.Parameters.AddWithValue("@HotelId", id);
ada.Fill(dt);
con.Close();
}
if (dt.Rows.Count == 1)
{
conferencemodel.HallId = Convert.ToInt32(dt.Rows[0][0].ToString());
//conferencemodel.CityName = dt.Rows[0][1].ToString();
//conferencemodel.HallName = dt.Rows[0][2].ToString();
//conferencemodel.facilities = dt.Rows[0][3].ToString();
//conferencemodel.capacity = Convert.ToInt32(dt.Rows[0][6].ToString());
//conferencemodel.budget = Convert.ToInt32(dt.Rows[0][9].ToString());
//conferencemodel.address = dt.Rows[0][10].ToString();
return(View(conferencemodel));
}
else
{
return(View());
}
}
public ActionResult Edit(wedding1 weddingmodel)
{
using (SqlConnection con = new SqlConnection(connectionstring))
{
con.Open();
string query = "Update wedding1 set CityName = @CityName, HallName = @HallName, facilities = @facilities, capacity = @capacity, budget = @budget, address = @address where HallId = @HallId";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.AddWithValue("@HallId", weddingmodel.HallId);
cmd.Parameters.AddWithValue("@CityName", weddingmodel.CityName);
cmd.Parameters.AddWithValue("@HallName", weddingmodel.HallName);
cmd.Parameters.AddWithValue("@facilities", weddingmodel.facilities);
cmd.Parameters.AddWithValue("@capacity", weddingmodel.capacity);
cmd.Parameters.AddWithValue("@budget", weddingmodel.budget);
cmd.Parameters.AddWithValue("@address", weddingmodel.address);
cmd.ExecuteNonQuery();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(wedding1 weddingmodel)
{
try
{
string filename = Path.GetFileNameWithoutExtension(weddingmodel.ImageFile.FileName);
string extension = Path.GetExtension(weddingmodel.ImageFile.FileName);
filename = filename + DateTime.Now.ToString("yymmssfff") + extension;
weddingmodel.image = "~/Image/" + filename;
filename = Path.Combine(Server.MapPath("~/Image/"), filename);
weddingmodel.ImageFile.SaveAs(filename);
using (hotelEntities8 dc = new hotelEntities8())
{
dc.wedding1.Add(weddingmodel);
dc.SaveChanges();
}
}
catch (Exception ex)
{
return(View(ex));
}
ModelState.Clear();
ViewBag.SuccessMessage = "Successful";
return(RedirectToAction("Index"));
}
