//Insert Data---------------------------------------------------------------------------------------------------------------
public void InsertNewQuote(Classes.DatabaseTables.ActiveQuotes newActiveQuote, Classes.DatabaseTables.QuoteStatus newQuoteStatus)
{
using (System.Data.IDbConnection connection = new System.Data.SqlClient.SqlConnection(Classes.Helper.CnnVal("TracerDB")))
{
//Add new ActiveQuotes and QuoteStatus
List <DatabaseTables.ActiveQuotes> activeQuote = new List <DatabaseTables.ActiveQuotes>();
List <DatabaseTables.QuoteStatus> quoteStatus = new List <DatabaseTables.QuoteStatus>();
activeQuote.Add(newActiveQuote);
quoteStatus.Add(newQuoteStatus);
connection.Execute($"insert into ActiveQuotes(QuoteWOR, Date, Time, PartID, Customer, PartDescription, QuoteConfidence, Consigned, Turnkey, QuoteComments, QuoteDueDate, QuoteInactive, POReceived) values(@QuoteWOR, @Date, @Time, @PartID, @Customer, @PartDescription, @QuoteConfidence, @Consigned, @Turnkey, @QuoteComments, @QuoteDueDate, @QuoteInactive, @POReceived)", activeQuote);
connection.Execute($"insert into QuoteStatus(QuoteWOR, BOMValidationRequest, BOMValidationInProgress, BOMValidationComplete, PartsReviewRequest, PartsReviewInProgress, PartsReviewComplete, PreBidRequest, PreBidInProgress, PreBidComplete, FinalReviewRequest, FinalReviewInProgress, FinalReviewComplete, QuoteSent, QuoteCurrentStatus) values(@QuoteWOR, @BOMValidationRequest, @BOMValidationInProgress, @BOMValidationComplete, @PartsReviewRequest, @PartsReviewInProgress, @PartsReviewComplete, @PreBidRequest, @PreBidInProgress, @PreBidComplete, @FinalReviewRequest, @FinalReviewInProgress, @FinalReviewComplete, @QuoteSent, @QuoteCurrentStatus)", quoteStatus);
}
}
//Physical Button Events--------------------------------------------------------------
private void btnAdd_Click(object sender, EventArgs e)
{
Classes.DataAccess.SalesDataAccess db = new Classes.DataAccess.SalesDataAccess();
//Holder to validate the Data
//Create new class to hold the new Active Quote
Classes.DatabaseTables.ActiveQuotes newActiveQuote = new Classes.DatabaseTables.ActiveQuotes();
Classes.DatabaseTables.QuoteStatus newQuoteStatus = new Classes.DatabaseTables.QuoteStatus();
//Fill New Active Quote
newActiveQuote.QuoteWOR = Int32.Parse(txtWOR.Text);
DateTime rightNow = new DateTime();
rightNow = DateTime.Now;
newActiveQuote.Date = rightNow.ToString("MM-dd-yyyy");
newActiveQuote.Time = rightNow.ToString("hh:mm:ss tt");
newActiveQuote.PartID = txtPartID.Text;
newActiveQuote.Customer = txtCustomer.Text;
newActiveQuote.PartDescription = txtDescription.Text;
if (radioLowConf.Checked)
{
newActiveQuote.QuoteConfidence = "Low";
}
if (radioMedConf.Checked)
{
newActiveQuote.QuoteConfidence = "Medium";
}
if (radioHighConf.Checked)
{
newActiveQuote.QuoteConfidence = "High";
}
newActiveQuote.QuoteComments = txtComment.Text;
newActiveQuote.QuoteDueDate = dtDueDate.Text;
if (ckConsigned.Checked == true)
{
newActiveQuote.Consigned = 1;
}
else
{
newActiveQuote.Consigned = 0;
}
if (ckTurnkey.Checked == true)
{
newActiveQuote.Turnkey = 1;
}
else
{
newActiveQuote.Turnkey = 0;
}
//Set Initial Status
newActiveQuote.QuoteInactive = 0;
newActiveQuote.POReceived = 0;
//QuoteStatus Initialization
newQuoteStatus.QuoteWOR = Int32.Parse(txtWOR.Text);
newQuoteStatus.BOMValidationRequest = 0;
newQuoteStatus.BOMValidationInProgress = 0;
newQuoteStatus.BOMValidationComplete = 0;
newQuoteStatus.PartsReviewRequest = 0;
newQuoteStatus.PartsReviewInProgress = 0;
newQuoteStatus.PartsReviewComplete = 0;
newQuoteStatus.PreBidRequest = 0;
newQuoteStatus.PreBidInProgress = 0;
newQuoteStatus.PreBidComplete = 0;
newQuoteStatus.FinalReviewRequest = 0;
newQuoteStatus.FinalReviewInProgress = 0;
newQuoteStatus.FinalReviewComplete = 0;
newQuoteStatus.QuoteSent = 0;
newQuoteStatus.QuoteCurrentStatus = "";
db.InsertNewQuote(newActiveQuote, newQuoteStatus);
btnClear_Click(null, null);
}
