public tblNewRFQMainHeader UpdateOrInsertNewRfq(tblNewRFQMainHeader newRow)
{
using (var context = new WorkFlowManagerDBEntities())
{
var oldRow = (from e in context.tblNewRFQMainHeaders
where e.Iserial == newRow.Iserial
select e).SingleOrDefault();
if (oldRow != null)
{
GenericUpdate(oldRow, newRow, context);
}
else
{
try
{
var max = context.tblNewRFQMainHeaders.Select(x => x.DocNumber).Cast <int>().Max(x => x);
newRow.DocNumber = (max + 1).ToString();
}
catch
{
newRow.DocNumber = "0";
}
context.tblNewRFQMainHeaders.AddObject(newRow);
}
context.SaveChanges();
return(newRow);
}
}
private void MapToMe(tblNewRFQMainHeader tblNewRfqMainHeader)
{
if (tblNewRfqMainHeader == null)
{
return;
}
Iserial = tblNewRfqMainHeader.Iserial;
SupplierCode = tblNewRfqMainHeader.SupplierCode;
BrandCode = tblNewRfqMainHeader.BrandCode;
DocNumber = tblNewRfqMainHeader.DocNumber;
SeasonCode = tblNewRfqMainHeader.SeasonCode;
tblNewRFQDetails.Clear();
var tmp = (from x in tblNewRfqMainHeader.tblNewRFQDetails
select new NewRFQDetailsViewModel
{
Iserial = x.Iserial,
ColorCode = x.ColorCode,
StyleCode = x.StyleCode,
Cost = x.Cost,
Qty = x.Qty,
DeliveryDate = x.DeliveryDate,
MainHeader = x.MainHeader,
RFSNumber = x.RFSNumber,
LandedCost = x.LandedCost,
ExchangeRate = x.ExchangeRate,
RawCost = x.Cost != 0 && x.ExchangeRate != 0 ? (x.Cost / x.ExchangeRate) : 0,
IsSampleRequested = x.RFSNumber == null ? NewRFQDetailsViewModel.YesNoEnum.No : NewRFQDetailsViewModel.YesNoEnum.Yes,
tblNewRFQMainHeader = this,
tblNewRFQSizeDetails =
new ObservableCollection <NewRFQSizeDetailVM>
(x.tblNewRFQSizeDetails
.Select(s => new NewRFQSizeDetailVM
{
Iserial = s.Iserial,
SizeRatio = s.SizeRatio,
SizeCode = s.SizeCode,
Qty = s.Qty,
ParentSerial = x.Iserial
}).ToList())
}).ToList();
tmp.ForEach(x => tblNewRFQDetails.Add(x));
}
private tblNewRFQMainHeader MapToModel(NewRFQViewModel tblNewRfqMainHeader)
{
var ret = new tblNewRFQMainHeader
{
Iserial = tblNewRfqMainHeader.Iserial,
SupplierCode = tblNewRfqMainHeader.SupplierCode,
BrandCode = tblNewRfqMainHeader.BrandCode,
DocNumber = tblNewRfqMainHeader.DocNumber,
SeasonCode = tblNewRfqMainHeader.SeasonCode
};
var tmp = (from x in tblNewRfqMainHeader.tblNewRFQDetails
select new tblNewRFQDetail
{
Iserial = x.Iserial,
ColorCode = x.ColorCode,
StyleCode = x.StyleCode,
Cost = x.Cost,
Qty = x.Qty,
DeliveryDate = x.DeliveryDate,
MainHeader = x.MainHeader,
RFSNumber = x.RFSNumber,
LandedCost = x.LandedCost,
ExchangeRate = x.ExchangeRate,
CurrencyID = (x.SelectedCurrency != null ? (int?)x.SelectedCurrency.Iserial : null),
tblNewRFQSizeDetails =
new ObservableCollection <tblNewRFQSizeDetail>
(x.tblNewRFQSizeDetails
.Select(s => new tblNewRFQSizeDetail
{
Iserial = s.Iserial,
SizeRatio = s.SizeRatio,
SizeCode = s.SizeCode,
Qty = s.Qty,
ParentSerial = x.Iserial
}).ToList())
}).ToList();
ret.tblNewRFQDetails = new ObservableCollection <tblNewRFQDetail>();
tmp.ForEach(x => ret.tblNewRFQDetails.Add(x));
return(ret);
}
