/// <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); } }