public void UpdateState(int QRQuotationID)
{
QRQuotation _dbEntry = _context.QRQuotations.Find(QRQuotationID);
_dbEntry.Enabled = false;
_context.SaveChanges();
}
public PRQuotationGridViewModel(int PurchaseRequestID,
IEnumerable <PRContent> PRContents,
IEnumerable <QRSupplier> PRSuppliers,
IEnumerable <QRQuotation> PRQuotations)
{
rows = new List <PRQuotationGridRowModel>();
foreach (PRContent _content in PRContents)
{
string[] SupplierName = new string[PRSuppliers.Count()];
int[] SupplierID = new int[PRSuppliers.Count()];
string[] Quotations = new string[PRQuotations.Count()];
int[] QuotationID = new int[PRQuotations.Count()];
int i = 0;
foreach (QRSupplier _supplier in PRSuppliers)
{
SupplierName[i] = _supplier.SupplierName;
SupplierID[i] = _supplier.SupplierID;
QRQuotation _quotation = PRQuotations.Where(p => p.SupplierID == _supplier.SupplierID).Where(p => p.QRContentID == _content.PRContentID).FirstOrDefault();
if (_quotation == null)
{
Quotations[i] = "-";
}
else
{
Quotations[i] = _quotation.UnitPrice.ToString();
}
PRQuotationGridRowModel _rowModel = new PRQuotationGridRowModel(_content, Quotations);
i = i + 1;
}
}
}
public int Save(QRQuotation QRQuotation)
{
if (QRQuotation.QRQuotationID == 0)
{
_context.QRQuotations.Add(QRQuotation);
}
else
{
QRQuotation _dbEntry = _context.QRQuotations.Find(QRQuotation.QRQuotationID);
if (_dbEntry != null)
{
_dbEntry.QRContentID = QRQuotation.QRContentID;
_dbEntry.SupplierID = QRQuotation.SupplierID;
_dbEntry.QuotationRequestID = QRQuotation.QuotationRequestID;
_dbEntry.UnitPrice = QRQuotation.UnitPrice;
_dbEntry.TotalPrice = QRQuotation.TotalPrice;
_dbEntry.Quantity = QRQuotation.Quantity;
_dbEntry.QuotationDate = QRQuotation.QuotationDate;
_dbEntry.UnitPriceWT = QRQuotation.UnitPriceWT;
_dbEntry.TotalPriceWT = QRQuotation.TotalPriceWT;
_dbEntry.TaxRate = QRQuotation.TaxRate;
_dbEntry.Enabled = true;
}
}
_context.SaveChanges();
return(QRQuotation.QRQuotationID);
}
public QRQuotationEditModel(QRContent QRContent, QRQuotation QRQuotation = null)
{
_qrContent = QRContent;
if (QRQuotation != null)
{
_prQuotation = QRQuotation;
}
else
{
_prQuotation = new QRQuotation();
}
}
