private TblAdjustmentTempDetail UpdateOrInsertAdjustmentTempDetail(TblAdjustmentTempDetail newRow, int index, out int outindex)
{
outindex = index;
using (var context = new WorkFlowManagerDBEntities())
{
try
{
var oldRow = (from e in context.TblAdjustmentTempDetails
where e.Iserial == newRow.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
//context.Entry(oldRow).CurrentValues.SetValues(newRow);
SharedOperation.GenericUpdate(oldRow, newRow, context);
}
else
{
context.TblAdjustmentTempDetails.AddObject(newRow);
}
context.SaveChanges();
}
catch (Exception ex) { }
return(newRow);
}
}
private TblAdjustmentTempDetail DeleteAdjustmentTempDetail(TblAdjustmentTempDetail row)
{
using (var context = new WorkFlowManagerDBEntities())
{
var oldRow = (from e in context.TblAdjustmentTempDetails
where e.Iserial == row.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
context.DeleteObject(oldRow);
}
context.SaveChanges();
}
return(row);
}
public void SaveDetailRow()
{
if (SelectedDetailRow != null)
{
var valiationCollection = new List <ValidationResult>();
var isvalid = Validator.TryValidateObject(SelectedDetailRow, new ValidationContext(SelectedDetailRow, null, null), valiationCollection, true);
if (isvalid)
{
var rowToSave = new TblAdjustmentTempDetail();
rowToSave.InjectFrom(SelectedDetailRow);
WarehouseClient.UpdateOrInsertAdjustmentTempDetailAsync(rowToSave, SelectedMainRow.TblAdjustmentTempDetails.IndexOf(SelectedDetailRow));
}
}
}
private TblAdjustmentTempDetail GetAdjustmentTempDetail(int headerId, int ItemDimIserail)
{
using (var context = new WorkFlowManagerDBEntities())
{
bool isNew = false;
decimal oldQty = 0;
var result = context.TblAdjustmentTempDetails.Include(nameof(TblAdjustmentTempDetail.TblAdjustmentHeader)).Include(
string.Format("{0}.{1}", nameof(TblAdjustmentTempDetail.TblAdjustmentHeader), nameof(TblAdjustmentHeader.TblWarehouse)))
.FirstOrDefault(v => v.AdjustmentHeaderIserial == headerId && v.ItemDimIserial == ItemDimIserail);
if (result == null)
{
isNew = true;
result = new TblAdjustmentTempDetail()
{
AdjustmentHeaderIserial = headerId, ItemDimIserial = ItemDimIserail
};
context.TblAdjustmentTempDetails.AddObject(result);
context.SaveChanges();
result = context.TblAdjustmentTempDetails.Include(nameof(TblAdjustmentTempDetail.TblAdjustmentHeader)).Include(
string.Format("{0}.{1}", nameof(TblAdjustmentTempDetail.TblAdjustmentHeader), nameof(TblAdjustmentHeader.TblWarehouse)))
.FirstOrDefault(v => v.AdjustmentHeaderIserial == headerId && v.ItemDimIserial == ItemDimIserail);
}
else
{
oldQty = result.CountedQuantity;
}
if (isNew)
{
result.ItemAdjustment = GetItemDimensionQuantitiesByDate(result.TblAdjustmentHeader.TblWarehouse.Code, ItemDimIserail, result.TblAdjustmentHeader.DocDate);
}
else
{
result.OldQuantity = oldQty;
}
result.AvailableQuantity = result.ItemAdjustment.AvailableQuantity;
result.DifferenceQuantity = result.ItemAdjustment.DifferenceQuantity;
result.CountedQuantity = result.ItemAdjustment.CountedQuantity;
context.SaveChanges();
return(result);
}
}
/// <summary>
/// لازم يكون معاه الهيدر بتاعه
/// </summary>
/// <param name="context"></param>
/// <param name="item"></param>
private static void GetAdjustmentTempItemDetails(WorkFlowManagerDBEntities context, TblAdjustmentTempDetail item)
{
// From
var tempFrom = context.GetItemDimDetails(item.ItemDimIserial);
var itemDimFromResult = tempFrom.FirstOrDefault();
item.ItemAdjustment.ItemId = itemDimFromResult.ItemIserial;
item.ItemAdjustment.ItemName = itemDimFromResult.ItemName;
item.ItemAdjustment.ItemType = itemDimFromResult.ItemType;
item.ItemAdjustment.ItemCode = context.FabricAccSearches.FirstOrDefault(fas =>
fas.Iserial == itemDimFromResult.ItemIserial && fas.ItemGroup == itemDimFromResult.ItemType).Code;
item.ItemAdjustment.DifferenceQuantity = item.DifferenceQuantity;
item.ItemAdjustment.AvailableQuantity = item.AvailableQuantity;
item.ItemAdjustment.CountedQuantity = item.CountedQuantity;
item.ItemAdjustment.Cost = item.Cost;
item.ItemAdjustment.ItemDimFromIserial = item.ItemDimIserial;
item.ItemAdjustment.ColorFromId = itemDimFromResult.ColorIserial;
item.ItemAdjustment.ColorFromCode = itemDimFromResult.ColorCode;
item.ItemAdjustment.SizeFrom = itemDimFromResult.Size;
item.ItemAdjustment.BatchNoFrom = itemDimFromResult.BatchNo;
item.ItemAdjustment.SiteFromIserial = itemDimFromResult.SiteIserial;
var vendor = context.Vendor_new.FirstOrDefault(v => context.TblTradeAgreementHeaders.Any(tah =>
tah.Vendor == v.Vendor_Code && tah.TblTradeAgreementDetails.Any(tad => tad.ItemCode == itemDimFromResult.ItemIserial)));
item.ItemAdjustment.Vendor = (vendor == null ? "" : vendor.Vendor_Ename);
}
