/// <summary>
/// Update the quotation state field to verify whether the quotation is input or not
/// </summary>
/// <param name="PurchaseRequestID"></param>
/// <param name="SupplierID"></param>
public void Quotation(int QuotationRequestID,
int SupplierID,
DateTime QuotationDate,
DateTime ValidDate,
double TaxRate,
int TaxInclude,
int ContactID)
{
QRSupplier _dbEntry = _context.QRSuppliers.Where(p => p.SupplierID == SupplierID).Where(p => p.QuotationRequestID == QuotationRequestID).FirstOrDefault();
if (_dbEntry != null)
{
_dbEntry.QuotationState = true;
_dbEntry.QuotationDate = QuotationDate;
_dbEntry.ValidDate = ValidDate;
_dbEntry.TaxRate = TaxRate;
if (TaxInclude == 0)
{
_dbEntry.TaxInclude = false;
}
else
{
_dbEntry.TaxInclude = true;
}
_dbEntry.ContactID = ContactID;
}
_context.SaveChanges();
}
public void Delete(int QRSupplierID)
{
QRSupplier _qrSupplier = _context.QRSuppliers.Find(QRSupplierID);
_qrSupplier.Enabled = false;
_context.SaveChanges();
}
public int Save(QRSupplier QRSupplier)
{
if (QRSupplier.QRSupplierID == 0)
{
QRSupplier _dbEntry = _context.QRSuppliers.Where(q => q.QuotationRequestID == QRSupplier.QuotationRequestID)
.Where(q => q.SupplierID == QRSupplier.SupplierID).FirstOrDefault();
if (_dbEntry == null)
{
QRSupplier.QuotationState = false;
QRSupplier.RequestDate = DateTime.Now;
QRSupplier.Enabled = true;
_context.QRSuppliers.Add(QRSupplier);
}
else
{
_dbEntry.QuotationRequestID = QRSupplier.QuotationRequestID;
_dbEntry.SupplierID = QRSupplier.SupplierID;
_dbEntry.RequestDate = QRSupplier.RequestDate;
_dbEntry.TaxInclude = QRSupplier.TaxInclude;
_dbEntry.TaxRate = QRSupplier.TaxRate;
_dbEntry.Enabled = QRSupplier.Enabled;
}
}
else
{
QRSupplier _dbEntry = _context.QRSuppliers.Find(QRSupplier.QRSupplierID);
if (_dbEntry != null)
{
_dbEntry.QuotationRequestID = QRSupplier.QuotationRequestID;
_dbEntry.SupplierID = QRSupplier.SupplierID;
_dbEntry.RequestDate = QRSupplier.RequestDate;
_dbEntry.TaxRate = QRSupplier.TaxRate;
_dbEntry.Enabled = QRSupplier.Enabled;
}
}
_context.SaveChanges();
return(QRSupplier.QRSupplierID);
}
