public ActionResult getSuggestionDetail(int numTender) { DbtenderEntities1 DB = new DbtenderEntities1(); var status = from t in DB.Tenders where t.numTender == numTender select t.status; if (status.ToList()[0].ToString().Contains("סגור")) { return(Json("close", JsonRequestBehavior.AllowGet)); } //return View(); var result = from p in DB.ProducToTender join t in DB.Tenders on p.numTender equals t.numTender where p.numTender == numTender orderby p.NameProduct select new { p.numProduct, p.NameProduct, p.Amount, p.PriceUpdate, p.sizeRoomy }; //return View(); return(Json(result.Distinct().ToList(), JsonRequestBehavior.AllowGet)); }
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 ActionResult Tenders() { DbtenderEntities1 DB = new DbtenderEntities1(); List <Tenders> TypeTender = DB.Tenders.ToList(); return(View(TypeTender)); }
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 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 Suggestions() { DbtenderEntities1 DB = new DbtenderEntities1(); List <Suggestions> TypeTender = DB.Suggestions.ToList(); return(View(TypeTender)); }
public ActionResult MyClients() { DbtenderEntities1 DB = new DbtenderEntities1(); List <Contestants> TypeTender = DB.Contestants.ToList(); return(View(TypeTender)); }
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 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 ActionResult getProduct(int numTender) { int max = getSuggestionsMax(numTender); if (max == 0) { return(null); } else { DbtenderEntities1 DB = new DbtenderEntities1(); var result = from s in DB.SuggestionDetail join p in DB.ProducToTender on s.numproduct equals p.numProduct join s1 in DB.Suggestions on s.numsuggest equals s1.numSuggestion join t in DB.Tenders on p.numTender equals t.numTender where p.numTender == numTender where s.numsuggest == max where p.numProduct == s.numproduct select new { s.priceToProduct, s.numproduct, p.sizeRoomy, p.Amount, p.NameProduct, p.weight, t.hourFinish, t.till, s1.timeSuggestion, s1.dataSuggestion }; return(Json(result.Distinct().ToList(), JsonRequestBehavior.AllowGet)); } }
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 GetSiteMenus() { using (DbtenderEntities1 dc = new DbtenderEntities1()) { var menu = dc.ClientMenu.ToList(); return(new JsonResult { Data = menu, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); } }
public JsonResult getTenders() { DbtenderEntities1 DB = new DbtenderEntities1(); List <Tenders> tenders = DB.Tenders.ToList(); return(new JsonResult { Data = tenders, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public ActionResult getTender(int numTender) { List <Tenders> Tender = new List <Tenders>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { Tender = DB.Tenders.Where(a => a.numTender.Equals(numTender)).OrderBy(a => a.numTender).ToList(); } return(Json(Tender, JsonRequestBehavior.AllowGet)); }
public ActionResult getPrice(int numSuggestion) { List <SuggestionDetail> products = new List <SuggestionDetail>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { products = DB.SuggestionDetail.Where(a => a.numsuggest.Equals(numSuggestion)).OrderBy(a => a.priceToProduct).ToList(); } return(Json(products, JsonRequestBehavior.AllowGet)); }
public ActionResult getSuggestion(int numTender) { List <Suggestions> products = new List <Suggestions>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { products = DB.Suggestions.Where(a => a.numTender.Equals(numTender)).OrderBy(a => a.numSuggestion).ToList(); } return(Json(products, JsonRequestBehavior.AllowGet)); }
public int checkHolland(ConToTender con) { int numtender = Convert.ToInt32(con.numTender); try { using (DbtenderEntities1 DB = new DbtenderEntities1()) { var tender = DB.Tenders.Find(Convert.ToInt32(numtender)); if (tender == null) { return(-1); } else if (tender.numType != 2) { return(-1); } } } catch (Exception) { } List <ConToTender> cont = new List <ConToTender>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { cont = DB.ConToTender.Where(a => a.numTender.Value.Equals(numtender)).OrderBy(a => a.numCon).ToList(); } // return Json(ProducToTender, JsonRequestBehavior.AllowGet); if (cont != null) { try { foreach (var item in cont) { using (DbtenderEntities1 DB = new DbtenderEntities1()) { if (item.numCon == con.numCon) { return(2); } } } return(0); } catch (Exception) { } } return(0); }
public int findLastCon() { int num = 0; DbtenderEntities1 DB = new DbtenderEntities1(); List <ConToTender> result = DB.ConToTender.ToList(); num = result.Count + 1; return(num); }
public int findLastSuggest2() { int num = 0; DbtenderEntities1 DB = new DbtenderEntities1(); List <Suggestions> result = DB.Suggestions.ToList(); num = result.Count + 1; return(num); }
public ActionResult findLastSuggest() { int num = 0; DbtenderEntities1 DB = new DbtenderEntities1(); List <Suggestions> result = DB.Suggestions.ToList(); num = result.Count + 1; return(Json(num, JsonRequestBehavior.AllowGet)); }
public int findTenderDetail() { int num = 0; DbtenderEntities1 DB = new DbtenderEntities1(); List <ProducToTender> result = DB.ProducToTender.ToList(); num = result.Count + 1; return(num); }
public ActionResult getSizeRoomy(int numTender) { DbtenderEntities1 DB = new DbtenderEntities1(); var result = from p in DB.ProducToTender where p.numTender == numTender orderby p.numProduct select new { p.numProduct, p.sizeRoomy }; return(Json(result.ToList(), JsonRequestBehavior.AllowGet)); }
public ActionResult getType(int numType) { List <TypeTender> type = new List <TypeTender>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { type = DB.TypeTender.Where(a => a.numType.Equals(numType)).OrderBy(a => a.nameType).ToList(); } return(Json(type, JsonRequestBehavior.AllowGet)); }
public int findTender() { int num = 0; DbtenderEntities1 DB = new DbtenderEntities1(); List <Tenders> result = DB.Tenders.ToList(); num = result.Count + 1; return(num); }
public ActionResult getNumOfCon() { int num = 0; DbtenderEntities1 DB = new DbtenderEntities1(); List <Contestants> result = DB.Contestants.ToList(); num = result.Count + 1; return(Json(num, JsonRequestBehavior.AllowGet)); }
public JsonResult getEditor() { List <Editors> Editors = new List <Editors>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { Editors = DB.Editors.OrderBy(a => a.nameEditor).ToList(); } return(new JsonResult { Data = Editors, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult getcon() { List <Contestants> con = new List <Contestants>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { con = DB.Contestants.OrderBy(a => a.nameCont).ToList(); } return(new JsonResult { Data = con, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult getSuggestionDetails1(int numsuggestion) { List <SuggestionDetail> suggestionDetail = new List <SuggestionDetail>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { suggestionDetail = DB.SuggestionDetail.Where(a => a.numDetailSuggestion.Equals(numsuggestion)).OrderBy(a => a.numDetailSuggestion).ToList(); } return(new JsonResult { Data = suggestionDetail, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult getAllSuggestions(int numtender) { List <Suggestions> suggestion = new List <Suggestions>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { suggestion = DB.Suggestions.Where(a => a.numTender.Equals(numtender)).OrderBy(a => a.numSuggestion).ToList(); } return(new JsonResult { Data = suggestion, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }
public JsonResult getProducts(int categoryID) { List <ProducToTender> products = new List <ProducToTender>(); using (DbtenderEntities1 DB = new DbtenderEntities1()) { products = DB.ProducToTender.Where(a => a.numProduct.Equals(categoryID)).OrderBy(a => a.NameProduct).ToList(); } return(new JsonResult { Data = products, JsonRequestBehavior = JsonRequestBehavior.AllowGet }); }