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