Ejemplo n.º 1
0
        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;
            }
        }
Ejemplo n.º 2
0
        public ActionResult Create_Post()
        {
            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 = new BusinessModelLayer.OrdersSingle();
                    TryUpdateModel(orders);
                    if (ModelState.IsValid)
                    {
                        //mm
                        ordersBusinessModelLayers.AddOrders(orders);
                        return(RedirectToAction("List"));
                    }
                    else
                    {
                        return(View());
                    }
                }
                catch (Exception ex)
                {
                    BusinessLayer.ExceptionLogging exlog = new BusinessLayer.ExceptionLogging();
                    exlog.SendExcepToDB(ex);
                    throw;
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Ejemplo n.º 3
0
        //END - delete


        //BEGIN - read
        public List <OrdersSingle> GetAllOrderss()
        {
            try     // handle exogenous exceptions
            {
                try // log all exceptions
                {
                    List <OrdersSingle> orderss = new List <OrdersSingle>();

                    using (SqlConnection con = new SqlConnection(connectionString))
                    {
                        SqlCommand cmd = new SqlCommand("spGetAllOrders", con)
                        {
                            CommandType = CommandType.StoredProcedure
                        };

                        con.Open();

                        SqlDataReader rdr = cmd.ExecuteReader();

                        while (rdr.Read())
                        {
                            OrdersSingle orders = new OrdersSingle
                            {
                                // EXAMPLES:
                                //EmployeeId = Convert.ToInt32(rdr["EmployeeId"]),
                                //Name = rdr["Name"].ToString(),
                                //IsPermanent = (bool)rdr["IsPermanent"],
                                //Salary = Convert.ToDecimal(rdr["Salary"]),
                                //DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"])

                                //OrderID = (int)rdr["OrderID"]
                                OrderID = rdr["OrderID"] == DBNull.Value ? default(int) : (int)rdr["OrderID"]
                                          //,CustomerID = (string)rdr["CustomerID"]
                                ,
                                CustomerID = rdr["CustomerID"] == DBNull.Value ? "" : (string)rdr["CustomerID"]
                                             //,EmployeeID = (int?)rdr["EmployeeID"]
                                ,
                                EmployeeID = rdr["EmployeeID"] == DBNull.Value ? default(int?) : (int?)rdr["EmployeeID"]
                                             //,OrderDate = (System.DateTime?)rdr["OrderDate"]
                                ,
                                OrderDate = rdr["OrderDate"] == DBNull.Value ? default(DateTime) : (System.DateTime?)rdr["OrderDate"]
                                            //,RequiredDate = (System.DateTime?)rdr["RequiredDate"]
                                ,
                                RequiredDate = rdr["RequiredDate"] == DBNull.Value ? default(DateTime) : (System.DateTime?)rdr["RequiredDate"]
                                               //,ShippedDate = (System.DateTime?)rdr["ShippedDate"]
                                ,
                                ShippedDate = rdr["ShippedDate"] == DBNull.Value ? default(DateTime) : (System.DateTime?)rdr["ShippedDate"]
                                              //,ShipVia = (int?)rdr["ShipVia"]
                                ,
                                ShipVia = rdr["ShipVia"] == DBNull.Value ? default(int?) : (int?)rdr["ShipVia"]
                                          //,Freight = (decimal?)rdr["Freight"]
                                ,
                                Freight = rdr["Freight"] == DBNull.Value ? default(decimal?) : (decimal?)rdr["Freight"]
                                          //,ShipName = (string)rdr["ShipName"]
                                ,
                                ShipName = rdr["ShipName"] == DBNull.Value ? "" : (string)rdr["ShipName"]
                                           //,ShipAddress = (string)rdr["ShipAddress"]
                                ,
                                ShipAddress = rdr["ShipAddress"] == DBNull.Value ? "" : (string)rdr["ShipAddress"]
                                              //,ShipCity = (string)rdr["ShipCity"]
                                ,
                                ShipCity = rdr["ShipCity"] == DBNull.Value ? "" : (string)rdr["ShipCity"]
                                           //,ShipRegion = (string)rdr["ShipRegion"]
                                ,
                                ShipRegion = rdr["ShipRegion"] == DBNull.Value ? "" : (string)rdr["ShipRegion"]
                                             //,ShipPostalCode = (string)rdr["ShipPostalCode"]
                                ,
                                ShipPostalCode = rdr["ShipPostalCode"] == DBNull.Value ? "" : (string)rdr["ShipPostalCode"]
                                                 //,ShipCountry = (string)rdr["ShipCountry"]
                                ,
                                ShipCountry = rdr["ShipCountry"] == DBNull.Value ? "" : (string)rdr["ShipCountry"]
                            };
                            orderss.Add(orders);
                        }
                        con.Close();
                        cmd.Dispose();
                    }
                    return(orderss);
                }
                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;
            }
        }
Ejemplo n.º 4
0
        //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;
            }
        }
