public MiscellaneousTransaction GetSingle(string id, long companyId)
{
long longId = Convert.ToInt64(id);
MiscellaneousTransaction miscTransaction = this.Context.MiscellaneousTransactions.FirstOrDefault(x => x.CompanyId == companyId && x.Id == longId);
return(miscTransaction);
}
public string Update(MiscellaneousTransaction entity)
{
MiscellaneousTransaction originalEntity = this.Context.MiscellaneousTransactions.Find(entity.Id);
this.Context.Entry(originalEntity).CurrentValues.SetValues(entity);
this.Context.Entry(originalEntity).State = EntityState.Modified;
return(entity.Id.ToString());
}
public MiscellaneousTransactionModel(MiscellaneousTransaction entity)
{
this.Id = entity.Id;
this.CompanyId = entity.CompanyId;
this.CreateBy = entity.CreateBy;
this.CreateDate = entity.CreateDate;
this.SOBId = entity.SOBId;
this.TransactionDate = entity.TransactionDate;
this.TransactionType = entity.TransactionType;
this.UpdateBy = entity.UpdateBy;
this.UpdateDate = entity.UpdateDate;
this.CodeCombinationId = entity.CodeCombinationId;
}
public MiscellaneousTransactionDetailModel(MiscellaneousTransaction entity)
{
this.Id = entity.Id;
this.CompanyId = entity.CompanyId;
this.Cost = entity.Cost;
this.CreateBy = entity.CreateBy;
this.CreateDate = entity.CreateDate;
this.ItemId = entity.ItemId;
this.LocatorId = entity.LocatorId;
this.LotNo = entity.LotNo;
this.Quantity = entity.Quantity;
this.SerialNo = entity.SerialNo;
this.SOBId = entity.SOBId;
this.TransactionDate = entity.TransactionDate;
this.TransactionType = entity.TransactionType;
this.UpdateBy = entity.UpdateBy;
this.UpdateDate = entity.UpdateDate;
this.WarehouseId = entity.WarehouseId;
this.CodeCombinationId = entity.CodeCombinationId;
}
private static MiscellaneousTransaction GetEntityByModel(MiscellaneousTransactionDetailModel model, int count)
{
if (model == null)
{
return(null);
}
MiscellaneousTransaction entity = new MiscellaneousTransaction();
if (count == 0)
{
entity.CompanyId = AuthenticationHelper.CompanyId.Value;
entity.CreateBy = AuthenticationHelper.UserId;
entity.CreateDate = DateTime.Now;
}
else
{
entity.CompanyId = model.CompanyId;
entity.CreateBy = model.CreateBy;
entity.CreateDate = model.CreateDate;
}
entity.CodeCombinationId = model.CodeCombinationId;
entity.Cost = model.Cost;
entity.Id = model.Id;
entity.ItemId = model.ItemId;
entity.LocatorId = model.LocatorId;
entity.LotNo = model.LotNo;
entity.Quantity = model.Quantity;
entity.SerialNo = model.SerialNo;
entity.SOBId = model.SOBId;
entity.TransactionDate = model.TransactionDate;
entity.TransactionType = model.TransactionType;
entity.UpdateBy = AuthenticationHelper.UserId;
entity.UpdateDate = DateTime.Now;
entity.WarehouseId = model.WarehouseId;
return(entity);
}
public static void Save(MiscellaneousTransactionModel miscellaneousTransactionModel)
{
var savedDetail = getMiscellaneousTransaction(miscellaneousTransactionModel.SOBId, miscellaneousTransactionModel.TransactionType, miscellaneousTransactionModel.CodeCombinationId, miscellaneousTransactionModel.TransactionDate);
if (SessionHelper.MiscellaneousTransaction != null)
{
if (savedDetail.Count() > miscellaneousTransactionModel.MiscellaneousTransactionDetail.Count())
{
var tobeDeleted = savedDetail.Take(savedDetail.Count() - miscellaneousTransactionModel.MiscellaneousTransactionDetail.Count());
foreach (var item in tobeDeleted)
{
service.Delete(item.Id.ToString(), AuthenticationHelper.CompanyId.Value);
IEnumerable <LotNumber> lotNum = lotNumService.CheckLotNumAvailability(AuthenticationHelper.CompanyId.Value, item.LotNo, item.ItemId, SessionHelper.SOBId);
if (lotNum.Any())
{
LotNumberHelper.Delete(lotNum.FirstOrDefault().Id.ToString());
}
//IEnumerable<SerialNumber> serialNum = lotNumService.CheckSerialNumAvailability(AuthenticationHelper.CompanyId.Value, item.LotNo, item.SerialNo);
//if (serialNum.Any())
//{
// LotNumberHelper.DeleteSerialNumber(serialNum.FirstOrDefault().Id.ToString());
//}
}
savedDetail = getMiscellaneousTransaction(miscellaneousTransactionModel.SOBId, miscellaneousTransactionModel.TransactionType, miscellaneousTransactionModel.CodeCombinationId, miscellaneousTransactionModel.TransactionDate);
}
foreach (var detail in miscellaneousTransactionModel.MiscellaneousTransactionDetail)
{
MiscellaneousTransaction detailEntity = GetEntityByModel(detail, savedDetail.Count());
if (detailEntity.IsValid())
{
if (savedDetail.Count() > 0)
{
detailEntity.Id = savedDetail.FirstOrDefault().Id;
savedDetail.Remove(savedDetail.FirstOrDefault(rec => rec.Id == detailEntity.Id));
service.Update(detailEntity);
IEnumerable <LotNumber> lotNum = lotNumService.CheckLotNumAvailability(AuthenticationHelper.CompanyId.Value, detailEntity.LotNo, detailEntity.ItemId, SessionHelper.SOBId);
if (lotNum.Any())
{
LotNumberHelper.Update(lotNum.FirstOrDefault());
}
//IEnumerable<SerialNumber> serialNum = lotNumService.CheckSerialNumAvailability(AuthenticationHelper.CompanyId.Value, detailEntity.LotNo, detailEntity.SerialNo);
//if (serialNum.Any())
//{
// LotNumberHelper.UpdateSerialNumber(serialNum.FirstOrDefault());
//}
}
else
{
service.Insert(detailEntity);
IEnumerable <LotNumber> lotNum = lotNumService.CheckLotNumAvailability(AuthenticationHelper.CompanyId.Value, detailEntity.LotNo, detailEntity.ItemId, SessionHelper.SOBId);
if (!lotNum.Any())
{
LotNumberHelper.Insert(new MiscellaneousTransactionDetailModel(detailEntity));
}
//IEnumerable<SerialNumber> serialNum = lotNumService.CheckSerialNumAvailability(AuthenticationHelper.CompanyId.Value, detailEntity.LotNo, detailEntity.SerialNo);
//if (!serialNum.Any())
//{
// LotNumberHelper.InsertSerialNumber(new MiscellaneousTransactionDetailModel(detailEntity));
//}
}
}
}
}
}
public string Insert(MiscellaneousTransaction entity)
{
this.Context.MiscellaneousTransactions.Add(entity);
this.Commit();
return(entity.Id.ToString());
}
public string Update(MiscellaneousTransaction entity)
{
return(this.repository.Update(entity));
}
public string Insert(MiscellaneousTransaction entity)
{
return(this.repository.Insert(entity));
}
