private void btn_add_prodname_Click(object sender, EventArgs e) { AddProduct_Form prod_add_frm = new AddProduct_Form(); prod_add_frm.Show(); prod_add_frm.FormClosed += delegate(object senderProdAddFrm, FormClosedEventArgs eProdAddFrm) { all_prod_names = ProductInfo_Main_Form.conn.GetProductSuggestions(""); //all_valid_rems = ProductInfo_Main_Form.conn.GetValidRemainders(ProductInfo_Main_Form.ActiveStoreID, true); LoadProdNamesList(); }; }
private void add_remainders_list_CellEndEdit(object sender, DataGridViewCellEventArgs e) { pressed_name_keystrokes = ""; if (submit_clicked && !add_remainders_list.Rows[e.RowIndex].IsNewRow) { HighlightNonCompleteFields(add_remainders_list.Rows[e.RowIndex]); } if (add_remainders_list.Columns[add_rem_barcode_col.Index].Index == e.ColumnIndex && null != add_remainders_list.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) { Product ProdJustScanned = ProductInfo_Main_Form.conn.GetProductByBarCode(add_remainders_list.Rows[e.RowIndex].Cells[add_rem_barcode_col.Index].EditedFormattedValue.ToString()); if ("nameless" == ProdJustScanned.name) { if (DialogResult.Yes == MessageBox.Show("შტრიხ–კოდი არ არის დარეგისტრირებული. გსურთ პროდუქტის ბაზაში დამატება?", "შეცდომა!", MessageBoxButtons.YesNo)) { AddProduct_Form add_scanned_frm = new AddProduct_Form(); add_scanned_frm.Show(); add_scanned_frm.Controls["barcode_txt"].Text = add_remainders_list.Rows[e.RowIndex].Cells[add_rem_barcode_col.Index].Value.ToString(); add_scanned_frm.Controls["name_txt"].Focus(); add_scanned_frm.Controls["prod_add_btn"].Click += new EventHandler(AddRemainders_Form_Click); } else { add_remainders_list.Rows[e.RowIndex].Cells[add_rem_barcode_col.Index].Value = "000000000"; } } else { try { add_remainders_list.Rows[e.RowIndex].Cells[add_rem_name_col.Index].Value = ProdJustScanned.name; } catch (System.ArgumentException) { } finally { } } } if (add_remainders_list.Columns[add_rem_name_col.Index].Index == e.ColumnIndex && null != add_remainders_list.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) { foreach (Product nXprod in all_products) { if (add_remainders_list.Rows[e.RowIndex].Cells[add_rem_name_col.Index].Value.ToString() == nXprod.name) { add_remainders_list.Rows[e.RowIndex].Cells[add_rem_barcode_col.Index].Value = nXprod.barcode; break; } } } try { if (null != add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_count_col.Index].Value) { if (null != add_remainders_list.Rows[e.RowIndex].Cells[add_rem_count_type_col.Index].Value) { if ("ცალობით" == add_remainders_list.Rows[e.RowIndex].Cells[add_rem_count_type_col.Index].Value.ToString()) { decimal row_piece_price = 0.0m; decimal row_sum_price = 0.0m; decimal row_piece_count = 0.0m; if (null != add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_count_col.Index].Value) { row_piece_count = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_count_col.Index].Value.ToString()); } if (null != add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_price_col.Index].Value) { row_piece_price = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_price_col.Index].Value.ToString()); row_sum_price = row_piece_count * row_piece_price; add_remainders_list.Rows[e.RowIndex].Cells[add_rem_sum_price_col.Index].Value = row_sum_price; // * ((decimal)add_remainders_list.Rows[e.RowIndex].Cells[add_rem_storeid_col.Index].Value + (decimal)add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_price_col.Index].Value); Row_Pricing[e.RowIndex] = row_sum_price; // decimal row_sell_price = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[add_rem_sell_price_col.Index].Value.ToString()); add_remainders_list.Rows[e.RowIndex].Cells[add_rem_namati_col.Index].Value = ((row_sell_price >= row_piece_price) ? "+" : "") + Math.Round(((row_sell_price - row_piece_price) / row_piece_price) * 100, 2) + "%"; add_remainders_list.Rows[e.RowIndex].Cells[add_rem_namati_col.Index].Style.BackColor = (row_sell_price >= row_piece_price) ? Color.LightGray : Color.Red; //add_remainders_list.Rows[e.RowIndex].Cells[add_rem_namati_col.Index].Style.ForeColor // = (row_sell_price >= row_piece_price) ? Color.Black : Color.White; // UpdateSumPrice(); } } else { decimal pack_count = 0.0m; decimal row_piece_price = 0.0m; decimal row_sum_price = 0.0m; decimal row_piece_count = 0.0m; if (null != add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_count_col.Index].Value) { row_piece_count = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_count_col.Index].Value.ToString()); } if (null != add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_price_col.Index].Value && null != add_remainders_list.Rows[e.RowIndex].Cells[add_rem_capacity_col.Index].Value) { row_piece_price = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_price_col.Index].Value.ToString()); pack_count = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[add_rem_capacity_col.Index].Value.ToString()); row_sum_price = row_piece_count * pack_count * row_piece_price; add_remainders_list.Rows[e.RowIndex].Cells[add_rem_sum_price_col.Index].Value = row_sum_price; // * ((decimal)add_remainders_list.Rows[e.RowIndex].Cells[add_rem_storeid_col.Index].Value + (decimal)add_remainders_list.Rows[e.RowIndex].Cells[add_rem_piece_price_col.Index].Value); Row_Pricing[e.RowIndex] = row_sum_price; // decimal row_sell_price = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[add_rem_sell_price_col.Index].Value.ToString()); add_remainders_list.Rows[e.RowIndex].Cells[add_rem_namati_col.Index].Value = ((row_sell_price >= row_piece_price) ? "+" : "") + Math.Round(((row_sell_price - row_piece_price) / row_piece_price) * 100, 2) + "%"; add_remainders_list.Rows[e.RowIndex].Cells[add_rem_namati_col.Index].Style.BackColor = (row_sell_price >= row_piece_price) ? Color.LightGray : Color.Red; //add_remainders_list.Rows[e.RowIndex].Cells[add_rem_namati_col.Index].Style.ForeColor // = (row_sell_price >= row_piece_price) ? Color.Black : Color.White; // UpdateSumPrice(); } } } } } catch (FormatException) { status_bar_lbl.Text = "შეავსეთ ველები შესაბამისი ფორმატით. "; } catch (NullReferenceException)//not needed { status_bar_lbl.Text = "ყველა ველი არაა შევსებული. "; } }
private void add_remainders_list_CellEndEdit(object sender, DataGridViewCellEventArgs e) { pressed_name_keystrokes = ""; if (submit_clicked && !add_remainders_list.Rows[e.RowIndex].IsNewRow) { HighlightNonCompleteFields(add_remainders_list.Rows[e.RowIndex]); } if (add_remainders_list.Columns["sell_rem_barcode_col"].Index == e.ColumnIndex && null != add_remainders_list.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) { Product ProdJustScanned = ProductInfo_Main_Form.conn.GetProductByBarCode(add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_barcode_col"].EditedFormattedValue.ToString()); if ("nameless" == ProdJustScanned.name) { if (DialogResult.Yes == MessageBox.Show("შტრიხ–კოდი არ არის დარეგისტრირებული. გსურთ პროდუქტის ბაზაში დამატება?", "შეცდომა!", MessageBoxButtons.YesNo)) { AddProduct_Form add_scanned_frm = new AddProduct_Form(); add_scanned_frm.Show(); add_scanned_frm.Controls["barcode_txt"].Text = add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_barcode_col"].Value.ToString(); add_scanned_frm.Controls["name_txt"].Focus(); add_scanned_frm.Controls["prod_add_btn"].Click += new EventHandler(Sell_Form_Click); } else { add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_barcode_col"].Value = "000000000"; } } else { add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_name_col"].Value = ProdJustScanned.name; } IEnumerable <Remainder> query = new List <Remainder>(); query = from r in all_rems where r.product_barcode == add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_barcode_col.Index].Value.ToString() select r; Remainder[] query_toarray = query.ToArray(); add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_remaining_col"].Value = query.Sum(r => r.remaining_pieces).ToString("G4") + " (სულ)"; if (query_toarray.Length > 0) { add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_capacity_col.Index].Value = query_toarray[0].pack_capacity.ToString("G4"); add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_initial_price_col.Index].Value = query_toarray[0].buy_price.ToString("G4") + " (#" + query_toarray[0].storehouse_id.ToString() + ")"; } else { MessageBox.Show("ეს პროდუქტი საწყობების ბაზაში არაა დარჩენილი. "); add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_barcode_col.Index].Value = "000000000"; } } if (add_remainders_list.Columns[sell_rem_name_col.Index].Index == e.ColumnIndex && null != add_remainders_list.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) { foreach (Product nXprod in all_products) { if (add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_name_col.Index].Value.ToString() == nXprod.name) { add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_barcode_col.Index].Value = nXprod.barcode; IEnumerable <Remainder> query = new List <Remainder>(); query = from r in all_rems where r.product_barcode == add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_barcode_col.Index].Value.ToString() select r; Remainder[] query_toarray = query.ToArray(); add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_remaining_col"].Value = query.Sum(r => r.remaining_pieces).ToString("G4") + " (სულ)"; if (query_toarray.Length > 0) { add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_capacity_col.Index].Value = query_toarray[0].pack_capacity.ToString("G4"); add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_initial_price_col.Index].Value = query_toarray[0].buy_price.ToString("G4") + " (#" + query_toarray[0].storehouse_id.ToString() + ")"; } else { MessageBox.Show("ეს პროდუქტი საწყობების ბაზაში არაა დარჩენილი. "); add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_barcode_col"].Value = "000000000"; } break; } } } if (add_remainders_list.Columns[sell_rem_storeid_col.Index].Index == e.ColumnIndex && null != add_remainders_list.Rows[e.RowIndex].Cells[e.ColumnIndex].Value && null != add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_barcode_col.Index].Value) { int CurrentStoreID = Int32.Parse(add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_storeid_col.Index].Value.ToString()); IEnumerable <Remainder> query = new List <Remainder>(); query = from r in all_rems where r.product_barcode == add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_barcode_col.Index].Value.ToString() && CurrentStoreID == r.storehouse_id select r; var StoreRems = from rem in query group rem by rem.storehouse_id into storrem select new { StoreID = storrem.Key, remaining_items = storrem.Sum(rem => rem.remaining_pieces) }; var rem_rem = (from sr in StoreRems where CurrentStoreID == sr.StoreID select sr.remaining_items).ToArray(); if (rem_rem.Length > 0) { add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_remaining_col"].Value = rem_rem[0].ToString("G4") + " (#" + CurrentStoreID.ToString() + ")"; } else { add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_remaining_col"].Value = 0.ToString("G4") + " (#" + CurrentStoreID.ToString() + ")"; } Remainder[] query_toarray = query.ToArray(); if (query_toarray.Length > 0) { add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_initial_price_col.Index].Value = query_toarray[0].buy_price.ToString("G4") + " (#" + query_toarray[0].storehouse_id.ToString() + ")"; } } if (add_remainders_list.Columns[sell_rem_piece_count_col.Index].Index == e.ColumnIndex && null != add_remainders_list.Rows[e.RowIndex].Cells[e.ColumnIndex].Value && null != add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_barcode_col.Index].Value && null != add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_storeid_col.Index].Value) { int CurrentStoreID = Int32.Parse(add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_storeid_col.Index].Value.ToString()); IEnumerable <Remainder> query = new List <Remainder>(); query = from r in all_rems where r.product_barcode == add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_barcode_col.Index].Value.ToString() && CurrentStoreID == r.storehouse_id select r; var StoreRems = from rem in query group rem by rem.storehouse_id into storrem select new { StoreID = storrem.Key, remaining_items = storrem.Sum(rem => rem.remaining_pieces) }; var rem_rem = (from sr in StoreRems where CurrentStoreID == sr.StoreID select sr.remaining_items).ToArray(); if (rem_rem.Length > 0) { add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_remaining_col"].Value = rem_rem[0].ToString("G4") + " (#" + CurrentStoreID.ToString() + ")"; } else { add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_remaining_col"].Value = 0.ToString("G4") + " (#" + CurrentStoreID.ToString() + ")"; } Remainder[] query_toarray = query.ToArray(); if (query_toarray.Length > 0) { add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_initial_price_col.Index].Value = query_toarray[0].buy_price.ToString("G4") + " (#" + query_toarray[0].storehouse_id.ToString() + ")"; } } if (add_remainders_list.Columns[sell_rem_pack_price_col.Index].Index == e.ColumnIndex && null != add_remainders_list.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) { if (null != add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_capacity_col.Index].Value) { decimal entered_capacity = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_capacity_col.Index].Value.ToString()); decimal entered_pack_price = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_pack_price_col.Index].Value.ToString()); add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_piece_price_col.Index].Value = entered_pack_price / entered_capacity; } } if (add_remainders_list.Columns[sell_rem_piece_price_col.Index].Index == e.ColumnIndex && null != add_remainders_list.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) { if (null != add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_capacity_col.Index].Value) { decimal entered_capacity = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_capacity_col.Index].Value.ToString()); decimal entered_piece_price = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_piece_price_col.Index].Value.ToString()); add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_pack_price_col.Index].Value = entered_piece_price * entered_capacity; } } try { if (null != add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_piece_count_col.Index].Value) { if (null != add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_count_type_col"].Value) { if ("ცალობით" == add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_count_type_col"].Value.ToString()) { decimal piece_price = 0.0m; decimal row_sum_price = 0.0m; decimal piece_count = 0.0m; if (null != add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_piece_count_col.Index].Value) { piece_count = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_piece_count_col.Index].Value.ToString()); } if (null != add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_piece_price_col"].Value) { piece_price = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_piece_price_col"].Value.ToString()); row_sum_price = piece_count * piece_price; add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_sum_price_col"].Value = row_sum_price; // * ((decimal)add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_storeid_col.Index].Value + (decimal)add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_piece_price_col"].Value); Row_Pricing[e.RowIndex] = row_sum_price; UpdateSumPrice(); } } else { decimal pack_count = 0.0m; decimal piece_price = 0.0m; decimal row_sum_price = 0.0m; decimal piece_count = 0.0m; if (null != add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_piece_count_col.Index].Value) { piece_count = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_piece_count_col.Index].Value.ToString()); } if (null != add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_piece_price_col"].Value && null != add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_capacity_col"].Value) { piece_price = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_piece_price_col"].Value.ToString()); pack_count = ParseDecimal(add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_capacity_col"].Value.ToString()); row_sum_price = piece_count * pack_count * piece_price; add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_sum_price_col"].Value = row_sum_price; // * ((decimal)add_remainders_list.Rows[e.RowIndex].Cells[sell_rem_storeid_col.Index].Value + (decimal)add_remainders_list.Rows[e.RowIndex].Cells["sell_rem_piece_price_col"].Value); Row_Pricing[e.RowIndex] = row_sum_price; UpdateSumPrice(); } } } } } catch (FormatException) { status_bar_lbl.Text = "შეავსეთ ველები შესაბამისი ფორმატით. "; } catch (NullReferenceException)//not needed { status_bar_lbl.Text = "ყველა ველი არაა შევსებული. "; } }