Ejemplo n.º 5
0
        //BEGIN - readBy
        public OrdersSingle GetOrdersData(int OrderID)
        {
            try     // handle exogenous exceptions
            {
                try // log all exceptions
                {
                    OrdersSingle orders = new OrdersSingle();
                    using (SqlConnection con = new SqlConnection(connectionString))
                    {
                        string sqlQuery = "SELECT * FROM [Orders] WHERE OrderID= " + OrderID.ToString();

                        using (SqlCommand cmd = new SqlCommand(sqlQuery, con))
                        {
                            con.Open();
                            SqlDataReader rdr = cmd.ExecuteReader();
                            while (rdr.Read())
                            {
                                //orders.OrderID = (int)rdr["OrderID"];
                                orders.OrderID = rdr["OrderID"] == DBNull.Value ? default(int) : (int)rdr["OrderID"];
                                //orders.CustomerID = (string)rdr["CustomerID"];
                                orders.CustomerID = rdr["CustomerID"] == DBNull.Value ? "" : (string)rdr["CustomerID"];


                                //orders.EmployeeID = (int?)rdr["EmployeeID"];
                                orders.EmployeeID = rdr["EmployeeID"] == DBNull.Value ? default(int?) : (int?)rdr["EmployeeID"];

                                //orders.OrderDate = (System.DateTime?)rdr["OrderDate"];
                                orders.OrderDate = rdr["OrderDate"] == DBNull.Value ? default(DateTime) : (System.DateTime?)rdr["OrderDate"];

                                //orders.RequiredDate = (System.DateTime?)rdr["RequiredDate"];
                                orders.RequiredDate = rdr["RequiredDate"] == DBNull.Value ? default(DateTime) : (System.DateTime?)rdr["RequiredDate"];

                                //orders.ShippedDate = (System.DateTime?)rdr["ShippedDate"];
                                orders.ShippedDate = rdr["ShippedDate"] == DBNull.Value ? default(DateTime) : (System.DateTime?)rdr["ShippedDate"];

                                //orders.ShipVia = (int?)rdr["ShipVia"];
                                orders.ShipVia = rdr["ShipVia"] == DBNull.Value ? default(int?) : (int?)rdr["ShipVia"];

                                //orders.Freight = (decimal?)rdr["Freight"];
                                orders.Freight = rdr["Freight"] == DBNull.Value ? default(decimal?) : (decimal?)rdr["Freight"];
                                //orders.ShipName = (string)rdr["ShipName"];
                                orders.ShipName = rdr["ShipName"] == DBNull.Value ? "" : (string)rdr["ShipName"];

                                //orders.ShipAddress = (string)rdr["ShipAddress"];
                                orders.ShipAddress = rdr["ShipAddress"] == DBNull.Value ? "" : (string)rdr["ShipAddress"];

                                //orders.ShipCity = (string)rdr["ShipCity"];
                                orders.ShipCity = rdr["ShipCity"] == DBNull.Value ? "" : (string)rdr["ShipCity"];

                                //orders.ShipRegion = (string)rdr["ShipRegion"];
                                orders.ShipRegion = rdr["ShipRegion"] == DBNull.Value ? "" : (string)rdr["ShipRegion"];

                                //orders.ShipPostalCode = (string)rdr["ShipPostalCode"];
                                orders.ShipPostalCode = rdr["ShipPostalCode"] == DBNull.Value ? "" : (string)rdr["ShipPostalCode"];

                                //orders.ShipCountry = (string)rdr["ShipCountry"];
                                orders.ShipCountry = rdr["ShipCountry"] == DBNull.Value ? "" : (string)rdr["ShipCountry"];


                                //EXAMPLES:
                                //employee.EmployeeId = Convert.ToInt32(rdr["EmployeeID"]);
                                //employee.Name = rdr["Name"].ToString();
                                //employee.Gender = rdr["Gender"].ToString();
                                //employee.Salary = (decimal)rdr["Salary"];
                                //employee.City = rdr["City"].ToString();
                                //employee.IsPermanent = (bool)rdr["IsPermanent"];
                                //employee.DateOfBirth = Convert.ToDateTime(rdr["DateOfBirth"]);
                            }
                        }
                    }
                    return(orders);
                }
                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;
            }
        }
Ejemplo n.º 6
0
        //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;
            }
        }