/// <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);
}
