public ActionResult Details(int id)
{
//ReturnMasterModel model = _context.ReturnMasterModel.Find(id);
var model = (from p in _context.OrderReturnModel
join pp in _context.OrderMasterModel on p.OrderId equals pp.OrderId
join sm in _context.StoreModel on p.StoreId equals sm.StoreId
join wm in _context.WarehouseModel on p.WarehouseId equals wm.WarehouseId
join cusle in _context.CustomerLevelModel on pp.CustomerLevelId equals cusle.CustomerLevelId
join prov in _context.ProvinceModel on pp.ProvinceId equals prov.ProvinceId into provTemp
from ptempt in provTemp.DefaultIfEmpty()
join distr in _context.DistrictModel on pp.DistrictId equals distr.DistrictId into DistrictId
from ptempt2 in DistrictId.DefaultIfEmpty()
where (p.OrderReturnMasterId == id && p.Actived == true)
select new OrderReturnMasterViewModel()
{
OrderReturnMasterId = p.OrderReturnMasterId,
OrderReturnMasterCode = p.OrderReturnMasterCode,
StoreName = sm.StoreName,
WarehouseName = wm.WarehouseName,
OrderCode = pp.OrderCode,
CustomerName = pp.FullName,
CustomerLevelName = cusle.CustomerLevelName,
IdentityCard = pp.IdentityCard,
Phone = pp.Phone,
Gender2 = pp.Gender == true ? "Nam" : "Nữ",
Email = pp.Email,
ProvinceName = string.IsNullOrEmpty(ptempt.ProvinceName) ? "" : ptempt.ProvinceName,
DistrictName = string.IsNullOrEmpty(ptempt2.DistrictName) ? "" : ptempt2.DistrictName,
Address = pp.Address,
SaleName = pp.SaleName,
CompanyName = pp.CompanyName,
TaxBillCode = pp.TaxBillCode,
ContractNumber = pp.ContractNumber,
TaxBillDate = pp.TaxBillDate,
// Note = p.Note,
DebtDueDate = pp.DebtDueDate,
Note = p.Note,
SumPrice = p.OrderReturnDetailModel.Sum(s => s.UnitPrice),
BillDiscount = p.BillDiscount,
BillDiscountTypeId = p.BillDiscountTypeId,
BillVAT = p.BillVAT,
TotalPrice = p.TotalPrice,
PaymentMethodId = p.PaymentMethodId,
Paid = p.Paid.HasValue ? p.Paid.Value : 0,
MoneyTransfer = p.MoneyTransfer.HasValue? p.MoneyTransfer.Value : 0,
RemainingAmount = p.RemainingAmount
}).FirstOrDefault();
if (model == null)
{
return(HttpNotFound());
}
return(View(model));
}
public ActionResult Get3FieldByOrderID(int?OrderID)
{
var data = (from p in _context.OrderMasterModel
join cusle in _context.CustomerLevelModel on p.CustomerLevelId equals cusle.CustomerLevelId
join prov in _context.ProvinceModel on p.ProvinceId equals prov.ProvinceId into provTemp
from ptempt in provTemp.DefaultIfEmpty()
join distr in _context.DistrictModel on p.DistrictId equals distr.DistrictId into DistrictId
from ptempt2 in DistrictId.DefaultIfEmpty()
where (p.OrderId == OrderID)
select new
{
StoreId = p.StoreId,
WarehouseId = p.WarehouseId,
CustomerId = p.FullName,
CustomerLevelId = cusle.CustomerLevelName,
IdentityCard = p.IdentityCard,
Phone = p.Phone,
Gender = p.Gender == true?"Nam": "Nữ",
Email = p.Email,
ProvinceId = string.IsNullOrEmpty(ptempt.ProvinceName) ? "" : ptempt.ProvinceName,
DistrictId = string.IsNullOrEmpty(ptempt2.DistrictName) ? "" : ptempt2.DistrictName,
Address = p.Address,
SaleId = p.SaleName,
CompanyName = p.CompanyName,
TaxBillCode = p.TaxBillCode,
ContractNumber = p.ContractNumber,
TaxBillDate = p.TaxBillDate,
// Note = p.Note,
DebtDueDate = p.DebtDueDate,
BillDiscount = p.BillDiscount,
BillDiscountTypeId = p.BillDiscountTypeId,
BillVAT = p.BillVAT
}).FirstOrDefault();
return(Json(data, JsonRequestBehavior.AllowGet));
}