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