public Form1(int emp_ID)
{
InitializeComponent();
table_Employees = DatabaseHelper.GetTable("Employees");
table_Persons = DatabaseHelper.GetTable("Person");
person_Id = int.Parse(table_Employees.Rows[emp_ID - 1]["Person ID"].ToString());
LoggedInEmployee.ID = person_Id;
string name = LoggedInEmployee.EmployeeInformation()["First Name"].ToString() + " " + LoggedInEmployee.EmployeeInformation()["Last Name"].ToString();///table_Persons.Rows[person_Id - 1]["First Name"].ToString();
lbl_Subtext.Text = "Welcome " + name;
}
private void PlaceOrder()
{
List <string> listStr = new List <string>();
foreach (ProductItem item in flw_Products.Controls)
{
listStr.Add(item.comboBox2.SelectedItem.ToString());
}
var duplicateKeys = listStr.GroupBy(x => x)
.Where(group => group.Count() > 1)
.Select(group => group.Key);
if (duplicateKeys.Count() > 0)
{
MessageBox.Show("There are duplicate products! Please fix this before continuing.");
return;
}
//Create entry in Orders table
int empID = LoggedInEmployee.ID;
DateTime orderDate = DateTime.Now;
DataRow dataRow = LoggedInEmployee.EmployeeInformation();
this.lbl_servicedEmployee.Text = dataRow["First Name"].ToString() + " " + dataRow["Last Name"].ToString() + " (You)";
int dealerID = dealerDict[cmb_Dealer.SelectedItem.ToString()];
string orderQuery = "";
if (btn_Place_Order.Text.Contains("Update"))
{
orderQuery = string.Format("UPDATE Orders SET [Dealer ID]={0}, [Order Date]=#{1}#, [Required Date]=#{2}#, [Required Time]={3}, [Last Updated By]={4} WHERE [Order ID] = {5}",
dealerID, orderDate, dtp_Order_Date.Value.Date, cmb_Time.SelectedIndex, empID, this.orderID);
}
else
{
orderQuery =
string.Format("INSERT INTO Orders([Dealer ID],[Order Date], [Serviced Employee ID], [Required Date],[Required Time]) VALUES ({0},#{1}#,{2},#{3}#,{4})",
dealerID, orderDate, empID, dtp_Order_Date.Value.Date, cmb_Time.SelectedIndex);
}
var rdr = DatabaseHelper.ExecuteQuery(orderQuery);
DataTable orderTable = DatabaseHelper.GetTable("Orders", null, null, true);
DataTable productTable = DatabaseHelper.GetTable("Products", null, null, true);
int orderID = -1;
if (btn_Place_Order.Text.Contains("Update"))
{
orderID = this.orderID;
}
else
{
orderID = int.Parse(orderTable.Rows[orderTable.Rows.Count - 1]["Order ID"].ToString());
}
List <string> productNames = new List <string>();
foreach (ProductItem item in flw_Products.Controls)
{
string query = "";
if (btn_Place_Order.Text.Contains("Update"))
{
DataTable tableCurrentProducts = DatabaseHelper.GetTable(null, null, "SELECT [Product Name] FROM [Order Details] WHERE [Order ID]=" + orderID);
List <string> productItemsKappaPride = new List <string>();
foreach (DataRow rowowoow in tableCurrentProducts.Rows)
{
productItemsKappaPride.Add(rowowoow["Product Name"].ToString());
}
if (!productItemsKappaPride.Contains(item.comboBox2.SelectedItem))
{
query = string.Format(
"INSERT INTO [Order Details]([Order ID], [Product Name], Quantity) VALUES " +
"({0},'{1}', {2})", orderID, item.comboBox2.SelectedItem,
item.numericUpDown1.Value);
}
else
{
query = string.Format("UPDATE [Order Details] SET [Quantity]={0} WHERE [Order ID]={1} AND [Product Name]='{2}'",
item.numericUpDown1.Value, orderID, item.comboBox2.SelectedItem);
}
}
else
{
query =
string.Format(
"INSERT INTO [Order Details]([Order ID], [Product Name], Quantity) VALUES " +
"({0},'{1}', {2})", orderID, item.comboBox2.SelectedItem,
item.numericUpDown1.Value);
}
OleDbDataReader reader = DatabaseHelper.ExecuteQuery(query);
productNames.Add(item.comboBox2.SelectedItem.ToString());
}
string querya = "SELECT * FROM [Order Details] WHERE [Order ID]=" + orderID;
DataTable dtb = DatabaseHelper.GetTable(null, null, querya);
foreach (DataRow productRow in dtb.Rows)
{
string productName = productRow["Product Name"].ToString();
if (!productNames.Contains(productName))
{
DatabaseHelper.ExecuteQuery("DELETE FROM [Order Details] WHERE [OrderDetails ID] =" + productRow["OrderDetails ID"].ToString());
}
}
MessageBox.Show("Order Processed Succesfully");
}
private void frm_AddOrder_Load(object sender, EventArgs e)
{
cmb_Time.SelectedIndex = 0;
table = DatabaseHelper.GetTable(null, null, "SELECT [Dealer ID], [First Name], [Last Name], Company FROM Dealer INNER JOIN Person ON Dealer.[Person ID] = Person.[Person ID]");
List <string> list = new List <string>();
for (int index = 0; index < table.Rows.Count; ++index)
{
string str1 = table.Rows[index]["First Name"].ToString();
string str2 = table.Rows[index]["Last Name"].ToString();
string str3 = table.Rows[index]["Company"].ToString();
list.Add(str1 + " " + str2 + " (" + str3 + ")");
dealerDict.Add(list[index], int.Parse(table.Rows[index]["Dealer ID"].ToString()));
}
this.cmb_Dealer.DataSource = list;
DataRow dataRow = LoggedInEmployee.EmployeeInformation();
this.lbl_servicedEmployee.Text = dataRow["First Name"].ToString() + " " + dataRow["Last Name"].ToString() + " (You)";
if (orderID >= 0)
{
Text = "Updating Order #" + orderID;
btn_Place_Order.Text = "Update Order";
if (updateRow == null)
{
MessageBox.Show("Lol u need a queery row tho");
return;
}
string dealerValue = dealerDict.FirstOrDefault(x =>
{
string name = updateRow.Cells["Dealer Name"].Value.ToString();
string company = updateRow.Cells["Company"].Value.ToString();
return(x.Key.Contains(name) && x.Key.Contains(company));
}
).Key;
if (dealerValue != null && cmb_Dealer.Items.Contains(dealerValue))
{
cmb_Dealer.SelectedItem = dealerValue;
}
cmb_Time.SelectedItem = updateRow.Cells["Required"].Value.ToString();
string lastUpdatedBy = updateRow.Cells["Last Updated By"].Value.ToString();
if (!string.IsNullOrEmpty(lastUpdatedBy) && int.Parse(lastUpdatedBy) > 0)
{
DataRow lastUpdatedPersonRow = DatabaseHelper.GetPerson(int.Parse(lastUpdatedBy));
string Name = lastUpdatedPersonRow["First Name"].ToString() + " " + lastUpdatedPersonRow["Last Name"].ToString();
if (!string.IsNullOrEmpty(lastUpdatedBy))
{
lbl_servicedEmployee.Text += " // Last Updated by " + Name;
}
}
foreach (DataRow detailRow in DatabaseHelper.GetTable("Order Details", null, null, true).Rows)
{
if (detailRow["Order ID"].ToString() == orderID.ToString())
{
string productName = detailRow["Product Name"].ToString();
int Quantity = int.Parse(detailRow["Quantity"].ToString());
AddProduct(productName, Quantity);
}
}
}
}