public ActionResult ViewOrderDetail(long OrderId = 0)
{
OrderShipModel model = new OrderShipModel();
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
var authorityList = currentUser != null ? currentUser.USER_AUTHORITY : 0;
if (currentUser == null || currentUser.USER_ID == 0)
{
return(RedirectToAction("Login", "UserAccount"));
}
CommonService comService = new CommonService();
CommonDa da = new CommonDa();
AdminOrderShipDa dataAccess = new AdminOrderShipDa();
if (OrderId > 0)
{
OrderShipModel infor = new OrderShipModel();
infor = dataAccess.getInforOrder(OrderId);
model = infor != null ? infor : model;
var inforUserSender = da.getInforUser(model.USER_ID);
if (inforUserSender != null)
{
model.SENDER_CITY_NAME = inforUserSender.CITY_NAME;
model.SENDER_DISTRICT_NAME = inforUserSender.DISTRICT_NAME;
model.SENDER_TOWN_NAME = inforUserSender.TOWN_NAME;
model.SENDER_NAME = inforUserSender.USER_NAME;
model.SENDER_PHONE = inforUserSender.USER_PHONE;
model.SENDER_ADDRESS = inforUserSender.USER_ADDRESS;
}
model.RECEIVE_TOTAL_MONEY = model.PRICE_PRODUCT.HasValue ? model.PRICE_PRODUCT.Value : 0;
if (model.USER_PAYMENT == User_Pay.Receiver)
{
decimal shipMoney = model.PRICE_SHIP;
decimal priceProduct = model.PRICE_PRODUCT.HasValue ? model.PRICE_PRODUCT.Value : 0;
model.RECEIVE_TOTAL_MONEY = priceProduct + shipMoney;
}
model.ORDER_STATUS_TEXT = OrderStatus.Items[model.ORDER_STATUS].ToString();
model.OTHER_REQUIREMENT_TEXT = Other_Requirement.Items[model.OTHER_REQUIREMENT].ToString();
model.PRODUCT_TYPE_TEXT = Product_Type.Items[model.PRODUCT_TYPE].ToString();
model.SHIP_TYPE_TEXT = Ship_Type.Items[model.SHIP_TYPE].ToString();
model.PRODUCT_WEIGHT_TEXT = Product_Weight.Items[model.PRODUCT_WEIGHT].ToString();
model.PRODUCT_SIZE_TEXT = Constant.PRODUCT_SIZE_TEXT_DEFAULT;
if (string.IsNullOrEmpty(model.ACCEPTANCE_NAME))
{
model.ACCEPTANCE_NAME = Constant.ACCEPTANCE_NAME_DEFAULT;
}
if (model.PRODUCT_LENGTH != null && model.PRODUCT_HEIGHT != null && model.PRODUCT_WIDTH != null && model.PRODUCT_LENGTH > 0 && model.PRODUCT_HEIGHT > 0 && model.PRODUCT_WIDTH > 0)
{
model.PRODUCT_SIZE_TEXT = model.PRODUCT_LENGTH.ToString() + "x" + model.PRODUCT_WIDTH.ToString() + "x" + model.PRODUCT_HEIGHT.ToString();
}
}
return(this.PartialView("ViewOrderDetail", model));
}
public IEnumerable <Product_Category> GetCategoryList()
{
// Declare new DataAccess object
CommonDa dataAccess = new CommonDa();
IEnumerable <Product_Category> results;
results = dataAccess.GetCategoryList();
return(results);
}
public IEnumerable <MstGroupArea> GetListGroupArea(int forUser)
{
// Declare new DataAccess object
CommonDa dataAccess = new CommonDa();
IEnumerable <MstGroupArea> results;
results = dataAccess.GetListGroupArea(forUser);
return(results);
}
public DistrictModel getInfoDistrict(int cityCd, int districtCd)
{
// Declare new DataAccess object
CommonDa dataAccess = new CommonDa();
DistrictModel results;
results = dataAccess.getInfoDistrict(cityCd, districtCd);
return(results);
}
public IEnumerable <MstTown> GetTownByDistrictCd(int cityCd, int districtCd)
{
// Declare new DataAccess object
CommonDa dataAccess = new CommonDa();
IEnumerable <MstTown> results;
results = dataAccess.GetTownByDistrictCd(cityCd, districtCd);
return(results);
}
public IEnumerable <MstDistrict> GetDistrictByCityCd(int cityCd)
{
// Declare new DataAccess object
CommonDa dataAccess = new CommonDa();
IEnumerable <MstDistrict> results;
results = dataAccess.GetDistrictByCityCd(cityCd);
return(results);
}
public IEnumerable <MstTown> GetTownList()
{
// Declare new DataAccess object
CommonDa dataAccess = new CommonDa();
IEnumerable <MstTown> results;
results = dataAccess.GetTownList();
return(results);
}
public long InsertOrder(OrderShipModel order)
{
long res = 0;
TblOrder entity = new TblOrder();
CommonDa da = new CommonDa();
entity.DEL_FLG = DeleteFlag.NON_DELETE;
entity.USER_ID = CmnEntityModel.USER_ID;
int maxOrder = da.getMaxOrder(entity.USER_ID) + 1;
entity.SHIP_CODE = "T" + CmnEntityModel.USER_ID.ToString("D4") + maxOrder.ToString("D7");
entity.PRODUCT_NAME = order.PRODUCT_NAME;
entity.PRODUCT_TYPE = order.PRODUCT_TYPE;
entity.CREATE_DATE = UtilityService.Utility.GetCurrentDateTime();
entity.PRODUCT_WEIGHT = order.PRODUCT_WEIGHT.HasValue? order.PRODUCT_WEIGHT.Value : 0;
entity.RECEIVED_NAME = order.RECEIVED_NAME;
entity.RECEIVED_PHONE = order.RECEIVED_PHONE;
entity.RECEIVED_CITY = order.RECEIVED_CITY;
entity.RECEIVED_DISTRICT = order.RECEIVED_DISTRICT;
entity.RECEIVED_TOWN = order.RECEIVED_TOWN;
entity.RECEIVED_ADDRESS = order.RECEIVED_ADDRESS;
entity.RECEIVE_HOUR_FROM = order.RECEIVE_HOUR_FROM;
entity.RECEIVE_HOUR_TO = order.RECEIVE_HOUR_TO;
entity.RECEIVE_TIME_DATE = order.RECEIVE_TIME_DATE;
entity.SHIP_TYPE = order.SHIP_TYPE;
entity.PRICE_PRODUCT = order.PRICE_PRODUCT.HasValue ? order.PRICE_PRODUCT.Value : 0;
entity.PRICE_SHIP = order.PRICE_SHIP;
entity.DISCOUNT = order.DISCOUNT;
entity.USER_PAYMENT = order.USER_PAYMENT;
entity.ORDER_STATUS = OrderStatus.Create;
entity.OTHER_REQUIREMENT = order.OTHER_REQUIREMENT;
entity.PRODUCT_HEIGHT = order.PRODUCT_HEIGHT.HasValue ? order.PRODUCT_HEIGHT.Value : 0;
entity.PRODUCT_LENGTH = order.PRODUCT_LENGTH.HasValue ? order.PRODUCT_LENGTH.Value : 0;
entity.PRODUCT_WIDTH = order.PRODUCT_WIDTH.HasValue ? order.PRODUCT_WIDTH.Value : 0;
// Declare new DataAccess object
OrderShipDa dataAccess = new OrderShipDa();
using (var transaction = new TransactionScope())
{
res = dataAccess.InsertOrder(entity);
if (res <= 0)
{
transaction.Dispose();
}
if (res > 0)
{
res = da.getShipID(entity.SHIP_CODE);
transaction.Complete();
}
}
return(res);
}
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 ExportCSVCustom()
{
CommonDa da = new CommonDa();
AdminOrderShipDa dataAccess = new AdminOrderShipDa();
CmnEntityModel currentUser = Session["CmnEntityModel"] as CmnEntityModel;
var authorityList = currentUser != null ? currentUser.USER_AUTHORITY : 0;
if (currentUser == null || currentUser.USER_ID == 0)
{
return(RedirectToAction("Login", "UserAccount"));
}
var modelCondition = Session["SearchOrderShipList"] as AdminOrderList ?? new AdminOrderList();
string[] columns = this.CreateColumnsExportInfo();
string fileName = "Danh_Sách_Đơn" + Utility.GetCurrentDateTime().ToString("dd/MM/yyyy HH:mm:ss") + ".csv";
var dataExport = dataAccess.getDataForCSV(modelCondition);
DataTable dt = ConvertToDataTableForExport(this, dataExport, columns);
ReportServices.ExportToCsvData(this, dt, fileName, columns);
return(new EmptyResult());
}
public ActionResult PrintOrderCustom(string ORDER_ID_STRING)
{
CommonDa da = new CommonDa();
OrderShipDa dataAccess = new OrderShipDa();
List <OrderShipModel> listOrderShip = new List <OrderShipModel>();
OrderShipModel model = new OrderShipModel();
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)
{
var infor = dataAccess.getInforOrder(ORDER_ID_LIST[i]);
model = infor != null ? infor : model;
var inforUserSender = da.getInforUser(model.USER_ID);
if (inforUserSender != null)
{
model.SENDER_CITY_NAME = inforUserSender.CITY_NAME;
model.SENDER_DISTRICT_NAME = inforUserSender.DISTRICT_NAME;
model.SENDER_TOWN_NAME = inforUserSender.TOWN_NAME;
model.SENDER_NAME = inforUserSender.USER_NAME;
model.SENDER_PHONE = inforUserSender.USER_PHONE;
model.SENDER_ADDRESS = inforUserSender.USER_ADDRESS;
}
model.RECEIVE_TOTAL_MONEY = model.PRICE_PRODUCT.HasValue ? model.PRICE_PRODUCT.Value : 0;
if (model.USER_PAYMENT == User_Pay.Receiver)
{
decimal shipMoney = model.PRICE_SHIP;
decimal priceProduct = model.PRICE_PRODUCT.HasValue ? model.PRICE_PRODUCT.Value : 0;
model.RECEIVE_TOTAL_MONEY = priceProduct + shipMoney;
}
model.ORDER_STATUS_TEXT = OrderStatus.Items[model.ORDER_STATUS].ToString();
model.OTHER_REQUIREMENT_TEXT = Other_Requirement.Items[model.OTHER_REQUIREMENT].ToString();
model.PRODUCT_TYPE_TEXT = Product_Type.Items[model.PRODUCT_TYPE].ToString();
model.SHIP_TYPE_TEXT = Ship_Type.Items[model.SHIP_TYPE].ToString();
model.PRODUCT_WEIGHT_TEXT = Product_Weight.Items[model.PRODUCT_WEIGHT].ToString();
model.PRODUCT_SIZE_TEXT = Constant.PRODUCT_SIZE_TEXT_DEFAULT;
if (string.IsNullOrEmpty(model.ACCEPTANCE_NAME))
{
model.ACCEPTANCE_NAME = Constant.ACCEPTANCE_NAME_DEFAULT;
}
if (model.PRODUCT_LENGTH != null && model.PRODUCT_HEIGHT != null && model.PRODUCT_WIDTH != null && model.PRODUCT_LENGTH > 0 && model.PRODUCT_HEIGHT > 0 && model.PRODUCT_WIDTH > 0)
{
model.PRODUCT_SIZE_TEXT = model.PRODUCT_LENGTH.ToString() + "x" + model.PRODUCT_WIDTH.ToString() + "x" + model.PRODUCT_HEIGHT.ToString();
}
listOrderShip.Add(model);
}
}
}
return(new ViewAsPdf("ViewOrderDetailPDF", listOrderShip));
//return View("ViewOrderDetailPDF", model);
}
return(new EmptyResult());
}
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());
}
