//END - create
//BEGIN - update
public void UpdateTbl_Exceptionloggingtodatabase(Tbl_ExceptionloggingtodatabaseSingle tbl_exceptionloggingtodatabase)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
BusinessLayer.Validation isdte = new BusinessLayer.Validation();
if (isdte.IsDate(tbl_exceptionloggingtodatabase.Logdate) == false)
{
tbl_exceptionloggingtodatabase.Logdate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("spUpdateTbl_Exceptionloggingtodatabase", con)
{
CommandType = CommandType.StoredProcedure
})
{
cmd.Parameters.AddWithValue("@Logid", tbl_exceptionloggingtodatabase.Logid);
cmd.Parameters.AddWithValue("@ExceptionMsg", (object)tbl_exceptionloggingtodatabase.ExceptionMsg ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ExceptionType", (object)tbl_exceptionloggingtodatabase.ExceptionType ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ExceptionSource", (object)tbl_exceptionloggingtodatabase.ExceptionSource ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ExceptionURL", (object)tbl_exceptionloggingtodatabase.ExceptionURL ?? DBNull.Value);
cmd.Parameters.AddWithValue("@Logdate", (object)tbl_exceptionloggingtodatabase.Logdate ?? DBNull.Value);
con.Open();
cmd.ExecuteNonQuery();
}
con.Close();
}
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
//errResult = "A Technical Error occurred, Please visit after some time.";
throw;
}
}
catch (Exception fx)
{
errResult = fx.Message.ToString();
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 ViewResult List(string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
ViewBag.CurrentSort = sortOrder;
ViewBag.TerritoryDescriptionSortParm = String.IsNullOrEmpty(sortOrder) ? "TerritoryDescription_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;
TerritoriesBusinessModelLayers territoriesBusinessModelLayers = new TerritoriesBusinessModelLayers();
List <BusinessModelLayer.Vwterritories> vwterritoriess = territoriesBusinessModelLayers.GetAllVwterritoriess();
if (!String.IsNullOrEmpty(searchString))
{
vwterritoriess = vwterritoriess.Where(s => s.TerritoryDescription.ToString().ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "TerritoryDescription_desc":
vwterritoriess = vwterritoriess.OrderByDescending(s => s.TerritoryDescription).ToList();
break;
//case "!!!":
// vwterritoriess = vwterritoriess.OrderBy(s => s.!!!).ToList();
// break;
//case "!!!_desc":
// vwterritoriess = vwterritoriess.OrderByDescending(s => s.!!!).ToList();
// break;
default: // TerritoryDescription ascending
vwterritoriess = vwterritoriess.OrderBy(s => s.TerritoryDescription).ToList();
break;
}
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
return(View(vwterritoriess.ToPagedList(pageNumber, pageSize)));
}
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;
}
}
//END - create
//BEGIN - update
public void UpdateEmployees(EmployeesSingle employees)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
BusinessLayer.Validation isdte = new BusinessLayer.Validation();
if (isdte.IsDate(employees.BirthDate) == false)
{
employees.BirthDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
if (isdte.IsDate(employees.HireDate) == false)
{
employees.HireDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("spUpdateEmployees", con)
{
CommandType = CommandType.StoredProcedure
})
{
cmd.Parameters.AddWithValue("@EmployeeID", employees.EmployeeID);
cmd.Parameters.AddWithValue("@LastName", employees.LastName);
cmd.Parameters.AddWithValue("@FirstName", employees.FirstName);
cmd.Parameters.AddWithValue("@Title", (object)employees.Title ?? DBNull.Value);
cmd.Parameters.AddWithValue("@TitleOfCourtesy", (object)employees.TitleOfCourtesy ?? DBNull.Value);
cmd.Parameters.AddWithValue("@BirthDate", (object)employees.BirthDate ?? DBNull.Value);
cmd.Parameters.AddWithValue("@HireDate", (object)employees.HireDate ?? DBNull.Value);
cmd.Parameters.AddWithValue("@Address", (object)employees.Address ?? DBNull.Value);
cmd.Parameters.AddWithValue("@City", (object)employees.City ?? DBNull.Value);
cmd.Parameters.AddWithValue("@Region", (object)employees.Region ?? DBNull.Value);
cmd.Parameters.AddWithValue("@PostalCode", (object)employees.PostalCode ?? DBNull.Value);
cmd.Parameters.AddWithValue("@Country", (object)employees.Country ?? DBNull.Value);
cmd.Parameters.AddWithValue("@HomePhone", (object)employees.HomePhone ?? DBNull.Value);
cmd.Parameters.AddWithValue("@Extension", (object)employees.Extension ?? DBNull.Value);
cmd.Parameters.AddWithValue("@Photo", (object)employees.Photo ?? DBNull.Value);
cmd.Parameters.AddWithValue("@Notes", (object)employees.Notes ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ReportsTo", (object)employees.ReportsTo ?? DBNull.Value);
cmd.Parameters.AddWithValue("@PhotoPath", (object)employees.PhotoPath ?? DBNull.Value);
con.Open();
cmd.ExecuteNonQuery();
}
con.Close();
}
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
//errResult = "A Technical Error occurred, Please visit after some time.";
throw;
}
}
catch (Exception fx)
{
errResult = fx.Message.ToString();
throw;
}
}
//END - readBy
//BEGIN - create
public void AddEmployees(EmployeesSingle employees)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
BusinessLayer.Validation isdte = new BusinessLayer.Validation();
if (isdte.IsDate(employees.BirthDate) == false)
{
employees.BirthDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
if (isdte.IsDate(employees.HireDate) == false)
{
employees.HireDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spAddEmployees", con)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter paramEmployeeID = new SqlParameter
{
ParameterName = "@EmployeeID",
Value = employees.EmployeeID
};
cmd.Parameters.Add(paramEmployeeID);
SqlParameter paramLastName = new SqlParameter
{
ParameterName = "@LastName",
Value = employees.LastName
};
cmd.Parameters.Add(paramLastName);
SqlParameter paramFirstName = new SqlParameter
{
ParameterName = "@FirstName",
Value = employees.FirstName
};
cmd.Parameters.Add(paramFirstName);
SqlParameter paramTitle = new SqlParameter
{
ParameterName = "@Title",
Value = employees.Title
};
cmd.Parameters.Add(paramTitle);
SqlParameter paramTitleOfCourtesy = new SqlParameter
{
ParameterName = "@TitleOfCourtesy",
Value = employees.TitleOfCourtesy
};
cmd.Parameters.Add(paramTitleOfCourtesy);
SqlParameter paramBirthDate = new SqlParameter
{
ParameterName = "@BirthDate",
Value = employees.BirthDate
};
cmd.Parameters.Add(paramBirthDate);
SqlParameter paramHireDate = new SqlParameter
{
ParameterName = "@HireDate",
Value = employees.HireDate
};
cmd.Parameters.Add(paramHireDate);
SqlParameter paramAddress = new SqlParameter
{
ParameterName = "@Address",
Value = employees.Address
};
cmd.Parameters.Add(paramAddress);
SqlParameter paramCity = new SqlParameter
{
ParameterName = "@City",
Value = employees.City
};
cmd.Parameters.Add(paramCity);
SqlParameter paramRegion = new SqlParameter
{
ParameterName = "@Region",
Value = employees.Region
};
cmd.Parameters.Add(paramRegion);
SqlParameter paramPostalCode = new SqlParameter
{
ParameterName = "@PostalCode",
Value = employees.PostalCode
};
cmd.Parameters.Add(paramPostalCode);
SqlParameter paramCountry = new SqlParameter
{
ParameterName = "@Country",
Value = employees.Country
};
cmd.Parameters.Add(paramCountry);
SqlParameter paramHomePhone = new SqlParameter
{
ParameterName = "@HomePhone",
Value = employees.HomePhone
};
cmd.Parameters.Add(paramHomePhone);
SqlParameter paramExtension = new SqlParameter
{
ParameterName = "@Extension",
Value = employees.Extension
};
cmd.Parameters.Add(paramExtension);
SqlParameter paramPhoto = new SqlParameter
{
ParameterName = "@Photo",
Value = employees.Photo
};
cmd.Parameters.Add(paramPhoto);
SqlParameter paramNotes = new SqlParameter
{
ParameterName = "@Notes",
Value = employees.Notes
};
cmd.Parameters.Add(paramNotes);
SqlParameter paramReportsTo = new SqlParameter
{
ParameterName = "@ReportsTo",
Value = employees.ReportsTo
};
cmd.Parameters.Add(paramReportsTo);
SqlParameter paramPhotoPath = new SqlParameter
{
ParameterName = "@PhotoPath",
Value = employees.PhotoPath
};
cmd.Parameters.Add(paramPhotoPath);
con.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
//errResult = "A Technical Error occurred, Please visit after some time.";
throw;
}
}
catch (Exception fx)
{
errResult = fx.Message.ToString();
throw;
}
}
//END - readBy
//BEGIN - create
public void AddTbl_Exceptionloggingtodatabase(Tbl_ExceptionloggingtodatabaseSingle tbl_exceptionloggingtodatabase)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
BusinessLayer.Validation isdte = new BusinessLayer.Validation();
if (isdte.IsDate(tbl_exceptionloggingtodatabase.Logdate) == false)
{
tbl_exceptionloggingtodatabase.Logdate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spAddTbl_Exceptionloggingtodatabase", con)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter paramLogid = new SqlParameter
{
ParameterName = "@Logid",
Value = tbl_exceptionloggingtodatabase.Logid
};
cmd.Parameters.Add(paramLogid);
SqlParameter paramExceptionMsg = new SqlParameter
{
ParameterName = "@ExceptionMsg",
Value = tbl_exceptionloggingtodatabase.ExceptionMsg
};
cmd.Parameters.Add(paramExceptionMsg);
SqlParameter paramExceptionType = new SqlParameter
{
ParameterName = "@ExceptionType",
Value = tbl_exceptionloggingtodatabase.ExceptionType
};
cmd.Parameters.Add(paramExceptionType);
SqlParameter paramExceptionSource = new SqlParameter
{
ParameterName = "@ExceptionSource",
Value = tbl_exceptionloggingtodatabase.ExceptionSource
};
cmd.Parameters.Add(paramExceptionSource);
SqlParameter paramExceptionURL = new SqlParameter
{
ParameterName = "@ExceptionURL",
Value = tbl_exceptionloggingtodatabase.ExceptionURL
};
cmd.Parameters.Add(paramExceptionURL);
SqlParameter paramLogdate = new SqlParameter
{
ParameterName = "@Logdate",
Value = tbl_exceptionloggingtodatabase.Logdate
};
cmd.Parameters.Add(paramLogdate);
con.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
//errResult = "A Technical Error occurred, Please visit after some time.";
throw;
}
}
catch (Exception fx)
{
errResult = fx.Message.ToString();
throw;
}
}
public ActionResult Edit(string CustomerTypeID, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
ViewBag.CurrentSort = sortOrder;
ViewBag.CustomerTypeID = CustomerTypeID;
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;
//CUSTOMERDEMOGRAPHICS TABLE MASTER
BusinessModelLayer.Customerdemographics.CustomerdemographicsMasterDetailModel pageModel = new BusinessModelLayer.Customerdemographics.CustomerdemographicsMasterDetailModel();
CustomerdemographicsBusinessModelLayers customerdemographicsBusinessModelLayers = new CustomerdemographicsBusinessModelLayers();
Customerdemographics.CustomerdemographicsMasterDetailModel customerdemographicsMasterDetailModel = new Customerdemographics.CustomerdemographicsMasterDetailModel();
pageModel.Customerdemographics = customerdemographicsBusinessModelLayers.GetAllCustomerdemographicss().FirstOrDefault(x => x.CustomerTypeID == CustomerTypeID);
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
//CUSTOMERCUSTOMERDEMO DETAIL BEGIN
ViewBag.CustomerTypeIDSortParm = String.IsNullOrEmpty(sortOrder) ? "CustomerTypeID_desc" : "";
CustomercustomerdemoBusinessModelLayers customercustomerdemoBusinessModelLayers = new CustomercustomerdemoBusinessModelLayers();
List <BusinessModelLayer.Vwcustomercustomerdemo> customercustomerdemos = customercustomerdemoBusinessModelLayers.GetAllVwcustomercustomerdemos().FindAll(x => x.CustomerTypeID == CustomerTypeID).ToList();
if (!String.IsNullOrEmpty(searchString))
{
customercustomerdemos = customercustomerdemos.Where(s => s.CustomerTypeID == CustomerTypeID && s.CustomerTypeID.ToString().ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "CustomerTypeID_desc":
customercustomerdemos = customercustomerdemos.OrderByDescending(s => s.CustomerTypeID).ToList();
break;
default: // CustomerTypeID ascending
customercustomerdemos = customercustomerdemos.OrderBy(s => s.CustomerTypeID).ToList();
break;
}
pageModel.CustomercustomerdemoVwDetl = customercustomerdemos.ToPagedList(pageNumber, pageSize);
//CUSTOMERCUSTOMERDEMO DETAIL END
return(View(pageModel));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(int OrderID, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
ShippersBusinessModelLayers shippersLUBusinessModelLayers = new ShippersBusinessModelLayers();
ViewBag.Shipperss = new SelectList(shippersLUBusinessModelLayers.ShippersSelect, "ShipperID", "CompanyName");
EmployeesBusinessModelLayers employeesLUBusinessModelLayers = new EmployeesBusinessModelLayers();
ViewBag.Employeess = new SelectList(employeesLUBusinessModelLayers.EmployeesSelect, "EmployeeID", "LastName");
CustomersBusinessModelLayers customersLUBusinessModelLayers = new CustomersBusinessModelLayers();
ViewBag.Customerss = new SelectList(customersLUBusinessModelLayers.CustomersSelect, "CustomerID", "CompanyName");
ViewBag.CurrentSort = sortOrder;
ViewBag.OrderID = OrderID;
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;
//ORDERS TABLE MASTER
BusinessModelLayer.Orders.OrdersMasterDetailModel pageModel = new BusinessModelLayer.Orders.OrdersMasterDetailModel();
OrdersBusinessModelLayers ordersBusinessModelLayers = new OrdersBusinessModelLayers();
Orders.OrdersMasterDetailModel ordersMasterDetailModel = new Orders.OrdersMasterDetailModel();
pageModel.Orders = ordersBusinessModelLayers.GetAllOrderss().FirstOrDefault(x => x.OrderID == OrderID);
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
//ORDER_DETAILS DETAIL BEGIN
ViewBag.OrderIDSortParm = String.IsNullOrEmpty(sortOrder) ? "OrderID_desc" : "";
Order_DetailsBusinessModelLayers order_detailsBusinessModelLayers = new Order_DetailsBusinessModelLayers();
List <BusinessModelLayer.Vworder_details> order_detailss = order_detailsBusinessModelLayers.GetAllVworder_detailss().FindAll(x => x.OrderID == OrderID).ToList();
if (!String.IsNullOrEmpty(searchString))
{
order_detailss = order_detailss.Where(s => s.OrderID == OrderID && s.ProductID.ToString().ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "OrderID_desc":
order_detailss = order_detailss.OrderByDescending(s => s.OrderID).ToList();
break;
default: // OrderID ascending
order_detailss = order_detailss.OrderBy(s => s.OrderID).ToList();
break;
}
pageModel.Order_DetailsVwDetl = order_detailss.ToPagedList(pageNumber, pageSize);
//ORDER_DETAILS DETAIL END
return(View(pageModel));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
public ActionResult Edit(int CategoryID, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
ViewBag.CurrentSort = sortOrder;
ViewBag.CategoryID = CategoryID;
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;
//CATEGORIES TABLE MASTER
BusinessModelLayer.Categories.CategoriesMasterDetailModel pageModel = new BusinessModelLayer.Categories.CategoriesMasterDetailModel();
CategoriesBusinessModelLayers categoriesBusinessModelLayers = new CategoriesBusinessModelLayers();
Categories.CategoriesMasterDetailModel categoriesMasterDetailModel = new Categories.CategoriesMasterDetailModel();
pageModel.Categories = categoriesBusinessModelLayers.GetAllCategoriess().FirstOrDefault(x => x.CategoryID == CategoryID);
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
//PRODUCTS DETAIL BEGIN
ViewBag.CategoryIDSortParm = String.IsNullOrEmpty(sortOrder) ? "CategoryID_desc" : "";
ProductsBusinessModelLayers productsBusinessModelLayers = new ProductsBusinessModelLayers();
List <BusinessModelLayer.Vwproducts> productss = productsBusinessModelLayers.GetAllVwproductss().FindAll(x => x.CategoryID == CategoryID).ToList();
if (!String.IsNullOrEmpty(searchString))
{
productss = productss.Where(s => s.CategoryID == CategoryID && s.ProductName.ToString().ToLower().Contains(searchString.ToLower())).ToList();
}
switch (sortOrder)
{
case "CategoryID_desc":
productss = productss.OrderByDescending(s => s.CategoryID).ToList();
break;
default: // CategoryID ascending
productss = productss.OrderBy(s => s.CategoryID).ToList();
break;
}
pageModel.ProductsVwDetl = productss.ToPagedList(pageNumber, pageSize);
//PRODUCTS 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(SuppliersSingle suppliers, string sortOrder, string currentFilter, string searchString, int?page, string PgeSize)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
SuppliersBusinessModelLayers suppliersBusinessModelLayers = new SuppliersBusinessModelLayers();
if (ModelState.IsValid)
{
//mm
suppliersBusinessModelLayers.UpdateSuppliers(suppliers);
return(RedirectToAction("List"));
}
ViewBag.CurrentSort = sortOrder;
ViewBag.SupplierID = suppliers.SupplierID;
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;
//SUPPLIERS TABLE MASTER
BusinessModelLayer.Suppliers.SuppliersMasterDetailModel pageModel = new BusinessModelLayer.Suppliers.SuppliersMasterDetailModel
{
Suppliers = suppliersBusinessModelLayers.GetAllSupplierss().Single(x => x.SupplierID == suppliers.SupplierID)
};
int pageSize = 10;
if (PgeSize != null)
{
Int32.TryParse(PgeSize, out pageSize);
}
ViewBag.PgeSize = pageSize;
int pageNumber = (page ?? 1);
//PRODUCTS DETAIL BEGIN
ViewBag.ProductNameSortParm = String.IsNullOrEmpty(sortOrder) ? "ProductName_desc" : "";
ProductsBusinessModelLayers productsBusinessModelLayers = new ProductsBusinessModelLayers();
pageModel.ProductsVwDetl = productsBusinessModelLayers.GetAllVwproductss().FindAll(x => x.SupplierID == suppliers.SupplierID).ToList().ToPagedList(pageNumber, pageSize);
if (!String.IsNullOrEmpty(searchString))
{
pageModel.ProductsVwDetl = pageModel.ProductsVwDetl.Where(s => s.ProductName.ToString().ToLower().Contains(searchString.ToLower())).ToList().ToPagedList(pageNumber, pageSize);
}
switch (sortOrder)
{
case "ProductName_desc":
pageModel.ProductsVwDetl = pageModel.ProductsVwDetl.OrderByDescending(s => s.ProductName).ToList().ToPagedList(pageNumber, pageSize);
break;
default: // ProductName ascending
pageModel.ProductsVwDetl = pageModel.ProductsVwDetl.OrderBy(s => s.ProductName).ToList().ToPagedList(pageNumber, pageSize);
break;
}
//PRODUCTS DETAIL END
return(View(pageModel));
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
throw;
}
}
catch (Exception)
{
throw;
}
}
//END - create
//BEGIN - update
public void UpdateOrders(OrdersSingle orders)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
BusinessLayer.Validation isdte = new BusinessLayer.Validation();
if (isdte.IsDate(orders.OrderDate) == false)
{
orders.OrderDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
if (isdte.IsDate(orders.RequiredDate) == false)
{
orders.RequiredDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
if (isdte.IsDate(orders.ShippedDate) == false)
{
orders.ShippedDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
using (SqlConnection con = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand("spUpdateOrders", con)
{
CommandType = CommandType.StoredProcedure
})
{
cmd.Parameters.AddWithValue("@OrderID", orders.OrderID);
cmd.Parameters.AddWithValue("@CustomerID", (object)orders.CustomerID ?? DBNull.Value);
cmd.Parameters.AddWithValue("@EmployeeID", (object)orders.EmployeeID ?? DBNull.Value);
cmd.Parameters.AddWithValue("@OrderDate", (object)orders.OrderDate ?? DBNull.Value);
cmd.Parameters.AddWithValue("@RequiredDate", (object)orders.RequiredDate ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ShippedDate", (object)orders.ShippedDate ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ShipVia", (object)orders.ShipVia ?? DBNull.Value);
cmd.Parameters.AddWithValue("@Freight", (object)orders.Freight ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ShipName", (object)orders.ShipName ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ShipAddress", (object)orders.ShipAddress ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ShipCity", (object)orders.ShipCity ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ShipRegion", (object)orders.ShipRegion ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ShipPostalCode", (object)orders.ShipPostalCode ?? DBNull.Value);
cmd.Parameters.AddWithValue("@ShipCountry", (object)orders.ShipCountry ?? DBNull.Value);
con.Open();
cmd.ExecuteNonQuery();
}
con.Close();
}
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
//errResult = "A Technical Error occurred, Please visit after some time.";
throw;
}
}
catch (Exception fx)
{
errResult = fx.Message.ToString();
throw;
}
}
//END - readBy
//BEGIN - create
public void AddOrders(OrdersSingle orders)
{
try // handle exogenous exceptions
{
try // log all exceptions
{
BusinessLayer.Validation isdte = new BusinessLayer.Validation();
if (isdte.IsDate(orders.OrderDate) == false)
{
orders.OrderDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
if (isdte.IsDate(orders.RequiredDate) == false)
{
orders.RequiredDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
if (isdte.IsDate(orders.ShippedDate) == false)
{
orders.ShippedDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
}
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spAddOrders", con)
{
CommandType = CommandType.StoredProcedure
};
SqlParameter paramOrderID = new SqlParameter
{
ParameterName = "@OrderID",
Value = orders.OrderID
};
cmd.Parameters.Add(paramOrderID);
SqlParameter paramCustomerID = new SqlParameter
{
ParameterName = "@CustomerID",
Value = orders.CustomerID
};
cmd.Parameters.Add(paramCustomerID);
SqlParameter paramEmployeeID = new SqlParameter
{
ParameterName = "@EmployeeID",
Value = orders.EmployeeID
};
cmd.Parameters.Add(paramEmployeeID);
SqlParameter paramOrderDate = new SqlParameter
{
ParameterName = "@OrderDate",
Value = orders.OrderDate
};
cmd.Parameters.Add(paramOrderDate);
SqlParameter paramRequiredDate = new SqlParameter
{
ParameterName = "@RequiredDate",
Value = orders.RequiredDate
};
cmd.Parameters.Add(paramRequiredDate);
SqlParameter paramShippedDate = new SqlParameter
{
ParameterName = "@ShippedDate",
Value = orders.ShippedDate
};
cmd.Parameters.Add(paramShippedDate);
SqlParameter paramShipVia = new SqlParameter
{
ParameterName = "@ShipVia",
Value = orders.ShipVia
};
cmd.Parameters.Add(paramShipVia);
SqlParameter paramFreight = new SqlParameter
{
ParameterName = "@Freight",
Value = orders.Freight
};
cmd.Parameters.Add(paramFreight);
SqlParameter paramShipName = new SqlParameter
{
ParameterName = "@ShipName",
Value = orders.ShipName
};
cmd.Parameters.Add(paramShipName);
SqlParameter paramShipAddress = new SqlParameter
{
ParameterName = "@ShipAddress",
Value = orders.ShipAddress
};
cmd.Parameters.Add(paramShipAddress);
SqlParameter paramShipCity = new SqlParameter
{
ParameterName = "@ShipCity",
Value = orders.ShipCity
};
cmd.Parameters.Add(paramShipCity);
SqlParameter paramShipRegion = new SqlParameter
{
ParameterName = "@ShipRegion",
Value = orders.ShipRegion
};
cmd.Parameters.Add(paramShipRegion);
SqlParameter paramShipPostalCode = new SqlParameter
{
ParameterName = "@ShipPostalCode",
Value = orders.ShipPostalCode
};
cmd.Parameters.Add(paramShipPostalCode);
SqlParameter paramShipCountry = new SqlParameter
{
ParameterName = "@ShipCountry",
Value = orders.ShipCountry
};
cmd.Parameters.Add(paramShipCountry);
con.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
}
}
catch (Exception ex)
{
BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
exlog.SendExcepToDB(ex);
//errResult = "A Technical Error occurred, Please visit after some time.";
throw;
}
}
catch (Exception fx)
{
errResult = fx.Message.ToString();
throw;
}
}
