public OrderModels MaperOnlyOrder(DataTable pData)
        {
            OrderModels vOrder = null;

            if (pData != null)
            {
                if (pData.Rows.Count > 0)
                {
                    for (int i = 0; i < pData.Rows.Count; i++)
                    {
                        DataRow vRow = pData.Rows[i];

                        vOrder = new OrderModels
                        {
                            ID = vRow["ID"] != null ? Convert.ToInt32(vRow["ID"].ToString()) : 0,
                            OrderNumber = vRow["OrderNumber"] != null ? vRow["OrderNumber"].ToString() : string.Empty,
                            CustomerName = vRow["CustomerName"] != null ? vRow["CustomerName"].ToString() : string.Empty,
                            DeliveryAddress = vRow["DeliveryAddress"] != null ? vRow["DeliveryAddress"].ToString() : string.Empty,
                            OrderDate = Convert.ToDateTime(vRow["OrderDate"])
                        };
                    }
                }
            }

            return vOrder;
        }
        public bool CheckUpdateOrder(OrderModels pOrder)
        {
            bool vIsUpdate = false;

            if (pOrder.ID > 0)
            {
                OrderModels vOrderDB = MaperOnlyOrder(new Business.SQL.Admin.clsRMOrder().sp_Get_RMOrder_ID(pOrder.ID));

                if (Equals(pOrder.ID, vOrderDB.ID) &&
                    Equals(pOrder.CustomerName, vOrderDB.CustomerName) &&
                    Equals(pOrder.DeliveryAddress, vOrderDB.DeliveryAddress) &&
                    Equals(pOrder.OrderDate, vOrderDB.OrderDate) &&
                    Equals(pOrder.OrderNumber, vOrderDB.OrderNumber))
                    vIsUpdate = false;
                else
                    vIsUpdate = true;
            }

            return vIsUpdate;
        }
        public ActionResult SaveOrder(OrderModels pModel)
        {
            _clsOrder.sp_Save_RMOrder(pModel.ID, pModel.OrderNumber, pModel.CustomerName, pModel.DeliveryAddress, pModel.OrderDate);

             return Json(pModel, JsonRequestBehavior.AllowGet);
        }
        public ActionResult ReturnOrders(OrderModels pModel)
        {
            bool vIsUpdate = _clsUtil.CheckUpdateOrder(pModel);

            return Json(vIsUpdate.ToString(), JsonRequestBehavior.AllowGet);
        }