public Delivery GetDelivery(int docNbr)
{
Delivery myOrder = new Delivery();
string _cmd = "Select * from " + PODConstants.DELIVERY_TABLE_NAME + " WHERE DocNum = " + docNbr.ToString() + " and DocType = 13"; ;
DataTable _table = Utilities.DataBaseUtility.GetTable(_cmd);
int nrows = _table.Rows.Count;
if (nrows != 1) return myOrder;
myOrder.DocNumber = Convert.ToInt32(_table.Rows[0][0]);
myOrder.SupplierID = Convert.ToInt32(_table.Rows[0]["ExtRef"]);
myOrder.PO_Date = Convert.ToDateTime(_table.Rows[0]["TextValue2"]);
myOrder.DeliveryDate = Convert.ToDateTime(_table.Rows[0]["TextValue1"]);
// myOrder.PurchaseQuotedPrice = Convert.ToDouble(_table.Rows[0]["QuotedPrice"]);
myOrder.Status = Convert.ToInt32(_table.Rows[0]["status"]);
return myOrder;
}
private void button_SubmitOrder_Click(object sender, EventArgs e)
{
Delivery del = new Delivery();
int order_no = 0;
int.TryParse(textBox_DocNumber.Text, out order_no);
if (order_no == 0) { MessageBox.Show("Invalid Order Number"); return; }
del.DocNumber = order_no;
del.SupplierID = comboBox_Supplier.SelectedIndex = 1;
del.Status = comboBox_Status.SelectedIndex;
del.PO_Date = dateTimePicker1.Value;
del.DeliveryDate = dateTimePicker2.Value;
// textBox_Employee.Text
// _action = new Utilities.Action();
//_action.DocNumber = order_no;
//_action.ActionType = 2;
//_action.EmployeeID = Int32.Parse(textBox_Employee.Text);
//_action.DepartmentID = 1; // not textBox_Role.Text;
//_action.ActionDate = DateTime.Now;
//_action.Status = 2;
//_action.Command = "";
//_action.Comment = textBox_Comment.Text;
Purchases.PurchaseOrder po = new Purchases.PurchaseOrder();
po.PO_ID = order_no;
po.SupplierID = comboBox_Supplier.SelectedIndex + 0;
po.PO_Status = comboBox_Status.SelectedIndex;
po.EmployeeID = Int32.Parse(textBox_Employee.Text);
po.PO_Date = dateTimePicker1.Value;
po.DeliveryDate = dateTimePicker2.Value;
po.Comment = textBox_Comment.Text;
if (po.Comment.Length < 1)
po.Comment = "create PO " + po.PO_ID.ToString();
if (Convert.ToDateTime(dateTimePicker1.Text) > Convert.ToDateTime(dateTimePicker2.Text))
{
MessageBox.Show("Start Date should not be greater than End Date"); return;
}
string[] cmds = textBox_Details.Text.Split(';');
int last = cmds.Length - 1;
for (int i = 0; i < last; i++)
{
//action.Command = ;
DataBaseUtility.Execute(cmds[i].Trim(), _ident);
}
//// if (po.Comment.Length < 1)
// po.Comment = "create PO " + po.PO_ID.ToString();
// if (Convert.ToDateTime(dateTimePicker1.Text) > Convert.ToDateTime(dateTimePicker2.Text))
// {
// MessageBox.Show("Start Date should not be greater than End Date"); return;
// }
cmds = textBox_Details.Text.Split(';');
last = cmds.Length - 1;
for (int i = 0; i < last; i++)
{
// _action.Command = cmds[i];
// DataBaseUtility.Execute(_action, _ident);
}
}
//private void FillProductDetails(int _id)
//{
// listBox_Products.Items.Clear();
// // listBox_Quant.Items.Clear();
// // listBox_Cost.Items.Clear();
// foreach (DataRow drProdut in dt_PurchaseOrder.Rows)
// {
// listBox_Products.Items.Add(Convert.ToString(drProdut["Name"]));
// // listBox_Quant.Items.Add(Convert.ToString(drProdut["Qty"]).PadLeft(5, ' '));
// // listBox_Cost.Items.Add(Convert.ToString(drProdut["Cost"]).PadLeft(5, ' '));
// }
//}
private void button_Preview_Click(object sender, EventArgs e)
{
if (radioButton_SQL.Checked) radioButton_SQL_CheckedChanged(this, null);
del = new Delivery(textBox_Details.Text );
//int order_no = 0;
//int.TryParse(textBox_DocNumber.Text, out order_no);
//if (order_no == 0) { MessageBox.Show("Invalid Order Number"); return; }
textBox_DocNumber.Text = del.DocNumber.ToString(); // = order_no;
textBox_Supplier.Text = del.SupplierID.ToString(); // = Int32.Parse(textBox_Supplier.Text);
// comboBox_Supplier.SelectedIndex = del.SupplierID;
comboBox_Status.SelectedIndex = del.Status;
textBox_Comment.Text = del.Comment;
textBox_Employee.Text = del.EmployeeID.ToString(); // _ident.UserID.ToString();
textBox_AuthLevel.Text = _ident.ActionLevel.ToString();
textBox_Role.Text = _ident.Role;
dateTimePicker1.Value = DateTime.Now; // Parse(_po.PO_Date).ToShortDateString();
// dateTimePicker1.Text = DateTime.Parse(_po.PO_Date).ToShortDateString();
if (_del.SupplierID > 0)
{
_supplierID = _del.SupplierID;
textBox_Supplier.Text = _supplierID.ToString();
FillSupplier(_supplierID.ToString());
}
for (int i = 0; i < del.DeliveryDetails.Count; i++)
{
dataGridResults.Rows.Add();
Del_DetailItem det = del.DeliveryDetails[i];
dataGridResults.Rows[i].Cells[0].Value = det.Del_ID;
dataGridResults.Rows[i].Cells[1].Value = det.ProductID ;
dataGridResults.Rows[i].Cells[2].Value = det.Quantity ;
dataGridResults.Rows[i].Cells[3].Value = det.Price ;
}
//dateTimePicker1.Value = (DateTime) del.PO_Date.ToOADate();
//del.DeliveryDate = dateTimePicker2.Value ;
//del.PO_Date = dateTimePicker1.Value;
//del.DeliveryDate = dateTimePicker2.Value ;
//del.Comment = textBox_Comment.Text;
//if (Convert.ToDateTime(dateTimePicker1.Text) > Convert.ToDateTime(dateTimePicker2.Text))
//{
// MessageBox.Show("Start Date should not be greater than End Date"); return;
//}
// string part1 = "INSERT into Deliveries values (";
}
private void button_FromPO_Click(object sender, EventArgs e)
{
//List<string> poStr = Utilities.DataBaseUtility.GetList("Select * from purchaseOrders where docnum = " + textBox_DocNumber.Text );
//string[] fields = poStr[1].Split('\t');
// _po = new PurchaseOrder(fields);
// _del = new Delivery(fields);
_ident = new IdentityObject();
_poID_Str = textBox_DocNumber.Text.Trim();
_poRecord = Utilities.DataBaseUtility.GetList("select * from PURCHASE_ORDERS where docnum = " + _poID_Str,',');
if (_poRecord.Count != 2)
{
MessageBox.Show("could not find purchase order : " + _poID_Str);
return;
}
textBox_Details.Text = _poRecord[1] + "\r\n";
// _po = new PurchaseOrder(_poRecord[1]);
_del = new Delivery(_poRecord[1]);
textBox_Supplier.Text = _del.SupplierID.ToString();
if (_ident == null) _ident = new IdentityObject("111", "Johnson", "clerk", 1, 2);
textBox_Employee.Text = _ident.UserID.ToString(); // _del.EmployeeID.ToString();
dateTimePicker1.Value = DateTime.Now; //.ToShortDateString();
// dateTimePicker1.Text = DateTime.Now.ToShortDateString();
// Parse(_po.PO_Date).ToShortDateString ();
if (_del.SupplierID > 0)
{
_supplierID = _del.SupplierID;
textBox_Supplier.Text = _supplierID.ToString();
FillSupplier(_supplierID.ToString());
FillProducts(_supplierID);
}
textBox_Comment.Text = "P. O. " + _poID_Str + " delivery";
// NewDelivery(_ident);
// string _titles = String.Format("{0}\t{1}\t{2}\t{3}", "Del.ID", "prod.ID", "Quant.", "Cost");
// textBox_Details.Text = _titles;
List<string> detailRecords = Utilities.DataBaseUtility.GetList("select * from PurchaseOrderDetails where docnum = " + _poID_Str, ',');
for (int i = 1; i < detailRecords.Count; i++)
{
textBox_Details.Text += detailRecords[i] + "\r\n";
}
}
private void button_Display_Click(object sender, EventArgs e)
{
try
{
Delivery _order = new Delivery();
string _cmd = "Select * from " + PODConstants.DELIVERY_TABLE_NAME + " WHERE DocNum = " + textBox_DocNumber.Text + " and DocType = 13";
DataTable _table = Utilities.DataBaseUtility.GetTable(_cmd);
dataGridView1.DataSource = _table;
string _supplierID = "3";
if (_table != null && _table.Rows != null && _table.Rows.Count > 0)
_supplierID = _table.Rows[0][2].ToString();
string supplierCmd = "Select * from suppliers WHERE supplierID = " + _supplierID;
DataTable supplierTable = Utilities.DataBaseUtility.GetTable(supplierCmd);
dataGridView2.DataSource = supplierTable;
string detailsCmd = "Select * from " + PODConstants.DELIVERY_DETAILS_TABLE_NAME + " WHERE DocNum = " + Convert.ToInt32(textBox_DocNumber.Text) + " and DocType = 13";
detailsTable = Utilities.DataBaseUtility.GetTable(detailsCmd);
gboOrderStatus.Visible = true;
_order = _order.GetDelivery(Convert.ToInt32(textBox_DocNumber.Text));
string _supplierName = Convert.ToString(supplierTable.Rows[0]["Name"]);
string _supplierAddress = Convert.ToString(supplierTable.Rows[0]["Address"]);
string _supplierAddress2 = Convert.ToString(supplierTable.Rows[0]["City"]) + ", " + Convert.ToString(supplierTable.Rows[0]["State"]) + " " + Convert.ToString(supplierTable.Rows[0]["PostalCode"]);
string _supplierPhone = Convert.ToString(supplierTable.Rows[0]["Phone"]);
string _supplierEmail = Convert.ToString(supplierTable.Rows[0]["WebAddress"]);
lblInvNumValue.Text = textBox_DocNumber.Text; //_ Convert.ToString(_order.DeliveryID);
//label_PO_Info.Text = _supplierName + "\r\n";
label_SupplierName.Text = _supplierName;
label_SupplierAddr.Text = _supplierAddress;
label_SupplierAddress2.Text = _supplierAddress2;
lblPhone.Text = Convert.ToString(_supplierPhone);
label_ShipName.Text = "Local Bikes";
label_ShippingAddr2.Text = "2700 Bay Area Blvd";
label_ShipAddress.Text = "Houston, TX, 77058";
lblDateValue.Text = _order.PO_Date.ToShortDateString();
label_SupplierEmail.Text = _supplierEmail;
comboBox2.SelectedIndex = _order.Status;
label_Status.Text = "Status: " + comboBox2.SelectedItem.ToString();
label_deliverydate.Text = _order.DeliveryDate.ToShortDateString();
gboOrderStatus.Visible = true;
int recnbr1 = 0;
double partsTotal = 0.0; // double partsTax = 0.0;
lvProducts.Items.Clear();
while (recnbr1 < detailsTable.Rows.Count)
{
string productCode = detailsTable.Rows[recnbr1][2].ToString();
_product_Names = Utilities.DataBaseUtility.GetList("Select productName from products where productID = " + productCode);
ListViewItem lvi = lvProducts.Items.Add(productCode); //detailsTable.Rows[recnbr1][1].ToString());
if (_product_Names.Count > 1 && _product_Names[1] != null)
{
lvi.SubItems.Add(_product_Names[1]);
}
//else
//{
// MessageBox.Show("Please check the products and inventory data, the inventory product " + productCode + " not available in products table");
//}
//lvi.SubItems.Add(detailsTable.Rows[recnbr1][2].ToString());
double _price = Double.Parse(detailsTable.Rows[recnbr1][6].ToString());
double _quant = Double.Parse(detailsTable.Rows[recnbr1][5].ToString());
lvi.SubItems.Add(_quant.ToString());
lvi.SubItems.Add(string.Format("{0:C}", _price));
lvi.SubItems.Add(string.Format("{0:C}", 0.00));
double _total = _quant * _price;
lvi.SubItems.Add(string.Format("{0:C}", _total));
partsTotal += _total; // order.POProdDetails[recnbr1].DetailProductLineTotal;
recnbr1++;
}
lblPartsSubTotalValue.Text = string.Format("{0:C}", partsTotal);
// int recnbr2 = 0;
// double serviceTotal = 0.0;
lblShippingCostValue.Text = string.Format("{0:C}", partsTotal * .04);
double _totalCost = partsTotal + partsTotal * .04;
lblGrandTotalValue.Text = string.Format("{0:C}", _totalCost);
// pnlService.Visible = true;
}
catch (Exception ex) { MessageBox.Show("Due to invalid or old data in Database, Application could not load the Delivery doc."); }
}
private void LoadDelivery()
{
// int poNum;
Delivery _order = new Delivery();
List<string> _ids = Utilities.DataBaseUtility.GetList("Select DocNum from " + PODConstants.DELIVERY_TABLE_NAME + " Where DocType = 13"); //order by PurchasOrderID");
comboBox1.Items.Clear();
for (int i =1; i< _ids.Count; i++)
comboBox1.Items.Add(_ids[i]);
}