public ActionResult AddEditTender(string pTenderID)
{
FillAllDropdowns();
User objUser = null;
if (AGHSession.IsInSession(SessionKeys.CurrentUser))
objUser = (User)AGHSession.GetDirectValue(SessionKeys.CurrentUser);
TenderListViewModel model = new TenderListViewModel();
model.Tender = new Tender();
if (TempData["ObjTender"] != null)
{
model.Tender = (Tender)TempData["ObjTender"];
}
if (ModelState.IsValid)
{
if (!string.IsNullOrEmpty(pTenderID))
{
model.Tender.TenderID = pTenderID;
model.Tender = _ObjService.Get(model.Tender);
if (!string.IsNullOrEmpty(model.Tender.TenderID))
{
Document objDoc = new Document();
objDoc.ObjectID = Utility.AUCTION_OBJECT_ID;
objDoc.ObjectInstanceID = model.Tender.TenderID;
List<Document> lstDocs = _DocService.GetAllDocuments(objDoc).ToList();
if (lstDocs != null && lstDocs.Count > 0)
model.DocumentList = lstDocs;
}
}
if (model.Tender != null)
{
if (model.Tender.OpeningDate == DateTime.MinValue)
model.Tender.OpeningDate = DateTime.Now.Date;
if (model.Tender.ClosingDate == DateTime.MinValue)
model.Tender.ClosingDate = DateTime.Now.Date;
if (model.Tender.ExtensionDate == DateTime.MinValue)
model.Tender.ExtensionDate = DateTime.Now.Date;
if (model.Tender.RFQLastDate == DateTime.MinValue)
model.Tender.RFQLastDate = DateTime.Now.Date;
}
if (model.Tender.CategoryList != null)
model.CategoryList = model.Tender.CategoryList;
else
{
model.Tender.CategoryList = GetAllCategory();
model.CategoryList = model.Tender.CategoryList;
}
}
return View(model);
}
public ActionResult Index()
{
// Create the model
var model = new TenderListViewModel();
using (var ctx = new CoronaSupportPlatformDbContext())
{
if (User.IsInRole("Administrator"))
{
// Load all tenders if administrator
var tenders = ctx.Tenders.Include("Organization").Include("Items.Product").Include("Properties").Include("Tags").ToList();
model.Tenders = tenders.Select(t => new TenderViewModel().From(t)).ToList();
}
else
{
// Load only the tenders for the current user
var tenders = ctx.Tenders.Include("Organization").Include("Items.Product").Include("Properties").Include("Items").Where(u => u.UserId == CurrentUser.Id).ToList();
model.Tenders = tenders.Select(t => new TenderViewModel().From(t)).ToList();
}
}
#region [ Breadcrumb ]
var breadcrumb = new BreadcrumbViewModel();
breadcrumb.PageName = "İhtiyaç Listesi";
breadcrumb.Items.Add("Anasayfa", "/");
breadcrumb.Items.Add("İhtiyaç Listesi", "");
TempData["Breadcrumb"] = breadcrumb;
#endregion
return(View(model));
}
public ActionResult ManageTender(TenderListViewModel model)
{
if (model.Tender == null)
{
model.Tender = new Tender();
}
if (!string.IsNullOrEmpty(model.Tender.sort))
{
model.Tender.SortExp = model.Tender.sort + " " + model.Tender.sortdir;
}
if (model.Tender.PageSize == 0)
{
int PageSize = Convert.ToInt32(ConfigurationManager.AppSettings["PageSize"]);
model.Tender.PageSize = PageSize;
}
if (model.Tender.PageIndex == 0)
{
model.Tender.PageIndex = 1;
}
model.TenderList = new List<Tender>();
model.Tender.TotalCount = 0;
//Searh Criteria
if (model != null && model.Tender != null)
{
if (!string.IsNullOrEmpty(model.Tender.SearchTenderRefNo))
model.Tender.TenderRefNo = model.Tender.SearchTenderRefNo;
if (!string.IsNullOrEmpty(model.Tender.SearchTenderName))
model.Tender.TenderName = model.Tender.SearchTenderName;
}
model.TenderList = _ObjService.GetAll(model.Tender).ToList();
if (model.TenderList != null && model.TenderList.Count > 0)
{
int TotalCount = model.TenderList[0].TotalCount;
model.Tender.TotalCount = TotalCount;
}
return View(model);
}
public ActionResult DeleteTender(string pTenderID)
{
if (!string.IsNullOrEmpty(pTenderID))
{
TenderListViewModel model = new TenderListViewModel();
model.Tender = new Tender();
model.Tender.TenderID = pTenderID;
int i = _ObjService.Delete(model.Tender);
if (i <= 0)
TempData["err"] = TenderRes.MsgDeleteError;
else
TempData["msg"] = TenderRes.MsgDeleteSuccess;
}
return RedirectToAction("ManageTender", "Tender");
}
public ActionResult AddEditTender(TenderListViewModel model, string submit)
{
FillAllDropdowns();
string strSuccessMsg = string.Empty;
string strErrorMsg = string.Empty;
if (submit == "Save")
{
if (model != null && model.Tender != null)
{
if (string.IsNullOrEmpty(model.Tender.TenderID))
{
strSuccessMsg = TenderRes.MsgAddSuccess;
strErrorMsg = TenderRes.MsgAddError;
}
else
{
strSuccessMsg = TenderRes.MsgEditSuccess;
strErrorMsg = TenderRes.MsgEditError;
}
int i = _ObjService.AddEdit(model.Tender);
if (i <= 0)
{
TempData["err"] = strErrorMsg;
}
else
{
TempData["msg"] = strSuccessMsg;
}
}
return RedirectToAction("AddEditTender", "Tender", new { pTenderID = model.Tender.TenderID });
}
else if (submit == "Upload")
{
if (model != null && model.Tender != null && !string.IsNullOrEmpty(model.Tender.TenderID))
{
if (model.Document != null && !string.IsNullOrEmpty(model.Document.ObjectDocTypeID))
{
if (model.Document.UploadedFile != null)
{
model.Document.ObjectID = Utility.AUCTION_OBJECT_ID;
model.Document.ObjectInstanceID = model.Tender.TenderID;
model.Document.DocumentRefNo = model.Tender.TenderRefNo;
int j = _DocService.AddEdit(model.Document);
if (j <= 0)
TempData["err"] = DocumentRes.MsgAddError;
else
TempData["msg"] = DocumentRes.MsgAddSuccess;
}
else
TempData["err"] = DocumentRes.MsgSelectFile;
}
else
TempData["err"] = DocumentRes.MsgDocumentTypeSelect;
return RedirectToAction("AddEditTender", "Tender", new { pTenderID = model.Tender.TenderID });
}
else
{
model.Tender.CategoryList = null;
TempData["ObjTender"] = model.Tender;
// TempData["warning"] = DocumentRes.MsgTenderSave;
return RedirectToAction("AddEditTender", "Tender", new { pTenderID = string.Empty });
}
}
else
return RedirectToAction("AddEditTender", "Tender");
}
public ActionResult Index(int page = 1, string text = "", int Sponsor = 0, int Type = 0, string StartData = "01/01/2018", string EndData = "01/12/2018", string rate = "", string time = "", int Category = 0)
{
Session["page"] = page;
Session["text"] = text;
Session["Sponsor"] = Sponsor;
Session["Type"] = Type;
Session["Rate"] = rate;
Session["Time"] = time;
Session["Category"] = Category;
var text_search = Session["text"].ToString();
var se_sponsor = Convert.ToInt32(Session["Sponsor"]);
var se_type = Convert.ToInt32(Session["Type"]);
var se_category = Convert.ToInt32(Session["Category"]);
DateTime start = Convert.ToDateTime(StartData);
DateTime end = Convert.ToDateTime(EndData);
if (se_sponsor != 0)
{
var name_sponsor = db.Cards.Where(x => x.Id == se_sponsor).FirstOrDefault();
var count_filter = db.Cards
.Include(x => x.Сurrency)
.Where(x => x.Sponsor == name_sponsor.Sponsor && x.TypeId == se_type && x.PublicationDate >= start && x.PublicationDate <= end).Count();
if (count_filter != 0)
{
TenderListViewModel filter = new TenderListViewModel
{
Cards = db.Cards
.Include(x => x.Сurrency)
.Where(x => x.Sponsor == name_sponsor.Sponsor && x.TypeId == se_type && x.PublicationDate >= start && x.PublicationDate <= end)
.OrderBy(x => x.Id)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = count_filter
}
};
return(View(filter));
}
else
{
ViewBag.Search = "Поиск не дал результатов...";
return(View());
}
}
else if (Session["Time"].ToString() == "asc")
{
TenderListViewModel result = new TenderListViewModel
{
Cards = db.Cards.Include(x => x.Сurrency)
.OrderBy(x => x.Id)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = db.Cards.Count()
}
};
return(View(result));
}
else if (Session["Time"].ToString() == "desc")
{
TenderListViewModel result = new TenderListViewModel
{
Cards = db.Cards.Include(x => x.Сurrency)
.OrderByDescending(x => x.Id)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = db.Cards.Count()
}
};
return(View(result));
}
else if (Session["Rate"].ToString() == "more")
{
TenderListViewModel result = new TenderListViewModel
{
Cards = db.Cards.Include(x => x.Сurrency)
.OrderByDescending(x => x.Rate)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = db.Cards.Count()
}
};
return(View(result));
}
else if (Session["Rate"].ToString() == "less")
{
TenderListViewModel result = new TenderListViewModel
{
Cards = db.Cards.Include(x => x.Сurrency)
.OrderBy(x => x.Rate)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = db.Cards.Count()
}
};
return(View(result));
}
else if (se_category != 0)
{
var count = db.Cards.Include(x => x.Сurrency).Where(x => x.СategoryId == se_category).Count();
TenderListViewModel result = new TenderListViewModel
{
Cards = db.Cards.Include(x => x.Сurrency).Where(x => x.СategoryId == se_category)
.OrderBy(x => x.Id)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = count
}
};
return(View(result));
}
else
{
if (text_search == "")
{
TenderListViewModel result = new TenderListViewModel
{
Cards = db.Cards.Include(x => x.Сurrency)
.OrderBy(x => x.Id)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = db.Cards.Count()
}
};
return(View(result));
}
else
{
var count_Subject = db.Cards.Include(x => x.Сurrency).Where(x => x.Subject.StartsWith(text_search)).Count();
var count_Description = db.Cards.Include(x => x.Сurrency).Where(x => x.Description.StartsWith(text_search)).Count();
if (count_Subject != 0)
{
TenderListViewModel result = new TenderListViewModel
{
Cards = db.Cards.Include(x => x.Сurrency).Where(x => x.Subject.StartsWith(text_search))
.OrderBy(x => x.Id)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = count_Subject
}
};
return(View(result));
}
else if (count_Description != 0)
{
TenderListViewModel result = new TenderListViewModel
{
Cards = db.Cards.Include(x => x.Сurrency).Where(x => x.Description.StartsWith(text_search))
.OrderBy(x => x.Id)
.Skip((Convert.ToInt32(Session["page"]) - 1) * PageSize)
.Take(PageSize),
PagingInfo = new PagingInfo
{
CurrentPage = Convert.ToInt32(Session["page"]),
ItemsPerPage = PageSize,
TotalItems = count_Subject
}
};
return(View(result));
}
else
{
ViewBag.Search = "Поиск не дал результатов...";
return(View());
}
}
}
}
