public string UpdateSpouse(SpouseModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
try
{
var data = db.spouses.FirstOrDefault(x => x.id == model.SpouseId);
data.lastname = model.SpouseLastName;
data.firstname = model.SpouseFirstName;
data.middlename = model.SpouseMiddleName;
data.date_of_birth = model.SpouseDateOfBirth;
data.occupation = model.SpouseOccupation;
data.employer = model.SpouseEmployer;
data.employer_address = model.SpouseEmployerAddress;
data.employer_contact = model.SpouseEmployerContact;
data.monthly_income = model.SpouseMonthlyIncome;
data.contact_numbers = model.SpouseContactNumber;
data.employment_status = model.SpouseEmploymentStatus;
db.SaveChanges();
return(_resultHelper.Success());
}
catch (Exception ex)
{
return(ex.Message);
}
}
}
public ActionResult GetSpouseDetail(int Id)
{
SpouseModel model = new SpouseModel();
model = _memberManager.GetSpouseDetail(Id);
model.SpouseIsEditMode = true;
return(PartialView("~/Views/Member/CreateSpouse.cshtml", model));
}
public ActionResult CreateSpouse(int?id)
{
int Id_ = NullIdProcessor(id);
var model = new SpouseModel();
model.SpouseMemberId = Id_;
return(PartialView("~/Views/Member/CreateSpouse.cshtml", model));
}
public ActionResult UpdateSpouse(SpouseModel model)
{
var message = "message";
var result = "result";
result = _memberManager.UpdateSpouse(model);
if (model != null && ModelState.IsValid)
{
message = result;
}
else
{
message = ModelState.ModelErrors();
}
return(Json(new { message = message, result = result }));
}
public ActionResult SaveSpouse(SpouseModel model)
{
var message = "message";
var result = "result";
model.SpouseCreatedByUserId = ActiveUser.UserId;
result = _memberManager.SaveSpouse(model);
if (model != null && ModelState.IsValid)
{
message = result;
}
else
{
message = ModelState.ModelErrors();
}
return(Json(new { message = message, result = result }));
}
public string SaveSpouse(SpouseModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
try
{
var data = db.spouses.Create();
data.lastname = model.SpouseLastName;
data.firstname = model.SpouseFirstName;
data.middlename = model.SpouseMiddleName;
data.date_of_birth = model.SpouseDateOfBirth;
data.occupation = model.SpouseOccupation;
data.employer = model.SpouseEmployer;
data.employer_address = model.SpouseEmployerAddress;
data.employer_contact = model.SpouseEmployerContact;
data.monthly_income = model.SpouseMonthlyIncome;
data.contact_numbers = model.SpouseContactNumber;
data.employment_status = model.SpouseEmploymentStatus;
data.member_id = model.SpouseMemberId;
data.created_by_user_id = model.SpouseCreatedByUserId;
data.date_started = DateTime.Now;
db.spouses.Add(data);
db.SaveChanges();
//Save if no issues
dbTran.Commit();
return(_resultHelper.Success());
}
catch (Exception ex)
{
dbTran.Rollback();
return(ex.Message);
}
}
}
}
public SpouseModel GetSpouseDetail(int id)
{
nasccoEntities db = new nasccoEntities();
SpouseModel model = new SpouseModel();
var c = db.spouses.FirstOrDefault(x => x.id == id);
if (c != null)
{
model.SpouseId = c.id;
model.SpouseLastName = c.lastname;
model.SpouseFirstName = c.firstname;
model.SpouseMiddleName = c.middlename;
model.SpouseDateOfBirth = c.date_of_birth;
model.SpouseOccupation = c.occupation;
model.SpouseEmployer = c.employer;
model.SpouseEmployerAddress = c.employer_address;
model.SpouseEmployerContact = c.employer_contact;
model.SpouseMonthlyIncome = c.monthly_income;
model.SpouseContactNumber = c.contact_numbers;
model.SpouseEmploymentStatus = c.employment_status;
model.SpouseMemberId = c.member_id;
}
return(model);
}
