public ActionResult Create()
{
ReturnMasterModel model = new ReturnMasterModel()
{
Actived = true
};
//model.SalemanName =
model.CreatedAccount = currentAccount.UserName;
AccountModel Account = _context.AccountModel.Where(p => p.UserName == model.CreatedAccount).FirstOrDefault();
model.SalemanName = Account.EmployeeModel.FullName;
ViewBag.SalemanName = model.SalemanName;
CreateViewBag(null, null, null, null, 1);
// Tìm giá trị STT ReturnMaster code
ViewBag.ReturnCode = GetReturnCode();
return(View(model));
}
public ActionResult Cancel(int id)
{
try
{
ReturnMasterModel model = _context.ReturnMasterModel
.Where(p => p.ReturnMasterId == id)
.FirstOrDefault();
var Resuilt = "";
if (model == null)
{
Resuilt = "Không tìm thấy đơn hàng yêu cầu !";
}
else
{
using (System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand())
{
cmd.CommandText = "usp_ReturnCanceled";
cmd.Parameters.AddWithValue("@ReturnMasterId", model.ReturnMasterId);
cmd.Parameters.AddWithValue("@DeletedDate", DateTime.Now);
AccountModel Account = _context.AccountModel.Where(p => p.UserName == model.CreatedAccount).FirstOrDefault();
model.DeletedEmployeeId = Account.EmployeeId;
cmd.Parameters.AddWithValue("@DeletedAccount", currentAccount.UserName);
cmd.Parameters.AddWithValue("@DeletedEmployeeId", model.DeletedEmployeeId);
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
//_context.Entry(model).State = System.Data.Entity.EntityState.Modified;
//_context.SaveChanges();
Resuilt = "success";
}
return(Json(Resuilt, JsonRequestBehavior.AllowGet));
}
catch
{
return(Json(string.Format(Resources.LanguageResource.CancelErrorMessenge, "Đơn trả hàng nhà cung cấp"), JsonRequestBehavior.AllowGet));
}
}
public ActionResult Save(ReturnMasterModel model, List <ReturnDetailViewModel> detail, decimal?GuestAmountPaid, int CreateReceipt = 1)
{
if (ModelState.IsValid)
{
try
{
using (TransactionScope ts = new TransactionScope())
{
var currentTime = DateTime.Now;
#region Lưu ReturnMaster
model.CreatedDate = currentTime;
model.CreatedAccount = currentAccount.UserName;
AccountModel Account = _context.AccountModel.Where(p => p.UserName == model.CreatedAccount).FirstOrDefault();
model.CreatedEmployeeId = Account.EmployeeId;
model.InventoryTypeId = EnumInventoryType.XC; //Xuất - Trả hàng cho nhà cung cấp
model.Paid = GuestAmountPaid.HasValue ? GuestAmountPaid : 0;
model.ReturnMasterCode = GetReturnCode();
model.Actived = true;
#endregion
var importModel = _context.ImportMasterModel.Where(p => p.ImportMasterId == model.ImportMasterId).FirstOrDefault();
#region Tính số dư còn lại
decimal?SuplierOldDebt = _context.AM_DebtModel
.Where(p => p.SupplierId == importModel.SupplierId)
.OrderByDescending(p => p.TimeOfDebt)
.Select(p => p.RemainingAmountAccrued)
.FirstOrDefault();
SuplierOldDebt = (SuplierOldDebt == null) ? 0 : SuplierOldDebt.Value;
model.RemainingAmount = (model.RemainingAmount == null) ? 0 : model.RemainingAmount.Value;
model.RemainingAmountAccrued = SuplierOldDebt.Value - model.RemainingAmount.Value;
_context.Entry(model).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges(); // LƯU TẠM ĐỂ LẤY ReturnMASTERID (SẼ BỊ SCROLLBACK KHI XẢY RA LỖI)
#endregion
if (CreateReceipt == 1)
{
#region Thêm vào giao dịch kế toán
AM_TransactionModel AMmodel;
#region TH1 : nhận đủ
if (model.TotalPrice == GuestAmountPaid)
{
AMmodel = new AM_TransactionModel()
{
StoreId = model.StoreId,
AMAccountId = (_context.AM_AccountModel.Where(p => p.Code == EnumAccountCode.TM && p.AMAccountTypeCode == EnumAM_AccountType.TIENMAT && p.StoreId == model.StoreId).Select(p => p.AMAccountId)).FirstOrDefault(),
TransactionTypeCode = EnumTransactionType.NXXUAT,
ContactItemTypeCode = EnumContactType.NCC,
CustomerId = null,
SupplierId = model.SupplierId,
EmployeeId = null,
OtherId = null,
Amount = GuestAmountPaid,
OrderId = null,
ImportMasterId = model.ImportMasterId,
IEOtherMasterId = null,
Note = model.Note,
CreateDate = currentTime,
CreateEmpId = currentEmployee.EmployeeId,
RemainingAmountAccrued = model.RemainingAmountAccrued
};
_context.Entry(AMmodel).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
}
#endregion
#region TH2 : Không nhận lưu vào công nợ
else if (GuestAmountPaid == 0 || GuestAmountPaid == null)
{
AMmodel = new AM_TransactionModel()
{
StoreId = model.StoreId,
AMAccountId = (_context.AM_AccountModel.Where(p => p.Code == EnumAccountCode.PTNCC && p.AMAccountTypeCode == EnumAM_AccountType.CONGNO && p.StoreId == model.StoreId).Select(p => p.AMAccountId)).FirstOrDefault(),
TransactionTypeCode = EnumTransactionType.NXXUAT,
ContactItemTypeCode = EnumContactType.NCC,
CustomerId = null,
SupplierId = model.SupplierId,
EmployeeId = null,
OtherId = null,
Amount = model.TotalPrice,
OrderId = null,
ImportMasterId = model.ImportMasterId,
IEOtherMasterId = null,
Note = model.Note,
CreateDate = currentTime,
CreateEmpId = currentEmployee.EmployeeId,
RemainingAmountAccrued = model.RemainingAmountAccrued
};
_context.Entry(AMmodel).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
}
#endregion
#region TH3 : nhận 1 phần
else
{
#region 1 phần (Tiền mặt hoặc chuyển khoản)
AMmodel = new AM_TransactionModel()
{
StoreId = model.StoreId,
AMAccountId = (_context.AM_AccountModel.Where(p => p.Code == EnumAccountCode.TM && p.AMAccountTypeCode == EnumAM_AccountType.TIENMAT && p.StoreId == model.StoreId).Select(p => p.AMAccountId)).FirstOrDefault(),
TransactionTypeCode = EnumTransactionType.NXXUAT,
ContactItemTypeCode = EnumContactType.NCC,
CustomerId = null,
SupplierId = model.SupplierId,
EmployeeId = null,
OtherId = null,
Amount = GuestAmountPaid,
OrderId = null,
ImportMasterId = model.ImportMasterId,
IEOtherMasterId = null,
Note = model.Note,
CreateDate = currentTime,
CreateEmpId = currentEmployee.EmployeeId,
RemainingAmountAccrued = model.RemainingAmountAccrued
};
_context.Entry(AMmodel).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
#endregion
#region 1 phần đưa vào công nợ
AMmodel = new AM_TransactionModel()
{
StoreId = model.StoreId,
AMAccountId = (_context.AM_AccountModel.Where(p => p.Code == EnumAccountCode.PTNCC && p.AMAccountTypeCode == EnumAM_AccountType.CONGNO && p.StoreId == model.StoreId).Select(p => p.AMAccountId)).FirstOrDefault(),
TransactionTypeCode = EnumTransactionType.NXXUAT,
ContactItemTypeCode = EnumContactType.NCC,
CustomerId = null,
SupplierId = model.SupplierId,
EmployeeId = null,
OtherId = null,
Amount = model.TotalPrice - GuestAmountPaid,
OrderId = null,
ImportMasterId = model.ImportMasterId,
IEOtherMasterId = null,
Note = model.Note,
CreateDate = currentTime,
CreateEmpId = currentEmployee.EmployeeId,
RemainingAmountAccrued = model.RemainingAmountAccrued
};
_context.Entry(AMmodel).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
#endregion
}
#endregion
#endregion
}
#region Thêm AM_DebtModel (Số nợ còn lại)
if (model.RemainingAmount > 0)
{
var AMDebModel = new AM_DebtModel()
{
SupplierId = importModel.SupplierId,
TimeOfDebt = currentTime,
RemainingAmountAccrued = model.RemainingAmountAccrued,
ReturnMasterId = model.ReturnMasterId,
TransactionTypeCode = EnumTransactionType.NXXUAT
};
_context.Entry(AMDebModel).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges();
}
#endregion
#region Lưu InventoryMaster
InventoryMasterModel InvenMaster = new InventoryMasterModel();
InvenMaster.WarehouseModelId = model.WarehouseId;
InvenMaster.InventoryCode = model.ReturnMasterCode;
InvenMaster.InventoryTypeId = EnumInventoryType.XC; //Xuất - Trả hàng cho nhà cung cấp
InvenMaster.CreatedDate = model.CreatedDate;
InvenMaster.CreatedAccount = model.CreatedAccount;
InvenMaster.CreatedEmployeeId = model.CreatedEmployeeId;
InvenMaster.Actived = true;
InvenMaster.BusinessId = model.ReturnMasterId; // Id nghiệp vụ
InvenMaster.BusinessName = "ReturnMasterModel"; // Tên bảng nghiệp vụ
InvenMaster.ActionUrl = "/ReturnMaster/Details/"; // Đường dẫn ( cộng ID cho truy xuất)
InvenMaster.StoreId = model.StoreId;
_context.Entry(InvenMaster).State = System.Data.Entity.EntityState.Added;
_context.SaveChanges(); // insert tạm để lấy InvenMasterID
#endregion
#region duyệt list lưu ReturnDetail và InvenrotyDetail
decimal TotalQty = 0;
foreach (var item in detail)
{
if (item.ReturnQty > 0) // Chỉ tính Số lượng trả > 0
{
TotalQty += item.ReturnQty.Value;
#region Lưu ReturnDetailModel
//// Lấy ReturnedQty mới nhất
//var tempLanDaTraCuoi = (from detal in _context.ReturnDetailModel
// join master in _context.ReturnMasterModel on detal.ReturnMasterId equals master.ReturnMasterId
// orderby detal.ReturnDetailId descending
// where master.Actived == true && detal.ProductId == item.ProductId
// select new
// {
// LanDaTraCuoi = detal.ReturnedQty.Value
// }).FirstOrDefault();
decimal CogsInOd = _context.ImportDetailModel.Where(p => p.ImportMasterId == model.ImportMasterId && p.ProductId == item.ProductId).Select(p => p.UnitCOGS.Value).FirstOrDefault();
item.UnitCOGS = CogsInOd;
ReturnDetailModel detailmodel = new ReturnDetailModel()
{
ReturnMasterId = model.ReturnMasterId,
ProductId = item.ProductId,
ImportQty = item.ImportQty,
//ReturnedQty = (tempLanDaTraCuoi == null ? 0 + (item.ReturnQty.HasValue ? item.ReturnQty : 0) : tempLanDaTraCuoi.LanDaTraCuoi + (item.ReturnQty.HasValue ? item.ReturnQty : 0)),
ReturnedQty = item.ReturnedQty,
InventoryQty = item.InventoryQty,
ReturnQty = item.ReturnQty.HasValue ? item.ReturnQty : 0,
Price = item.Price,
UnitShippingWeight = item.UnitShippingWeight,
UnitPrice = item.UnitPrice,
Note = item.Note,
ShippingFee = item.ShippingFee,
UnitCOGS = item.UnitCOGS
};
//_context.Entry(detailmodel).State = System.Data.Entity.EntityState.Added;
model.ReturnDetailModel.Add(detailmodel);
_context.SaveChanges();
#endregion
#region Lưu InventoryDetail
//var temp = _context.InventoryDetailModel.OrderByDescending(p => p.InventoryDetailId).Where(p => p.ProductId == item.ProductId).Select(p => p.EndInventoryQty).FirstOrDefault();
//var temp = (from detal in _context.InventoryDetailModel
// join master in _context.InventoryMasterModel on detal.InventoryMasterId equals master.InventoryMasterId
// orderby detal.InventoryDetailId descending
// where master.Actived == true && detal.ProductId == item.ProductId
// select new
// {
// TonCuoi = detal.EndInventoryQty.Value
// }).FirstOrDefault();
//decimal tondau;
//if (temp != null)
//{
// tondau = Convert.ToInt32(temp.TonCuoi);
//}
//else
//{
// tondau = 0;
//}
EndInventoryRepository EndInventoryRepo = new EndInventoryRepository(_context);
decimal tondau = EndInventoryRepo.GetQty(item.ProductId.Value);
var tempt2 = _context.ProductModel.Where(p => p.ProductId == item.ProductId).FirstOrDefault();
decimal GiaVon = tempt2.COGS.HasValue ? tempt2.COGS.Value : 0;
InventoryDetailModel InvenDetail = new InventoryDetailModel()
{
InventoryMasterId = InvenMaster.InventoryMasterId,
ProductId = item.ProductId,
BeginInventoryQty = tondau,
//COGS = GiaVon,
Price = item.Price,
//ImportQty = 0,
ExportQty = item.ReturnQty.HasValue ? item.ReturnQty : 0,// Xuất
//UnitCOGS = GiaVon * (item.ReturnQty.HasValue ? item.ReturnQty : 0),
UnitPrice = item.UnitPrice.HasValue ? item.UnitPrice : 0,
EndInventoryQty = tondau - (item.ReturnQty.HasValue ? item.ReturnQty : 0)
};
_context.Entry(InvenDetail).State = System.Data.Entity.EntityState.Added;
// _context.SaveChanges();
}
#endregion
}
#endregion
// Cập nhật lại Tổng giá vốn
model.SumCOGSOfOrderDetail = detail.Where(p => p.ReturnQty > 0).Sum(p => p.UnitCOGS * p.ReturnQty);
model.TotalQty = TotalQty;
_context.Entry(model).State = System.Data.Entity.EntityState.Modified;
_context.SaveChanges();
ts.Complete(); // hoàn tất và thực sự lưu vào db
return(Json("success", JsonRequestBehavior.AllowGet));
}
}
catch
{
return(Json(Resources.LanguageResource.AddErrorMessage, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(Resources.LanguageResource.AddErrorMessage, JsonRequestBehavior.AllowGet));
}
}
