public JsonResult saveProductTender(List <ProducToTender> pt) { bool status = false; DbtenderEntities1 db = new DbtenderEntities1(); List <ProducToTender> ptlist = db.ProducToTender.ToList(); bool flag; foreach (var item in pt) { flag = false; foreach (var item2 in ptlist) { if (item2.numTender == item.numTender && item2.numProduct == item.numProduct) { flag = true; ProducToTender p = item2; p.NameProduct = item.NameProduct; p.numProduct = item.numProduct; p.PriceLimit = item.PriceLimit; p.sizeRoomy = item.sizeRoomy; p.Amount = item.Amount; try { db.SaveChanges(); status = true; } catch (Exception) { } } } if (!flag) { ProducToTender p = item; var a = TryUpdateModel(p); db.ProducToTender.Add(p); try { db.SaveChanges(); status = true; } catch (Exception) { throw; } } } return(new JsonResult { Data = new { status = status } }); }
public JsonResult save(List <ConToTender> ct) { bool status = false; //var isValidModel = TryUpdateModel(ct); //if (isValidModel) //{ using (DbtenderEntities1 DB = new DbtenderEntities1()) { foreach (var item in ct) { int last = findLastCon(); item.numConToTender = last; DB.ConToTender.Add(item); } try { DB.SaveChanges(); } catch (Exception) { } status = true; } //} return(new JsonResult { Data = new { status = status } }); }
public JsonResult saving(Suggestions s1) { bool status = false; var isValidModel = TryUpdateModel(s1); if (isValidModel) { using (DbtenderEntities1 DB = new DbtenderEntities1()) { DB.Suggestions.Add(s1); try { DB.SaveChanges(); } catch (Exception) { } status = true; } } return(new JsonResult { Data = new { status = status } }); }
public ActionResult ChangePrice(int numtender) { DateTime dt = DateTime.Now; List <ProducToTender> products = new List <ProducToTender>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { products = DB.ProducToTender.Where(a => a.numTender.Equals(numtender)).OrderBy(a => a.numTender).ToList(); } // return Json(ProducToTender, JsonRequestBehavior.AllowGet); if (products != null) { try { foreach (var item in products) { using (DbtenderEntities1 DB = new DbtenderEntities1()) { var tender = DB.ProducToTender.Find((item.TenderDetailsID)); tender.PriceUpdate = item.PriceUpdate - (float)item.sizeRoomy; tender.DateUpdate = dt; DB.SaveChanges(); } } } catch (Exception) { } } return(View()); }
public ActionResult updateTender(Suggestions t) { int num = findLastSuggest2(); Suggestions s2 = t; t.numSuggestion = num; t.dataSuggestion = DateTime.Now; using (DbtenderEntities1 DB1 = new DbtenderEntities1()) { DB1.Suggestions.Add(s2); try { DB1.SaveChanges(); } catch { } } try { using (DbtenderEntities1 DB = new DbtenderEntities1()) { var tender = DB.Tenders.Find(Convert.ToInt32(t.numTender)); tender.status = "סגור"; tender.winner = t.numCont; tender.till = t.dataSuggestion; tender.numSugestion = num; DB.SaveChanges(); } } catch (Exception) { } return(View()); }
public JsonResult saveP(List <ProducToTender> pt) { int TenderDetail = findTenderDetail(); bool status = false; var isValidModel = true; //if (isValidModel) //{ using (DbtenderEntities1 DB = new DbtenderEntities1()) { foreach (var item in pt) { item.TenderDetailsID = TenderDetail; DB.ProducToTender.Add(item); TenderDetail = TenderDetail + 1; } try { DB.SaveChanges(); status = true; } catch (Exception) { } } // } return(new JsonResult { Data = new { status = status } }); }
public ActionResult checkTenders() { List <Tenders> tenders = new List <Tenders>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { tenders = DB.Tenders.Where(a => a.status.Contains("טרם")).OrderBy(a => a.numTender).ToList(); } // return Json(ProducToTender, JsonRequestBehavior.AllowGet); if (tenders != null) { try { foreach (var item in tenders) { using (DbtenderEntities1 DB = new DbtenderEntities1()) { if (item.from <= DateTime.Now) { item.status = "פעיל"; try { DB.SaveChanges(); } catch { } } else if (item.from == DateTime.Now) { if (item.hourStart >= DateTime.Now.TimeOfDay) { item.status = "פעיל"; DB.SaveChanges(); } } } } } catch (Exception) { } } return(View()); }
public ActionResult stopTender(string numTender) { try { using (DbtenderEntities1 DB = new DbtenderEntities1()) { var tender = DB.Tenders.Find(Convert.ToInt32(numTender)); tender.status = "סגור"; DB.SaveChanges(); } } catch (Exception) { } return(View()); }
public ActionResult updateTender(Tenders t) { try { using (DbtenderEntities1 DB = new DbtenderEntities1()) { var tender = DB.Tenders.Find(Convert.ToInt32(t.numTender)); tender.status = "סגור"; tender.winner = t.winner; tender.till = t.till; DB.SaveChanges(); } } catch (Exception) { } return(View()); }
public JsonResult save(Tenders Tenders) { bool status = false; DateTime dateOrgF; DateTime dateOrgT; var isValidDateFrom = DateTime.TryParseExact(Tenders.from.ToString(), "mm-dd-yyyy", null, System.Globalization.DateTimeStyles.None, out dateOrgF); if (isValidDateFrom) { Tenders.from = dateOrgF; } var isValidDateTill = DateTime.TryParseExact(Tenders.till.ToString(), "mm-dd-yyyy", null, System.Globalization.DateTimeStyles.None, out dateOrgT); if (isValidDateTill) { Tenders.from = dateOrgT; } var isValidModel = TryUpdateModel(Tenders); if (isValidModel) { using (DbtenderEntities1 DB = new DbtenderEntities1()) { //foreach (var item in Tenders.ProducToTender) //{ // DB.ProducToTender.Add(item); //} //DB.SaveChanges(); DB.Tenders.Add(Tenders); try { DB.SaveChanges(); } catch (Exception) { } status = true; } } return(new JsonResult { Data = new { status = status } }); }
public JsonResult save(Contestants con) { bool status = false; var isValidModel = TryUpdateModel(con); using (DbtenderEntities1 DB = new DbtenderEntities1()) { DB.Contestants.Add(con); try { DB.SaveChanges(); } catch (Exception) { } status = true; } return(new JsonResult { Data = new { status = status } }); }
public JsonResult save(Suggestions s1) { // List<Suggestions> s2 = new List<Suggestions>(); Suggestions s2; s2 = s1; //s2.numSuggestion = 0; //s2.numTender = 0; //s2.numCont = 0; //s2.numSuggestion = s1.numSuggestion; //s2.numTender = s1.numTender; //s2.numCont = s1.numCont; //s2.priceToproduct = s1.priceToproduct; bool status = false; //var isValidModel = TryUpdateModel(s2); //if (isValidModel) //{ using (DbtenderEntities1 DB = new DbtenderEntities1()) { DB.Suggestions.Add(s2); try { DB.SaveChanges(); } catch (Exception) { } status = true; } // } return(new JsonResult { Data = new { status = status } }); }
public ActionResult stopEnglishTender(int numTender) { int d = getSuggestionsMax(numTender); List <Suggestions> suggestion = new List <Suggestions>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { suggestion = DB.Suggestions.Where(a => a.numSuggestion.Equals(d)).OrderBy(a => a.numSuggestion).ToList(); } try { using (DbtenderEntities1 DB = new DbtenderEntities1()) { var tender = DB.Tenders.Find(Convert.ToInt32(numTender)); tender.status = "סגור"; tender.winner = suggestion[0].numCont; tender.numSugestion = suggestion[0].numSuggestion; DB.SaveChanges(); } } catch (Exception) { } return(View()); }
public ActionResult saveUpdateTender(Tenders t) { ViewBag.Message = ""; DbtenderEntities1 db = new DbtenderEntities1(); List <Tenders> t1 = db.Tenders.ToList(); foreach (var item in t1) { if (item.numTender == t.numTender) { Tenders t2 = item; t2.name = t.name; t2.numEditor = t.numEditor; t2.numType = t.numType; t2.status = t.status; t2.typeAcquire = t.typeAcquire; t2.codCategory = t.codCategory; t2.from = t.from; t2.till = t.till; t2.hourStart = t.hourStart; t2.hourFinish = t.hourFinish; try { db.SaveChanges(); } catch (Exception) { } break; } } return(View()); }