private void button1_Click(object sender, EventArgs e) { string Result = ""; try { Result = DatabaseCalls.AddItem(ItemNewName_txt.Text, ItemModel_txt.Text, Convert.ToInt32(ItemQuantity_txt.Text), Convert.ToDecimal(ItemPrice_txt.Text), ItemPictureBox.ImageLocation, ItemCategory_txt.Text); if (Result.StartsWith("Item Added with") != true) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = Result; return; } ItemDataSet = DatabaseCalls.GetItems(); ItemCode_txt.Items.Clear(); foreach (DataRow asdf in ItemDataSet.Tables[0].Rows) { ItemCode_txt.Items.Add(asdf["CODE"]); } ItemCode_txt.Focus(); Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = Result; } catch (Exception ex) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = ex.Message; } }
private void button1_Click(object sender, EventArgs e) { string Result = ""; try { if (ItemNewName_txt.Text == "") { return; } if (ItemPictureBox.ImageLocation == null || ItemPictureBox.ImageLocation == "") { if (File.Exists("ItemImages\\" + ItemNewName_txt.Text + ".JPG") == true) { ItemPictureBox.ImageLocation = Directory.GetCurrentDirectory() + "\\ItemImages\\" + ItemNewName_txt.Text + ".JPG"; } else if (File.Exists("ItemImages\\" + ItemNewName_txt.Text + ".JPEG") == true) { ItemPictureBox.ImageLocation = Directory.GetCurrentDirectory() + "\\ItemImages\\" + ItemNewName_txt.Text + ".JPEG"; } } Result = DatabaseCalls.AddItem(ItemNewName_txt.Text, ItemModel_txt.Text, Convert.ToInt32(ItemQuantity_txt.Text), Convert.ToDecimal(ItemPrice_txt.Text), ItemPictureBox.ImageLocation, ItemCategory_txt.Text); Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = Result; if (Result.StartsWith("Item Added with") != true) { return; } DataSet Result1 = new DataSet(); Result1 = DatabaseCalls.GetItems(); ItemsDataGridView.DataSource = Result1.Tables[0]; ItemsDataGridView.Columns[0].Visible = false; } catch (Exception ex) { Variables.NotificationMessageText = ex.Message; Variables.NotificationMessageTitle = this.Name; Variables.NotificationStatus = true; Console.WriteLine(ex.Message); } button6_Click(sender, e); }
private void PopulateConsignmentData(object sender, EventArgs e) { try { string Result = ""; ItemDataSet = DatabaseCalls.GetItems(); ItemCode_txt.Items.Clear(); foreach (DataRow asdf in ItemDataSet.Tables[0].Rows) { ItemCode_txt.Items.Add(asdf["CODE"]); } string ItemCode = " "; for (int loop = ExcelReader.Variables.RangeCurrentIndex; loop < ExcelReader.Variables.Range.Length && ItemCode != "" && ItemCode != "-----"; loop++) { try { ItemCode = ExcelReader.Variables.Range[loop][0]; if (ItemCode != "-----") { try { ItemCode_txt.Text = ExcelReader.Variables.Range[loop][0]; Description_txt.Text = ExcelReader.Variables.Range[loop][1]; Ctn_txt.Text = ExcelReader.Variables.Range[loop][2]; QtyPerBox_txt.Text = ExcelReader.Variables.Range[loop][3]; TQuantity_txt.Text = ExcelReader.Variables.Range[loop][4]; Price_txt.Text = ExcelReader.Variables.Range[loop][5]; if (ItemCode_txt.Items.Equals(ItemCode_txt.Text) == false && ItemCode_txt.Text != "" && Description_txt.Text != "" && Convert.ToInt32(QtyPerBox_txt.Text) > 0 && Convert.ToDecimal(Price_txt.Text) > 0) { try { Result = DatabaseCalls.AddItem(ItemCode_txt.Text, Description_txt.Text, Convert.ToInt32(QtyPerBox_txt.Text), Convert.ToDecimal(Price_txt.Text), ItemPictureBox.ImageLocation, "Toys"); Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = Result; if (Result.StartsWith("Item Added with") != true) { Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = Result; Variables.NotificationStatus = true; } } catch (Exception ex) { Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = ex.Message; Variables.NotificationStatus = true; } } } catch (Exception ex) { Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = ex.Message; Variables.NotificationStatus = true; } } // if (ItemCode_txt.Items.Contains(ItemCode) == true) { AddDataToGrid(); } } catch (Exception ex) { } //= ExcelReader.Variables.Range[loop][6]; } } catch (Exception ex) { Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = ex.Message; Variables.NotificationStatus = true; } }
private void toolStripButton1_Click(object sender, EventArgs e) { try { if (ConsignmentNumber_txt.Text == "") { Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = "Please Enter The consignment Name.."; Variables.NotificationStatus = true; return; } string Result = ""; try { //Add Consignment Result = DatabaseCalls.AddConsignment(ConsignmentNumber_txt.Text, Convert.ToDateTime(ConsignmentDate_txt.Text)); if (Result.StartsWith("Consignment Added with ID") != true) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = Result; return; } //Add Consignment Details foreach (DataGridViewRow GridViewRow in ConsignmentDataGridView.Rows) { try { if (GridViewRow.Cells[2].Value != null && GridViewRow.Cells[2].Value.ToString() != "None" && GridViewRow.Cells[2].Value != "") { //if qty_box != same ... add item string ItemCode = GridViewRow.Cells["ItemCode"].Value.ToString(); foreach (DataRow DR in ItemDataSet.Tables[0].Rows) { if (GridViewRow.Cells["ItemCode"].Value.ToString() == DR["Code"].ToString()) { if (GridViewRow.Cells["ItemCode"].Value.ToString() == "302") { } if (GridViewRow.Cells["QtyPerBox"].Value.ToString() != DR["QTY_BOX"].ToString()) { string result = ""; try { ItemCode = ItemCode + "(" + GridViewRow.Cells["QtyPerBox"].Value.ToString() + "P)"; GridViewRow.Cells[1].Value = ItemCode; result = DatabaseCalls.AddItem(ItemCode, GridViewRow.Cells["Description"].Value.ToString(), Convert.ToInt32(GridViewRow.Cells["QtyPerBox"].Value), Convert.ToDecimal(GridViewRow.Cells["Price"].Value), "", "Toys"); } catch (Exception ex) { ItemCode = ItemCode + "(" + GridViewRow.Cells["QtyPerBox"].Value.ToString() + "P)"; GridViewRow.Cells[1].Value = ItemCode; } } break; } } String Result2 = DatabaseCalls.AddConsignmentDetail(ItemCode, ConsignmentNumber_txt.Text, Convert.ToInt32(GridViewRow.Cells["TQuantity"].Value), Convert.ToInt32(GridViewRow.Cells["QtyPerBox"].Value), GridViewRow.Cells["Description"].Value.ToString(), Convert.ToInt32(GridViewRow.Cells["Ctn"].Value), Convert.ToDecimal(GridViewRow.Cells["Price"].Value), Convert.ToDecimal(GridViewRow.Cells["SUBTOTAL"].Value)); if (Result2.StartsWith("Consignment added with id") != true) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = Result2; return; } ItemDetails = DatabaseCalls.GetItemDetails("code", GridViewRow.Cells[1].Value.ToString()); int UpdatedItem_Quantity = (Convert.ToInt32(ItemDetails.Tables[0].Rows[0]["T_QUANTITY"]) + Convert.ToInt32(GridViewRow.Cells[5].Value)); String UpdateItemResult = DatabaseCalls.AddItemQutantity(GridViewRow.Cells[1].Value.ToString(), UpdatedItem_Quantity); if (UpdateItemResult.StartsWith("Item Quantity Modified") != true) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = UpdateItemResult; return; } String AddSaleResult = DatabaseCalls.AddSale(0, 0, -1, 0, GridViewRow.Cells[1].Value.ToString(), "Name", 0, 0, -1); if (UpdateItemResult.StartsWith("Item Quantity Modified") != true) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = UpdateItemResult; return; } //UPDATE PRICE IF MODIFIED foreach (DataRow asdf in ItemDataSet.Tables[0].Rows) { if (asdf["CODE"].ToString() == GridViewRow.Cells["ItemCode"].Value.ToString()) { if (Price_txt.Text != GridViewRow.Cells["Price"].Value.ToString()) { string ModifyCustomerResult = DatabaseCalls.ModifyItemPrice(GridViewRow.Cells["ItemCode"].Value.ToString(), Convert.ToDecimal(GridViewRow.Cells["Price"].Value)); if (ModifyCustomerResult.StartsWith("Item Price Modified") != true) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = ModifyCustomerResult; return; } //Item Price Modified } } } } } catch (Exception ex) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = ex.Message; } } //ClearAllData(); Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = "Consignment Added Successfully... :)"; this.Close(); //ClearAllData(); } catch (Exception ex) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = ex.Message; } RandomAlgos.DeleteConsignmentFile(); } catch (Exception ex) { Variables.NotificationStatus = true; Variables.NotificationMessageTitle = this.Name; Variables.NotificationMessageText = ex.Message; } }