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