public IHttpActionResult PutJobPosting(int id, JobPosting JobPosting)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != JobPosting.Id)
{
return(BadRequest());
}
db.Entry(JobPosting).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!JobPostingExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public object createcontact(Registration lvv)
{
try
{
User user = new User();
if (user.Id == 0)
{
user.UserName = lvv.UserName;
user.Password = lvv.Password;
user.Email = lvv.Email;
user.PhoneNumber = lvv.PhoneNumber;
db.User.Add(user);
db.SaveChanges();
return(new Response
{
Status = "Success", Message = "SuccessFully Saved."
});
}
}
catch (Exception)
{
throw;
}
return(new Response
{
Status = "Error", Message = "Invalid Data."
});
}
public static bool InsertPartner(Partner p)
{
NGOEntities e = new NGOEntities();
e.Partners.Add(p);
return(e.SaveChanges() > 0 ? true : false);
}
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 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 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 CreateAU(AboutUs au)
{
NGOEntities e = new NGOEntities();
e.AboutUs1.Add(au);
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 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 InsertImg(ProgramImage pi)
{
NGOEntities e = new NGOEntities();
e.ProgramImages.Add(pi);
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 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 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 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 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 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 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 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 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 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 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 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 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 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 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);
}
public static int CreateUser(User u)
{
NGOEntities e = new NGOEntities();
var checkMail = GetUserByMail(u.UserMail);
if (checkMail != null)
{
return(-1);
}
u.UserActive = true;
u.RoleID = 2;
u.UserDateCreate = DateTime.Now;
u.UserVolunteer = false;
u.UserPwd = Encrypt.EncryptPasswordMD5(u.UserPwd);
u.MoneyDonate = 0;
e.Users.Add(u);
if (e.SaveChanges() > 0)
{
return(u.ID);
}
return(0);
}
