public string AddNewOffer(Offers newOffer, string UserName) { newOffer = this.CompleteOfferWithData(newOffer, UserName); Db.Offers.Add(newOffer); Db.SaveChanges(); return newOffer.OfferID; }
public string AddNewOffer(Offers newOffer, string UserName) { newOffer = this.CompleteOfferWithData(newOffer, UserName); Db.Offers.Add(newOffer); Db.SaveChanges(); return(newOffer.OfferID); }
public string GetAndDeleteCurrency(Offers Offer) { string Result = null; if (Offer.Price != null) { if (Offer.Price.Contains("RUB")) { Result = "RUB"; } if (Offer.Price.Contains("EUR")) { Result = "EUR"; } if (Offer.Price.Contains("CNY")) { Result = "CNY"; } if (Offer.Price.Contains("USD")) { Result = "USD"; } Offer.Price = Offer.Price.Substring(0, Offer.Price.Length - 4); } return(Result); }
public Offers CompleteOfferWithData(Offers newOffer, String UserName) { String UserID = GetActiveUserID(UserName); newOffer.Users = (from rec in Db.Users where rec.UserID == UserID select rec).FirstOrDefault(); newOffer.DateAndTime = DateTime.Now; newOffer.OfferedBy = UserID; newOffer.OfferID = Guid.NewGuid().ToString(); return newOffer; }
public Offers CompleteOfferWithData(Offers newOffer, String UserName) { String UserID = GetActiveUserID(UserName); newOffer.Users = (from rec in Db.Users where rec.UserID == UserID select rec).FirstOrDefault(); newOffer.DateAndTime = DateTime.Now; newOffer.OfferedBy = UserID; newOffer.OfferID = Guid.NewGuid().ToString(); return(newOffer); }
public void DeleteOffer(string OfferID) { Offers RemoveOffer = (from OfferRecords in Db.Offers where OfferRecords.OfferID == OfferID select OfferRecords).FirstOrDefault(); DeleteOfferRaiting(OfferID); DeleteOfferTags(OfferID); DeleteOfferComments(OfferID); DeleteOfferOrders(OfferID); Db.Offers.Remove(RemoveOffer); Db.SaveChanges(); }
public string AndNewOrModify(Offers Offer, string UserName) { string Result = null; int count = (from OfferRecords in Db.Offers where OfferRecords.OfferID == Offer.OfferID select OfferRecords).Count(); if (count == 0) { Result = AddNewOffer(Offer, UserName); } else Result = ModifyExistedOffer(Offer); return Result; }
public string ModifyExistedOffer(Offers EditedOffer) { Offers OldOne = (from OfferRecords in Db.Offers where OfferRecords.OfferID == EditedOffer.OfferID select OfferRecords).FirstOrDefault(); OldOne.Name = EditedOffer.Name; OldOne.Description = EditedOffer.Description; OldOne.Price = EditedOffer.Price; OldOne.Photo1URL = EditedOffer.Photo1URL; OldOne.Photo2URL = EditedOffer.Photo2URL; OldOne.Photo3URL = EditedOffer.Photo3URL; OldOne.Photo4URL = EditedOffer.Photo4URL; Db.SaveChanges(); return(OldOne.OfferID); }
public void DeleteOfferTags(string OfferID) { Offers Offer = (from OffersRecords in Db.Offers where OffersRecords.OfferID == OfferID select OffersRecords).FirstOrDefault(); ICollection <Tags> OfferTags = (from OfferRecords in Db.Offers where OfferRecords.OfferID == OfferID select OfferRecords.Tags).FirstOrDefault(); if (OfferTags != null) { foreach (Tags Tag in OfferTags) { Offer.Tags.Remove(Tag); Tag.Offers.Remove(Offer); } Db.SaveChanges(); } }
public string AndNewOrModify(Offers Offer, string UserName) { string Result = null; int count = (from OfferRecords in Db.Offers where OfferRecords.OfferID == Offer.OfferID select OfferRecords).Count(); if (count == 0) { Result = AddNewOffer(Offer, UserName); } else { Result = ModifyExistedOffer(Offer); } return(Result); }
public void CreateIndex(Offers newOffer) { // index location var indexLocation = new FileSystemIndexLocation(new DirectoryInfo(Server.MapPath("~/Index"))); var definition = new OfferIndexDefinition(); var task = new EntityUpdateTask <Offers>(newOffer, definition, indexLocation); task.IndexOptions.RecreateIndex = false; task.IndexOptions.OptimizeIndex = true; //IndexQueue.Instance.Queue(task); var indexWriter = new DirectoryIndexWriter(new DirectoryInfo(Server.MapPath("~/Index")), false); using (var indexService = new IndexService(indexWriter)) { task.Execute(indexService); } }
public void AddTagsToOffer(Offers Offer, string TagsString) { string[] InputedTags = TagsString.Split(','); foreach (string str in InputedTags) { if (str != "") { Tags Tag = null; Tag = (from TagsRecords in Db.Tags where TagsRecords.Name == str select TagsRecords).FirstOrDefault(); if (Tag == null) { Tag = new Tags(); Tag.TagID = Guid.NewGuid().ToString(); Tag.Name = str; } Tag.Offers.Add(Offer); Offer.Tags.Add(Tag); } } Db.SaveChanges(); }
public void CreateIndex(Offers newOffer) { // index location var indexLocation = new FileSystemIndexLocation(new DirectoryInfo(Server.MapPath("~/Index"))); var definition = new OfferIndexDefinition(); var task = new EntityUpdateTask<Offers>(newOffer, definition, indexLocation); task.IndexOptions.RecreateIndex = false; task.IndexOptions.OptimizeIndex = true; //IndexQueue.Instance.Queue(task); var indexWriter = new DirectoryIndexWriter(new DirectoryInfo(Server.MapPath("~/Index")), false); using (var indexService = new IndexService(indexWriter)) { task.Execute(indexService); } }
public string ModifyExistedOffer(Offers EditedOffer) { Offers OldOne = (from OfferRecords in Db.Offers where OfferRecords.OfferID == EditedOffer.OfferID select OfferRecords).FirstOrDefault(); OldOne.Name = EditedOffer.Name; OldOne.Description = EditedOffer.Description; OldOne.Price = EditedOffer.Price; OldOne.Photo1URL = EditedOffer.Photo1URL; OldOne.Photo2URL = EditedOffer.Photo2URL; OldOne.Photo3URL = EditedOffer.Photo3URL; OldOne.Photo4URL = EditedOffer.Photo4URL; Db.SaveChanges(); return OldOne.OfferID; }
public string GetAndDeleteCurrency(Offers Offer) { string Result = null; if (Offer.Price != null) { if (Offer.Price.Contains("RUB")) Result = "RUB"; if (Offer.Price.Contains("EUR")) Result = "EUR"; if (Offer.Price.Contains("CNY")) Result = "CNY"; if (Offer.Price.Contains("USD")) Result = "USD"; Offer.Price = Offer.Price.Substring(0, Offer.Price.Length - 4); } return Result; }