public string Save(UserModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
try
{
var data = db.users.Create();
data.member_id = model.UserMemberId;
data.roles_id = model.RolesId;
data.statuses_id = model.UserStatusesId;
data.username = model.Username;
data.password = EncryptDecryptString.Encrypt(model.Password);
data.date_created = DateTime.Now;
data.created_by_user_id = model.CreatedByUserId;
db.users.Add(data);
db.SaveChanges();
//Save if no issues
dbTran.Commit();
return(_resultHelper.Success());
}
catch (Exception ex)
{
dbTran.Rollback();
return(ex.Message);
}
}
}
}
public string RemoveUser(int id)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
try
{
var record = (from x in db.users
where x.id == id
select x).FirstOrDefault();
db.users.Remove(record);
db.SaveChanges();
dbTran.Commit();
return(_resultHelper.Success());
}
catch (Exception ex)
{
dbTran.Rollback();
return(ex.Message);
}
}
}
}
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 string ChangePassword(UserModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
try
{
var data = db.users.FirstOrDefault(x => x.id == model.UserId);
data.password = EncryptDecryptString.Encrypt(model.Password);
db.SaveChanges();
//Save if no issues
dbTran.Commit();
return(_resultHelper.Success());
}
catch (Exception ex)
{
dbTran.Rollback();
return(ex.Message);
}
}
}
}
public string SaveReferences(ReferencesModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
try
{
var data = db.references.Create();
data.full_name = model.ReferencesFullName;
data.relation = model.ReferencesRelation;
data.address = model.ReferencesAddress;
data.contact_number = model.ReferencesContactNumber;
data.member_id = model.ReferencesMemberId;
data.created_by_user_id = model.ReferencesCreatedByUserId;
data.date_created = DateTime.Now;
db.references.Add(data);
db.SaveChanges();
//Save if no issues
dbTran.Commit();
return(_resultHelper.Success());
}
catch (Exception ex)
{
dbTran.Rollback();
return(ex.Message);
}
}
}
}
public string SaveMember(MemberModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
using (DbContextTransaction dbTran = db.Database.BeginTransaction())
{
try
{
var data = db.members.Create();
data.pmes_certificate_number = model.PmesCertificateNumber;
data.date_of_application = model.DateOfApplication;
data.lastname = model.LastName;
data.firstname = model.LastName;
data.middlename = model.MiddleName;
data.date_of_birth = model.DateOfBirth;
data.place_of_birth = model.PlaceOfBirth;
data.height = model.Heigth;
data.weight = model.Weight;
data.tin = model.Tin;
data.sss_number = model.SssNumber;
data.others_id = model.OthersId;
data.weight = model.Weight;
data.tin = model.Tin;
data.highest_education = model.HighestEducation;
data.course = model.Course;
data.present_address = model.PresentAddress;
data.address_status = model.AddressStatus;
data.provincial_address = model.ProvincialAddress;
data.present_address_lenght_of_time = model.PresentAddressLengthOfTime;
data.contact_numbers = model.ContactNumbers;
data.email_address = model.EmailAddress;
data.statuses_id = model.StatusesId;
data.employee_id = model.EmployeeId;
data.created_by_user_id = model.CreatedByUserId;
db.members.Add(data);
db.SaveChanges();
//Save if no issues
dbTran.Commit();
return(_resultHelper.Success());
}
catch (Exception ex)
{
dbTran.Rollback();
return(ex.Message);
}
}
}
}
public string Update(MemberModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
try
{
var data = db.members.FirstOrDefault(x => x.id == model.MemberId);
data.pmes_certificate_number = model.PmesCertificateNumber;
data.date_of_application = model.DateOfApplication;
data.lastname = model.LastName;
data.firstname = model.FirstName;
data.middlename = model.MiddleName;
data.date_of_birth = model.DateOfBirth;
data.place_of_birth = model.PlaceOfBirth;
data.height = model.Heigth;
data.weight = model.Weight;
data.tin = model.Tin;
data.sss_number = model.SssNumber;
data.others_id = model.OthersId;
data.weight = model.Weight;
data.tin = model.Tin;
data.highest_education = model.HighestEducation;
data.course = model.Course;
data.present_address = model.PresentAddress;
data.address_status = model.AddressStatus;
data.provincial_address = model.ProvincialAddress;
data.present_address_lenght_of_time = model.PresentAddressLengthOfTime;
data.contact_numbers = model.ContactNumbers;
data.email_address = model.EmailAddress;
data.statuses_id = model.StatusesId;
data.employee_id = model.EmployeeId;
db.SaveChanges();
return(_resultHelper.Success());
}
catch (Exception ex)
{
return(ex.Message);
}
}
}
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 string Update(UserModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
try
{
var data = db.users.FirstOrDefault(x => x.id == model.UserId);
data.member_id = model.UserMemberId;
data.roles_id = model.RolesId;
data.statuses_id = model.UserStatusesId;
data.username = model.Username;
db.SaveChanges();
return(_resultHelper.Success());
}
catch (Exception ex)
{
return(ex.Message);
}
}
}
public string UpdateReferences(ReferencesModel model)
{
ResultHelper _resultHelper = new ResultHelper();
using (var db = new nasccoEntities())
{
try
{
var data = db.references.FirstOrDefault(x => x.id == model.ReferencesId);
data.full_name = model.ReferencesFullName;
data.relation = model.ReferencesRelation;
data.address = model.ReferencesAddress;
data.contact_number = model.ReferencesContactNumber;
db.SaveChanges();
return(_resultHelper.Success());
}
catch (Exception ex)
{
return(ex.Message);
}
}
}