public static bool InsertPartner(Partner p) { NGOEntities e = new NGOEntities(); e.Partners.Add(p); return(e.SaveChanges() > 0 ? true : false); }
public static User GetUserLogin(string mail, string pass) { NGOEntities e = new NGOEntities(); var pwd = Encrypt.EncryptPasswordMD5(pass); return(e.Users.SingleOrDefault(s => s.UserMail == mail && s.UserPwd == pwd && s.UserActive == true)); }
public static List <UserDonate> GetDonateCurrentDay() { NGOEntities e = new NGOEntities(); var currDay = DateTime.Now; return(e.UserDonates.Where(w => DbFunctions.TruncateTime(w.DateCreate) == DbFunctions.TruncateTime(currDay)).ToList()); }
public static bool UpdateDonate(Donate d) { NGOEntities e = new NGOEntities(); var item = e.Donates.Find(d.ID); item.DonateName = d.DonateName; item.DonateContent = d.DonateContent; item.StartDay = d.StartDay; item.EndDay = d.EndDay; item.DonateHide = d.DonateHide; item.CateID = d.CateID; if (d.StartDay <= DateTime.Now && d.EndDay >= DateTime.Now) { d.DonateStatus = 2; } else if (d.EndDay < DateTime.Now) { d.DonateStatus = 3; } else if (d.StartDay > DateTime.Now) { d.DonateStatus = 1; } if (e.SaveChanges() > 0) { return(true); } return(false); }
public static List <Donate> GetDonates(int stt, int take) { NGOEntities e = new NGOEntities(); var ls = e.Donates.Where(s => s.DonateStatus == stt && s.DonateHide == true).OrderByDescending(o => o.DonateDateCreate).Take(take).ToList(); CheckStt(ls); var lsNew = e.Donates.Where(s => s.DonateStatus == stt && s.DonateHide == true).OrderByDescending(o => o.DonateDateCreate).Take(take).ToList(); return(lsNew); }
public static List <Donate> GetAllDonateByCate(int cate) { NGOEntities e = new NGOEntities(); var ls = e.Donates.Where(s => s.CateID == cate && s.DonateHide == false).OrderByDescending(o => o.DonateDateCreate).ToList(); CheckStt(ls); var lsNew = e.Donates.Where(s => s.CateID == cate && s.DonateHide == false).OrderByDescending(o => o.DonateDateCreate).ToList(); return(lsNew); }
public static bool DelImg(int id) { NGOEntities e = new NGOEntities(); e.ProgramImages.Remove(e.ProgramImages.Find(id)); if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateAU(AboutUs au) { NGOEntities e = new NGOEntities(); e.AboutUs1.Add(au); if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdatePartner(Partner p) { NGOEntities e = new NGOEntities(); var item = e.Partners.Find(p.ID); item.PartnerName = p.PartnerName; item.PartnerImage = p.PartnerImage; item.PartnerLink = p.PartnerLink; item.PartnerActive = p.PartnerActive; return(e.SaveChanges() > 0 ? true : false); }
public static bool InsertImg(ProgramImage pi) { NGOEntities e = new NGOEntities(); e.ProgramImages.Add(pi); if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool DelCate(int id) { NGOEntities e = new NGOEntities(); e.Categories.Remove(e.Categories.Find(id)); if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateProgram(Program p) { NGOEntities e = new NGOEntities(); p.ProDateCreate = DateTime.Now; e.Programs.Add(p); if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool DelPro(int id) { NGOEntities e = new NGOEntities(); var item = e.Programs.Find(id); e.Programs.Remove(item); if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateQues(UserQuestion q) { NGOEntities e = new NGOEntities(); q.QuesDateCreate = DateTime.Now; q.QuesNew = true; e.UserQuestions.Add(q); if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool CreateDonate(Donate d) { NGOEntities e = new NGOEntities(); d.DonateStatus = 1; d.DonateDateCreate = DateTime.Now; d.TotalMoney = 0; e.Donates.Add(d); if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdateUser(User u) { NGOEntities e = new NGOEntities(); var item = e.Users.Find(u.ID); item.UserName = u.UserName; item.UserGender = u.UserGender; item.UserDOB = u.UserDOB; if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool InsertAns(int id, string answer) { NGOEntities e = new NGOEntities(); var item = e.UserQuestions.Find(id); item.AnswerContent = answer; item.AnswerDateCreate = DateTime.Now; item.QuesNew = false; if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool ForgetPwd(string mail, string newPwd) { NGOEntities e = new NGOEntities(); var user = e.Users.SingleOrDefault(s => s.UserMail == mail && s.UserActive == true); if (user != null) { user.UserPwd = Encrypt.EncryptPasswordMD5(newPwd); if (e.SaveChanges() > 0) { return(true); } } return(false); }
public static bool UpdateAU(AboutUs au) { NGOEntities e = new NGOEntities(); var item = e.AboutUs1.Find(au.ID); item.AboutName = au.AboutName; item.AboutContent = au.AboutContent; item.AboutHide = au.AboutHide; item.AboutImage = au.AboutImage; if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool UpdatePro(Program p) { NGOEntities e = new NGOEntities(); var item = e.Programs.Find(p.ID); item.ProName = p.ProName; item.ProContent = p.ProContent; item.ProHide = p.ProHide; item.TypeID = p.TypeID; if (e.SaveChanges() > 0) { return(true); } return(false); }
public static int InsertCate(Category c) { NGOEntities e = new NGOEntities(); var checkName = e.Categories.SingleOrDefault(s => s.CateName.ToLower() == c.CateName.ToLower()); if (checkName != null) { return(-1); } e.Categories.Add(c); if (e.SaveChanges() > 0) { return(c.ID); } return(0); }
public static Donate GetDonateByID(int id) { NGOEntities e = new NGOEntities(); var d = e.Donates.Find(id); if (d.DonateStatus == 2 && d.EndDay < DateTime.Now) { d.DonateStatus = 3; } else if (d.DonateStatus == 1 && d.StartDay < DateTime.Now) { d.DonateStatus = 2; } e.SaveChanges(); return(e.Donates.Find(id)); }
public static int InsertType(TypeProgram t) { NGOEntities e = new NGOEntities(); var checkName = e.TypePrograms.SingleOrDefault(s => s.TypeName.ToLower() == t.TypeName.ToLower()); if (checkName != null) { return(-1); } e.TypePrograms.Add(t); if (e.SaveChanges() > 0) { return(t.ID); } return(0); }
public IEnumerable <User> GetUser() { List <User> User = null; using (NGOEntities entities = new NGOEntities()) { User = entities.User.AsEnumerable().Select(x => new User { Id = x.Id, UserName = x.UserName, Email = x.Email, Password = x.Password, PhoneNumber = Convert.ToString(x.PhoneNumber) }).ToList(); } return(User); }
public static void CheckStt(List <Donate> ls) { NGOEntities e = new NGOEntities(); foreach (var item in ls) { var d = e.Donates.Find(item.ID); if (item.DonateStatus == 1 && item.StartDay <= DateTime.Now) { d.DonateStatus = 2; } else if (item.DonateStatus == 2 && item.EndDay < DateTime.Now) { d.DonateStatus = 3; } e.SaveChanges(); } }
public static int InsertUD(UserDonate ud) { NGOEntities e = new NGOEntities(); ud.TypeCard = "VISA"; ud.DateCreate = DateTime.Now; e.UserDonates.Add(ud); if (e.SaveChanges() > 0) { var donate = e.Donates.Find(ud.DonateID); donate.TotalMoney += ud.Money; var user = e.Users.Find(ud.UserID); user.MoneyDonate += ud.Money; e.SaveChanges(); return(1); } return(0); }
public static int UpdateCate(Category c) { NGOEntities e = new NGOEntities(); var checkName = e.Categories.SingleOrDefault(s => s.CateName.ToLower() == c.CateName.ToLower() && s.ID != c.ID); if (checkName != null) { return(-1); } var item = e.Categories.Find(c.ID); item.CateName = c.CateName; if (e.SaveChanges() > 0) { return(c.ID); } return(0); }
public static int UpdateType(TypeProgram t) { NGOEntities e = new NGOEntities(); var checkName = e.TypePrograms.SingleOrDefault(s => s.TypeName.ToLower() == t.TypeName.ToLower() && s.ID != t.ID); if (checkName != null) { return(-1); } var item = e.TypePrograms.Find(t.ID); item.TypeName = t.TypeName; if (e.SaveChanges() > 0) { return(t.ID); } return(0); }
public static bool CheckImgMain(int id) { NGOEntities e = new NGOEntities(); var item = e.ProgramImages.Find(id); if (item.ImgMain == true) { item.ImgMain = false; } else { item.ImgMain = true; } if (e.SaveChanges() > 0) { return(true); } return(false); }
public static bool CheckVolunteer(int id) { NGOEntities e = new NGOEntities(); var item = e.Users.Find(id); if (item.UserVolunteer == true) { item.UserVolunteer = false; } else { item.UserVolunteer = true; } if (e.SaveChanges() > 0) { return(true); } return(false); }