// // GET: /FirstTest/Edit/5 public ActionResult Edit(int id) { City(); MDFirst MDFST = new MDFirst(); DataTable DT = new DataTable(); using (CNN = new SqlConnection(CNNSTR)) { CNN.Open(); QUR = "SELECT * FROM tbl_Detail WHERE ID=@ID "; DA = new SqlDataAdapter(QUR, CNN); DA.SelectCommand.Parameters.AddWithValue("@ID", id); DA.Fill(DT); } if (DT.Rows.Count == 1) { MDFST.ID = Convert.ToInt32(DT.Rows[0][0].ToString()); MDFST.Name = DT.Rows[0][1].ToString(); MDFST.Address = DT.Rows[0][2].ToString(); MDFST.City_ID = Convert.ToInt32(DT.Rows[0][3].ToString()); MDFST.EmailID = DT.Rows[0][4].ToString(); // MDFST.Is_Act = DT.Rows[0][5].ToString(); return(View(MDFST)); } else { return(RedirectToAction("Index")); } }
public ActionResult Edit(MDFirst MDFDT) { using (CNN = new SqlConnection(CNNSTR)) { CNN.Open(); QUR = "UPDATE tbl_Detail SET Name=@Name,Address=@Address,City_ID=@City_ID,EmailID=@EmailID WHERE ID=@ID"; CMD = new SqlCommand(QUR, CNN); CMD.Parameters.AddWithValue("@ID", MDFDT.ID); CMD.Parameters.AddWithValue("@Name", MDFDT.Name); CMD.Parameters.AddWithValue("@Address", MDFDT.Address); CMD.Parameters.AddWithValue("@City_ID", MDFDT.City_ID); CMD.Parameters.AddWithValue("@EmailID", MDFDT.EmailID); CMD.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
public ActionResult Create(MDFirst MDFST) { using (CNN = new SqlConnection(CNNSTR)) { CNN.Open(); QUR = "INSERT INTO tbl_Detail "; QUR += "SELECT MAX(ID) + 1,"; QUR += "@Name,"; QUR += "@Address,"; QUR += "@City_ID,"; QUR += "@EmailID "; QUR += "FROM tbl_Detail"; CMD = new SqlCommand(QUR, CNN); CMD.Parameters.AddWithValue("@Name", MDFST.Name); CMD.Parameters.AddWithValue("@Address", MDFST.Address); CMD.Parameters.AddWithValue("@City_ID", MDFST.City_ID); CMD.Parameters.AddWithValue("@EmailID", MDFST.EmailID); CMD.ExecuteNonQuery(); } return(RedirectToAction("Index")); }
public ActionResult City() { List <MDFirst> list = new List <MDFirst>(); QUR = "SELECT * FROM tbl_City"; CNN = new SqlConnection(CNNSTR); CMD = new SqlCommand(QUR, CNN); CNN.Open(); SqlDataReader DR = CMD.ExecuteReader(); while (DR.Read()) { MDF = new MDFirst(); MDF.City_ID = Convert.ToInt32(DR.GetValue(0).ToString()); MDF.CityNAme = DR.GetValue(1).ToString(); list.Add(MDF); } ViewBag.City = new SelectList(list, "City_ID", "CityNAme"); DR.Close(); CNN.Close(); return(View()); }