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