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