/// <summary>
/// Create a new PurchaseRequest object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="pRNo">Initial value of the PRNo property.</param>
/// <param name="requestedBy">Initial value of the RequestedBy property.</param>
/// <param name="isPoReady">Initial value of the IsPoReady property.</param>
/// <param name="isQuoted">Initial value of the IsQuoted property.</param>
/// <param name="isFinished">Initial value of the IsFinished property.</param>
/// <param name="isCanvased">Initial value of the IsCanvased property.</param>
/// <param name="isEditable">Initial value of the IsEditable property.</param>
/// <param name="dateRequired">Initial value of the DateRequired property.</param>
public static PurchaseRequest CreatePurchaseRequest(global::System.Guid id, global::System.Int32 pRNo, global::System.Guid requestedBy, global::System.Boolean isPoReady, global::System.Boolean isQuoted, global::System.Boolean isFinished, global::System.Boolean isCanvased, global::System.Boolean isEditable, global::System.DateTime dateRequired)
{
PurchaseRequest purchaseRequest = new PurchaseRequest();
purchaseRequest.Id = id;
purchaseRequest.PRNo = pRNo;
purchaseRequest.RequestedBy = requestedBy;
purchaseRequest.IsPoReady = isPoReady;
purchaseRequest.IsQuoted = isQuoted;
purchaseRequest.IsFinished = isFinished;
purchaseRequest.IsCanvased = isCanvased;
purchaseRequest.IsEditable = isEditable;
purchaseRequest.DateRequired = dateRequired;
return purchaseRequest;
}
/// <summary>
/// Deprecated Method for adding a new object to the PurchaseRequests EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToPurchaseRequests(PurchaseRequest purchaseRequest)
{
base.AddObject("PurchaseRequests", purchaseRequest);
}
private void SaveRfqToDb()
{
//------------------Database Operation-------------------------
foreach (var vendor in selectedVendors) {
selectedVendor = vendor;
// Create RFQ
Guid rfqId = Guid.NewGuid();
var rfq = db.RFQs.CreateObject();
rfq.Id = rfqId;
rfq.IssuedBy = CurrentUser.Id;
rfq.DateRequired = DateRequired;
rfq.date_created = DateTime.Now;
rfq.VendorId = vendor.Id;
bool IsPrDataTaken = false;
Guid RequestId = Guid.Empty;
//Add Items
foreach (var item in items) {
//Add to quotation item list
var mRfqItems = db.mRfqs_mItemsRequests.CreateObject();
mRfqItems.RfqId = rfqId;
mRfqItems.mItemsRequestId = item.ext_id;
//Mark itemrequest as quoted
IQueryable<mItemsRequest> allItemRequest = db.mItemsRequests;
var itemRequest = allItemRequest.Where(x => x.Id == item.ext_id).SingleOrDefault();
itemRequest.IsQuoteSent = true;
//Get Purchase Request Data for printing
if (!IsPrDataTaken) {
CurrentRequest = itemRequest.PurchaseRequest;
CurrentRequest.Status = "Pending Quotation";
RequestId = CurrentRequest.Id;
IsPrDataTaken = true;
}
//Add object
mRfqItems.RequestId = RequestId;
db.mRfqs_mItemsRequests.AddObject(mRfqItems);
}
// Add object
rfq.RequestId = RequestId;
db.RFQs.AddObject(rfq);
//Save To Database
db.SaveChanges();
RfqNo = db.RFQs.Where(x => x.Id == rfqId).SingleOrDefault().RfqNumber;
DeployAndRenderRfq();
}
}