/// <summary> /// generate foundry order number /// </summary> /// <returns></returns> public string FoundryOrderNumber() { Enums.DocumentNumberType type = Enums.DocumentNumberType.PO; var foundryOrderNumber = string.Empty; try { var newFoundryOrderNumber = new PurchaseOrderNumber() { Type = type.ToString(), Number = null }; var insertedPurchaseOrderNumber = _db.PurchaseOrderNumber.Add(newFoundryOrderNumber); _db.SaveChanges(); foundryOrderNumber = insertedPurchaseOrderNumber.Type + String.Format("{0:D6}", insertedPurchaseOrderNumber.Value); var recentPurchaseOrderNumber = _db.PurchaseOrderNumber.FirstOrDefault(x => x.Value == insertedPurchaseOrderNumber.Value && x.Type == insertedPurchaseOrderNumber.Type); recentPurchaseOrderNumber.Number = foundryOrderNumber; _db.SaveChanges(); } catch (Exception e) { logger.Error("An error occurred while retrieving FoundryOrderNumber. Error: " + e); } return(foundryOrderNumber); }
/// <summary> /// generate quote number /// </summary> /// <returns></returns> public string QuoteNumber() { Enums.DocumentNumberType type = Enums.DocumentNumberType.Q; var quoteNumber = string.Empty; try { var newQuoteNumber = new QuoteNumber() { Type = type.ToString(), Number = null }; var insertedQuoteNumber = _db.QuoteNumber.Add(newQuoteNumber); _db.SaveChanges(); quoteNumber = insertedQuoteNumber.Type + String.Format("{0:D6}", insertedQuoteNumber.Value); var recentQuoteNumber = _db.QuoteNumber.FirstOrDefault(x => x.Value == insertedQuoteNumber.Value && x.Type == insertedQuoteNumber.Type); recentQuoteNumber.Number = quoteNumber; _db.SaveChanges(); } catch (Exception ex) { logger.ErrorFormat("Error occurred generating quote number: {0} ", ex.ToString()); } return(quoteNumber); }
/// <summary> /// generate rfq number /// </summary> /// <returns></returns> public string RfqNumber() { Enums.DocumentNumberType type = Enums.DocumentNumberType.RFQ; var rfqNumber = string.Empty; try { var newRfqNumber = new RfqNumber() { Type = type.ToString(), Number = null }; var insertedRfqNumber = _db.RfqNumber.Add(newRfqNumber); _db.SaveChanges(); rfqNumber = insertedRfqNumber.Type + String.Format("{0:D6}", insertedRfqNumber.Value); var recentRfqNumber = _db.RfqNumber.FirstOrDefault(x => x.Value == insertedRfqNumber.Value && x.Type == insertedRfqNumber.Type); recentRfqNumber.Number = rfqNumber; _db.SaveChanges(); } catch (Exception ex) { logger.ErrorFormat("Error generating rfq number: {0} ", ex.ToString()); } return(rfqNumber); }
/// <summary> /// generate price sheet number /// </summary> /// <returns></returns> public string PriceSheetNumber() { Enums.DocumentNumberType type = Enums.DocumentNumberType.PS; var priceSheetNumber = string.Empty; try { var newPriceSheetNumber = new PriceSheetNumber() { Type = type.ToString(), Number = null }; var insertedPriceSheetNumber = _db.PriceSheetNumber.Add(newPriceSheetNumber); _db.SaveChanges(); priceSheetNumber = insertedPriceSheetNumber.Type + String.Format("{0:D6}", insertedPriceSheetNumber.Value); var recentPriceSheetNumber = _db.PriceSheetNumber.FirstOrDefault(x => x.Value == insertedPriceSheetNumber.Value && x.Type == insertedPriceSheetNumber.Type); recentPriceSheetNumber.Number = priceSheetNumber; _db.SaveChanges(); } catch (Exception ex) { logger.ErrorFormat("Error occurred generating price sheet number: { 0} ", ex.ToString()); } return(priceSheetNumber); }
/// <summary> /// generate new debit memo number /// </summary> /// <returns></returns> public string DebitMemoNumber() { Enums.DocumentNumberType type = Enums.DocumentNumberType.DM1; var debitMemoNumber = string.Empty; try { var newDebitMemoNumber = new DebitMemoNumber() { Type = type.ToString(), Number = null }; var insertedDebitMemoNumber = _db.DebitMemoNumber.Add(newDebitMemoNumber); _db.SaveChanges(); debitMemoNumber = insertedDebitMemoNumber.Type + String.Format("{0:D6}", insertedDebitMemoNumber.Value); var recentDebitMemoNumber = _db.DebitMemoNumber.FirstOrDefault(x => x.Value == insertedDebitMemoNumber.Value && x.Type == insertedDebitMemoNumber.Type); recentDebitMemoNumber.Number = debitMemoNumber; _db.SaveChanges(); } catch (Exception ex) { logger.ErrorFormat("Error occurred generating new debit memo number: {0} ", ex.ToString()); } return(debitMemoNumber); }