public VNok Add(VNok nok)
{
using (_context)
{
var newnok = new NextOfKins()
{
CellphoneNumber = nok.Cellphone,
Email = nok.Email,
OtherNames = nok.Othernames,
Surname = nok.Surname,
PatientID = nok.Patientid,
Active = true
};
_context.NextOfKins.Add(newnok);
_context.SaveChanges();
nok.ID = newnok.ID;
base.Audittrail(new VAuditTrails()
{
Action = "Insert",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "NextOfKins",
RecordID = nok.ID,
Record = JsonConvert.SerializeObject(nok)
});
return(nok);
}
}
public VContacts UpdatePatientContacts(VContacts contacts)
{
using (_context)
{
var dbcontacts = _context.Contacts.Where(t => t.PatientID == contacts.Patientid).FirstOrDefault();
if (dbcontacts != null)
{
dbcontacts.Cellphone = contacts.Cellphone;
dbcontacts.Cellphone2 = contacts.Cellphone2;
dbcontacts.Email = contacts.Email;
_context.SaveChanges();
base.Audittrail(new VAuditTrails()
{
Action = "Update",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Contacts",
RecordID = dbcontacts.ID,
Record = JsonConvert.SerializeObject(contacts)
});
}
else
{
var newcontact = new Contacts()
{
PatientID = contacts.Patientid,
Cellphone = contacts.Cellphone,
Cellphone2 = contacts.Cellphone2,
Email = contacts.Email,
Active = true
};
_context.Contacts.Add(newcontact);
_context.SaveChanges();
base.Audittrail(new VAuditTrails()
{
Action = "Insert",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Contacts",
RecordID = dbcontacts.ID,
Record = JsonConvert.SerializeObject(contacts)
});
}
return(contacts);
}
}
/// <summary>
/// Updates a user and ensures the share fields are included
/// </summary>
/// <param name="dto"></param>
public override void UserUpdateForShare(FbDTO dto)
{
using (var context = new PHCEntities())
{
User usr = context.Users.Where(p => p.fbid == dto.fbid).SingleOrDefault();
if (usr != null)
{
usr.FirstName = dto.Fname;
usr.LastName = dto.Lname;
usr.Gender = dto.Sex;
usr.Email = dto.Email;
usr.fbid = dto.fbid;
usr.acesstoken = dto.acctoken;
if (dto.SharedToFacebookOn > DateTime.MinValue)
{
usr.SharedToFacebookOn = dto.SharedToFacebookOn;
}
if (dto.SharedToPinterestOn > DateTime.MinValue)
{
usr.SharedToPinterestOn = dto.SharedToPinterestOn;
}
if (dto.SharedToTwitterOn > DateTime.MinValue)
{
usr.SharedToTwitterOn = dto.SharedToTwitterOn;
}
context.SaveChanges();
}
}
}
public override string Save_challenge(ChallengeDTO dto)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Challenge ch = new Challenge();
ch.ChallengeName = dto.ChallengeName;
ch.Description = dto.Description;
ch.CatDescription = dto.CatDescription;
ch.DogChallengeImage = dto.dogchImg;
ch.CatChallengeImage = dto.catchImg;
ch.BadgeID = dto.BID;
ch.ChallengeCreatedDate = dto.ChcreatedDate;
context.AddToChallenges(ch);
context.SaveChanges();
msg = "success";
}
catch (Exception)
{
msg = "fail";
}
return(msg);
}
}
public void UpdateBiodata(VPatients patient)
{
using (_context = new PHCEntities())
{
var dbpatient = _context.Patients.Where(t => t.ID == patient.ID).FirstOrDefault();
if (dbpatient != null)
{
dbpatient.Title = patient.Title;
dbpatient.Surname = patient.Surname;
dbpatient.OtherNames = patient.Othernames;
dbpatient.Gender = patient.Gender;
dbpatient.DOB = patient.DOB;
dbpatient.EnrollmentNumber = patient.Enrollmentnumber;
dbpatient.EnrollmentDate = patient.Enrollmentdate;
dbpatient.OccupationID = patient.Occupationid;
_context.SaveChanges();
base.Audittrail(new VAuditTrails()
{
Action = "Update",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Patients",
RecordID = dbpatient.ID,
Record = JsonConvert.SerializeObject(patient)
});
}
}
}
public void DeleteNok(int id)
{
using (_context = new PHCEntities())
{
var dbnok = _context.NextOfKins.Where(t => t.ID == id).FirstOrDefault();
if (dbnok != null)
{
dbnok.Active = false;
_context.SaveChanges();
base.Audittrail(new VAuditTrails()
{
Action = "Delete",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "NextOfKins",
RecordID = dbnok.ID,
Record = JsonConvert.SerializeObject(new VNok()
{
ID = dbnok.ID,
Othernames = dbnok.OtherNames,
Surname = dbnok.Surname,
Cellphone = dbnok.CellphoneNumber,
Email = dbnok.Email,
Patientid = dbnok.PatientID
})
});
}
}
}
public override string update_challenge(ChallengeDTO dto)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Challenge chl = new Challenge();
chl = context.Challenges.Where(p => p.CHID == dto.CHID).SingleOrDefault();
if (chl != null)
{
chl.CHID = dto.CHID;
chl.ChallengeName = dto.ChallengeName;
chl.Description = dto.Description;
chl.BadgeID = dto.BID;
chl.DogChallengeImage = dto.dogchImg;
chl.CatChallengeImage = dto.catchImg;
chl.ChallengeCreatedDate = Convert.ToDateTime(dto.SChcreatedDate);
chl.CatDescription = dto.CatDescription;
context.SaveChanges();
msg = "success";
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
}
public override FbDTO Save_user(FbDTO dto)
{
using (var context = new PHCEntities())
{
FbDTO fb = new FbDTO();
try
{
User usr = new User();
usr.FirstName = dto.Fname;
usr.LastName = dto.Lname;
usr.Gender = dto.Sex;
usr.Email = dto.Email;
usr.fbid = dto.fbid;
usr.acesstoken = dto.acctoken;
// usr.Address = dto.Address;
// usr.Link = dto.Link;
context.AddToUsers(usr);
context.SaveChanges();
fb.UID = usr.UID;
fb.Email = usr.Email;
fb.Fname = usr.FirstName;
fb.acctoken = usr.acesstoken;
fb.fbid = usr.fbid;
}
catch (Exception)
{
throw;
}
return(fb);
}
}
public override string Update_Wall(RewardsDTO dto)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Wallpaper wall = new Wallpaper();
wall = context.Wallpapers.Where(p => p.WID == dto.WID).SingleOrDefault();
if (wall != null)
{
wall.Title = dto.Title;
wall.WallImage = dto.WallImage;
context.SaveChanges();
msg = "success";
}
}
catch (Exception ex)
{
msg = ex.Message;
}
}
return(msg);
}
public override string Update_badge(badgeDTO dto)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Badge bdg = new Badge();
bdg = context.Badges.Where(p => p.BId == dto.BID).SingleOrDefault();
if (bdg != null)
{
bdg.Badgename = dto.Badgename;
bdg.Badgelogo = dto.badgeImage;
bdg.createdDate = DateTime.Now;
bdg.CDescription = dto.cdescription;
bdg.LDescription = dto.ldescription;
context.SaveChanges();
msg = "success";
}
}
catch (Exception ex)
{
msg = ex.Message;
}
}
return(msg);
}
public void DeleteContact(int id)
{
using (_context = new PHCEntities())
{
var dbcontact = _context.Contacts.Where(t => t.ID == id).FirstOrDefault();
if (dbcontact != null)
{
dbcontact.Active = false;
_context.SaveChanges();
base.Audittrail(new VAuditTrails()
{
Action = "Delete",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Contacts",
RecordID = dbcontact.ID,
Record = JsonConvert.SerializeObject(new VContacts()
{
Cellphone2 = dbcontact.Cellphone2,
Cellphone = dbcontact.Cellphone,
Email = dbcontact.Email,
Patientid = dbcontact.PatientID
})
});
}
}
}
public override string Save_badge(badgeDTO dto)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Badge bg = new Badge();
bg.Badgename = dto.Badgename;
bg.Badgelogo = dto.badgeImage;
bg.createdDate = DateTime.Now;
bg.CDescription = dto.cdescription;
bg.LDescription = dto.ldescription;
context.AddToBadges(bg);
context.SaveChanges();
msg = "success";
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
}
public override int UpdateUID(PetProfileDTO dt)
{
using (var context = new PHCEntities())
{
try
{
PetProfile pp = context.PetProfiles.Where(p => p.PID == dt.PID).SingleOrDefault();
if (pp != null)
{
pp.UID = dt.UID;
context.SaveChanges();
int c = pp.PID;
return(c);
}
else
{
return(0);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
public void MakeNOKpatient(int id)
{
var nok = _context.NextOfKins.Where(t => t.ID == id).FirstOrDefault();
if (nok != null)
{
var newpatient = new Patients()
{
Surname = nok.Surname,
OtherNames = nok.OtherNames,
Active = true
};
_context.Patients.Add(newpatient);
_context.SaveChanges();
var newpatientcontact = new Contacts()
{
PatientID = newpatient.ID,
Cellphone = nok.CellphoneNumber,
Active = true
};
_context.Contacts.Add(newpatientcontact);
_context.SaveChanges();
base.Audittrail(new VAuditTrails()
{
Action = "Insert",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Patients",
RecordID = newpatient.ID,
Record = JsonConvert.SerializeObject(new VPatients()
{
ID = newpatient.ID,
Othernames = newpatient.OtherNames,
Surname = newpatient.Surname,
})
});
}
}
public virtual void Audittrail(VAuditTrails audit)
{
_context.AuditTrails.Add(new AuditTrails()
{
Action = audit.Action,
Actionby = audit.ActionBy,
ActionDate = audit.ActionDate,
Record = audit.Record,
RecordTable = audit.RecordTable,
RecordID = audit.RecordID
});
_context.SaveChanges();
}
/// <summary>
/// Indicates this prize has been received
/// </summary>
/// <param name="userId"></param>
/// <param name="prizeId"></param>
public void MarkPrizeAsRedeemed(int userId, int prizeId)
{
using (var context = new PHCEntities())
{
var reward = context.Rewards.Where(x => x.UID == userId && x.WID == prizeId).FirstOrDefault();
if (reward == null)
{
return;
}
reward.DateClaimed = DateTime.UtcNow;
context.SaveChanges();
}
}
public VOccupations Add(VOccupations occupation)
{
using (_context)
{
var newoccupation = new Occupations()
{
Occupation = occupation.Occupation,
Active = true
};
_context.Occupations.Add(newoccupation);
_context.SaveChanges();
occupation.ID = newoccupation.ID;
return(occupation);
}
}
public void DeletePatient(int patientid)
{
using (_context = new PHCEntities())
{
var dbpatient = _context.Patients.Where(t => t.ID == patientid).FirstOrDefault();
if (dbpatient != null)
{
dbpatient.Active = false;
_context.SaveChanges();
base.Audittrail(new VAuditTrails()
{
Action = "Delete",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Patients",
RecordID = dbpatient.ID,
Record = JsonConvert.SerializeObject(new VPatients()
{
DOB = dbpatient.DOB,
Enrollmentdate = dbpatient.EnrollmentDate,
Enrollmentnumber = dbpatient.EnrollmentNumber,
Gender = dbpatient.Gender,
ID = dbpatient.ID,
Occupationid = dbpatient.OccupationID,
Othernames = dbpatient.OtherNames,
Surname = dbpatient.Surname,
Title = dbpatient.Title
})
});
}
//Delete contacts
var contacts = dbpatient.Contacts;
foreach (var contact in contacts)
{
_contacts.DeleteContact(contact.ID);
}
//Delete NoK
var noks = dbpatient.NextOfKins;
foreach (var nok in noks)
{
_nok.DeleteNok(nok.ID);
}
}
}
public override string delete_badge(int id)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Badge bdg = new Badge();
bdg = context.Badges.Where(p => p.BId == id).SingleOrDefault();
if (bdg != null)
{
context.DeleteObject(bdg);
}
List <Challenge> profile = context.Challenges.Where(m => m.BadgeID == id).ToList();
if (profile != null)
{
foreach (Challenge n in profile)
{
context.DeleteObject(n);
}
}
List <PetEarnBadge> pearn = context.PetEarnBadges.Where(m => m.BID == id).ToList();
if (pearn != null)
{
foreach (PetEarnBadge n in pearn)
{
context.DeleteObject(n);
}
}
context.SaveChanges();
msg = "success";
}
catch (Exception ex)
{
msg = ex.Message;
}
}
return(msg);
}
public override string deleteuser(int id)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
User usr = context.Users.Where(p => p.UID == id).SingleOrDefault();
context.DeleteObject(usr);
List <PetEarnBadge> pern = context.PetEarnBadges.Where(k => k.UID == id).ToList();
if (pern != null)
{
foreach (PetEarnBadge c in pern)
{
context.DeleteObject(c);
}
}
List <PetProfile> profile = context.PetProfiles.Where(m => m.UID == id).ToList();
if (profile != null)
{
foreach (PetProfile n in profile)
{
context.DeleteObject(n);
}
}
context.SaveChanges();
msg = "success";
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
}
/// <summary>
/// Indicates that a user is now eligable for a particular reward/prize
/// </summary>
/// <param name="userId"></param>
/// <param name="prizeId"></param>
public void AssignPrizeToUser(int userId, int prizeId)
{
using (var context = new PHCEntities())
{
var reward = context.Rewards.Where(x => x.WID == prizeId && x.UID == userId).FirstOrDefault();
if (reward == null) // if there's not already an entry, then let's assign this prize
{
reward = new Reward()
{
DateUnlocked = DateTime.UtcNow,
UID = userId,
WID = prizeId
};
context.Rewards.AddObject(reward);
context.SaveChanges();
}
}
}
public VVillages Add(VVillages village)
{
using (_context)
{
var newvillage = new Villages()
{
WardID = village.Wardid,
Village = village.Village,
Active = true
};
_context.Villages.Add(newvillage);
_context.SaveChanges();
village.ID = newvillage.ID;
//village.Subcountyid = newvillage.Wards.SubCountyID;
//village.Countyid = newvillage.Wards.SubCounties.CountyID;
return(village);
}
}
public void UpdatePatientLocation(int patientid, int Villageid)
{
using (_context = new PHCEntities())
{
var dbpatient = _context.Patients.Where(t => t.ID == patientid).FirstOrDefault();
if (dbpatient != null)
{
dbpatient.LocationID = Villageid;
_context.SaveChanges();
base.Audittrail(new VAuditTrails()
{
Action = "Update",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Patients",
RecordID = dbpatient.ID,
Record = JsonConvert.SerializeObject(new { LocationID = Villageid })
});
}
}
}
public override FbDTO update_user(FbDTO dto)
{
using (var context = new PHCEntities())
{
FbDTO fb = new FbDTO();
try
{
User usr = context.Users.Where(p => p.fbid == dto.fbid).SingleOrDefault();
if (usr != null)
{
usr.FirstName = dto.Fname;
usr.LastName = dto.Lname;
usr.Gender = dto.Sex;
usr.Email = dto.Email;
usr.fbid = dto.fbid;
usr.acesstoken = dto.acctoken;
// usr.Address = dto.Address;
// usr.Link = dto.Link;
context.SaveChanges();
}
fb.UID = usr.UID;
fb.Email = usr.Email;
fb.Fname = usr.FirstName;
fb.acctoken = usr.acesstoken;
fb.fbid = usr.fbid;
}
catch (Exception)
{
throw;
}
return(fb);
}
}
public override PetProfileDTO SavePetDetSignUp(PetProfileDTO dto)
{
using (var context = new PHCEntities())
{
try
{
PetProfileDTO pdto = new PetProfileDTO();
PetProfile pp = new PetProfile();
pp.UID = dto.UID;
pp.PetName = dto.PetName;
pp.PetBreed = dto.PetBreed;
pp.PetCategory = dto.pcid.ToString();
context.AddToPetProfiles(pp);
context.SaveChanges();
pdto.PID = pp.PID;
return(pdto);
}
catch (Exception ex)
{
throw ex;
}
}
}
public override string Save_Wallpaper(RewardsDTO adto)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Wallpaper bg = new Wallpaper();
bg.Title = adto.Title;
bg.WallImage = adto.WallImage;
context.AddToWallpapers(bg);
context.SaveChanges();
msg = "success";
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
}
public VPatients AddBiodata(VPatients patient)
{
using (_context = new PHCEntities())
{
var newpatient = new Patients()
{
Title = patient.Title,
Surname = patient.Surname,
OtherNames = patient.Othernames,
Gender = patient.Gender,
DOB = patient.DOB,
EnrollmentNumber = patient.Enrollmentnumber,
EnrollmentDate = patient.Enrollmentdate,
OccupationID = patient.Occupationid,
Active = true
};
_context.Patients.Add(newpatient);
_context.SaveChanges();
patient.ID = newpatient.ID;
base.Audittrail(new VAuditTrails()
{
Action = "Insert",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Patients",
RecordID = patient.ID,
Record = JsonConvert.SerializeObject(patient)
});
patient.Occupation = newpatient.Occupations?.Occupation;
}
return(patient);
}
public List <VVillages> AddPatientLocation(int patientid, int Villageid)
{
using (_context = new PHCEntities())
{
List <VVillages> villagelist = new List <VVillages>();
var dbpatient = _context.Patients.Include("Villages").Where(t => t.ID == patientid).FirstOrDefault();
if (dbpatient != null)
{
dbpatient.LocationID = Villageid;
_context.SaveChanges();
var patientvillage = dbpatient.Villages;
if (patientvillage != null)
{
villagelist.Add(new VVillages()
{
ID = patientvillage.ID,
Countyid = patientvillage.Wards.SubCounties.CountyID,
Subcountyid = patientvillage.Wards.SubCountyID,
Wardid = patientvillage.WardID,
Village = patientvillage.Village,
});
}
base.Audittrail(new VAuditTrails()
{
Action = "Update",
ActionBy = 1,
ActionDate = DateTime.Now,
RecordTable = "Patients",
RecordID = dbpatient.ID,
Record = JsonConvert.SerializeObject(new { LocationID = Villageid })
});
}
return(villagelist);
}
}
public override string delete_wall(int id)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Wallpaper wall = new Wallpaper();
wall = context.Wallpapers.Where(p => p.WID == id).SingleOrDefault();
if (wall != null)
{
context.DeleteObject(wall);
context.SaveChanges();
msg = "success";
}
}
catch (Exception ex)
{
msg = ex.Message;
}
}
return(msg);
}
public override string delete_challenge(int id)
{
string msg = "";
using (var context = new PHCEntities())
{
try
{
Challenge chl = new Challenge();
chl = context.Challenges.Where(p => p.CHID == id).SingleOrDefault();
if (chl != null)
{
context.DeleteObject(chl);
}
List <PetEarnBadge> pearn = context.PetEarnBadges.Where(m => m.CID == id).ToList();
if (pearn != null)
{
foreach (PetEarnBadge n in pearn)
{
context.DeleteObject(n);
}
}
msg = "success";
context.SaveChanges();
}
catch (Exception ex)
{
msg = ex.Message;
}
}
return(msg);
}
