private static LotNumber GetLotEntityByMiscellaneousTransaction(MiscellaneousTransactionDetailModel model, int count)
{
if (model == null) return null;
LotNumber entity = new LotNumber();
if (count == 0)
{
entity.CreateBy = AuthenticationHelper.UserId;
entity.CreateDate = DateTime.Now;
}
else
{
entity.CreateBy = model.CreateBy;
entity.CreateDate = model.CreateDate;
}
entity.CompanyId = AuthenticationHelper.CompanyId.Value;
entity.Id = model.Id;
entity.ItemId = model.ItemId;
entity.LotNo = model.LotNo;
entity.SOBId = SessionHelper.SOBId;
entity.SourceId = model.Id;
entity.SourceType = "Miscellaneous Transaction";
entity.UpdateBy = AuthenticationHelper.UserId;
entity.UpdateDate = DateTime.Now;
return entity;
}
public string Update(LotNumber entity)
{
return this.repository.Update(entity);
}
public string Insert(LotNumber entity)
{
return this.repository.Insert(entity);
}
public IEnumerable<SerialNumber> GetAvailableSerials(LotNumber entity, long companyId, long sobId)
{
return this.repository.GetAvailableSerials(entity, companyId, sobId);
}
public string Update(LotNumber entity)
{
LotNumber originalEntity = this.Context.LotNumbers.Find(entity.Id);
this.Context.Entry(originalEntity).CurrentValues.SetValues(entity);
this.Context.Entry(originalEntity).State = EntityState.Modified;
this.Commit();
return entity.Id.ToString();
}
public string Insert(LotNumber entity)
{
this.Context.LotNumbers.Add(entity);
this.Commit();
return entity.Id.ToString();
}
public IEnumerable<SerialNumber> GetAvailableSerials(LotNumber entity, long companyId, long sobId)
{
List<SerialNumber> serialExist = this.GetSerialsbyLotNo(entity.Id, companyId, sobId).ToList();
if (serialExist != null && serialExist.Count > 0)
{
var availableSerials = (from a in serialExist
group a by a.SerialNo into g
where g.Count() % 2 != 0
select new SerialNumber
{
CompanyId = g.FirstOrDefault().CompanyId,
CreateBy = g.FirstOrDefault().CreateBy,
CreateDate = g.FirstOrDefault().CreateDate,
Id = g.FirstOrDefault().Id,
LotNo = g.FirstOrDefault().LotNo,
LotNoId = g.FirstOrDefault().LotNoId,
SerialNo = g.FirstOrDefault().SerialNo,
UpdateBy = g.FirstOrDefault().UpdateBy,
UpdateDate = g.FirstOrDefault().UpdateDate
}).ToList();
return availableSerials;
}
return new List<SerialNumber>();
}
public static string SaveLot(LotNumber entity)
{
return service.Insert(entity);
}
public static string Update(LotNumber entity)
{
return service.Update(entity);
}
