//-----------------------------
// CREATE RFQ BUTTON METHODS |
//-----------------------------
private void btnCreateRFQ_Click(object sender, EventArgs e)
{
RFQ_CreateForm crfq = new RFQ_CreateForm();
//Generating the RFQ No.
//Search SQL for existing RFQs with "YYMM-%" (e.g. 1604-%). nthRFQ is +1 to the number of rows returned.
string year = DateTime.Now.ToString("yy"); //Last two digits of year (e.g. 2016 becomes 16)
string month = DateTime.Now.ToString("MM");
int rfqCount = sql.GetRowCount("rfq_t", year, month);
string generatedRFQNo = year + month + "-" + (rfqCount + 1).ToString("D3"); //D3 for padded zeroes and ensure there are 3 digits.
crfq.RFQNo = generatedRFQNo;
crfq.ShowDialog(); //Validation happens at RFQ_CreateForm.cs
if (crfq.Cancel == false) //Meaning, will create the RFQ. If Cancel is true, nothing happens.
{
//---ADD the new Request for Price Quotation to the ArrayList
rfqList.Add(new RFQ(crfq.RFQNo,
crfq.RequestDate,
crfq.PaymentTerms,
crfq.DeliveryTerms,
crfq.CustomerIDFK,
crfq.SupplierIDFK,
null)); //Null, since there's no PQ No. (Its value will only be set when its PQ has been created)
//Save to rfq_t database
RFQ newRFQ = (RFQ)rfqList[(rfqList.Count - 1)]; //Casting
sql.InsertRFQ(newRFQ);
for (int i = 0; i < crfq.RFQOrderLineList.Count; i++) //Go through newly created RFQs' OrderLines
{
//Add to ArrayList
RFQ_OrderLine rol = (RFQ_OrderLine)crfq.RFQOrderLineList[i]; //Casting
/*rfqOrderLineList.Add(new RFQ_OrderLine(rol.RFQNo,
* rol.PartNumber,
* rol.Quantity)); --> No need; won't use*/
//Save to rfq_order_line_t database
sql.InsertRFQOrderLine(rol);
//MessageBox.Show("OrderLine added to comprehensive list: " + rol.RFQNo + ", " + rol.PartNumber + ", " + rol.Quantity);
}
//---DISPLAY the newly created RFQ in the Main Screen DGV
dgvRFQ.Rows.Add(crfq.RFQNo, crfq.RequestDate, crfq.SupplierName, crfq.CustomerName);
dgvRFQ.Sort(dgvRFQ.Columns["RFQNo"], ListSortDirection.Descending); //So that newly added row is on top
//---OPEN THE RFQ Printout Print Preview
RFQ_PrintScreen rfqps = new RFQ_PrintScreen();
rfqps.RFQNo = crfq.RFQNo; //For the Print Screen to use in its SQL statement
rfqps.FirstTime = true;
rfqps.ShowDialog();
//---MESSAGEBOX FOR DEBUG PURPOSES
/*MessageBox.Show("RFQ CREATED: " + crfq.RFQNo + ", " + crfq.RequestDate + ", " + crfq.PaymentTerms + ", " +
* crfq.DeliveryTerms + ", " + "Customer " + crfq.CustomerIDFK + ", " + "Supplier " + crfq.SupplierIDFK + ", "
+ "With " + crfq.RFQOrderLineList.Count + " Orderlines. Inserted to ArrayList index [" + (rfqList.Count - 1) + "]");
*/
}
}
//------------------------
// OTHER FORM ELEMENTS |
//------------------------
private void dtpDateOfRequest_ValueChanged(object sender, EventArgs e)
{ //If the User wants to input an RFQ with date of year/month != current year/month
string year = dtpDateOfRequest.Value.ToString("yy");
string month = dtpDateOfRequest.Value.ToString("MM");
int rfqCount = sql.GetRowCount("rfq_t", year, month);
string generatedRFQNo = year + month + "-" + (rfqCount + 1).ToString("D3");
RFQNo = generatedRFQNo;
}
private void btnCreatePQ_Click(object sender, EventArgs e)
{
if (dgvRFQSelected.Rows.Count == 0)
{
MessageBox.Show("Please include Request for Price Quotation.", "Incomplete Fields", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
this.Close();
PQ_CreateForm pf = new PQ_CreateForm();
for (int i = 0; i < dgvRFQSelected.RowCount; i++)
{
string rfqNo;
DataGridViewRow row = dgvRFQSelected.Rows[i];
rfqNo = (row.Cells["SelectedRFQNo"].Value).ToString(); //get the RFQNo of the rfq selected
RFQ r = sql.SelectRFQDetails(rfqNo); //from the RFQNo taken, get its details
selectedRFQList.Add(new RFQ(r.RFQNo, r.RequestDate, r.PaymentTerms, r.DeliveryTerms, r.CustomerID, r.SupplierID, r.PQNo)); //put in an ArrayList the details taken
pf.RFQNo = rfqNo;
string year = DateTime.Now.ToString("yy");
string month = DateTime.Now.ToString("MM");
int pqCount = sql.GetRowCount("pq_t", year, month);
string generatedPQNo = year + month + "-" + (pqCount + 1).ToString("D3");
pf.PQNo = generatedPQNo;
pf.PaymentTerms = r.PaymentTerms;
pf.DeliveryTerms = r.DeliveryTerms;
Customer c = sql.SelectCustomerDetails(r.CustomerID); //to retrieve the details of Customer from MySqlDatabaseDriver
pf.CustomerName = c.CustomerName;
pf.CustomerPerson = c.CustomerPerson;
pf.CustomerNumber = c.CustomerNumber;
pf.CustomerEmail = c.CustomerEmail;
pf.CustomerAddress = c.CustomerAddress;
pf.ShowDialog();
}
if (pf.Cancel == false)
{//if save button were clicked, this will save the pq details in arrayList then in the database
string FromDateNoTime = pf.FromDate.ToShortDateString();
string ToDateNoTime = pf.ToDate.ToShortDateString();
string PQDateNoTime = pf.PQDate.ToShortDateString();
pqList.Add(new PQ(pf.PQNo,
PQDateNoTime,
FromDateNoTime,
ToDateNoTime,
pf.PaymentTerms,
pf.DeliveryTerms,
pf.BillTo,
pf.ShipTo,
pf.InFavorOf,
double.Parse(pf.TotalAmount),
pf.CustomerIDFK));
PQ newPQ = (PQ)pqList[(pqList.Count - 1)];
sql.InsertPQ(newPQ);
for (int j = 0; j < pf.PQOrderLineList.Count; j++)
{
PQ_OrderLine pol = (PQ_OrderLine)pf.PQOrderLineList[j];
sql.InsertPQOrderLine(pol);
//MessageBox.Show("OrderLine added to comprehensive list: " + pol.PQNo + ", " + pol.PartNumber + ", " + pol.ReicUnitPrice + "," + pol.Quantity + "," + pol.ItemTotal);
}
//---OPEN THE PQ Printout Print Preview
/*if (pf.InFavorOf == "Supplier")
* {
* PQ_PrintScreen_IFOSupplier pq = new PQ_PrintScreen_IFOSupplier();
* pq.PQNo = pf.PQNo;
* pq.FirstTime = false;
* pq.ShowDialog();
* }
* else
* {
* PQ_PrintScreen pq = new PQ_PrintScreen();
* pq.PQNo = pf.PQNo;
* pq.FirstTime = false;
* pq.ShowDialog();
* }*/
}
}