public void EditAd(ad a) { var cx1 = new Database1Entities8(); cx1.Entry(a).State = EntityState.Modified; cx1.SaveChanges(); }
public void IsignUp(User u) { var cx = new Database1Entities8(); cx.Users.Add(u); cx.SaveChanges(); }
public void saveUserAdData(int adId, int UId) { var cx = new Database1Entities8(); userAd o = new userAd(); o.adId = adId; o.userId = UId; cx.userAds.Add(o); cx.SaveChanges(); }
public int UserId(string s) { var cx = new Database1Entities8(); var q = cx.Users.Where(a => a.UserName.Equals(s)).Select(a => new { a.Id }); foreach (var x in q) { return(x.Id); } return(0); }
public bool ICheckUserName(string UserName) { var cx = new Database1Entities8(); int i = cx.Users.Where(u => u.UserName.Equals(UserName)).Count(); if (i == 1) { return(true); } else { return(false); } }
public bool loginUser(User user) { var db = new Database1Entities8(); int i = db.Users.Where(z => z.UserName.Equals(user.UserName) && z.Password.Equals(user.Password)).Count(); if (i == 1) { return(true); } else { return(false); } }
public List <ad> getAdsOfUser(string s) { var cx1 = new Database1Entities8(); ISignUp o = new userRep(); int id = o.UserId(s); var q = cx1.userAds.Where(a => a.userId == id).Select(a => new{ a.adId }); List <ad> l = new List <ad>(); foreach (var x in q) { l.Add(cx1.ads.Find(x.adId)); } return(l); }
public void DeleteAd(int id) { var db = new Database1Entities8(); ad a = db.ads.Find(id); db.ads.Remove(a); var q = db.userAds.Where(b => b.adId == id).Select(b => b); userAd o = null; foreach (var x in q) { o = x; } db.userAds.Remove(o); db.SaveChanges(); }
public int IpostAd(ad d) { var cx1 = new Database1Entities8(); var q = cx1.ads.Select(a => new { a.Id }); cx1.ads.Add(d); cx1.SaveChanges(); int max = 0; foreach (var x in q) { if (x.Id > max) { max = x.Id; } } return(max); }
public ad getad(int id) { var cx1 = new Database1Entities8(); return(cx1.ads.Find(id)); }
public List <ad> searchByTitle(string s) { var cx1 = new Database1Entities8(); return(cx1.ads.Where(a => a.title.Equals(s)).Select(a => a).ToList()); }
public List <ad> getAllAds() { var cx1 = new Database1Entities8(); return(cx1.ads.Select(a => a).ToList()); }