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