public ActionResult Verify(string Username, string Password) { try // handle exogenous exceptions { try // log all exceptions { Tbl_LoginBusinessModelLayers tbl_loginBusinessModelLayers = new Tbl_LoginBusinessModelLayers(); BusinessModelLayer.Tbl_LoginSingle tbl_login = tbl_loginBusinessModelLayers.GetAllTbl_Logins().FirstOrDefault(x => x.Username == Username && x.Password == Password); if (tbl_login != null) { UpdateModel <Tbl_LoginSingle>(tbl_login); if (ModelState.IsValid) { FormsAuthentication.SetAuthCookie(tbl_login.Username, false); return(RedirectToAction("List", "Orders")); } } return(View("Error")); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public IHttpActionResult Get(string Username) { try // handle exogenous exceptions { try // log all exceptions { Tbl_LoginBusinessModelLayers tbl_loginBusinessModelLayers = new Tbl_LoginBusinessModelLayers(); List<BusinessModelLayer.Tbl_LoginSingle> tbl_logins = tbl_loginBusinessModelLayers.GetAllTbl_Logins().FindAll(x => x.Username == Username); //BusinessModelLayer.Tbl_LoginSingle tbl_logins = tbl_loginBusinessModelLayers.GetTbl_LoginData(Username); return Ok(tbl_logins); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Details(string TerritoryID) { try // handle exogenous exceptions { try // log all exceptions { RegionBusinessModelLayers regionLUBusinessModelLayers = new RegionBusinessModelLayers(); ViewBag.Regions = new SelectList(regionLUBusinessModelLayers.RegionSelect, "RegionID", "RegionDescription"); TerritoriesBusinessModelLayers territoriesBusinessModelLayers = new TerritoriesBusinessModelLayers(); BusinessModelLayer.TerritoriesSingle territories = territoriesBusinessModelLayers.GetAllTerritoriess().FirstOrDefault(x => x.TerritoryID == TerritoryID); return(View(territories)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Delete_Post(int EmployeeID) { try // handle exogenous exceptions { try // log all exceptions { EmployeesBusinessModelLayers employeesBusinessModelLayers = new EmployeesBusinessModelLayers(); //mm employeesBusinessModelLayers.DeleteEmployees(EmployeeID); return(RedirectToAction("List")); } 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"); EmployeesBusinessModelLayers employeesBusinessModelLayers = new EmployeesBusinessModelLayers(); BusinessModelLayer.EmployeesSingle employees = new BusinessModelLayer.EmployeesSingle(); TryUpdateModel(employees); if (ModelState.IsValid) { //mm employeesBusinessModelLayers.AddEmployees(employees); return(RedirectToAction("List")); } else { return(View()); } } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
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; } }
//END - read //BEGIN - sql view public List <Vwcategories> GetAllVwcategoriess() { try // handle exogenous exceptions { try // log all exceptions { List <Vwcategories> Vwcategoriess = new List <Vwcategories>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SELECT * FROM Vwcategories", con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Vwcategories vwcategories = new Vwcategories { // EXAMPLES: //EmployeeId = Convert.ToInt32(rdr["EmployeeId"]), //Name = rdr["Name"].ToString(), //IsPermanent = (bool)rdr["IsPermanent"], //Salary = Convert.ToDecimal(rdr["Salary"]), //DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]) //CategoryID = (int)rdr["CategoryID"] CategoryID = rdr["CategoryID"] == DBNull.Value ? default(int) : (int)rdr["CategoryID"] //,CategoryName = (string)rdr["CategoryName"] , CategoryName = rdr["CategoryName"] == DBNull.Value ? "" : (string)rdr["CategoryName"] //,Description = (string)rdr["Description"] , Description = rdr["Description"] == DBNull.Value ? "" : (string)rdr["Description"] //,Picture = (byte[])rdr["Picture"] , Picture = rdr["Picture"] == DBNull.Value ? default(byte[]) : (byte[])rdr["Picture"] }; Vwcategoriess.Add(vwcategories); } con.Close(); cmd.Dispose(); } return(Vwcategoriess); } 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 IHttpActionResult Get(int OrderID, int?ProductID) { try // handle exogenous exceptions { try // log all exceptions { Order_DetailsBusinessModelLayers order_detailsBusinessModelLayers = new Order_DetailsBusinessModelLayers(); BusinessModelLayer.Order_DetailsSingle order_detailss = new Order_DetailsSingle(); if (ProductID == null) { order_detailss = order_detailsBusinessModelLayers.GetAllOrder_Detailss().FirstOrDefault(x => x.OrderID == OrderID); } else { order_detailss = order_detailsBusinessModelLayers.GetAllOrder_Detailss().FirstOrDefault(x => x.OrderID == OrderID && x.ProductID == ProductID); } return(Ok(order_detailss)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Create_Get() { 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"); return(View()); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Details(int OrderID) { 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"); OrdersBusinessModelLayers ordersBusinessModelLayers = new OrdersBusinessModelLayers(); BusinessModelLayer.OrdersSingle orders = ordersBusinessModelLayers.GetAllOrderss().FirstOrDefault(x => x.OrderID == OrderID); return(View(orders)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
//END - delete //BEGIN - read public List <ShippersSingle> GetAllShipperss() { try // handle exogenous exceptions { try // log all exceptions { List <ShippersSingle> shipperss = new List <ShippersSingle>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("spGetAllShippers", con) { CommandType = CommandType.StoredProcedure }; con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { ShippersSingle shippers = new ShippersSingle { // EXAMPLES: //EmployeeId = Convert.ToInt32(rdr["EmployeeId"]), //Name = rdr["Name"].ToString(), //IsPermanent = (bool)rdr["IsPermanent"], //Salary = Convert.ToDecimal(rdr["Salary"]), //DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]) //ShipperID = (int)rdr["ShipperID"] ShipperID = rdr["ShipperID"] == DBNull.Value ? default(int) : (int)rdr["ShipperID"] //,CompanyName = (string)rdr["CompanyName"] , CompanyName = rdr["CompanyName"] == DBNull.Value ? "" : (string)rdr["CompanyName"] //,Phone = (string)rdr["Phone"] , Phone = rdr["Phone"] == DBNull.Value ? "" : (string)rdr["Phone"] }; shipperss.Add(shippers); } con.Close(); cmd.Dispose(); } return(shipperss); } 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 Details(int ProductID) { try // handle exogenous exceptions { try // log all exceptions { CategoriesBusinessModelLayers categoriesLUBusinessModelLayers = new CategoriesBusinessModelLayers(); ViewBag.Categoriess = new SelectList(categoriesLUBusinessModelLayers.CategoriesSelect, "CategoryID", "CategoryName"); SuppliersBusinessModelLayers suppliersLUBusinessModelLayers = new SuppliersBusinessModelLayers(); ViewBag.Supplierss = new SelectList(suppliersLUBusinessModelLayers.SuppliersSelect, "SupplierID", "CompanyName"); ProductsBusinessModelLayers productsBusinessModelLayers = new ProductsBusinessModelLayers(); BusinessModelLayer.ProductsSingle products = productsBusinessModelLayers.GetAllProductss().FirstOrDefault(x => x.ProductID == ProductID); return(View(products)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Delete_Post(int ProductID) { try // handle exogenous exceptions { try // log all exceptions { ProductsBusinessModelLayers productsBusinessModelLayers = new ProductsBusinessModelLayers(); //mm productsBusinessModelLayers.DeleteProducts(ProductID); return(RedirectToAction("List")); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
//END - read //BEGIN - sql view public List <Vwtbl_login> GetAllVwtbl_logins() { try // handle exogenous exceptions { try // log all exceptions { List <Vwtbl_login> Vwtbl_Logins = new List <Vwtbl_login>(); using (SqlConnection con = new SqlConnection(connectionString)) { SqlCommand cmd = new SqlCommand("SELECT * FROM Vwtbl_Login", con); con.Open(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Vwtbl_login vwtbl_login = new Vwtbl_login { // EXAMPLES: //EmployeeId = Convert.ToInt32(rdr["EmployeeId"]), //Name = rdr["Name"].ToString(), //IsPermanent = (bool)rdr["IsPermanent"], //Salary = Convert.ToDecimal(rdr["Salary"]), //DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]) //Username = (string)rdr["Username"] Username = rdr["Username"] == DBNull.Value ? "" : (string)rdr["Username"] //,Password = (string)rdr["Password"] , Password = rdr["Password"] == DBNull.Value ? "" : (string)rdr["Password"] //,Roles = (string)rdr["Roles"] , Roles = rdr["Roles"] == DBNull.Value ? "" : (string)rdr["Roles"] //,ActiveStatus = (bool)rdr["ActiveStatus"] , ActiveStatus = rdr["ActiveStatus"] == DBNull.Value ? false : (bool)rdr["ActiveStatus"] }; Vwtbl_Logins.Add(vwtbl_login); } con.Close(); cmd.Dispose(); } return(Vwtbl_Logins); } 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 Delete_Post(string CustomerTypeID) { try // handle exogenous exceptions { try // log all exceptions { CustomerdemographicsBusinessModelLayers customerdemographicsBusinessModelLayers = new CustomerdemographicsBusinessModelLayers(); //mm customerdemographicsBusinessModelLayers.DeleteCustomerdemographics(CustomerTypeID); return(RedirectToAction("List")); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public IHttpActionResult Get(string CustomerID, string CustomerTypeID) { try // handle exogenous exceptions { try // log all exceptions { CustomercustomerdemoBusinessModelLayers customercustomerdemoBusinessModelLayers = new CustomercustomerdemoBusinessModelLayers(); BusinessModelLayer.CustomercustomerdemoSingle customercustomerdemos = new CustomercustomerdemoSingle(); if (CustomerTypeID == null) { customercustomerdemos = customercustomerdemoBusinessModelLayers.GetAllCustomercustomerdemos().FirstOrDefault(x => x.CustomerID == CustomerID); } else { customercustomerdemos = customercustomerdemoBusinessModelLayers.GetAllCustomercustomerdemos().FirstOrDefault(x => x.CustomerID == CustomerID && x.CustomerTypeID == CustomerTypeID); } return(Ok(customercustomerdemos)); } 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 { CustomerdemographicsBusinessModelLayers customerdemographicsBusinessModelLayers = new CustomerdemographicsBusinessModelLayers(); BusinessModelLayer.CustomerdemographicsSingle customerdemographics = new BusinessModelLayer.CustomerdemographicsSingle(); TryUpdateModel(customerdemographics); if (ModelState.IsValid) { //mm customerdemographicsBusinessModelLayers.AddCustomerdemographics(customerdemographics); return(RedirectToAction("List")); } else { return(View()); } } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Delete_Post(int OrderID, int?ProductID) { try // handle exogenous exceptions { try // log all exceptions { Order_DetailsBusinessModelLayers order_detailsBusinessModelLayers = new Order_DetailsBusinessModelLayers(); if (ProductID == null) { //mm order_detailsBusinessModelLayers.DeleteOrder_Details(OrderID); } else { //mm order_detailsBusinessModelLayers.EXE_sql("DELETE FROM [Order Details] WHERE (OrderID = " + "N'" + OrderID.ToString() + "'" + ") AND (ProductID = " + "N'" + ProductID.ToString() + "'" + ")"); } return(RedirectToAction("List")); } 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 { RegionBusinessModelLayers regionBusinessModelLayers = new RegionBusinessModelLayers(); BusinessModelLayer.RegionSingle region = new BusinessModelLayer.RegionSingle(); TryUpdateModel(region); if (ModelState.IsValid) { //mm regionBusinessModelLayers.AddRegion(region); return(RedirectToAction("List")); } else { return(View()); } } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
//END - create //BEGIN - update public void UpdateEmployeeterritories(EmployeeterritoriesSingle employeeterritories) { try // handle exogenous exceptions { try // log all exceptions { using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("spUpdateEmployeeterritories", con) { CommandType = CommandType.StoredProcedure }) { cmd.Parameters.AddWithValue("@EmployeeID", employeeterritories.EmployeeID); cmd.Parameters.AddWithValue("@TerritoryID", employeeterritories.TerritoryID); 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 Delete_Post(string CustomerID, string CustomerTypeID) { try // handle exogenous exceptions { try // log all exceptions { CustomercustomerdemoBusinessModelLayers customercustomerdemoBusinessModelLayers = new CustomercustomerdemoBusinessModelLayers(); if (CustomerTypeID == null) { //mm customercustomerdemoBusinessModelLayers.DeleteCustomercustomerdemo(CustomerID); } else { //mm customercustomerdemoBusinessModelLayers.EXE_sql("DELETE FROM [CustomerCustomerDemo] WHERE (CustomerID = " + "N'" + CustomerID.ToString() + "'" + ") AND (CustomerTypeID = " + "N'" + CustomerTypeID.ToString() + "'" + ")"); } return(RedirectToAction("List")); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Details(int EmployeeID) { try // handle exogenous exceptions { try // log all exceptions { EmployeesBusinessModelLayers employeesLUBusinessModelLayers = new EmployeesBusinessModelLayers(); ViewBag.Employeess = new SelectList(employeesLUBusinessModelLayers.EmployeesSelect, "EmployeeID", "LastName"); EmployeesBusinessModelLayers employeesBusinessModelLayers = new EmployeesBusinessModelLayers(); BusinessModelLayer.EmployeesSingle employees = employeesBusinessModelLayers.GetAllEmployeess().FirstOrDefault(x => x.EmployeeID == EmployeeID); return(View(employees)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Edit_Post(long Logid) { try // handle exogenous exceptions { try // log all exceptions { Tbl_ExceptionloggingtodatabaseBusinessModelLayers tbl_exceptionloggingtodatabaseBusinessModelLayers = new Tbl_ExceptionloggingtodatabaseBusinessModelLayers(); BusinessModelLayer.Tbl_ExceptionloggingtodatabaseSingle tbl_exceptionloggingtodatabase = tbl_exceptionloggingtodatabaseBusinessModelLayers.GetAllTbl_Exceptionloggingtodatabases().Single(x => x.Logid == Logid); UpdateModel <Tbl_ExceptionloggingtodatabaseSingle>(tbl_exceptionloggingtodatabase); if (ModelState.IsValid) { //mm tbl_exceptionloggingtodatabaseBusinessModelLayers.UpdateTbl_Exceptionloggingtodatabase(tbl_exceptionloggingtodatabase); return(RedirectToAction("List")); } return(View(tbl_exceptionloggingtodatabase)); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
//END - update //BEGIN - delete public void DeleteCustomerdemographics(string CustomerTypeID) { try // handle exogenous exceptions { try // log all exceptions { using (SqlConnection con = new SqlConnection(connectionString)) { using (SqlCommand cmd = new SqlCommand("spDeleteCustomerdemographics", con) { CommandType = CommandType.StoredProcedure }) { cmd.Parameters.AddWithValue("@CustomerTypeID", CustomerTypeID); 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 Delete_Post(long Logid) { try // handle exogenous exceptions { try // log all exceptions { Tbl_ExceptionloggingtodatabaseBusinessModelLayers tbl_exceptionloggingtodatabaseBusinessModelLayers = new Tbl_ExceptionloggingtodatabaseBusinessModelLayers(); //mm tbl_exceptionloggingtodatabaseBusinessModelLayers.DeleteTbl_Exceptionloggingtodatabase(Logid); return(RedirectToAction("List")); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Delete_Post(string TerritoryID) { try // handle exogenous exceptions { try // log all exceptions { TerritoriesBusinessModelLayers territoriesBusinessModelLayers = new TerritoriesBusinessModelLayers(); //mm territoriesBusinessModelLayers.DeleteTerritories(TerritoryID); return(RedirectToAction("List")); } 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 { Tbl_ExceptionloggingtodatabaseBusinessModelLayers tbl_exceptionloggingtodatabaseBusinessModelLayers = new Tbl_ExceptionloggingtodatabaseBusinessModelLayers(); BusinessModelLayer.Tbl_ExceptionloggingtodatabaseSingle tbl_exceptionloggingtodatabase = new BusinessModelLayer.Tbl_ExceptionloggingtodatabaseSingle(); TryUpdateModel(tbl_exceptionloggingtodatabase); if (ModelState.IsValid) { //mm tbl_exceptionloggingtodatabaseBusinessModelLayers.AddTbl_Exceptionloggingtodatabase(tbl_exceptionloggingtodatabase); return(RedirectToAction("List")); } else { return(View()); } } 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 { RegionBusinessModelLayers regionLUBusinessModelLayers = new RegionBusinessModelLayers(); ViewBag.Regions = new SelectList(regionLUBusinessModelLayers.RegionSelect, "RegionID", "RegionDescription"); TerritoriesBusinessModelLayers territoriesBusinessModelLayers = new TerritoriesBusinessModelLayers(); BusinessModelLayer.TerritoriesSingle territories = new BusinessModelLayer.TerritoriesSingle(); TryUpdateModel(territories); if (ModelState.IsValid) { //mm territoriesBusinessModelLayers.AddTerritories(territories); return(RedirectToAction("List")); } else { return(View()); } } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }
public ActionResult Delete_Post(string Username) { try // handle exogenous exceptions { try // log all exceptions { Tbl_LoginBusinessModelLayers tbl_loginBusinessModelLayers = new Tbl_LoginBusinessModelLayers(); //mm tbl_loginBusinessModelLayers.DeleteTbl_Login(Username); return(RedirectToAction("List")); } catch (Exception ex) { BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging(); exlog.SendExcepToDB(ex); throw; } } catch (Exception) { throw; } }