/// <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 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 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 List <VPatients> Getpatients_byage(int age)
{
using (_context = new PHCEntities())
{
var d = DateTime.Now.AddYears(-age);
List <VPatients> patient = new List <VPatients>();
var dbpatients = _context.Patients.Where(t => t.DOB >= d);
foreach (var dbpatient in dbpatients)
{
patient.Add(new VPatients()
{
ID = dbpatient.ID,
Title = dbpatient.Title,
Surname = dbpatient.Surname,
Othernames = dbpatient.OtherNames,
Gender = dbpatient.Gender,
DOB = dbpatient.DOB,
Occupationid = dbpatient.OccupationID,
Occupation = dbpatient.Occupations?.Occupation,
Enrollmentdate = dbpatient.EnrollmentDate,
Enrollmentnumber = dbpatient.EnrollmentNumber
});
}
return(patient);
}
}
public List <VPatients> Getpatients(int id)
{
using (_context = new PHCEntities())
{
List <VPatients> patient = new List <VPatients>();
var dbpatients = _context.Patients.Where(t => t.ID == id);
foreach (var dbpatient in dbpatients)
{
patient.Add(new VPatients()
{
ID = dbpatient.ID,
Title = dbpatient.Title,
Surname = dbpatient.Surname,
Othernames = dbpatient.OtherNames,
Gender = dbpatient.Gender,
DOB = dbpatient.DOB,
//Cellphone = dbpatient.Cellphone,
//Cellphone2 = dbpatient.Cellphone2,
//Email = dbpatient.Email,
Occupationid = dbpatient.OccupationID,
Occupation = dbpatient.Occupations?.Occupation,
Enrollmentdate = dbpatient.EnrollmentDate,
Enrollmentnumber = dbpatient.EnrollmentNumber
});
}
return(patient);
}
}
/// <summary>
/// Returns a single user by facebookId
/// </summary>
/// <param name="fbId"></param>
/// <returns></returns>
public override FbDTO GetUserByFacebookId(string fbId)
{
using (var context = new PHCEntities())
{
FbDTO fb = new FbDTO();
var usr = context.Users.Where(p => p.fbid == fbId).SingleOrDefault();
if (usr == null)
{
return(fb);
}
fb.UID = usr.UID;
fb.Email = usr.Email;
fb.Fname = usr.FirstName;
fb.Lname = usr.LastName;
fb.Sex = usr.Gender;
fb.acctoken = usr.acesstoken;
fb.fbid = usr.fbid;
fb.SharedToFacebookOn = usr.SharedToFacebookOn.HasValue ? usr.SharedToFacebookOn.Value : DateTime.MinValue;
fb.SharedToPinterestOn = usr.SharedToPinterestOn.HasValue ? usr.SharedToPinterestOn.Value : DateTime.MinValue;
fb.SharedToTwitterOn = usr.SharedToTwitterOn.HasValue ? usr.SharedToTwitterOn.Value : DateTime.MinValue;
return(fb);
}
}
public override ChallengeDTO ChkChallengebyDate(DateTime dt)
{
using (var context = new PHCEntities())
{
try
{
ChallengeDTO dto = new ChallengeDTO();
Challenge ch = context.Challenges.Where(u => u.ChallengeCreatedDate == dt).SingleOrDefault();
if (ch != null)
{
dto.CHID = ch.CHID;
dto.ChallengeName = ch.ChallengeName;
dto.Description = ch.Description;
dto.BID = Convert.ToInt32(ch.BadgeID);
dto.catchImg = ch.CatChallengeImage;
dto.dogchImg = ch.DogChallengeImage;
dto.CatDescription = ch.CatDescription;
return(dto);
}
else
{
return(null);
}
}
catch (Exception ex)
{
throw ex;
}
}
}
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 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 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 override ChallengeDTO Edit_challenge(int id)
{
using (var context = new PHCEntities())
{
try
{
ChallengeDTO adto = new ChallengeDTO();
Challenge chl = new Challenge();
chl = context.Challenges.Where(p => p.CHID == id).SingleOrDefault();
if (chl != null)
{
adto.CHID = chl.CHID;
adto.ChallengeName = chl.ChallengeName;
adto.Description = chl.Description;
adto.catchImg = chl.CatChallengeImage;
adto.dogchImg = chl.DogChallengeImage;
adto.ChcreatedDate = Convert.ToDateTime(chl.ChallengeCreatedDate);
string dob = null;
dob = string.Format("{0:MM/dd/yyyy}", adto.ChcreatedDate);
adto.SChcreatedDate = dob;
adto.BID = Convert.ToInt32(chl.BadgeID);
adto.chnamehidden = chl.ChallengeName;
adto.CatDescription = chl.CatDescription;
}
return(adto);
}
catch (Exception)
{
throw;
}
}
}
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 override RewardsDTO Edit_Wall(int id)
{
using (var context = new PHCEntities())
{
try
{
RewardsDTO dto = new RewardsDTO();
Wallpaper wall = new Wallpaper();
wall = context.Wallpapers.Where(p => p.WID == id).SingleOrDefault();
if (wall != null)
{
dto.WID = wall.WID;
dto.Title = wall.Title;
dto.WallImage = wall.WallImage;
}
return(dto);
}
catch (Exception ex)
{
throw ex;
}
}
}
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 badgeDTO Edit_badge(int id)
{
using (var context = new PHCEntities())
{
try
{
badgeDTO dto = new badgeDTO();
Badge badg = new Badge();
badg = context.Badges.Where(p => p.BId == id).SingleOrDefault();
if (badg != null)
{
dto.BID = badg.BId;
dto.Badgename = badg.Badgename;
dto.badgeImage = badg.Badgelogo;
dto.bnamehidden = badg.Badgename;
dto.cdescription = badg.CDescription;
dto.ldescription = badg.LDescription;
}
return(dto);
}
catch (Exception)
{
throw;
}
}
}
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 List <FbDTO> users_list()
{
using (var context = new PHCEntities())
{
List <FbDTO> ldto = new List <FbDTO>();
FbDTO dto = null;
try
{
List <User> usr = new List <User>();
usr = context.Users.ToList();
if (usr != null)
{
foreach (User u in usr)
{
dto = new FbDTO();
dto.Fname = u.FirstName;
dto.Lname = u.LastName;
dto.Sex = u.Gender;
dto.Email = u.Email;
dto.UID = u.UID;
dto.fbid = u.fbid;
ldto.Add(dto);
}
}
}
catch (Exception)
{
throw;
}
return(ldto);
}
}
public override List <badgeDTO> GetBadges_list()
{
using (var context = new PHCEntities())
{
List <badgeDTO> ldto = new List <badgeDTO>();
badgeDTO dto = null;
try
{
List <Badge> bdg = new List <Badge>();
bdg = context.Badges.ToList();
if (bdg != null)
{
foreach (Badge b in bdg)
{
dto = new badgeDTO();
dto.BID = b.BId;
dto.Badgename = b.Badgename;
dto.badgeImage = "~/Content/Uploads/Challenges/" + b.Badgelogo;
dto.createdDate = string.Format("{0:MM-dd/yyyy}", b.createdDate);
ldto.Add(dto);
}
}
}
catch (Exception)
{
throw;
}
return(ldto);
}
}
public override List <RewardsDTO> GetWall_list()
{
using (var context = new PHCEntities())
{
List <RewardsDTO> ldto = new List <RewardsDTO>();
RewardsDTO dto = null;
try
{
List <Wallpaper> bdg = new List <Wallpaper>();
bdg = context.Wallpapers.ToList();
if (bdg != null)
{
foreach (Wallpaper b in bdg)
{
dto = new RewardsDTO();
dto.WID = b.WID;
dto.Title = b.Title;
dto.WallImage = "~/Content/Uploads/Challenges/" + b.WallImage;
ldto.Add(dto);
}
}
}
catch (Exception)
{
throw;
}
return(ldto);
}
}
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 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 int usercount(FbDTO dto)
{
int cnt;
using (var context = new PHCEntities())
{
cnt = context.Users.Where(p => p.fbid == dto.fbid).Count();
}
return(cnt);
}
/// <summary>
/// Get prize by a pin
/// </summary>
/// <param name="ICGPin"></param>
/// <returns></returns>
public WallpaperDTO GetPrizeByPin(string ICGPin)
{
using (var context = new PHCEntities())
{
var prize = context.Wallpapers.Where(x => x.ICGPin == ICGPin).FirstOrDefault();
if (prize == null)
{
throw new Exception("Prize not found");
}
return(MapWallpapperToWallpaperDTO(prize));
}
}
/// <summary>
/// Gets a prize by Id
/// </summary>
/// <param name="prizeId"></param>
/// <returns></returns>
public WallpaperDTO GetPrize(int prizeId)
{
using (var context = new PHCEntities())
{
var prize = context.Wallpapers.Where(x => x.WID == prizeId).FirstOrDefault();
if (prize == null)
{
throw new Exception("Prize not found");
}
return(MapWallpapperToWallpaperDTO(prize));
}
}
/// <summary>
/// Returns the user specfic reward of this prize
/// </summary>
/// <param name="userId"></param>
/// <param name="prizeId"></param>
/// <returns></returns>
public RewardsDTO GetReward(int userId, int prizeId)
{
using (var context = new PHCEntities())
{
var prize = context.Rewards.Where(x => x.WID == prizeId && x.UID == userId).FirstOrDefault();
if (prize == null)
{
return(new RewardsDTO());
}
return(MapRewardToRewardDTO(prize));
}
}
/// <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 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 int Badge_count(string bname)
{
int cnt = 0;
using (var context = new PHCEntities())
{
try
{
cnt = context.Badges.Where(p => p.Badgename == bname).Count();
}
catch (Exception)
{
throw;
}
return(cnt);
}
}
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);
}
}
