public void ShowSoldZedDetails(string buyer_ident_arg, string zed_ident_arg, DateTime dro_arg)
{
this.ViewMode = DetailedListViewMode.SoldZed;
this.EditingZedIdent = zed_ident_arg;
this.EditingZedOperation = "Sell";
this.EditingZedClientIdent = buyer_ident_arg;
LoadEditingZedValues();
this.SellOrderID = ProductInfo_Main_Form.conn.SellOrderIDByZedCode(buyer_ident_arg, zed_ident_arg);
string soldzed_buyer_name = (from Buyer b in ProductInfo_Main_Form.conn.AllBuyers() where b.saidentifikacio_kodi == buyer_ident_arg select b.saxeli).ToArray()[0];
this.Text = soldzed_buyer_name + "-ზე გასული ზედნადები N. " + zed_ident_arg;
so_details = ProductInfo_Main_Form.conn.SoldZedDetails(buyer_ident_arg, zed_ident_arg);
txtZedIdent.Text = zed_ident_arg;
//populate client list with buyers
cbZedClient.DataSource = dt_all_buyers;
cbZedClient.ValueMember = "saidentifikacio_kodi";
cbZedClient.DisplayMember = "saxeli";
//set client list value to editing zed ident
cbZedClient.SelectedValue = buyer_ident_arg;
//
ProductInfo_Main_Form.DataTableToListView(sold_rem_list, so_details, true);
attributes_lbl.Text = "გაყიდვის დრო: " + dro_arg.ToString() + "\n"
// + "მყიდველი: " + soldzed_buyer_name
// + "\nზედნადების ნომერი: " + zed_ident_arg
+ "\n\n\n\n\n\n";
SOd_print_btn.Enabled = true;
SOd_print_gasavali_btn.Enabled = true;
CleanUpSensitiveSellOrderInfo();
}
public void ShowBoughtZedDetails(string supplier_ident_arg, string zed_ident_arg, DateTime dro_arg)
{
this.ViewMode = DetailedListViewMode.BoughtZed;
this.EditingZedIdent = zed_ident_arg;
this.EditingZedOperation = "Buy";
this.EditingZedClientIdent = supplier_ident_arg;
LoadEditingZedValues();
string boughtzed_supplier_name = (from Supplier s in ProductInfo_Main_Form.conn.AllSuppliers() where s.saidentifikacio_kodi == supplier_ident_arg select s.saxeli).ToArray()[0];
this.Text = boughtzed_supplier_name + "-სგან მიღებული ზედნადები N. " + zed_ident_arg;
so_details = ProductInfo_Main_Form.conn.BoughtZedDetails(supplier_ident_arg, zed_ident_arg);
txtZedIdent.Text = zed_ident_arg;
//populate client list with suppliers
cbZedClient.DataSource = dt_all_suppliers;
cbZedClient.ValueMember = "saidentifikacio_kodi";
cbZedClient.DisplayMember = "saxeli";
//set client list value to editing zed ident
cbZedClient.SelectedValue = supplier_ident_arg;
//
ProductInfo_Main_Form.DataTableToListView(sold_rem_list, so_details, true);
attributes_lbl.Text = "მიღების დრო: " + dro_arg.ToString() + "\n"
// + "მომწოდებელი: " + boughtzed_supplier_name// + "\nზედნადების ნომერი: " + zed_ident_arg
+ "\n\n\n\n\n\n";
SOd_print_btn.Enabled = true;
SOd_print_gasavali_btn.Enabled = false;
SOd_print_gasavali_btn.Visible = false;
CleanUpSensitiveSellOrderInfo();
}
public void ShowSellOrderDetails(int SellOrderID_arg, string zed_ident_arg, string using_check_arg)
{
this.ViewMode = DetailedListViewMode.SellOrder;
this.Text = "გაყიდვის დეტალები";
this.SellOrderID = SellOrderID_arg;
lblZedIdent.Visible = false;
txtZedIdent.Visible = false;
btnEnableEditingZedIdent.Visible = false;
lblZedClient.Visible = false;
cbZedClient.Visible = false;
btnEnableEditingZedClient.Visible = false;
datetime_zed_tarigi.Visible = false;
txt_af_seria.Visible = false;
txt_af_nomeri.Visible = false;
btn_zed_update.Visible = false;
lbl_edit_af_seria.Visible = false;
lbl_edit_af_nomeri.Visible = false;
lbl_editzed_af_date.Visible = false;
datepicker_af_date.Visible = false;
btn_add_soldrems.Location = new Point(btn_add_soldrems.Location.X, sold_rem_list.Location.Y - 16 - btn_add_soldrems.Height);
so_details = ProductInfo_Main_Form.conn.SellOrderDetails(SellOrderID_arg);
ProductInfo_Main_Form.DataTableToListView(sold_rem_list, so_details, true);
attributes_lbl.Text = /*"გაყიდვის დრო: " + SellOrderDate.ToString() +*/ "\nზედნადების ნომერი: " + (("" != zed_ident_arg) ? zed_ident_arg : "გაყიდულია უზედნადებოდ") + "\n" + (("1" == using_check_arg | "ჩეკით" == using_check_arg) ? "გაყიდულია ჩეკით" : "გაყიდულია უჩეკოდ") + "\n\n\n";
SOd_print_btn.Enabled = true;
SOd_print_gasavali_btn.Enabled = true;
CleanUpSensitiveSellOrderInfo();
}
void add_list_Control_KeyPress(object sender, KeyPressEventArgs e)
{
if (add_rem_name_col.Index == add_remainders_list.CurrentCell.ColumnIndex)
{
Control ctl = (Control)sender;
//e.SuppressKeyPress = false;
//e.Handled = true;
//string pressedKey = ((char)e.KeyCode).ToString();
string pressedKey = e.KeyChar.ToString();
//if (!e.Shift)
//{
// pressedKey = pressedKey.ToLower();
//}
//if (e.KeyData != Keys.Shift)
//{
if (pressed_name_keystrokes != ProductInfo_Main_Form.UTF8String(pressedKey))
{
pressed_name_keystrokes += ProductInfo_Main_Form.UTF8String(pressedKey);
}
//}
status_bar_lbl.Text = pressed_name_keystrokes;
if ("" != pressed_name_keystrokes)
{
try
{
Product[] prod_suggestions = ProductInfo_Main_Form.conn.GetProductSuggestions(pressed_name_keystrokes);
if (prod_suggestions.Length > 0)
{
add_remainders_list.CurrentRow.Cells[add_rem_barcode_col.Index].Value = prod_suggestions[0].barcode;
foreach (object nextItem in add_rem_name_col.Items)
{
if (nextItem.ToString() == prod_suggestions[0].name)
{
add_remainders_list.CurrentRow.Cells[add_rem_name_col.Index].Value = nextItem.ToString();//prod_suggestions[0].name;
break;
}
}
/*
* add_rem_name_col.Items.Clear();
* foreach (Product nprod in prod_suggestions)
* {
* add_rem_name_col.Items.Add(nprod.name);
* }
* that's if product name is a combobox
* */
}
}
catch (NullReferenceException)
{
MessageBox.Show("null ref");
}
}
}//AutoComplete Product Name
}
private void SOd_print_gasavali_btn_Click(object sender, EventArgs e)
{
DataTable so_gasavali_print = ProductInfo_Main_Form.conn.Gasavali(SellOrderID);
so_gasavali_print = ProductInfo_Main_Form.DataTable_AddSum(so_gasavali_print);
PrintPreview_Form prevw_frm = new PrintPreview_Form();
prevw_frm.Show();
prevw_frm.DrawData(so_gasavali_print, false);
}
private void btn_exportCSV_SOd_Click(object sender, EventArgs e)
{
string csv_output = ProductInfo_Main_Form.ListViewToCSV(sold_rem_list);
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "csv files (*.csv)|*.csv|All files (*.*)|*.*";
try
{
switch (this.ViewMode)
{
case DetailedListViewMode.SellOrder:
sfd.FileName = "გაყიდვა #" + SellOrderID + " - " + DateTime.Now.Day + " " + BitmapGenerator.GeorgianMonths[DateTime.Now.Month] + " " + DateTime.Now.Year + " " + DateTime.Now.Hour + "-" + DateTime.Now.Minute;
break;
case DetailedListViewMode.BoughtZed:
sfd.FileName = "" + EditingZedClientIdent + "–სგან შემოსული ზედნადები #" + EditingZedIdent + " - " + DateTime.Now.Day + " " + BitmapGenerator.GeorgianMonths[DateTime.Now.Month] + " " + DateTime.Now.Year + " " + DateTime.Now.Hour + "-" + DateTime.Now.Minute;
break;
case DetailedListViewMode.SoldZed:
sfd.FileName = "" + EditingZedClientIdent + "–ზე გასული ზედნადები #" + EditingZedIdent + " - " + DateTime.Now.Day + " " + BitmapGenerator.GeorgianMonths[DateTime.Now.Month] + " " + DateTime.Now.Year + " " + DateTime.Now.Hour + "-" + DateTime.Now.Minute;
break;
}
}
catch
{
}
DialogResult sfd_ShowDialogResult = DialogResult.Cancel;
try
{
sfd_ShowDialogResult = sfd.ShowDialog();
}
catch
{
sfd.FileName = "";
sfd_ShowDialogResult = sfd.ShowDialog();
}
if (DialogResult.OK == sfd_ShowDialogResult)
{
info savefile_info = Utilities.Externals.SaveCSV(sfd.FileName, csv_output);
if (0 != savefile_info.errcode)
{
MessageBox.Show(savefile_info.details, savefile_info.errcode.ToString());
}
//
}
}
private void buyer_chooser_KeyPress(object sender, KeyPressEventArgs e)
{
Control ctl = (Control)sender;
//e.SuppressKeyPress = false;
e.Handled = true;
//string pressedKey = ((char)e.KeyValue).ToString();
/*
* if (!e.Shift)
* {
* pressedKey = pressedKey.ToLower();
* }
* else
* {
* return;//shift was pressed
* pressed_buyer_name_keystrokes += ProductInfo_Main_Form.UTF8String(ProductInfo_Main_Form.EngFromUTF8String(pressedKey).ToUpper());
* }*/
string pressedKey = e.KeyChar.ToString();
pressed_buyer_name_keystrokes += ProductInfo_Main_Form.UTF8String(pressedKey);
status_bar_lbl.Text = pressed_buyer_name_keystrokes;
if ("" != pressed_buyer_name_keystrokes)
{
try
{
Buyer[] matched_buyers = (from Buyer b in all_buyers
where b.saxeli.Contains(pressed_buyer_name_keystrokes)
select b).ToArray();
if (matched_buyers.Length > 0)
{
buyer_chooser.SelectedItem = matched_buyers[0].saxeli;
buyer_chooser.Text = matched_buyers[0].saxeli;
}
else
{
status_bar.Text = "მსგავსი მყიდველი არ მოიძებნა!";
}
}
catch (NullReferenceException)
{
MessageBox.Show("null ref");
}
}
}
private void supplier_chooser_KeyPress(object sender, KeyPressEventArgs e)
{
Control ctl = (Control)sender;
//e.SuppressKeyPress = false;
e.Handled = true;
//string pressedKey = ((char)e.KeyValue).ToString();
/*if (!e.Shift)
* {
* pressedKey = pressedKey.ToLower();
* }
* if (e.KeyData != Keys.Shift)
* {
* pressed_supp_name_keystrokes += ProductInfo_Main_Form.UTF8String(pressedKey);
* }*/
string pressedKey = e.KeyChar.ToString();
pressed_supp_name_keystrokes += ProductInfo_Main_Form.UTF8String(pressedKey);
status_bar_lbl.Text = pressed_supp_name_keystrokes;
if ("" != pressed_supp_name_keystrokes)
{
try
{
Supplier[] matched_supps = (from Supplier s in all_suppliers
where s.saxeli.Contains(pressed_supp_name_keystrokes)
select s).ToArray();
if (matched_supps.Length > 0)
{
supplier_chooser.SelectedItem = matched_supps[0].saxeli;
supplier_chooser.Text = matched_supps[0].saxeli;
}
else
{
status_bar.Text = "მსგავსი მომწოდებელი არ მოიძებნა!";
}
}
catch (NullReferenceException)
{
MessageBox.Show("null ref");
}
}
}
private void prod_add_btn_Click(object sender, EventArgs e)
{
ProductInfo_Main_Form main_frm = new ProductInfo_Main_Form();
main_frm.Enabled = true;
if ("" == barcode_txt.Text | "" == name_txt.Text)
{
return;
}
Product prod2add = new Product(barcode_txt.Text, name_txt.Text, vat_ckb.Checked);
info prod_add_info = ProductInfo_Main_Form.conn.AddProductName(prod2add);
MessageBox.Show(prod_add_info.details, prod_add_info.errcode.ToString());
if (0 == prod_add_info.errcode)
{
//success
this.Close();
}
}
