private void btnAdd_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrWhiteSpace(tbxMarital.Text))
{
errorProviderMarital.SetError(tbxMarital, "Add Marital Status!");
return;
}
else
{
MaritalStatu marital = new MaritalStatu
{
Name = tbxMarital.Text
};
db.MaritalStatus.Add(marital);
db.SaveChanges();
updateInfo();
clearTxt();
}
}
catch (Exception ex)
{
MessageBox.Show("Please try again after 2 minutes!");
File.AppendAllText(path, "\n" + ex + ":" + DateTime.Now);
return;
}
}
public ActionResult Create(MaritalStatu maritalStatu)
{
try
{
MaritalStatu m = db.MaritalStatus.FirstOrDefault(de => de.MaritalStatusName == maritalStatu.MaritalStatusName);
if (m == null)
{
maritalStatu.CreatedBy = Convert.ToInt32(Session["emp_id"]);
maritalStatu.CreatedOn = DateTime.Now;
db.MaritalStatus.Add(maritalStatu);
try
{
db.SaveChanges();
ViewBag.MessageType = "success";
ViewBag.Message = "Data has been saved successfully.";
}
catch (DbUpdateException ex)
{
ViewBag.MessageType = "error";
ViewBag.Message = ex.Message;
ModelState.AddModelError(string.Empty, ex.Message);
}
}
else
{
ModelState.AddModelError(string.Empty, "Marital Status is already exists.");
ViewBag.MessageType = "error";
ViewBag.Message = "Marital Status is already exists.";
}
}
catch (DbEntityValidationException ex)
{
string ErrorMessage = "";
int count = 0;
foreach (DbEntityValidationResult validationResult in ex.EntityValidationErrors)
{
string entityName = validationResult.Entry.Entity.GetType().Name;
foreach (DbValidationError error in validationResult.ValidationErrors)
{
ModelState.AddModelError(string.Empty, error.ErrorMessage);
count++;
ErrorMessage += count + "-" + string.Concat(error.PropertyName, " is required.") + "<br />";
}
}
ViewBag.MessageType = "error";
ViewBag.Message = ErrorMessage;
}
model.MaritalStatus = db.MaritalStatus.OrderByDescending(a => a.MaritalStatusID).ToList();
model.SelectedMaritalStatu = null;
model.DisplayMode = "WriteOnly";
ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", maritalStatu.IsActive);
return(View("Index", model));
}
public override T ObjectConvert <T, U>(U entity)
{
MaritalStatu Mstatus = entity as MaritalStatu;
if (Mstatus == null)
{
return(default(T));
}
BO.Common.MaritalStatus MstatusBO = new BO.Common.MaritalStatus();
MstatusBO.ID = Mstatus.Id;
MstatusBO.StatusText = Mstatus.StatusText;
MstatusBO.IsDeleted = Mstatus.IsDeleted;
return((T)(object)MstatusBO);
}
public ActionResult Edit(MaritalStatu maritalStatu)
{
try
{
db.Entry(maritalStatu).State = EntityState.Modified;
maritalStatu.ModifiedBy = Convert.ToInt32(Session["emp_id"]);
maritalStatu.ModifiedOn = DateTime.Now;
try
{
db.SaveChanges();
ViewBag.MessageType = "success";
ViewBag.Message = "Data has been saved successfully.";
}
catch (DbUpdateException ex)
{
ViewBag.MessageType = "error";
ViewBag.Message = ex.Message;
ModelState.AddModelError(string.Empty, ex.Message);
}
}
catch (DbEntityValidationException ex)
{
string ErrorMessage = "";
int count = 0;
foreach (DbEntityValidationResult validationResult in ex.EntityValidationErrors)
{
string entityName = validationResult.Entry.Entity.GetType().Name;
foreach (DbValidationError error in validationResult.ValidationErrors)
{
ModelState.AddModelError(string.Empty, error.ErrorMessage);
count++;
ErrorMessage += string.Concat(count, "-", error.ErrorMessage, "\n");
}
}
ViewBag.MessageType = "error";
ViewBag.Message = ErrorMessage;
}
model.MaritalStatus = db.MaritalStatus.OrderByDescending(a => a.MaritalStatusID).ToList();
model.SelectedMaritalStatu = null;
model.DisplayMode = "WriteOnly";
ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", maritalStatu.IsActive);
return(View("Index", model));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
MaritalStatu maritalStatu = db.MaritalStatus.Find(id);
if (maritalStatu == null)
{
return(HttpNotFound());
}
model.MaritalStatus = db.MaritalStatus.OrderByDescending(a => a.MaritalStatusID).ToList();
model.SelectedMaritalStatu = maritalStatu;
model.DisplayMode = "Delete";
ViewBag.MessageType = "";
ViewBag.Message = "";
return(View("Index", model));
}
private void dgvMarital_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
try
{
int id = (int)dgvMarital.Rows[e.RowIndex].Cells[0].Value;
selectedMarital = db.MaritalStatus.Where(w => w.ID == id).FirstOrDefault();
tbxMarital.Text = selectedMarital.Name;
btnAdd.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("Please try again after 2 minutes!");
File.AppendAllText(path, "\n" + ex + ":" + DateTime.Now);
return;
}
}
public ActionResult DeleteConfirmed(int id)
{
try
{
MaritalStatu maritalStatu = db.MaritalStatus.Find(id);
db.MaritalStatus.Remove(maritalStatu);
db.SaveChanges();
ViewBag.MessageType = "success";
ViewBag.Message = "Record has been removed successfully.";
}
catch (DbUpdateException ex)
{
ViewBag.MessageType = "error";
ViewBag.Message = ex.Message;
ModelState.AddModelError(string.Empty, ex.Message);
}
model.MaritalStatus = db.MaritalStatus.OrderByDescending(a => a.MaritalStatusID).ToList();
model.SelectedMaritalStatu = null;
model.DisplayMode = "WriteOnly";
ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc");
return(View("Index", model));
}
public void SeedPatientDemographics()
{
string[] relations = new string[] { "Son", "Daughter", "Father", "Mother", "Brother", "Sister" };
if (db.Relationships.ToList().Count() < relations.Count())
{
var realationship = new Relationship();
foreach (var rel in relations)
{
if (db.Relationships.FirstOrDefault(e => e.RelationshipName.Trim().ToLower().Equals(rel.ToLower().Trim())) == null)
{
realationship.RelationshipName = rel;
db.Relationships.Add(realationship);
db.SaveChanges();
}
}
}
string[] bloodGroups = new string[] { "A+", "A-", "B+", "B-", "AB+", "AB-", "O+", "O-" };
if (db.Relationships.ToList().Count() < bloodGroups.Count())
{
var bg = new BloodGroup();
foreach (var bgName in bloodGroups)
{
if (db.BloodGroups.FirstOrDefault(e =>
e.BloodGroupName.Trim().ToLower().Equals(bgName.ToLower().Trim())) == null)
{
bg.BloodGroupName = bgName;
db.BloodGroups.Add(bg);
db.SaveChanges();
}
}
}
string[] religions = new string[] { "Christian", "Muslim", "Hindu" };
if (db.Religions.ToList().Count() < religions.Count())
{
var r = new Religion();
foreach (var rName in religions)
{
if (db.Religions.FirstOrDefault(e =>
e.ReligionName.Trim().ToLower().Equals(rName.ToLower().Trim())) == null)
{
r.ReligionName = rName;
db.Religions.Add(r);
db.SaveChanges();
}
}
}
string[] maritals = new string[] { "Single", "Married", "Separated", "Divorced", "Widowed", "Baby", "Prefer not to answer" };
if (db.MaritalStatus.ToList().Count() < maritals.Count())
{
var m = new MaritalStatu();
foreach (var mName in maritals)
{
if (db.MaritalStatus.FirstOrDefault(e =>
e.MaritalStatusName.Trim().ToLower().Equals(mName.ToLower().Trim())) == null)
{
m.MaritalStatusName = mName;
db.MaritalStatus.Add(m);
db.SaveChanges();
}
}
}
string[] idTypes = new string[] { "National Card", "License", "Birth Cirtificate" };
if (db.IdentificationTypes.ToList().Count() < idTypes.Count())
{
var it = new IdentificationType();
foreach (var itName in idTypes)
{
if (db.IdentificationTypes.FirstOrDefault(e =>
e.IdentificationTypeName.Trim().ToLower().Equals(itName.ToLower().Trim())) == null)
{
it.IdentificationTypeName = itName;
db.IdentificationTypes.Add(it);
db.SaveChanges();
}
}
}
}
