public ActionResult UnArchive(int Id)
{
if (Request["Submit"] == "Save")
{
var rePayPoints = RePayPointsService.Get(Id);
//Kiểm tra cho phép sửa chứng từ này hay không
if (Helpers.Common.KiemTraNgaySuaChungTu(rePayPoints.CreatedDate.Value) == false)
{
TempData[Globals.FailedMessageKey] = "Quá hạn sửa chứng từ!";
}
else
{
//cập nhật trạng thái
rePayPoints.ModifiedUserId = WebSecurity.CurrentUserId;
rePayPoints.ModifiedDate = DateTime.Now;
rePayPoints.IsArchive = false;
rePayPoints.Status = RePayPointsStatus.Inprogress;
RePayPointsService.Update(rePayPoints);
// xoá lịch sử điểm và cập nhật lại điểm cho khách hàng
DeletePoint(rePayPoints);
// bỏ ghi sổ phiếu xuất kho
var ProductOutbound = ProductOutboundRepository.GetAllProductOutbound().Where(item => item.IsArchive == true && item.Type == ProductOutboundType.Gift && item.PayPointId == rePayPoints.Id).FirstOrDefault();
if (ProductOutbound != null)
{
ProductOutboundController.unArchiveFromInvoice(ProductOutboundRepository, ProductOutbound, TempData);
// xoá phiếu xuất kho
ProductOutbound.ModifiedUserId = WebSecurity.CurrentUserId;
ProductOutbound.ModifiedDate = DateTime.Now;
ProductOutbound.IsDeleted = true;
ProductOutbound.CancelReason = "Bỏ ghi số đơn quà tặng - " + rePayPoints.Code;
ProductOutboundRepository.UpdateProductOutbound(ProductOutbound);
}
PostController.SavePost(rePayPoints.Id, "RePayPoints", "Bỏ ghi sổ (" + rePayPoints.Code + ")");
TempData[Globals.SuccessMessageKey] = "Đã bỏ ghi sổ";
}
}
return(RedirectToAction("Detail", new { Id = Id }));
}
public ActionResult Exchange(int Id)
{
var PhysicalInventory = PhysicalInventoryRepository.GetPhysicalInventoryById(Id);
if (PhysicalInventory == null)
{
TempData[Globals.FailedMessageKey] = App_GlobalResources.Wording.NotfoundObject;
if (PhysicalInventory.Type == PhysicalInventoryType.Product)
{
return(RedirectToAction("Index"));
}
else
{
return(RedirectToAction("ListForCard"));
}
}
List <ProductOutboundDetail> outboundDetails = new List <ProductOutboundDetail>();
List <ProductInboundDetail> inboundDetails = new List <ProductInboundDetail>();
var listDetail = PhysicalInventoryRepository.GetAllPhysicalInventoryDetail(Id).Where(x => x.QuantityInInventory != x.QuantityRemaining).ToList();
foreach (var item in listDetail)
{
var product = ProductRepository.GetProductById(item.ProductId);
if (item.QuantityDiff < 0) //Chênh lệch dương thì thuộc về xuất
{
outboundDetails.Add(
new ProductOutboundDetail
{
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedUserId = Helpers.Common.CurrentUser.Id,
ModifiedDate = DateTime.Now,
ModifiedUserId = Helpers.Common.CurrentUser.Id,
Price = product.PriceOutbound,
ProductId = product.Id,
Quantity = Math.Abs(item.QuantityDiff),
}
);
}
else if (item.QuantityDiff > 0) //Chênh lệch âm thì thuộc về nhập
{
inboundDetails.Add(
new ProductInboundDetail
{
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedUserId = Helpers.Common.CurrentUser.Id,
ModifiedDate = DateTime.Now,
ModifiedUserId = Helpers.Common.CurrentUser.Id,
Price = product.PriceInbound.Value,
ProductId = product.Id,
Quantity = Math.Abs(item.QuantityDiff),
}
);
}
}
if (outboundDetails.Count != 0)
{
var outbound = new ProductOutbound
{
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedUserId = Helpers.Common.CurrentUser.Id,
ModifiedDate = DateTime.Now,
ModifiedUserId = Helpers.Common.CurrentUser.Id,
BranchId = Helpers.Common.CurrentUser.BranchId,
IsDone = true,
Type = PhysicalInventory.Type == PhysicalInventoryType.Product ? ProductOutboundType.Physical : ProductOutboundType.PhysicalCard,
TotalAmount = outboundDetails.Sum(x => x.Quantity * x.Price),
WarehouseSourceId = PhysicalInventory.WarehouseId,
PhysicalInventoryId = PhysicalInventory.Id,
Note = "Xuất kho kiểm kê"
};
productOutboundRepository.InsertProductOutbound(outbound);
foreach (var item in outboundDetails)
{
item.ProductOutboundId = outbound.Id;
item.IsDeleted = false;
item.CreatedUserId = WebSecurity.CurrentUserId;
item.ModifiedUserId = WebSecurity.CurrentUserId;
item.CreatedDate = DateTime.Now;
item.ModifiedDate = DateTime.Now;
productOutboundRepository.InsertProductOutboundDetail(item);
}
//cập nhật lại mã xuất kho
outbound.Code = Erp.BackOffice.Helpers.Common.GetOrderNo("ProductOutbound");
productOutboundRepository.UpdateProductOutbound(outbound);
Erp.BackOffice.Helpers.Common.SetOrderNo("ProductOutbound");
foreach (var item in listDetail.Where(x => x.QuantityDiff < 0))
{
item.ModifiedDate = DateTime.Now;
item.ModifiedUserId = Helpers.Common.CurrentUser.Id;
item.ReferenceVoucher = outbound.Code;
PhysicalInventoryRepository.UpdatePhysicalInventoryDetail(item);
}
ProductOutboundController.Archive(productOutboundRepository, outbound, TempData);
}
if (inboundDetails.Count != 0)
{
var inbound = new ProductInbound
{
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedUserId = Helpers.Common.CurrentUser.Id,
ModifiedDate = DateTime.Now,
ModifiedUserId = Helpers.Common.CurrentUser.Id,
BranchId = Helpers.Common.CurrentUser.BranchId,
IsDone = true,
Type = PhysicalInventory.Type == PhysicalInventoryType.Product ? ProductInboundType.Physical : ProductInboundType.PhysicalCard,
TotalAmount = inboundDetails.Sum(x => x.Quantity * x.Price),
WarehouseDestinationId = PhysicalInventory.WarehouseId,
PhysicalInventoryId = PhysicalInventory.Id,
Note = "Nhập kho kiểm kê"
};
productInboundRepository.InsertProductInbound(inbound);
//Thêm chi tiết phiếu nhập
foreach (var item in inboundDetails)
{
item.ProductInboundId = inbound.Id;
item.IsDeleted = false;
item.CreatedUserId = WebSecurity.CurrentUserId;
item.ModifiedUserId = WebSecurity.CurrentUserId;
item.CreatedDate = DateTime.Now;
item.ModifiedDate = DateTime.Now;
productInboundRepository.InsertProductInboundDetail(item);
}
//cập nhật lại mã xuất kho
inbound.Code = Erp.BackOffice.Helpers.Common.GetOrderNo("ProductInbound");
productInboundRepository.UpdateProductInbound(inbound);
Erp.BackOffice.Helpers.Common.SetOrderNo("ProductInbound");
foreach (var item in listDetail.Where(x => x.QuantityDiff > 0))
{
item.ModifiedDate = DateTime.Now;
item.ModifiedUserId = Helpers.Common.CurrentUser.Id;
item.ReferenceVoucher = inbound.Code;
PhysicalInventoryRepository.UpdatePhysicalInventoryDetail(item);
}
ProductInboundController.Archive(productInboundRepository, inbound, TempData);
}
PhysicalInventory.IsExchange = true;
PhysicalInventory.ModifiedDate = DateTime.Now;
PhysicalInventory.ModifiedUserId = Helpers.Common.CurrentUser.Id;
PhysicalInventoryRepository.UpdatePhysicalInventory(PhysicalInventory);
TempData[Globals.SuccessMessageKey] += App_GlobalResources.Wording.Success;
return(RedirectToAction("Detail", new { Id = PhysicalInventory.Id }));
}
public ActionResult Exchange(int Id)
{
var PhysicalInventory = PhysicalInventoryRepository.GetvwPhysicalInventoryById(Id);
var model = new PhysicalInventory();
if (PhysicalInventory == null)
{
TempData[Globals.FailedMessageKey] = App_GlobalResources.Wording.NotfoundObject;
return(RedirectToAction("Index"));
}
using (var scope = new TransactionScope(TransactionScopeOption.Required))
{
try
{
AutoMapper.Mapper.Map(PhysicalInventory, model);
List <ProductOutboundDetail> outboundDetails = new List <ProductOutboundDetail>();
List <ProductInboundDetail> inboundDetails = new List <ProductInboundDetail>();
var outbounds = productOutboundRepository.GetAllProductOutbound().Where(item => item.Code == PhysicalInventory.ProductOutboundCode);
if (outbounds.Count() > 0)
{
//Xóa chi tiết xuất cũ
var outboundDetails_old = productOutboundRepository.GetAllProductOutboundDetailByOutboundId(outbounds.FirstOrDefault().Id).Select(item => item.Id).ToList();
foreach (var item in outboundDetails_old)
{
productOutboundRepository.DeleteProductOutboundDetail(item);
}
productOutboundRepository.DeleteProductOutbound(outbounds.FirstOrDefault().Id);
}
var inbounds = productInboundRepository.GetAllProductInbound().Where(item => item.Code == PhysicalInventory.ProductInboundCode);
if (inbounds.Count() > 0)
{
//Xóa chi tiết nhập cũ
var inboundDetails_old = productInboundRepository.GetAllProductInboundDetailByInboundId(inbounds.FirstOrDefault().Id).Select(item => item.Id).ToList();
foreach (var item in inboundDetails_old)
{
productInboundRepository.DeleteProductInboundDetail(item);
}
productInboundRepository.DeleteProductInbound(inbounds.FirstOrDefault().Id);
}
var listDetail = PhysicalInventoryRepository.GetAllPhysicalInventoryDetail(Id).Where(x => x.QuantityInInventory != x.QuantityRemaining).ToList();
foreach (var item in listDetail)
{
var product = ProductRepository.GetProductById(item.ProductId);
if (item.QuantityDiff < 0) //Chênh lệch dương thì thuộc về xuất
{
outboundDetails.Add(
new ProductOutboundDetail
{
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedUserId = Helpers.Common.CurrentUser.Id,
ModifiedDate = DateTime.Now,
ModifiedUserId = Helpers.Common.CurrentUser.Id,
Price = product.PriceOutbound,
ProductId = product.Id,
Quantity = Math.Abs(item.QuantityDiff),
ExpiryDate = item.ExpiryDate,
LoCode = item.LoCode
}
);
}
else if (item.QuantityDiff > 0) //Chênh lệch âm thì thuộc về nhập
{
inboundDetails.Add(
new ProductInboundDetail
{
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedUserId = Helpers.Common.CurrentUser.Id,
ModifiedDate = DateTime.Now,
ModifiedUserId = Helpers.Common.CurrentUser.Id,
Price = product.PriceInbound,
ProductId = product.Id,
Quantity = Math.Abs(item.QuantityDiff),
LoCode = item.LoCode,
ExpiryDate = item.ExpiryDate
}
);
}
}
if (outboundDetails.Count != 0)
{
var outbound = new ProductOutbound
{
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedUserId = Helpers.Common.CurrentUser.Id,
ModifiedDate = DateTime.Now,
ModifiedUserId = Helpers.Common.CurrentUser.Id,
BranchId = model.BranchId,
IsDone = true,
Type = "PhysicalInventory",
TotalAmount = outboundDetails.Sum(x => x.Quantity * x.Price),
WarehouseSourceId = PhysicalInventory.WarehouseId,
PhysicalInventoryId = PhysicalInventory.Id,
Note = "Xuất kho kiểm kê"
};
productOutboundRepository.InsertProductOutbound(outbound);
foreach (var item in outboundDetails)
{
item.ProductOutboundId = outbound.Id;
item.IsDeleted = false;
item.CreatedUserId = WebSecurity.CurrentUserId;
item.ModifiedUserId = WebSecurity.CurrentUserId;
item.CreatedDate = DateTime.Now;
item.ModifiedDate = DateTime.Now;
productOutboundRepository.InsertProductOutboundDetail(item);
}
//cập nhật lại mã xuất kho
string prefix = Erp.BackOffice.Helpers.Common.GetSetting("prefixOrderNo_Outbound");
outbound.Code = Erp.BackOffice.Helpers.Common.GetCode(prefix, outbound.Id);
productOutboundRepository.UpdateProductOutbound(outbound);
foreach (var item in listDetail.Where(x => x.QuantityDiff < 0))
{
item.ModifiedDate = DateTime.Now;
item.ModifiedUserId = Helpers.Common.CurrentUser.Id;
item.ReferenceVoucher = outbound.Code;
PhysicalInventoryRepository.UpdatePhysicalInventoryDetail(item);
}
}
if (inboundDetails.Count != 0)
{
var inbound = new ProductInbound
{
IsDeleted = false,
CreatedDate = DateTime.Now,
CreatedUserId = Helpers.Common.CurrentUser.Id,
ModifiedDate = DateTime.Now,
ModifiedUserId = Helpers.Common.CurrentUser.Id,
BranchId = model.BranchId,
IsDone = true,
Type = "PhysicalInventory",
TotalAmount = inboundDetails.Sum(x => x.Quantity * x.Price),
WarehouseDestinationId = PhysicalInventory.WarehouseId,
PhysicalInventoryId = PhysicalInventory.Id,
Note = "Nhập kho kiểm kê"
};
productInboundRepository.InsertProductInbound(inbound);
//Thêm chi tiết phiếu nhập
foreach (var item in inboundDetails)
{
item.ProductInboundId = inbound.Id;
item.IsDeleted = false;
item.CreatedUserId = WebSecurity.CurrentUserId;
item.ModifiedUserId = WebSecurity.CurrentUserId;
item.CreatedDate = DateTime.Now;
item.ModifiedDate = DateTime.Now;
productInboundRepository.InsertProductInboundDetail(item);
}
//cập nhật lại mã xuất kho
string prefix = Erp.BackOffice.Helpers.Common.GetSetting("prefixOrderNo_Inbound");
inbound.Code = Erp.BackOffice.Helpers.Common.GetCode(prefix, inbound.Id);
productInboundRepository.UpdateProductInbound(inbound);
foreach (var item in listDetail.Where(x => x.QuantityDiff > 0))
{
item.ModifiedDate = DateTime.Now;
item.ModifiedUserId = Helpers.Common.CurrentUser.Id;
item.ReferenceVoucher = inbound.Code;
PhysicalInventoryRepository.UpdatePhysicalInventoryDetail(item);
}
}
model.IsExchange = true;
model.ModifiedDate = DateTime.Now;
model.ModifiedUserId = Helpers.Common.CurrentUser.Id;
PhysicalInventoryRepository.UpdatePhysicalInventory(model);
scope.Complete();
}
catch (DbUpdateException)
{
return(Content("Fail"));
}
}
TempData[Globals.SuccessMessageKey] = App_GlobalResources.Wording.Success;
return(RedirectToAction("Detail", new { Id = PhysicalInventory.Id }));
}