public JsonResult Edit_MasterVaccinationReminder(int MasterVaccinationReminderID)
{
BL_MasterVaccinationReminder BLMstVacc = new BL_MasterVaccinationReminder();
List <MasterVaccinationReminder> serch = new List <MasterVaccinationReminder>();
DataSet ds = BLMstVacc.SelectMasterVaccinationReminderByID(MasterVaccinationReminderID);
MasterVaccinationReminder obj = new MasterVaccinationReminder();
obj.MasterVaccinationReminderID = Convert.ToInt32(ds.Tables[0].Rows[0]["MasterVaccinationReminderID"].ToString());
obj.MasterVaccinationReminderName = ds.Tables[0].Rows[0]["MasterVaccinationReminderName"].ToString();
obj.Advice = ds.Tables[0].Rows[0]["Advise"].ToString();
// serch.Add(obj);
foreach (DataRow dr in ds.Tables[1].Rows)
{
serch.Add(new MasterVaccinationReminder
{
VaccinesName = dr["VaccinesName"].ToString(),
MasterVaccinationReminderName = ds.Tables[0].Rows[0]["MasterVaccinationReminderName"].ToString(),
Advice = ds.Tables[0].Rows[0]["Advise"].ToString(),
});
}
return(new JsonResult {
Data = serch, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ActionResult MasterVaccinationReminder(MasterVaccinationReminder location, FormCollection collection)
{
try
{
BL_MasterVaccinationReminder BLmastervacc = new BL_MasterVaccinationReminder();
//HospitalLocation Location = new HospitalLocation();
//collection
//return View();
location.VaccinesName = collection["VaccinesName"];
if (BLmastervacc.CheckMasterVaccinationReminder(location.MasterVaccinationReminderID, location.MasterVaccinationReminderName))
{
if (location.MasterVaccinationReminderID > 0)
{
if (BLmastervacc.Edit(location))
{
ModelState.Clear();
TempData["Msg"] = "Record Updated Successfully";
}
}
else
{
if (BLmastervacc.Save(location))
{
ModelState.Clear();
TempData["Msg"] = "Record Save Successfully";
}
}
}
else
{
TempData["Msg"] = "Already Exist's";
}
}
catch (Exception ex)
{
TempData["Msg"] = ex.Message;
return(RedirectToAction("MasterVaccinationReminder", "MasterVaccinationReminder"));
}
return(RedirectToAction("MasterVaccinationReminder", "MasterVaccinationReminder"));
}
public bool Save(MasterVaccinationReminder obj)
{
Connect();
try
{
#region IUMasterVaccinationReminder
SqlCommand cmd = new SqlCommand("IUMasterVaccinationReminder", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
cmd.Parameters.AddWithValue("@MasterVaccinationReminderID", 0);
cmd.Parameters["@MasterVaccinationReminderID"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("@MasterVaccinationReminderName", obj.MasterVaccinationReminderName);
cmd.Parameters.AddWithValue("@ReferenceCode", DBNull.Value);
cmd.Parameters.AddWithValue("@Advise", obj.Advice);
cmd.Parameters.AddWithValue("@CreationID", UserID);
cmd.Parameters.AddWithValue("@Mode", "Add");
con.Open();
int i = cmd.ExecuteNonQuery();
con.Close();
#endregion
varMasterVaccinationReminderID = Convert.ToInt32(cmd.Parameters["@MasterVaccinationReminderID"].Value.ToString());
if (varMasterVaccinationReminderID > 0)
{
if (obj.VaccinesName != null)
{
string[] vaccinesname = obj.VaccinesName.Split(',');
for (int k = 0; k < vaccinesname.Length; k++)
{
if (vaccinesname[k].ToString() != "")
{
#region IUMasterVaccinationReminderDetail
SqlCommand cmd1 = new SqlCommand("IUMasterVaccinationReminderDetail", con);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd1.Parameters.AddWithValue("@LocationID", LocationID);
cmd1.Parameters.AddWithValue("@MasterVaccinationReminderID", varMasterVaccinationReminderID);
cmd1.Parameters.AddWithValue("@MasterVaccinationReminderDetailID", 0);
cmd1.Parameters["@MasterVaccinationReminderDetailID"].Direction = ParameterDirection.Output;
cmd1.Parameters.AddWithValue("@VaccinesName", vaccinesname[k]);
//cmd1.Parameters.AddWithValue("@DueDate",null);
//cmd1.Parameters.AddWithValue("@GivenDate",null);
//cmd1.Parameters.AddWithValue("@HealthCheckupDate", null);
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);
}
}
