public ActionResult Delete_Post(int EmployeeID, string TerritoryID)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
if (TerritoryID == null)
{
//mm
employeeterritoriesBusinessModelLayers.DeleteEmployeeterritories(EmployeeID);
}
else
{
//mm
employeeterritoriesBusinessModelLayers.EXE_sql("DELETE FROM [EmployeeTerritories] WHERE (EmployeeID = " + "N'" + EmployeeID.ToString() + "'" + ") AND (TerritoryID = " + "N'" + TerritoryID.ToString() + "'" + ")");
}
return(RedirectToAction("List"));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult Get(int EmployeeID, string TerritoryID)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
BusinessModelLayer.EmployeeterritoriesSingle employeeterritoriess = new EmployeeterritoriesSingle();
if (TerritoryID == null)
{
employeeterritoriess = employeeterritoriesBusinessModelLayers.GetAllEmployeeterritoriess().FirstOrDefault(x => x.EmployeeID == EmployeeID);
}
else
{
employeeterritoriess = employeeterritoriesBusinessModelLayers.GetAllEmployeeterritoriess().FirstOrDefault(x => x.EmployeeID == EmployeeID && x.TerritoryID == TerritoryID);
}
return(Ok(employeeterritoriess));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit_Post(int EmployeeID, string TerritoryID)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
BusinessModelLayer.EmployeeterritoriesSingle employeeterritories;
if (TerritoryID == null)
{
employeeterritories = employeeterritoriesBusinessModelLayers.GetAllEmployeeterritoriess().Single(x => x.EmployeeID == EmployeeID);
}
else
{
employeeterritories = employeeterritoriesBusinessModelLayers.GetAllEmployeeterritoriess().Single(x => x.EmployeeID == EmployeeID && x.TerritoryID == TerritoryID);
}
UpdateModel <EmployeeterritoriesSingle>(employeeterritories);
if (ModelState.IsValid)
{
//mm
employeeterritoriesBusinessModelLayers.UpdateEmployeeterritories(employeeterritories);
return(RedirectToAction("List"));
}
return(View(employeeterritories));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public IHttpActionResult Get()
{
try // handle exogenous exceptions
{
try // log all exceptions
{
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
List <BusinessModelLayer.EmployeeterritoriesSingle> employeeterritoriess = employeeterritoriesBusinessModelLayers.GetAllEmployeeterritoriess();
return(Ok(employeeterritoriess));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(int EmployeeID, string TerritoryID)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
EmployeesBusinessModelLayers employeesLUBusinessModelLayers = new EmployeesBusinessModelLayers();
ViewBag.Employeess = new SelectList(employeesLUBusinessModelLayers.EmployeesSelect, "EmployeeID", "LastName");
TerritoriesBusinessModelLayers territoriesLUBusinessModelLayers = new TerritoriesBusinessModelLayers();
ViewBag.Territoriess = new SelectList(territoriesLUBusinessModelLayers.TerritoriesSelect, "TerritoryID", "TerritoryDescription");
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
BusinessModelLayer.EmployeeterritoriesSingle employeeterritories;
if (TerritoryID == null)
{
employeeterritories = employeeterritoriesBusinessModelLayers.GetAllEmployeeterritoriess().FirstOrDefault(x => x.EmployeeID == EmployeeID);
}
else
{
employeeterritories = employeeterritoriesBusinessModelLayers.GetAllEmployeeterritoriess().FirstOrDefault(x => x.EmployeeID == EmployeeID && x.TerritoryID == TerritoryID);
}
return(View(employeeterritories));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Create_Post()
{
try // handle exogenous exceptions
{
try // log all exceptions
{
EmployeesBusinessModelLayers employeesLUBusinessModelLayers = new EmployeesBusinessModelLayers();
ViewBag.Employeess = new SelectList(employeesLUBusinessModelLayers.EmployeesSelect, "EmployeeID", "LastName");
TerritoriesBusinessModelLayers territoriesLUBusinessModelLayers = new TerritoriesBusinessModelLayers();
ViewBag.Territoriess = new SelectList(territoriesLUBusinessModelLayers.TerritoriesSelect, "TerritoryID", "TerritoryDescription");
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
BusinessModelLayer.EmployeeterritoriesSingle employeeterritories = new BusinessModelLayer.EmployeeterritoriesSingle();
TryUpdateModel(employeeterritories);
if (ModelState.IsValid)
{
//mm
employeeterritoriesBusinessModelLayers.AddEmployeeterritories(employeeterritories);
return(RedirectToAction("List"));
}
else
{
return(View());
}
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(string TerritoryID, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
RegionBusinessModelLayers regionLUBusinessModelLayers = new RegionBusinessModelLayers();
ViewBag.Regions = new SelectList(regionLUBusinessModelLayers.RegionSelect, "RegionID", "RegionDescription");
ViewBag.CurrentSort = sortOrder;
ViewBag.TerritoryID = TerritoryID;
BusinessLayer.Validation pge = new BusinessLayer.Validation();
List <SelectListItem> PgeSizes = pge.PageSize();
//Assigning generic list to ViewBag
ViewBag.PgeSizeList = PgeSizes;
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
//TERRITORIES TABLE MASTER
BusinessModelLayer.Territories.TerritoriesMasterDetailModel pageModel = new BusinessModelLayer.Territories.TerritoriesMasterDetailModel();
TerritoriesBusinessModelLayers territoriesBusinessModelLayers = new TerritoriesBusinessModelLayers();
Territories.TerritoriesMasterDetailModel territoriesMasterDetailModel = new Territories.TerritoriesMasterDetailModel();
pageModel.Territories = territoriesBusinessModelLayers.GetAllTerritoriess().FirstOrDefault(x => x.TerritoryID == TerritoryID);
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
//EMPLOYEETERRITORIES DETAIL BEGIN
ViewBag.TerritoryIDSortParm = String.IsNullOrEmpty(sortOrder) ? "TerritoryID_desc" : "";
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
List <BusinessModelLayer.Vwemployeeterritories> employeeterritoriess = employeeterritoriesBusinessModelLayers.GetAllVwemployeeterritoriess().FindAll(x => x.TerritoryID == TerritoryID).ToList();
if (!String.IsNullOrEmpty(searchString))
{
employeeterritoriess = employeeterritoriess.Where(s => s.TerritoryID == TerritoryID && s.TerritoryID.ToString().ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "TerritoryID_desc":
employeeterritoriess = employeeterritoriess.OrderByDescending(s => s.TerritoryID).ToList();
break;
default: // TerritoryID ascending
employeeterritoriess = employeeterritoriess.OrderBy(s => s.TerritoryID).ToList();
break;
}
pageModel.EmployeeterritoriesVwDetl = employeeterritoriess.ToPagedList(pageNumber, pageSize);
//EMPLOYEETERRITORIES DETAIL END
return(View(pageModel));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit_Post(TerritoriesSingle territories, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
TerritoriesBusinessModelLayers territoriesBusinessModelLayers = new TerritoriesBusinessModelLayers();
if (ModelState.IsValid)
{
//mm
territoriesBusinessModelLayers.UpdateTerritories(territories);
return(RedirectToAction("List"));
}
ViewBag.CurrentSort = sortOrder;
ViewBag.TerritoryID = territories.TerritoryID;
BusinessLayer.Validation pge = new BusinessLayer.Validation();
List <SelectListItem> PgeSizes = pge.PageSize();
//Assigning generic list to ViewBag
ViewBag.PgeSizeList = PgeSizes;
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
//TERRITORIES TABLE MASTER
BusinessModelLayer.Territories.TerritoriesMasterDetailModel pageModel = new BusinessModelLayer.Territories.TerritoriesMasterDetailModel
{
Territories = territoriesBusinessModelLayers.GetAllTerritoriess().Single(x => x.TerritoryID == territories.TerritoryID)
};
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
//EMPLOYEETERRITORIES DETAIL BEGIN
ViewBag.TerritoryIDSortParm = String.IsNullOrEmpty(sortOrder) ? "TerritoryID_desc" : "";
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
pageModel.EmployeeterritoriesVwDetl = employeeterritoriesBusinessModelLayers.GetAllVwemployeeterritoriess().FindAll(x => x.TerritoryID == territories.TerritoryID).ToList().ToPagedList(pageNumber, pageSize);
if (!String.IsNullOrEmpty(searchString))
{
pageModel.EmployeeterritoriesVwDetl = pageModel.EmployeeterritoriesVwDetl.Where(s => s.TerritoryID.ToString().ToLower().Contains(searchString.ToLower())).ToList().ToPagedList(pageNumber, pageSize);
}
switch (sortOrder)
{
case "TerritoryID_desc":
pageModel.EmployeeterritoriesVwDetl = pageModel.EmployeeterritoriesVwDetl.OrderByDescending(s => s.TerritoryID).ToList().ToPagedList(pageNumber, pageSize);
break;
default: // TerritoryID ascending
pageModel.EmployeeterritoriesVwDetl = pageModel.EmployeeterritoriesVwDetl.OrderBy(s => s.TerritoryID).ToList().ToPagedList(pageNumber, pageSize);
break;
}
//EMPLOYEETERRITORIES DETAIL END
return(View(pageModel));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ViewResult List(string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
ViewBag.CurrentSort = sortOrder;
ViewBag.TerritoryIDSortParm = String.IsNullOrEmpty(sortOrder) ? "TerritoryID_desc" : "";
BusinessLayer.Validation pge = new BusinessLayer.Validation();
List <SelectListItem> PgeSizes = pge.PageSize();
//Assigning generic list to ViewBag
ViewBag.PgeSizeList = PgeSizes;
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
ViewBag.CurrentFilter = searchString;
EmployeeterritoriesBusinessModelLayers employeeterritoriesBusinessModelLayers = new EmployeeterritoriesBusinessModelLayers();
List <BusinessModelLayer.Vwemployeeterritories> vwemployeeterritoriess = employeeterritoriesBusinessModelLayers.GetAllVwemployeeterritoriess();
if (!String.IsNullOrEmpty(searchString))
{
vwemployeeterritoriess = vwemployeeterritoriess.Where(s => s.TerritoryID.ToString().ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "TerritoryID_desc":
vwemployeeterritoriess = vwemployeeterritoriess.OrderByDescending(s => s.TerritoryID).ToList();
break;
//case "!!!":
// vwemployeeterritoriess = vwemployeeterritoriess.OrderBy(s => s.!!!).ToList();
// break;
//case "!!!_desc":
// vwemployeeterritoriess = vwemployeeterritoriess.OrderByDescending(s => s.!!!).ToList();
// break;
default: // TerritoryID ascending
vwemployeeterritoriess = vwemployeeterritoriess.OrderBy(s => s.TerritoryID).ToList();
break;
}
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
return(View(vwemployeeterritoriess.ToPagedList(pageNumber, pageSize)));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
