private ReceivingDetail getEntityByModel(ReceivingDetailModel model)
{
if (model == null)
{
return(null);
}
ReceivingDetail entity = new ReceivingDetail();
if (model.Id == 0)
{
entity.CreateBy = AuthenticationHelper.UserId;
entity.CreateDate = DateTime.Now;
}
else
{
entity.CreateBy = model.CreateBy;
entity.CreateDate = model.CreateDate;
}
entity.Id = model.Id;
entity.ItemId = model.ItemId;
entity.LocatorId = model.LocatorId;
entity.LotNoId = model.LotNoId;
entity.Quantity = model.ThisPurchaseQty;
entity.ReceiptId = model.ReceiptId;
entity.SerialNo = model.SerialNo;
entity.UpdateBy = model.UpdateBy;
entity.UpdateDate = model.UpdateDate;
entity.WarehouseId = model.WarehouseId;
entity.PODetailId = model.PODetailId;
return(entity);
}
public ActionResult AddNewPartial(ReceivingDetailModel model)
{
if (ModelState.IsValid)
{
try
{
if (model.ThisPurchaseQty > model.BalanceQty)
{
ViewData["EditError"] = "Quantity can not be more than balance!";
}
if (!string.IsNullOrEmpty(model.SerialNo))
{
if (string.IsNullOrEmpty(model.LotNo))
{
ViewData["EditError"] = "Serials can not be defined without Lot!";
}
}
else
{
if (SessionHelper.Receiving != null)
{
if (SessionHelper.Receiving.ReceivingDetail != null && SessionHelper.Receiving.ReceivingDetail.Count() > 0)
{
model.Id = SessionHelper.Receiving.ReceivingDetail.LastOrDefault().Id + 1;
}
else
{
model.Id = 1;
}
}
else
{
model.Id = 1;
}
SessionHelper.Receiving.ReceivingDetail.Add(model);
}
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
}
return(PartialView("_Detail", getReceivingDetail()));
}
public ActionResult DeletePartial(ReceivingDetailModel model)
{
try
{
ReceivingModel receiving = SessionHelper.Receiving;
ReceivingDetailModel receivingDetail = receiving.ReceivingDetail.FirstOrDefault(rec => rec.Id == model.Id);
SessionHelper.Receiving.ReceivingDetail.Remove(receivingDetail);
}
catch (Exception ex)
{
ViewData["EditError"] = ex.Message;
}
return(PartialView("_Detail", getReceivingDetail()));
}
private string deleteLot(ReceivingDetailModel model)
{
LotNumber lot = lotService.GetSingle(model.LotNoId.Value.ToString(), AuthenticationHelper.CompanyId.Value);
List <LotNumber> savedLots = lotService.GetAllbyLotNo(AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId, lot.LotNo, lot.ItemId).ToList();
if (model.LotNoId != null)
{
List <SerialNumber> savedSerials = lotService.GetSerialsbyLotNo(model.LotNoId.Value, AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId);
if (savedSerials != null && savedSerials.Count() > 0)
{
if (!string.IsNullOrEmpty(model.SerialNo))
{
List <string> currentSerials = model.SerialNo.Trim().Split(new char[] { ',' }).ToList();
if (savedSerials.Any(rec => rec.SerialNo != currentSerials.FirstOrDefault(x => x == rec.SerialNo)))
{
lot.Qty = lot.Qty - model.ThisPurchaseQty;
lotService.Update(lot);
return("");
}
else
{
lotService.Delete(model.LotNoId.Value.ToString(), AuthenticationHelper.CompanyId.Value);
}
}
else
{
lot.Qty = lot.Qty - model.ThisPurchaseQty;
lotService.Update(lot);
return("");
}
}
else
{
lotService.Delete(model.LotNoId.Value.ToString(), AuthenticationHelper.CompanyId.Value);
}
}
return("");
}
private string deleteSerials(ReceivingDetailModel model)
{
ReceivingDetail savedDetail = service.GetSingleReceivingDetail(model.Id);
if (!string.IsNullOrEmpty(savedDetail.SerialNo))
{
List <string> savedSerials = savedDetail.SerialNo.Split(new char[] { ',' }).ToList();
bool isAllowed = true;
List <SerialNumber> tobeDeleted = new List <SerialNumber>();
foreach (var serial in savedSerials)
{
SerialNumber currentSerial = lotService.GetSerialNo(serial, savedDetail.LotNoId.Value, AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId);
if (currentSerial != null)
{
isAllowed = lotService.CheckSerialNumAvailability(AuthenticationHelper.CompanyId.Value, savedDetail.LotNoId.Value, serial);
if (!isAllowed)
{
return("Record can not be deleted!");
}
else
{
tobeDeleted.Add(lotService.GetSerialNo(serial, savedDetail.LotNoId.Value, AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId));
}
}
}
if (isAllowed)
{
if (tobeDeleted.Count() > 0)
{
foreach (var item in tobeDeleted)
{
lotService.DeleteSerialNum(item.Id.ToString(), AuthenticationHelper.CompanyId.Value);
}
}
}
}
return("");
}
public ActionResult UpdatePartial(ReceivingDetailModel model)
{
if (ModelState.IsValid)
{
try
{
ReceivingDetailModel completeModel = SessionHelper.Receiving.ReceivingDetail.FirstOrDefault(x => x.Id == model.Id);
Item item = itemService.GetSingle(completeModel.ItemId.ToString(), AuthenticationHelper.CompanyId.Value);
if (item.LotControl)
{
if (string.IsNullOrEmpty(model.LotNo))
{
ViewData["EditError"] = "Please provide Lot #!";
return(PartialView("_Detail", getReceivingDetail()));
}
}
else
{
if (!string.IsNullOrEmpty(model.LotNo))
{
ViewData["EditError"] = "Item does not support Lot!";
return(PartialView("_Detail", getReceivingDetail()));
}
}
if (item.SerialControl)
{
if (string.IsNullOrEmpty(model.SerialNo))
{
ViewData["EditError"] = "Please provide Serial #!";
return(PartialView("_Detail", getReceivingDetail()));
}
else
{
if (string.IsNullOrEmpty(model.LotNo))
{
ViewData["EditError"] = "Please provide Lot #!";
return(PartialView("_Detail", getReceivingDetail()));
}
}
}
else
{
if (!string.IsNullOrEmpty(model.SerialNo))
{
ViewData["EditError"] = "Item does not support Serials!";
return(PartialView("_Detail", getReceivingDetail()));
}
}
if (model.WarehouseId == 0)
{
ViewData["EditError"] = "Please select Warehouse!";
return(PartialView("_Detail", getReceivingDetail()));
}
if (model.LocatorId == 0)
{
ViewData["EditError"] = "Please select Locator!";
return(PartialView("_Detail", getReceivingDetail()));
}
if (model.ThisPurchaseQty > completeModel.BalanceQty + model.ThisPurchaseQty)
{
ViewData["EditError"] = "Quantity can not be more than balance!";
return(PartialView("_Detail", getReceivingDetail()));
}
if (!string.IsNullOrEmpty(model.SerialNo))
{
if (string.IsNullOrEmpty(model.LotNo))
{
ViewData["EditError"] = "Serials can not be defined without Lot!";
return(PartialView("_Detail", getReceivingDetail()));
}
else
{
List <string> serials = model.SerialNo.Split(new char[] { ',' }).ToList();
if (serials.Count() != model.ThisPurchaseQty)
{
ViewData["EditError"] = "Serials must be according to the Quantity!";
return(PartialView("_Detail", getReceivingDetail()));
}
}
}
ReceivingDetailModel currentModel = SessionHelper.Receiving.ReceivingDetail.FirstOrDefault(rec => rec.Id == model.Id);
currentModel.Id = model.Id;
currentModel.LocatorId = model.LocatorId;
currentModel.LotNo = model.LotNo;
currentModel.SerialNo = model.SerialNo;
currentModel.WarehouseId = model.WarehouseId;
currentModel.ThisPurchaseQty = model.ThisPurchaseQty;
currentModel.BalanceQty = completeModel.OrderQty - (completeModel.PurchaseQty + model.ThisPurchaseQty);
currentModel.OrderQty = completeModel.OrderQty;
currentModel.LotNoId = completeModel.LotNoId;
currentModel.ItemId = completeModel.ItemId;
currentModel.ItemName = completeModel.ItemName;
currentModel.PODetailId = completeModel.PODetailId;
currentModel.ReceiptId = completeModel.ReceiptId;
SessionHelper.Receiving.ReceivingDetail.Remove(SessionHelper.Receiving.ReceivingDetail.FirstOrDefault(rec => rec.Id == model.Id));
SessionHelper.Receiving.ReceivingDetail.Add(currentModel);
}
catch (Exception e)
{
ViewData["EditError"] = e.Message;
}
}
else
{
ViewData["EditError"] = "Please, correct all errors.";
}
return(PartialView("_Detail", getReceivingDetail()));
}
private string save(ReceivingModel model)
{
Receiving entity = getEntityByModel(model);
if (model.Id > 0)
{
List <ReceivingDetailModel> receivingDetail = service.GetAllReceivingDetail(model.Id).Select(rec => new ReceivingDetailModel(rec, true)).ToList();
if (receivingDetail != null && receivingDetail.Count() > 0)
{
foreach (var item in receivingDetail)
{
if (!model.ReceivingDetail.Any(rec => rec.PODetailId == item.PODetailId))
{
string serialResult = deleteSerials(item);
if (string.IsNullOrEmpty(serialResult))
{
service.DeleteReceivingDetail(item.Id);
deleteLot(item);
}
else
{
return(serialResult);
}
}
}
}
}
List <ReceivingDetailModel> tobeUpdatedDetail = model.ReceivingDetail.Where(rec => rec.LocatorId > 0 && rec.WarehouseId > 0).ToList();
string result = string.Empty;
if (entity.IsValid())
{
bool goodToSave = false;
foreach (var item in tobeUpdatedDetail)
{
ReceivingDetailModel updatedModel = item;
string lotResult = updateLot(updatedModel);
int outVal;
bool isNumeric = int.TryParse(lotResult, out outVal);
if (isNumeric || string.IsNullOrEmpty(lotResult))
{
item.LotNoId = isNumeric ? (long?)Convert.ToInt64(lotResult) : null;
string serialResult = updateSerials(updatedModel);
if (string.IsNullOrEmpty(serialResult))
{
goodToSave = true;
}
else
{
if (item.LotNoId != null)
{
LotNumber lot = lotService.GetSingle(item.LotNoId.Value.ToString(), AuthenticationHelper.CompanyId.Value);
lot.Qty = lot.Qty - item.ThisPurchaseQty;
lotService.Update(lot);
}
return(serialResult);
}
}
else
{
return(lotResult);
}
}
if (goodToSave)
{
if (model.Id > 0)
{
result = service.Update(entity);
}
else
{
result = service.Insert(entity);
}
if (!string.IsNullOrEmpty(result))
{
var savedLines = getReceivingDetail(result);
if (savedLines.Count() > tobeUpdatedDetail.Count())
{
var tobeDeleted = savedLines.Take(savedLines.Count() - tobeUpdatedDetail.Count());
foreach (var item in tobeDeleted)
{
string serialResult = deleteSerials(item);
if (string.IsNullOrEmpty(serialResult))
{
string lotResult = deleteLot(item);
if (string.IsNullOrEmpty(lotResult))
{
service.DeleteReceivingDetail(item.Id);
}
else
{
return("Record can not be deleted");
}
}
else
{
return("Record can not be deleted");
}
}
savedLines = getReceivingDetail(result);
}
foreach (var detail in tobeUpdatedDetail)
{
ReceivingDetail detailEntity = getEntityByModel(detail);
if (detailEntity.IsValid())
{
detailEntity.ReceiptId = Convert.ToInt64(result);
if (savedLines.Count() > 0)
{
detailEntity.Id = savedLines.FirstOrDefault().Id;
savedLines.Remove(savedLines.FirstOrDefault(rec => rec.Id == detailEntity.Id));
string receivingDetailId = service.Update(detailEntity);
if (detailEntity.LotNoId != null)
{
LotNumber lottobeUpdated = lotService.GetSingle(detailEntity.LotNoId.ToString(), AuthenticationHelper.CompanyId.Value);
lottobeUpdated.SourceId = Convert.ToInt64(receivingDetailId);
lotService.Update(lottobeUpdated);
}
}
else
{
string receivingDetailId = service.Insert(detailEntity);
if (detailEntity.LotNoId != null)
{
LotNumber lottobeUpdated = lotService.GetSingle(detailEntity.LotNoId.ToString(), AuthenticationHelper.CompanyId.Value);
lottobeUpdated.SourceId = Convert.ToInt64(receivingDetailId);
lotService.Update(lottobeUpdated);
}
}
}
}
}
}
}
return("");
}
private string updateSerials(ReceivingDetailModel model)
{
if (!string.IsNullOrEmpty(model.SerialNo))
{
List <string> newSerials = model.SerialNo.Trim().Split(new char[] { ',' }).ToList();
if (newSerials.Count() != model.ThisPurchaseQty)
{
return("Serials must be according to the Quantity");
}
}
if (model.Id > 0)
{
ReceivingDetail savedDetail = service.GetSingleReceivingDetail(model.Id);
if (!string.IsNullOrEmpty(model.SerialNo))
{
List <string> unsavedSerials = model.SerialNo.Trim().Split(new char[] { ',' }).ToList();
if (!string.IsNullOrEmpty(savedDetail.SerialNo))
{
List <string> savedSerials = savedDetail.SerialNo.Split(new char[] { ',' }).ToList();
bool isAvailable = true;
foreach (var serial in savedSerials)
{
isAvailable = lotService.CheckSerialNumAvailability(AuthenticationHelper.CompanyId.Value, savedDetail.LotNoId.Value, serial);
if (!isAvailable)
{
return("Serial is in use!");
}
}
if (isAvailable)
{
if (savedSerials.Count() > unsavedSerials.Count())
{
List <string> tobeDeleted = savedSerials.Take(savedSerials.Count() - unsavedSerials.Count()).ToList();
if (tobeDeleted != null && tobeDeleted.Count() > 0)
{
foreach (var item in tobeDeleted)
{
SerialNumber serialNum = lotService.GetSerialNo(item, savedDetail.LotNoId.Value, AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId);
if (serialNum != null)
{
lotService.DeleteSerialNum(serialNum.Id.ToString(), AuthenticationHelper.CompanyId.Value);
}
}
}
}
foreach (var serial in unsavedSerials)
{
SerialNumber entity = lotService.GetSerialNo(serial, savedDetail.LotNoId.Value, AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId);
if (entity != null)
{
entity.LotNo = model.LotNo;
entity.SerialNo = serial;
lotService.UpdateSerialNum(entity);
}
else
{
lotService.InsertSerialNum(new SerialNumber
{
CompanyId = AuthenticationHelper.CompanyId.Value,
CreateBy = AuthenticationHelper.UserId,
CreateDate = DateTime.Now,
LotNo = model.LotNo,
LotNoId = savedDetail.LotNoId.Value,
SerialNo = serial,
UpdateBy = null,
UpdateDate = null
});
}
}
}
}
else
{
foreach (var serial in unsavedSerials)
{
lotService.InsertSerialNum(new SerialNumber
{
CompanyId = AuthenticationHelper.CompanyId.Value,
CreateBy = AuthenticationHelper.UserId,
CreateDate = DateTime.Now,
LotNo = model.LotNo,
LotNoId = savedDetail.Id,
SerialNo = serial,
UpdateBy = null,
UpdateDate = null
});
}
}
}
}
else
{
if (!string.IsNullOrEmpty(model.SerialNo))
{
if (!string.IsNullOrEmpty(model.LotNo))
{
LotNumber lot = lotService.GetLotbyItem(AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId, model.ItemId, model.LotNo);
if (lot != null)
{
List <string> serials = model.SerialNo.Trim().Split(new char[] { ',' }).ToList();
bool notAvailable = true;
foreach (var serial in serials)
{
notAvailable = lotService.CheckSerialNumAvailability(AuthenticationHelper.CompanyId.Value, lot.Id, serial);
if (notAvailable)
{
return("Serial # " + serial + " is already defined");
}
}
if (!notAvailable)
{
foreach (var serial in serials)
{
lotService.InsertSerialNum(new SerialNumber
{
CompanyId = AuthenticationHelper.CompanyId.Value,
CreateBy = AuthenticationHelper.UserId,
CreateDate = DateTime.Now,
LotNo = lot.LotNo,
LotNoId = lot.Id,
SerialNo = serial,
UpdateBy = null,
UpdateDate = null
});
}
}
}
else
{
return("Lot not found!");
}
}
else
{
return("Serials can not be defined without lot!");
}
}
}
return("");
}
private string updateLot(ReceivingDetailModel model)
{
if (!string.IsNullOrEmpty(model.LotNo))
{
if (model.Id > 0)
{
ReceivingDetail savedDetail = service.GetSingleReceivingDetail(model.Id);
LotNumber savedLot = lotService.GetSingle(model.LotNoId.ToString(), AuthenticationHelper.CompanyId.Value);
if (savedLot.LotNo == model.LotNo)
{
savedLot.Qty = savedLot.Qty - savedDetail.Quantity + model.ThisPurchaseQty;
return(lotService.Update(savedLot));
}
else
{
List <LotNumber> savedLots = lotService.GetAllbyLotNo(AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId, savedLot.LotNo, savedLot.ItemId).ToList();
if (savedLots.Count() > 1)
{
return("Lot can not be edited!");
}
else
{
savedLot.Qty = savedLot.Qty - savedDetail.Quantity + model.ThisPurchaseQty;
savedLot.LotNo = model.LotNo;
return(lotService.Update(savedLot));
}
}
}
else
{
LotNumber savedLot = lotService.GetLotbyItem(AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId, model.ItemId, model.LotNo);
if (savedLot != null)
{
savedLot.Qty = savedLot.Qty + model.ThisPurchaseQty;
return(lotService.Update(savedLot));
}
else
{
return(lotService.Insert(new LotNumber
{
CompanyId = AuthenticationHelper.CompanyId.Value,
CreateBy = AuthenticationHelper.UserId,
CreateDate = DateTime.Now,
ItemId = model.ItemId,
LotNo = model.LotNo,
Qty = model.ThisPurchaseQty,
SOBId = SessionHelper.SOBId,
SourceId = 0,
SourceType = "Receiving",
UpdateBy = null,
UpdateDate = null
}));
}
}
}
else
{
if (model.Id > 0)
{
ReceivingDetail savedDetail = service.GetSingleReceivingDetail(model.Id);
LotNumber lot = lotService.GetSingle(savedDetail.LotNoId.Value.ToString(), AuthenticationHelper.CompanyId.Value);
List <LotNumber> savedLots = lotService.GetAllbyLotNo(AuthenticationHelper.CompanyId.Value, SessionHelper.SOBId, lot.LotNo, lot.ItemId).ToList();
if (savedDetail.LotNoId != null)
{
if (savedLots.Count() > 1)
{
return("Lot can not be deleted!");
}
else
{
lotService.Delete(savedDetail.LotNoId.Value.ToString(), AuthenticationHelper.CompanyId.Value);
}
}
return("");
}
return("");
}
}
