public ActionResult MedicineLibrary(MedicineLibrary objMedicineLibrary) { objMedicineLibrary.txtdeteils = Request.Form["txtdeteils"].ToString(); try { if (obj.CheckMedicineLibrary(objMedicineLibrary.MedicineLibraryID, objMedicineLibrary.Medicines)) { if (obj.Save(objMedicineLibrary)) { if (objMedicineLibrary.MedicineLibraryID > 0) { ModelState.Clear(); TempData["msg"] = "Medicine Library Updated Successfully !"; return(RedirectToAction("MedicineLibrary", "MedicineLibrary")); } else { ModelState.Clear(); TempData["msg"] = "Medicine Library Saved Successfully !"; return(RedirectToAction("MedicineLibrary", "MedicineLibrary")); } } } else { TempData["msg"] = "Medicine Library Already Exists !"; } return(RedirectToAction("MedicineLibrary", "MedicineLibrary")); } catch (Exception Ex) { TempData["msg"] = Ex.Message; return(RedirectToAction("MedicineLibrary", "MedicineLibrary")); } }
public bool Save(MedicineLibrary obj) { Connect(); SqlCommand cmd = new SqlCommand("IUMedicineLibrary", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (obj.MedicineLibraryID == 0) { cmd.Parameters.AddWithValue("@MedicineLibraryID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@MedicineLibraryID", obj.MedicineLibraryID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@Medicines", obj.Medicines); if (obj.Type == null) { cmd.Parameters.AddWithValue("@Type", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Type", obj.Type); } if (obj.Unit == null) { cmd.Parameters.AddWithValue("@Unit", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Unit", obj.Unit); } if (obj.Time == null) { cmd.Parameters.AddWithValue("@Time", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Time", obj.Time); } if (obj.Instruction == null) { cmd.Parameters.AddWithValue("@Instruction", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Instruction", obj.Instruction); } if (obj.Frequency1 == null) { cmd.Parameters.AddWithValue("@Frequency1", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Frequency1", obj.Frequency1); } if (obj.txtdeteils == null) { cmd.Parameters.AddWithValue("@Frequency2", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Frequency2", obj.txtdeteils); } if (obj.Frequency3 == null) { cmd.Parameters.AddWithValue("@Frequency3", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Frequency3", obj.Frequency3); } if (obj.Frequency4 == null) { cmd.Parameters.AddWithValue("@Frequency4", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Frequency4", obj.Frequency4); } if (obj.Strength == null) { cmd.Parameters.AddWithValue("@Strength", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Strength", obj.Strength); } if (obj.Days == null) { cmd.Parameters.AddWithValue("@Days", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Days", obj.Days); } if (obj.Quantity == null) { cmd.Parameters.AddWithValue("@Quantity", DBNull.Value); } else { cmd.Parameters.AddWithValue("@Quantity", obj.Quantity); } if (obj.CompositionName == null) { cmd.Parameters.AddWithValue("@CompositionName", DBNull.Value); } else { cmd.Parameters.AddWithValue("@CompositionName", obj.CompositionName); } cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } }