public ActionResult DeleteConfirmed(int id)
{
BirthCertificate birthCertificate = db.BirthCertificates.Find(id);
db.BirthCertificates.Remove(birthCertificate);
db.SaveChanges();
return RedirectToAction("Index");
}
public ActionResult BirthCertificate(BirthCertificate cert)
{
try
{
string A = Request.Form["PatientName"];
TempData["Msg"] = "";
if (Request.Form["PatientName"] != null)
{
if (cert.CertificateNo > 0)
{
if (bl_birth.Save(cert))
{
cert.PatientName = "";
Session["CertificateNo"] = cert.CertificateNo;
return(RedirectToAction("RptBirthCertificate", "BirthCertificate"));
//TempData["Msg"] = "Update Successfully";
//ModelState.Clear();
//RedirectToAction("BirthCertificate", "BirthCertificate");
}
RedirectToAction("BirthCertificate", "BirthCertificate");
}
else
{
try
{
if (bl_birth.Save(cert))
{
if (cert.CertificateNo > 0)
{
cert.PatientName = "";
Session["CertificateNo"] = cert.CertificateNo;
return(RedirectToAction("RptBirthCertificate", "BirthCertificate"));
//TempData["Msg"] = "Update Successfully";
//ModelState.Clear();
//RedirectToAction("BirthCertificate", "BirthCertificate");
}
Session["CertificateNo"] = cert.CertificateNo;
return(RedirectToAction("RptBirthCertificate", "BirthCertificate"));
//TempData["Msg"] = "Save Successfully";
//RedirectToAction("BirthCertificate", "BirthCertificate");
}
}
catch (Exception ex)
{
TempData["Msg"] = ex.Message;
RedirectToAction("BirthCertificate", "BirthCertificate");
}
}
}
}
catch (Exception ex)
{
TempData["Msg"] = ex.Message;
return(RedirectToAction("BirthCertificate", "BirthCertificate"));
}
return(RedirectToAction("BirthCertificate", "BirthCertificate"));
}
public ActionResult Edit([Bind(Include = "BirthCertificateID,RegistrationDate,ExpirationDate,CivilStatus,PersonID,FatherID,MotherID")] BirthCertificate birthCertificate)
{
if (ModelState.IsValid)
{
db.Entry(birthCertificate).State = EntityState.Modified;
db.SaveChanges();
return RedirectToAction("Index");
}
ViewBag.FatherID = new SelectList(db.People, "PersonID", "PersonalNumber", birthCertificate.FatherID);
ViewBag.MotherID = new SelectList(db.People, "PersonID", "PersonalNumber", birthCertificate.MotherID);
ViewBag.PersonID = new SelectList(db.People, "PersonID", "PersonalNumber", birthCertificate.PersonID);
return View(birthCertificate);
}
// GET: BirthCertificates/Details/5
public ActionResult Details(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
BirthCertificate birthCertificate = db.BirthCertificates.Find(id);
if (birthCertificate == null)
{
return HttpNotFound();
}
return View(birthCertificate);
}
// GET: BirthCertificates/Edit/5
public ActionResult Edit(int? id)
{
if (id == null)
{
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
}
BirthCertificate birthCertificate = db.BirthCertificates.Find(id);
if (birthCertificate == null)
{
return HttpNotFound();
}
ViewBag.FatherID = new SelectList(db.People, "PersonID", "PersonalNumber", birthCertificate.FatherID);
ViewBag.MotherID = new SelectList(db.People, "PersonID", "PersonalNumber", birthCertificate.MotherID);
ViewBag.PersonID = new SelectList(db.People, "PersonID", "PersonalNumber", birthCertificate.PersonID);
return View(birthCertificate);
}
public bool Save(BirthCertificate birth)
{
Connect();
con.Open();
SqlCommand cmd = new SqlCommand("IUPatientBirthCertificate", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@HospitalID", HospitalID);
cmd.Parameters.AddWithValue("@LocationID", LocationID);
if (birth.CertificateNo == 0)
{
cmd.Parameters.AddWithValue("@CertificateNo", 0);
cmd.Parameters["@CertificateNo"].Direction = ParameterDirection.Output;
cmd.Parameters.AddWithValue("Mode", "ADD");
}
else
{
cmd.Parameters.AddWithValue("@CertificateNo", birth.CertificateNo);
cmd.Parameters.AddWithValue("Mode", "Edit");
}
cmd.Parameters.AddWithValue("@ReferenceCode", ReffrenceCode());
cmd.Parameters.AddWithValue("@PatientRegNo", birth.PatientRegNo);
cmd.Parameters.AddWithValue("@PatientName", birth.PatientName);
if (birth.Cast != null)
{
cmd.Parameters.AddWithValue("@Cast", birth.Cast);
}
else
{
cmd.Parameters.AddWithValue("@Cast", "");
}
if (birth.Date != null)
{
cmd.Parameters.AddWithValue("@Date", birth.Date);
}
else
{
cmd.Parameters.AddWithValue("@Date", "");
}
if (birth.MotherName != null)
{
cmd.Parameters.AddWithValue("@MotherName", birth.MotherName);
}
else
{
cmd.Parameters.AddWithValue("@MotherName", "");
}
if (birth.FatherName != null)
{
cmd.Parameters.AddWithValue("@FatherName", birth.FatherName);
}
else
{
cmd.Parameters.AddWithValue("@FatherName", "");
}
if (birth.Address != null)
{
cmd.Parameters.AddWithValue("@Address", birth.Address);
}
else
{
cmd.Parameters.AddWithValue("@Address", "");
}
if (birth.MAge != null)
{
cmd.Parameters.AddWithValue("@MAge", birth.MAge);
}
else
{
cmd.Parameters.AddWithValue("@MAge", "");
}
if (birth.MNationality != null)
{
cmd.Parameters.AddWithValue("@MNationality", birth.MNationality);
}
else
{
cmd.Parameters.AddWithValue("@MNationality", "");
}
if (birth.MReligion != null)
{
cmd.Parameters.AddWithValue("@MReligion", birth.MReligion);
}
else
{
cmd.Parameters.AddWithValue("@MReligion", "");
}
if (birth.MQualification != null)
{
cmd.Parameters.AddWithValue("@MQualification", birth.MQualification);
}
else
{
cmd.Parameters.AddWithValue("@MQualification", "");
}
if (birth.MOccuption != null)
{
cmd.Parameters.AddWithValue("@MOccuption", birth.MOccuption);
}
else
{
cmd.Parameters.AddWithValue("@MOccuption", "");
}
if (birth.FAge != null)
{
cmd.Parameters.AddWithValue("@FAge", birth.FAge);
}
else
{
cmd.Parameters.AddWithValue("@FAge", "");
}
if (birth.FNationality != null)
{
cmd.Parameters.AddWithValue("@FNationality", birth.FNationality);
}
else
{
cmd.Parameters.AddWithValue("@FNationality", "");
}
if (birth.FReligion != null)
{
cmd.Parameters.AddWithValue("@FReligion", birth.FReligion);
}
else
{
cmd.Parameters.AddWithValue("@FReligion", "");
}
if (birth.FQualification != null)
{
cmd.Parameters.AddWithValue("@FQualification", birth.FQualification);
}
else
{
cmd.Parameters.AddWithValue("@FQualification", "");
}
if (birth.FOccuption != null)
{
cmd.Parameters.AddWithValue("@FOccuption", birth.FOccuption);
}
else
{
cmd.Parameters.AddWithValue("@FOccuption", "");
}
if (birth.DOB1 != null)
{
cmd.Parameters.AddWithValue("@DOB1", birth.DOB1);
}
else
{
cmd.Parameters.AddWithValue("@DOB1", "");
}
if (birth.DOB2 != null)
{
cmd.Parameters.AddWithValue("@DOB2", birth.DOB2);
}
else
{
cmd.Parameters.AddWithValue("@DOB2", DBNull.Value);
}
if (birth.DOB3 != null)
{
cmd.Parameters.AddWithValue("@DOB3", birth.DOB3);
}
else
{
cmd.Parameters.AddWithValue("@DOB3", DBNull.Value);
}
if (birth.DOB4 != null)
{
cmd.Parameters.AddWithValue("@DOB4", birth.DOB4);
}
else
{
cmd.Parameters.AddWithValue("@DOB4", DBNull.Value);
}
if (birth.TOB1 != null)
{
cmd.Parameters.AddWithValue("@TOB1", birth.TOB1);
}
else
{
cmd.Parameters.AddWithValue("@TOB1", DBNull.Value);
}
if (birth.TOB2 != null)
{
cmd.Parameters.AddWithValue("@TOB2", birth.TOB2);
}
else
{
cmd.Parameters.AddWithValue("@TOB2", DBNull.Value);
}
if (birth.TOB3 != null)
{
cmd.Parameters.AddWithValue("@TOB3", birth.TOB3);
}
else
{
cmd.Parameters.AddWithValue("@TOB3", DBNull.Value);
}
if (birth.TOB4 != null)
{
cmd.Parameters.AddWithValue("@TOB4", birth.TOB4);
}
else
{
cmd.Parameters.AddWithValue("@TOB4", DBNull.Value);
}
if (birth.Weight1 != null)
{
cmd.Parameters.AddWithValue("@Weight1", birth.Weight1);
}
else
{
cmd.Parameters.AddWithValue("@Weight1", "");
}
if (birth.Weight2 != null)
{
cmd.Parameters.AddWithValue("@Weight2", birth.Weight2);
}
else
{
cmd.Parameters.AddWithValue("@Weight2", "");
}
if (birth.Weight3 != null)
{
cmd.Parameters.AddWithValue("@Weight3", birth.Weight3);
}
else
{
cmd.Parameters.AddWithValue("@Weight3", "");
}
if (birth.Weight4 != null)
{
cmd.Parameters.AddWithValue("@Weight4", birth.Weight4);
}
else
{
cmd.Parameters.AddWithValue("@Weight4", "");
}
if (birth.Sex1 != null)
{
cmd.Parameters.AddWithValue("@Sex1", birth.Sex1);
}
else
{
cmd.Parameters.AddWithValue("@Sex1", "");
}
if (birth.Sex2 != null)
{
cmd.Parameters.AddWithValue("@Sex2", birth.Sex2);
}
else
{
cmd.Parameters.AddWithValue("@Sex2", "");
}
if (birth.Sex3 != null)
{
cmd.Parameters.AddWithValue("@Sex3", birth.Sex3);
}
else
{
cmd.Parameters.AddWithValue("@Sex3", "");
}
if (birth.Sex4 != null)
{
cmd.Parameters.AddWithValue("@Sex4", birth.Sex4);
}
else
{
cmd.Parameters.AddWithValue("@Sex4", "");
}
if (birth.BirthPlace != null)
{
cmd.Parameters.AddWithValue("@BirthPlace", birth.BirthPlace);
}
else
{
cmd.Parameters.AddWithValue("@BirthPlace", "");
}
if (birth.DeliveryType != null)
{
cmd.Parameters.AddWithValue("@DeliveryType", birth.DeliveryType);
}
else
{
cmd.Parameters.AddWithValue("@DeliveryType", "");
}
if (birth.HODone != null)
{
cmd.Parameters.AddWithValue("@HODone", birth.HODone);
}
else
{
cmd.Parameters.AddWithValue("@HODone", "");
}
if (birth.Remarks != null)
{
cmd.Parameters.AddWithValue("@Remarks", birth.Remarks);
}
else
{
cmd.Parameters.AddWithValue("@Remarks", "");
}
if (birth.NoOfChild != null)
{
cmd.Parameters.AddWithValue("@NoOfChild", birth.NoOfChild);
}
else
{
cmd.Parameters.AddWithValue("@NoOfChild", "");
}
cmd.Parameters.AddWithValue("@CreationID", UserID);
int i = cmd.ExecuteNonQuery();
birth.CertificateNo = Convert.ToInt32(cmd.Parameters["@CertificateNo"].Value);
con.Close();
if (i > 0)
{
return(true);
}
else
{
return(false);
}
}
public IResult Update(BirthCertificate birthCertificate)
{
_birthCertificateDal.Update(birthCertificate);
return(new SuccessResult());
}
public IResult Delete(BirthCertificate birthCertificate)
{
throw new NotImplementedException();
}
public ActionResult BirthCertificateAdd(BirthCertificate birthCertificate)
{
_birthCertificateService.Add(birthCertificate);
return(RedirectToAction("birthCertificateGetList"));
}
public ActionResult BirthCertificateUpdate(BirthCertificate birthCertificate)
{
_birthCertificateService.Update(birthCertificate);
return(RedirectToAction(""));
}
