public void BindDDLs(ContractView contractView, ObjectContext db)
{
//contract validities ddl
IContractValiditiesRepository contractValiditiesRepository = new ContractValiditiesRepository(db);
contractView.ContractValidities = new SelectList(contractValiditiesRepository.GetValid().OrderBy("Name ASC").ToList(), "ContractValidityPK", "Name");
//currencies ddl
ICurrenciesRepository currenciesRepository = new CurrenciesRepository(db);
contractView.Currencies = new SelectList(currenciesRepository.GetValid().OrderBy(c => c.Name).Select(c => new { value = c.CurrencyPK, text = c.Name + " (" + c.Sign + ")" }), "value", "text");
}
public ActionResult Delete(int?contractValidityPK)
{
IContractValiditiesRepository contractValiditiesRepository = new ContractValiditiesRepository(db);
if (contractValidityPK != null)
{
ContractValidity contractValidity = contractValiditiesRepository.GetContractValidityByPK((int)contractValidityPK);
contractValidity.Deleted = true;
contractValiditiesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("DELETE", contractValidity.ContractValidityPK);
}
return(Redirect(Request.UrlReferrer.AbsoluteUri));
}
public ActionResult Edit(int?contractValidityPK)
{
if (contractValidityPK != null)
{
IContractValiditiesRepository contractValiditiesRepository = new ContractValiditiesRepository(db);
ContractValidity contractValidity = contractValiditiesRepository.GetContractValidityByPK((int)contractValidityPK);
ContractValidityView contractValidityView = new ContractValidityView();
contractValidityView.ConvertFrom(contractValidity, contractValidityView);
return(View(contractValidityView));
}
else
{
return(RedirectToAction("Index", "ContractValidity"));
}
}
public ActionResult Index()
{
IContractValiditiesRepository contractValiditiesRepository = new ContractValiditiesRepository(db);
int page = !String.IsNullOrWhiteSpace(Request.QueryString["page"]) ? Convert.ToInt32(Request.QueryString["page"]) : 1;
int pageSize = !String.IsNullOrWhiteSpace(Request.QueryString["pageSize"]) ? Convert.ToInt32(Request.QueryString["pageSize"]) : Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["ResultsPerPage"]);
string sortOrder = !String.IsNullOrWhiteSpace(Request.QueryString["sortOrder"]) ? Request.QueryString["sortOrder"] : "DESC";
string sortColumn = !String.IsNullOrWhiteSpace(Request.QueryString["sortColumn"]) ? Request.QueryString["sortColumn"] : "ContractValidityPK";
string ordering = sortColumn + " " + sortOrder;
ordering = ordering.Trim();
IQueryable <ContractValidity> contractValidities = contractValiditiesRepository.GetValid()
.OrderBy(ordering);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
contractValidities = contractValidities.Where(c => c.Name.Contains(searchString));
}
contractValidities = contractValidities.Page(page, pageSize);
if (!String.IsNullOrWhiteSpace(Request.QueryString["searchString"]))
{
string searchString = Request.QueryString["searchString"].ToString();
ViewData["numberOfRecords"] = contractValiditiesRepository.GetValid().Where(c => c.Name.Contains(searchString)).Count();
}
else
{
ViewData["numberOfRecords"] = contractValiditiesRepository.GetValid().Count();
}
int numberOfPages = ((int)ViewData["numberOfRecords"] + pageSize - 1) / pageSize;
if (page > numberOfPages)
{
string url = LinkHelper.getQueryStringArray(new string[] { "page" });
return(Redirect("ContractValidity?" + url + "page=" + numberOfPages));
}
else
{
return(View("Index", contractValidities.ToList()));
}
}
public ActionResult Edit(ContractValidityView contractValidityModel)
{
if (ModelState.IsValid)
{
IContractValiditiesRepository contractValiditiesRepository = new ContractValiditiesRepository(db);
ContractValidity contractValidity = contractValiditiesRepository.GetContractValidityByPK((int)contractValidityModel.ContractValidityPK);
contractValidityModel.ConvertTo(contractValidityModel, contractValidity);
contractValiditiesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("UPDATE", contractValidity.ContractValidityPK);
return(RedirectToAction("Index", "ContractValidity"));
}
else
{
return(View(contractValidityModel));
}
}
public ActionResult Add(ContractValidityView contractValidityView)
{
if (ModelState.IsValid)
{
IContractValiditiesRepository contractValiditiesRepository = new ContractValiditiesRepository(db);
ContractValidity contractValidity = new ContractValidity();
contractValidityView.ConvertTo(contractValidityView, contractValidity);
contractValiditiesRepository.Add(contractValidity);
contractValiditiesRepository.SaveChanges();
TempData["message"] = LayoutHelper.GetMessage("INSERT", contractValidity.ContractValidityPK);
return(RedirectToAction("Index", "ContractValidity"));
}
else
{
return(View(contractValidityView));
}
}
