/// <summary>
/// Get Order List
/// </summary>
/// <param name="objViewOrderModel">object of Model ViewDocumentModel </param>
/// <returns></returns>
public DataTable GetOrderList(ViewOrderModel objViewOrderModel)
{
try
{
SqlParameter[] parmList =
{
new SqlParameter("@CurrentPage", objViewOrderModel.CurrentPage)
, new SqlParameter("@PageSize", objViewOrderModel.PageSize)
, new SqlParameter("@SortBy", objViewOrderModel.SortBy)
, new SqlParameter("@SortOrder", objViewOrderModel.SortOrder)
};
DataSet ds = SQLHelper.ExecuteDataset(SQLHelper.ConnectionStringLocalTransaction, CommandType.StoredProcedure, DBConstants.Admin_GetOrderList, parmList);
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ViewOrder()
{
ViewOrderModel ObjViewOrderModel = new ViewOrderModel();
try
{
//initial set of current page, pageSize , Total pages
ObjViewOrderModel.CurrentPage = 1;
ObjViewOrderModel.PageSize = CommonUtils.PageSize;
ObjViewOrderModel.TotalPages = 0;
//Get Order List
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Order + "/GetOrderList", ObjViewOrderModel);
ObjViewOrderModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewOrderModel>().Result : null;
//ObjViewOrderModel = objBLOrder.GetOrderList(ObjViewOrderModel);
//Set Success Message if comes from save page after click on save button
if (!String.IsNullOrEmpty(Convert.ToString(TempData["SucessMessage"])))
{
ObjViewOrderModel.Message = Convert.ToString(TempData["SucessMessage"]);
ObjViewOrderModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
TempData["SucessMessage"] = null;
}
}
catch (Exception ex)
{
ErrorLog(ex, "Order", "View GET");
}
return(View("ViewOrder", ObjViewOrderModel));
}
public ActionResult ViewOrderItem([Bind(Include = ("ID"))] OrderModel orderModel)
{
ViewOrderModel vom = new ViewOrderModel();
ViewOrderDTO vodto = new ViewOrderDTO();
// Guid userId = new Guid(Session["UserID"].ToString());
//vodto = oc.viewOrder(userId);
vodto = oc.viewOrder(orderModel.ID);
vom = omapper.Map <ViewOrderDTO, ViewOrderModel>(vodto);
return(View(vom));
}
public ActionResult ViewOrderDetail(long OrderId = 0)
{
ViewOrderModel model = new ViewOrderModel();
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
if (currentUser == null || currentUser.IsAdmin == false)
{
return(RedirectToAction("Login", "Login"));
}
CommonService comService = new CommonService();
CommonDa da = new CommonDa();
AdminOrderDa dataAccess = new AdminOrderDa();
if (OrderId > 0)
{
ViewOrderModel infor = new ViewOrderModel();
infor = dataAccess.getInforOrder(OrderId);
model = infor != null ? infor : model;
string CompanyCd = "00000";
var inforCompany = da.getInfoCompany(CompanyCd);
if (inforCompany != null)
{
model.CompanyName = inforCompany.COMPANY_NAME;
model.CompanyAddress = inforCompany.COMPANY_ADDRESS;
model.CompanyEmail = inforCompany.COMPANY_EMAIL;
model.CompanyPhone = inforCompany.COMPANY_PHONE;
}
model.AddressCustomer = model.DistrictName + ", " + model.Receive_Address;
model.ORDER_STATUS_TEXT = OrderStatus.Items[model.Status].ToString();
var getOrderDetail = dataAccess.getOrderDetail(model.ID).Take(3);
ViewBag.listOrderDetail = getOrderDetail.ToList();
foreach (var data in getOrderDetail)
{
model.ProductDetailTotal += data.ProductName + " (Số lượng: " + data.Quantity.ToString() + "), ";
}
if (String.IsNullOrEmpty(model.LINK_QRCODE))
{
model.LINK_QRCODE = QRCodeServices.creatQR(model.Code);
dataAccess.UpdateQRLink(OrderId, model.LINK_QRCODE);
}
if (!String.IsNullOrEmpty(model.LINK_QRCODE))
{
model.LINK_QRCODE = model.LINK_QRCODE.Replace("~", "");
}
}
return(this.PartialView("ViewOrderDetail", model));
}
public ActionResult ViewOrder(ViewOrderModel model)
{
DataBaseContext db = new DataBaseContext();
List <Staff> _staffList = db.Staffs.ToList();
SelectList staffList = new SelectList(_staffList, 0);
var Edit = db.ViewOrders
.Where(m => m.Id == model.Id)
.FirstOrDefault();
Edit.State = true;
//Edit.Staff = model.Staff;
Edit.Staff = model.Staff;
db.SaveChanges();
//ViewBag.staffList = staffList;
return(RedirectToAction("NewOrders"));
}
public ActionResult ViewOrders()
{
var memId = Convert.ToInt32(Session["MemberId"]);
ClASDBEntities db = new ClASDBEntities();
//var currentDocID = db.Doctors.FirstOrDefault(m => m.MemberId == memId);
List <ViewOrderModel> lst = new List <ViewOrderModel>();
var id = Convert.ToInt32(Session["ID"]);
var getdata = (from od in db.PatientOrderDetails
join d in db.Drugs
on od.DrugId equals d.DrugID
join dd in db.DrugDeliveries
on od.OrderID equals dd.OrderID
where dd.SupplierId == id
select new
{
od.OrderNumber,
dd.SupplierId,
d.DrugID,
od.OrderID,
d.DrugName,
od.OrderDate,
od.Quantity,
od.OrderStatus
});
foreach (var item in getdata)
{
lst.Add(new ViewOrderModel
{
OrderID = item.OrderID,
SupplierId = item.SupplierId,
OrderDate = item.OrderDate,
DrugId = item.DrugID,
DrugName = item.DrugName,
OrderStatus = item.OrderStatus,
OrderQtty = item.Quantity,
OrderNo = item.OrderNumber
});
}
ViewOrderModel dm = new ViewOrderModel();
dm.ListOrder = lst;
return(View(dm));
}
public ViewOrderModel GetOrderList(ViewOrderModel objViewOrderModel)
{
List <OdersModel> lstOdersModel = new List <OdersModel>();
//if FilterDocumentName is NULL than set to empty
objViewOrderModel.FilterSubCatName = objViewOrderModel.FilterSubCatName ?? String.Empty;
//if SortBy is NULL than set to empty
objViewOrderModel.SortBy = objViewOrderModel.SortBy ?? String.Empty;
//call GetDocumentList Method which will retrun datatable of Document
DataTable dtDocument = objDLOrder.GetOrderList(objViewOrderModel);
//fetch each row of datable
foreach (DataRow dr in dtDocument.Rows)
{
//Convert datarow into Model object and set Model object property
OdersModel itemOdersModel = GetDataRowToEntity <OdersModel>(dr);
//Add Document in List
lstOdersModel.Add(itemOdersModel);
}
//set Document List of Model ViewDocumentModel
objViewOrderModel.OdersList = lstOdersModel;
//if Document List count is not null and greater than 0 Than set Total Pages for Paging.
if (objViewOrderModel != null && objViewOrderModel.OdersList != null && objViewOrderModel.OdersList.Count > 0)
{
objViewOrderModel.CurrentPage = objViewOrderModel.OdersList[0].CurrentPage;
int totalRecord = objViewOrderModel.OdersList[0].TotalCount;
if (decimal.Remainder(totalRecord, objViewOrderModel.PageSize) > 0)
{
objViewOrderModel.TotalPages = (totalRecord / objViewOrderModel.PageSize + 1);
}
else
{
objViewOrderModel.TotalPages = totalRecord / objViewOrderModel.PageSize;
}
}
else
{
objViewOrderModel.TotalPages = 0;
objViewOrderModel.CurrentPage = 1;
}
return(objViewOrderModel);
}
public ActionResult ViewOrder()
{
List <ViewOrderModel> vom = new List <ViewOrderModel>();
foreach (var piz in PizzasLt.PizzaList) //prints current order of user
{
ViewOrderModel ord = new ViewOrderModel();
ord.amount = piz.Amount;
ord.pizzaType = piz.PizzaType;
ord.size = piz.Size;
ord.crust = piz.Crust;
ord.total = piz.Total;
vom.Add(ord);
}
return(View(vom));
}
public ActionResult ViewOrder(ViewOrderModel objViewOrderModel)
{
try
{
int ErrorCode = 0;
String ErrorMessage = "";
objViewOrderModel.Message = objViewOrderModel.MessageType = String.Empty;
if (objViewOrderModel.ActionType == "delete")
{
//delete
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Order + "/DeleteOrder", objViewOrderModel);
objViewOrderModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewOrderModel>().Result : null;
if (Convert.ToInt32(ErrorCode).Equals(0))
{
//if error code 0 means delete successfully than set Delete success message.
objViewOrderModel.Message = "Order Deleted Successfully";
objViewOrderModel.MessageType = CommonUtils.MessageType.Success.ToString().ToLower();
}
else
{
//if error code is not 0 means delete error than set Delete error message.
objViewOrderModel.Message = "Error while deleting record";
objViewOrderModel.MessageType = CommonUtils.MessageType.Error.ToString().ToLower();;
}
}
//Get Order List based on searching , sorting and paging parameter.
serviceResponse = objUtilityWeb.PostAsJsonAsync(WebApiURL.Order + "/GetOrderList", objViewOrderModel);
objViewOrderModel = serviceResponse.StatusCode == HttpStatusCode.OK ? serviceResponse.Content.ReadAsAsync <ViewOrderModel>().Result : null;
}
catch (Exception ex)
{
ErrorLog(ex, "Order", "View POST");
}
return(PartialView("_OrderList", objViewOrderModel));
}
public ActionResult ViewOrders()
{
var patEmailId = Convert.ToString(Session["EmailId"]);
ClASDBEntities db = new ClASDBEntities();
ViewOrderModel pm = new ViewOrderModel();
//var currentPat = db.Patients.FirstOrDefault(m => m.MemberID == memId);
List <ViewOrderModel> lst1 = new List <ViewOrderModel>();
var patId = Convert.ToInt32(Session["ID"]);
var getdata = (from d in db.Drugs
join pod in db.PatientOrderDetails
on d.DrugID equals pod.DrugId
where (pod.PatientID == patId)
select new
{
d.DrugName,
pod.OrderDate,
pod.OrderStatus,
pod.Quantity,
pod.OrderID
}).ToList();
foreach (var item in getdata)
{
lst1.Add(new ViewOrderModel
{
//DoctorId=item.DoctorId,
OrderID = item.OrderID,
DrugName = item.DrugName,
OrderDate = item.OrderDate,
OrderStatus = item.OrderStatus,
OrderQtty = item.Quantity
});
}
pm.ListOrder = lst1;
return(View(pm));
}
public IActionResult CreateOrder(ViewOrderModel order)
{
return(null);
}
public ActionResult PrintOrderCustom(string ORDER_ID_STRING)
{
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
if (currentUser == null || currentUser.IsAdmin == false)
{
return(RedirectToAction("Login", "Login"));
}
CommonService comService = new CommonService();
CommonDa da = new CommonDa();
AdminOrderDa dataAccess = new AdminOrderDa();
List <ViewOrderModel> listOrderDetail = new List <ViewOrderModel>();
ViewOrderModel model = new ViewOrderModel();
if (!string.IsNullOrEmpty(ORDER_ID_STRING))
{
List <long> ORDER_ID_LIST = ORDER_ID_STRING.Split(',').Select(long.Parse).ToList();
if (ORDER_ID_LIST.Count > 0)
{
for (int i = 0; i < ORDER_ID_LIST.Count(); i++)
{
if (ORDER_ID_LIST[i] > 0)
{
ViewOrderModel infor = new ViewOrderModel();
infor = dataAccess.getInforOrder(ORDER_ID_LIST[i]);
model = infor != null ? infor : model;
string CompanyCd = "00000";
var inforCompany = da.getInfoCompany(CompanyCd);
if (inforCompany != null)
{
model.CompanyName = inforCompany.COMPANY_NAME;
model.CompanyAddress = inforCompany.COMPANY_ADDRESS;
model.CompanyEmail = inforCompany.COMPANY_EMAIL;
model.CompanyPhone = inforCompany.COMPANY_PHONE;
}
model.AddressCustomer = model.DistrictName + ", " + model.Receive_Address;
model.ORDER_STATUS_TEXT = OrderStatus.Items[model.Status].ToString();
var getOrderDetail = dataAccess.getOrderDetail(model.ID).Take(3);
ViewBag.listOrderDetail = getOrderDetail.ToList();
foreach (var data in getOrderDetail)
{
model.ProductDetailTotal += data.ProductName + " (Số lượng: " + data.Quantity.ToString() + "), ";
}
if (String.IsNullOrEmpty(model.LINK_QRCODE))
{
model.LINK_QRCODE = QRCodeServices.creatQR(model.Code);
dataAccess.UpdateQRLink(ORDER_ID_LIST[i], model.LINK_QRCODE);
}
if (!String.IsNullOrEmpty(model.LINK_QRCODE))
{
model.LINK_QRCODE = model.LINK_QRCODE.Replace("~", "");
}
listOrderDetail.Add(model);
}
}
}
//return new ViewAsPdf("ViewOrderDetailPDF", listOrderDetail);
return(PartialView("ViewOrderDetailPDF", listOrderDetail));
}
return(new EmptyResult());
}
public ActionResult Order(Client model)
{
if (model == null)
{
ModelState.AddModelError("Error", "Ошибка! Заполните все поля");
return(View(model));
}
if (String.IsNullOrEmpty(model.Adres) || String.IsNullOrEmpty(model.Name) || String.IsNullOrEmpty(model.Phone))
{
ModelState.AddModelError("Error", "Ошибка! Заполните все поля");
return(View(model));
}
DataBaseContext db = new DataBaseContext();
db.Clients.Add(model);
db.SaveChanges();
Order _sale = new Order();
_sale.Client = db.Clients.Local[db.Clients.Local.Count - 1];
_sale.Date = DateTime.Now;
Cart _cart = GetCart();
List <Sushi> _productList = new List <Sushi>();
_productList = db.Sushis.ToList();
for (int i = 0; i < _cart.lineCollection.Count; i++)
{
for (int j = 0; j < _cart.lineCollection[i].Quantity; j++)
{
int id = _cart.lineCollection[i].Product.SushiId;
Sushi product = db.Sushis
.FirstOrDefault(g => g.SushiId == id);
_sale.Product = product;
db.Orders.Add(_sale);
db.SaveChanges();
}
}
double Price = 0;
ViewOrderModel _newOrder = new ViewOrderModel();
_newOrder.Name = model.Name;
_newOrder.State = false;
for (int i = 0; i < _cart.lineCollection.Count; i++)
{
int id = _cart.lineCollection[i].Product.SushiId;
Sushi product = db.Sushis
.FirstOrDefault(g => g.SushiId == id);
_sale.Product = product;
_newOrder.Order += product.Name + " ";
_newOrder.Order += _cart.lineCollection[i].Quantity + " шт.";
_newOrder.Order += "; ";
Price += _cart.lineCollection[i].Product.Price * _cart.lineCollection[i].Quantity;
}
_newOrder.Adres = _sale.Client.City + ", " + _sale.Client.Adres;
_newOrder.Cost = Price;
_newOrder.Phone = model.Phone;
_newOrder.Date = DateTime.Now;
db.ViewOrders.Add(_newOrder);
db.SaveChanges();
GetCart().Clear();
return(RedirectToAction("ThankYou", "Cart"));
}
public ViewOrderModel GetOrderList(ViewOrderModel objViewOrderModel)
{
return(objBLOrder.GetOrderList(objViewOrderModel));
}
public OrderDetailPage(ViewOrderModel viewOrder)
{
InitializeComponent();
BindingContext = new OrderDetailViewModel(Navigation, viewOrder);
}
public ActionResult ViewPatientOrders()
{
var memId = Convert.ToInt32(Session["MemberId"]);
ClASDBEntities db = new ClASDBEntities();
//var currentDocID = db.Doctors.FirstOrDefault(m => m.MemberId == memId);
List <ViewOrderModel> lst = new List <ViewOrderModel>();
var getdata = (from od in db.PatientOrderDetails
join p in db.Patients
on od.PatientID equals p.PatientID
join d in db.Drugs
on od.DrugId equals d.DrugID
select new
{
od.OrderNumber,
p.FirstName,
p.PatientID,
d.DrugID,
od.OrderID,
d.DrugName,
od.OrderDate,
od.Quantity,
od.OrderStatus
});
foreach (var item in getdata)
{
lst.Add(new ViewOrderModel
{
OrderID = item.OrderID,
PatientID = item.PatientID,
OrderDate = item.OrderDate,
DrugId = item.DrugID,
DrugName = item.DrugName,
OrderStatus = item.OrderStatus,
OrderQtty = item.Quantity,
PatientName = item.FirstName,
OrderNo = item.OrderNumber
});
}
ViewOrderModel dm = new ViewOrderModel();
dm.ListOrder = lst;
Supplier s = new Supplier();
List <SelectListItem> list2 = new List <SelectListItem>();
var getd = db.Suppliers.Select(m => new { m.SupplierID, m.FirstName }).ToList();
foreach (var item in getd)
{
list2.Add(new SelectListItem
{
Text = item.FirstName,
Value = Convert.ToString(item.SupplierID)
});
}
dm.ListSupp = list2;
return(View(dm));
}
