public void AddAdv(string id)
{
int advId = int.Parse(id);
string src = Request.Params["src"].ToString();
string cost = Request.Params["cost"].ToString();
string url = Request.Params["url"].ToString();
url = url.Replace(",/Admin/AddAdv/1", "");
url = url.Replace(",/Admin/AddAdv/2", "");
url = url.Replace(",/Admin/AddAdv/3", "");
List <advert> ads = (from item in db.adverts where item.advNo == advId && item.status == 1 select item).ToList();
if (ads.Count != 0)
{
var adv = new advert {
id = ads[0].id, advert1 = src, cost = int.Parse(cost), datetime = DateTime.Now, url = url
};
using (var db = new socialEntities())
{
db.adverts.Attach(adv);
db.Entry(adv).Property(x => x.advert1).IsModified = true;
db.Entry(adv).Property(x => x.cost).IsModified = true;
db.Entry(adv).Property(x => x.url).IsModified = true;
db.Entry(adv).Property(x => x.datetime).IsModified = true;
db.SaveChanges();
}
}
else
{
advert ad = new advert();
ad.advNo = advId;
ad.status = 1;
ad.advert1 = src;
ad.url = url;
ad.datetime = DateTime.Now;
ad.cost = int.Parse(cost);
db.adverts.Add(ad);
db.SaveChanges();
}
}
select TupleFrom(advert, pow : pow),
select TupleFrom(advert, gmina, pow, woj),
select TupleFrom(advert, gmina),
select TupleFrom(advert, gmina, pow, woj, miejsc),
select TupleFrom(advert, miejsc.Gmi, miejsc : miejsc),