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