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