public bool Save(MedicinePackage obj) { Connect(); try { #region IUMedicinePackage SqlCommand cmd = new SqlCommand("IUPackages", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); cmd.Parameters.AddWithValue("@PackagesID", 0); cmd.Parameters["@PackagesID"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@PackagesName", obj.Package); cmd.Parameters.AddWithValue("@CreationID", UserID); cmd.Parameters.AddWithValue("@Mode", "Add"); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); #endregion int PackagesID = Convert.ToInt32(cmd.Parameters["@PackagesID"].Value.ToString()); if (PackagesID > 0) { if (obj.Package != null) { string[] Medicines = obj.Medicines.Split(','); string[] MedicinesID = obj.MedicinesID.Split(','); for (int k = 0; k < Medicines.Length; k++) { if (Medicines[k].ToString() != "") { #region IUPackagesDetails SqlCommand cmd1 = new SqlCommand("IUPackagesDetail", con); cmd1.CommandType = CommandType.StoredProcedure; cmd1.Parameters.AddWithValue("@HospitalID", HospitalID); cmd1.Parameters.AddWithValue("@LocationID", LocationID); cmd1.Parameters.AddWithValue("@PackagesID", PackagesID); cmd1.Parameters.AddWithValue("@PackagesDetailsID", 0); cmd1.Parameters["@PackagesDetailsID"].Direction = ParameterDirection.Output; cmd1.Parameters.AddWithValue("@PackagesName", obj.Package); cmd1.Parameters.AddWithValue("@MedicinesID", MedicinesID[k]); cmd1.Parameters.AddWithValue("@Medicines", Medicines[k]); cmd1.Parameters.AddWithValue("@CreationID", UserID); cmd1.Parameters.AddWithValue("@Mode", "Add"); con.Open(); int j = cmd1.ExecuteNonQuery(); con.Close(); #endregion } } } return(true); } else { return(false); } } catch (Exception ex) { return(false); } }
public ActionResult MedicinePackage(MedicinePackage location, FormCollection collection) { try { location.Medicines = Request.Form["MedicineName"].ToString(); location.MedicinesID = Request.Form["MedicineID"].ToString(); string pack = Request.Form["PackagesID"].ToString(); if (pack.EndsWith(",")) { pack = pack.Substring(0, pack.Length - 1); } if (pack == "") { location.PackagesID = 0; } else { location.PackagesID = Convert.ToInt32(pack); } BL_MedicinePackage BLMedPackages = new BL_MedicinePackage(); //HospitalLocation Location = new HospitalLocation(); //collection //return View(); if (BLMedPackages.CheckMedicinePackages(location.PackagesID, location.Package)) { if (location.PackagesID > 0) { if (BLMedPackages.Edit(location)) { ModelState.Clear(); TempData["msg"] = "Medicine Package Updated Successfully !"; } } else { if (BLMedPackages.Save(location)) { ModelState.Clear(); TempData["msg"] = "Medicine Package Saved Successfully !"; } } } else { TempData["msg"] = "Medicine Package Already Exists !"; } } catch (Exception ex) { TempData["msg"] = ex.Message; return(RedirectToAction("MedicinePackage", "MedicinePackages")); } return(RedirectToAction("MedicinePackage", "MedicinePackages")); }