public ActionResult Edit([Bind(Include = "ContactId,ContactName,Designation,EmailId,PhoneNo1,PhoneNo2,Address")] Contact contact) { if (ModelState.IsValid) { db.Entry(contact).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(contact)); }
public ActionResult Edit([Bind(Include = "MId,MedicineName,Formula,DisseaseId,Comment,CreatedBy,CreationDate,UpdatedBy,Updationdate")] Medicine medicine) { if (ModelState.IsValid) { db.Entry(medicine).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(medicine)); }
public ActionResult EditDisseaseDetail(Diseass obj) { // db.sp_Update_Dissease_ById(obj.DiseasesId,obj.DisseaseName, obj.Description, obj.CreatedBy, Convert.ToInt32(Session["UserId"])); //Diseass dobj = db.Diseasses.Find(obj.DiseasesId); //dobj.DisseaseName= obj.UpdatedBy = 1; db.Entry(obj).State = System.Data.Entity.EntityState.Modified; int Result = db.SaveChanges(); if (Result > 0) { return RedirectToAction("GetDisseaseDetails"); } else { ViewBag.Message = "Record Failed To Update"; return View(obj); } }
public ActionResult EditMedicine(DisseaseDetails obj)// { ViewBag.Medicine = new SelectList(db.sp_get_Dissease(), "DiseasesId", "DisseaseName"); Medicine createobj = db.Medicines.Find(obj.MedicineId); createobj.DisseaseId = obj.DiseasesId; createobj.MedicineName = obj.MedicineName; createobj.Comment = obj.Comment; createobj.Formula = obj.Formula; createobj.UpdatedBy = 1; db.Entry(createobj).State = System.Data.Entity.EntityState.Modified; // db.sp_Insert_Medicine(createobj.MedicineName, createobj.Formula, createobj.DisseaseId, createobj.Comment, createobj.CreatedBy, createobj.UpdatedBy); SqlCommand cmd = new SqlCommand("sp_getMediciine", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DisseaseId", createobj.DisseaseId); cmd.Parameters.AddWithValue("@MedicineName", createobj.MedicineName); cmd.Parameters.AddWithValue("@Content", createobj.Comment); cmd.Parameters.AddWithValue("@Formula", createobj.Formula); cmd.Parameters.AddWithValue("@Mid", createobj.MId); // cmd.Parameters.AddWithValue("@Mid", createobj.UpdatedBy); con.Open(); int Result = cmd.ExecuteNonQuery(); if (Result > 0) { con.Close(); return(RedirectToAction("GetMedicine")); } else { con.Close(); ViewBag.Message = "Record Failed To Insert"; return(View(createobj)); } }