private void button1_Click(object sender, EventArgs e) { try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand comm = new SqlCommand("ADDNEWUSER", DatabaseConnection.mConnection); comm.CommandType = CommandType.StoredProcedure; comm.Parameters.AddWithValue("@EMP_ID", myEmployee.SH_ID); comm.Parameters.AddWithValue("@EMP_NAME", myEmployee.SH_EMPLOYEE_NAME); comm.Parameters.AddWithValue("@EMP_USER_NAME", txtEmpUserName.Text); comm.Parameters.AddWithValue("@EMP_PASSWORD", txtEmpPassword.Text); comm.Parameters.AddWithValue("@CREATIONDATE", DateTime.Now); comm.ExecuteNonQuery(); MessageBox.Show("تم تسجيل الموظف كمستخدم بنجاح"); bttnSave.Enabled = false; myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }
void load_clients_data_search(string clientname) { clients.Clear(); try { string query = "SELECT * FROM SH_CLIENT_COMPANY WHERE SH_CLIENT_COMPANY_NAME LIKE N'%" + clientname + "' OR SH_CLIENT_COMPANY_NAME LIKE N'%" + clientname + "%' OR SH_CLIENT_COMPANY_NAME LIKE N'" + clientname + "%' "; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); // cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_NAME" ,clientname); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { clients.Add(new SH_CLIENT_COMPANY { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_CLIENT_COMPANY_NAME = reader["SH_CLIENT_COMPANY_NAME"].ToString(), SH_CLIENT_COMPANY_TYPE = reader["SH_CLIENT_COMPANY_TYPE"].ToString(), SH_CLIENT_COMPANY_TELEPHONE = reader["SH_CLIENT_COMPANY_TELEPHONE"].ToString(), SH_CLIENT_COMPANY_FAX_NUMBER = reader["SH_CLIENT_COMPANY_FAX_NUMBER"].ToString() }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING CLIENTS DATA FROM DB" + ex.ToString()); } }
void loadspecificationsofcutprintedmaterial() { specifications.Clear(); try { string query = "SELECT * FROM SH_SPECIFICATION_OF_CUT_PRINTED_MATERIAL"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { specifications.Add(new SH_SPECIFICATION_OF_CUT_PRINTED_MATERIAL() { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_CLIENT_ID = long.Parse(reader["SH_CLIENT_ID"].ToString()), SH_PRODUCT_ID = long.Parse(reader["SH_PRODUCT_ID"].ToString()) }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING SPECIFICATIONS OF CUT PRINTED MATERIAL " + ex.ToString()); } }
long loadPlasticTappaspcification() { SpecList.Clear(); try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("getPlasticMoldSpecification", DatabaseConnection.mConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@SH_MOLD_TYPE_NAME", textBoxType.Text); cmd.Parameters.AddWithValue("@SH_MOLD_SIZE_VALUE", double.Parse(textBoxClintName.Text)); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { long id_spec = long.Parse(reader["SH_ID"].ToString()); textBoxQuntityInStock.Clear(); textBoxQuntityInStock.Text = reader["SH_TOTAL_NO_ITEMS"].ToString(); return(id_spec); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING Plastic Mold specification FROM DB " + ex.ToString()); } return(0); }
void loadUserPermisions() { string query = "select * from SH_USER_PERMISIONS"; try { DatabaseConnection conn = new DatabaseConnection(); conn.openConnection(); SqlCommand comm = new SqlCommand(query, DatabaseConnection.mConnection); SqlDataReader red = comm.ExecuteReader(); while (red.Read()) { userPermList.Add(new SH_USER_PERMISIONS { SH_ID = long.Parse(red["SH_ID"].ToString()), SH_ACCOUNT_ID = long.Parse(red["SH_ACCOUNT_ID"].ToString()), SH_ACCOUNT_NAME = red["SH_ACCOUNT_NAME"].ToString() }); } red.Close(); conn.closeConnection(); } catch (Exception ex) { MessageBox.Show("Error in loading User permisions from dataBase" + ex.Message); } }
void loadallshoporders() { work_shop_orders.Clear(); try { string query = "SELECT * FROM SH_WORK_SHOP_WORK_ORDERS "; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { work_shop_orders.Add(new SH_WORK_SHOP_WORK_ORDERS() { SH_ASKED_MAN_NAME = reader["SH_ASKED_MAN_NAME"].ToString(), SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_NAME = reader["SH_ITEM_NAME"].ToString(), SH_ITEM_QUANTITY = long.Parse(reader["SH_ITEM_QUANTITY"].ToString()), SH_NOTES = reader["SH_NOTES"].ToString(), SH_START_WORK_DATE = DateTime.Parse(reader["SH_START_WORK_DATE"].ToString()), SH_WORKING_MACHINE = reader["SH_WORKING_MACHINE"].ToString(), SH_WORKING_TOTAL_HOURS = long.Parse(reader["SH_WORKING_TOTAL_HOURS"].ToString()), SH_FINISH_DATE = DateTime.Parse(reader["SH_FINISH_DATE"].ToString()), SH_WORK_STAT = long.Parse(reader["SH_WORK_STAT"].ToString()), SH_WORK_STAT_NAME = reader["SH_WORK_STAT_NAME"].ToString() }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING WORKSHOP ORDERS " + ex.ToString()); } }
void loadmuranmaterials() { muran_materials.Clear(); try { string query = "SELECT * FROM SH_SPECIFICATION_OF_MURAN_MATERIAL"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { muran_materials.Add(new SH_SPECIFICATION_OF_MURAN_MATERIAL() { SH_ITEM_LENGTH = double.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_BOTTLE_CAPACITY = reader["SH_BOTTLE_CAPACITY"].ToString(), SH_BOTTLE_HEIGHT = double.Parse(reader["SH_BOTTLE_HEIGHT"].ToString()), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_FIRST_FACE = reader["SH_ITEM_FIRST_FACE"].ToString(), SH_ITEM_SECOND_FACE = reader["SH_ITEM_SECOND_FACE"].ToString(), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_MURAN_TYPE = reader["SH_MURAN_TYPE"].ToString(), SH_SIZE_ID = long.Parse(reader["SH_SIZE_ID"].ToString()), SH_SIZE_NAME = reader["SH_SIZE_NAME"].ToString(), SH_ID = long.Parse(reader["SH_ID"].ToString()) }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING ALL MURAN TIN INFORMATION " + ex.ToString()); } }
void update_specifiction_quanities(long sid) { try { string query = "UPDATE SH_SPECIFICATION_OF_RAW_MATERIAL SET SH_ITEM_TOTAL_NUMBER_OF_SHEETS = SH_ITEM_TOTAL_NUMBER_OF_SHEETS + @SH_ITEM_TOTAL_NUMBER_OF_SHEETS"; query += ", SH_TOTAL_NET_WEIGHT = SH_TOTAL_NET_WEIGHT + @SH_TOTAL_NET_WEIGHT, SH_ITEM_TOTAL_NUMBER_OF_PACKAGES = SH_ITEM_TOTAL_NUMBER_OF_PACKAGES + @SH_ITEM_TOTAL_NUMBER_OF_PACKAGES ,"; query += " SH_TOTAL_GROSS_WEIGHT = SH_TOTAL_GROSS_WEIGHT + @SH_TOTAL_GROSS_WEIGHT WHERE SH_ID = @SH_ID"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_SHEETS", all_packages_no_sheets); cmd.Parameters.AddWithValue("@SH_TOTAL_NET_WEIGHT", (((double.Parse(item_length_text_box.Text) * double.Parse(item_width_text_box.Text) * double.Parse(item_thickness_text_box.Text)) / 1000000) * double.Parse(item_intensity_text_box.Text)) * double.Parse(all_packages_no_sheets.ToString())); cmd.Parameters.AddWithValue("@SH_TOTAL_GROSS_WEIGHT", all_packages_gross_weight); cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_PACKAGES", total_no_packges); cmd.Parameters.AddWithValue("@SH_ID", sid); cmd.ExecuteNonQuery(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR UPDATING QUANTITES IN SPECIFICATION TABLE" + ex.ToString()); } }
void LOADALLRAWTININFOS() { all_raw_tin.Clear(); try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("Select * FROM SH_SPECIFICATION_OF_RAW_MATERIAL ", DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { all_raw_tin.Add(new SH_SPECIFICATION_OF_RAW_MATERIAL { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_LENGTH = double.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_FINISH = reader["SH_ITEM_FINISH"].ToString(), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_INTENSITY = double.Parse(reader["SH_ITEM_INTENSITY"].ToString()), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_ITEM_NAME = reader["SH_ITEM_NAME"].ToString(), SH_CREATION_DATE = DateTime.Parse(reader["SH_CREATION_DATE"].ToString()), SH_ITEM_TOTAL_GROSS_WEIGHT = double.Parse(reader["SH_TOTAL_GROSS_WEIGHT"].ToString()), SH_ITEM_TOTAL_NET_WEIGHT = double.Parse(reader["SH_TOTAL_NET_WEIGHT"].ToString()), SH_ITEM_TOTAL_NUMBER_OF_PACKAGES = long.Parse(reader["SH_ITEM_TOTAL_NUMBER_OF_PACKAGES"].ToString()), SH_ITEM_TOTAL_NUMBER_OF_SHEETS = long.Parse(reader["SH_ITEM_TOTAL_NUMBER_OF_SHEETS"].ToString()) }); } myconnection.closeConnection(); } catch (Exception) { MessageBox.Show("خطأ فى تحميل البيانات ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } }
void loadsuppliersdata() { SUPPLIERS.Clear(); try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("SELECT * FROM SH_SUPPLY_COMPANY", DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { SUPPLIERS.Add(new SH_SUPPLY_COMPANY() { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_SUPPLY_COMAPNY_NAME = reader["SH_SUPPLY_COMAPNY_NAME"].ToString(), SH_SUPPLY_COMPANY_TELEPHONE = reader["SH_SUPPLY_COMPANY_TELEPHONE"].ToString(), SH_SUPPLY_COMPANY_MOBILE = reader["SH_SUPPLY_COMPANY_MOBILE"].ToString(), SH_SUPPLY_COMPANY_TYPE = reader["SH_SUPPLY_COMPANY_TYPE"].ToString(), SH_SUPPLY_COMPANY_FAX = reader["SH_SUPPLY_COMPANY_FAX"].ToString() }); } reader.Close(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING SUPLLIERS DATA" + ex.ToString()); } }
void loadDataGrid() { try { string query = "select * from SH_QUANTITY_OF_EXCHANGED_PRINTED_MATERIAL where SH_CUTTER_ID=@id"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@id", cutters[cutters_combo_box.SelectedIndex].SH_ID); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { QntExchPrntMaterialLst.Add(new SH_QUANTITY_OF_EXCHANGED_PRINTED_MATERIAL { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_CUTTER_NAME = reader["SH_CUTTER_NAME"].ToString(), SH_CONFIDENTIAL_MAN_ID = long.Parse(reader["SH_CONFIDENTIAL_MAN_ID"].ToString()), SH_EXCHANGE_PERMISSION_NUMBER = reader["SH_EXCHANGE_PERMISSION_NUMBER"].ToString(), SH_CONFIDENTIAL_MAN_NAME = reader["SH_CONFIDENTIAL_MAN_NAME"].ToString(), SH_CUTTER_ID = long.Parse(reader["SH_CUTTER_ID"].ToString()), SH_CUTTER_MAN_NAME = reader["SH_CUTTER_MAN_NAME"].ToString(), SH_DEPARTMENET_ID = long.Parse(reader["SH_DEPARTMENET_ID"].ToString()), SH_DEPARTMENT_NAME = reader["SH_DEPARTMENT_NAME"].ToString(), SH_NUMBER_OF_PARCELS = long.Parse(reader["SH_NUMBER_OF_PARCELS"].ToString()), SH_STOCK_NAME = reader["SH_STOCK_NAME"].ToString(), SH_NUMBER_OF_SHEETS = long.Parse(reader["SH_NUMBER_OF_SHEETS"].ToString()), SH_RECEIVED_MAN_ID = long.Parse(reader["SH_RECEIVED_MAN_ID"].ToString()), SH_RECEIVED_MAN_NAME = reader["SH_RECEIVED_MAN_NAME"].ToString(), SH_STOCK_ID = long.Parse(reader["SH_STOCK_ID"].ToString()), SH_STOCK_MAN_ID = long.Parse(reader["SH_STOCK_MAN_ID"].ToString()), SH_STOCK_MAN_NAME = reader["SH_STOCK_MAN_NAME"].ToString() }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERRO WHILE GETTING QUANTITY_OF_EXCHANGED_PRINTED_MATERIAL DATA FROM DB " + ex.ToString()); } }
void fillprintedmaterialparcelsgridview() { parcels.Clear(); try { string query = "SELECT SH_PALLETS_OF_CUT_PRINTED_MATERIAL.* "; query += " FROM SH_PALLETS_OF_CUT_PRINTED_MATERIAL "; query += "WHERE(SH_CLIENT_ID = @SH_CLIENT_ID) AND(SH_PRODUCT_ID = @SH_PRODUCT_ID)"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_CLIENT_ID", clients[clients_combo_box.SelectedIndex].SH_ID); cmd.Parameters.AddWithValue("@SH_PRODUCT_ID", client_products[client_products_combo_box.SelectedIndex].SH_ID); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { parcels.Add(new SH_PALLETS_OF_CUT_PRINTED_MATERIAL() { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_CLIENT_ID = long.Parse(reader["SH_CLIENT_ID"].ToString()), SH_CLIENT_NAME = reader["SH_CLIENT_NAME"].ToString(), SH_ADDITION_DATE = DateTime.Parse(reader["SH_ADDITION_DATE"].ToString()), SH_ADDTION_PERMISSION_NUMBER = reader["SH_ADDTION_PERMISSION_NUMBER"].ToString(), SH_CUTTER_ID = long.Parse(reader["SH_CUTTER_ID"].ToString()), SH_CUTTER_NAME = reader["SH_CUTTER_NAME"].ToString(), SH_CUTTER_TECHNICAL_MAN = reader["SH_CUTTER_TECHNICAL_MAN"].ToString(), SH_NUMBER_OF_BOTTLES_PER_SEQUENCE = long.Parse(reader["SH_NUMBER_OF_BOTTLES_PER_SEQUENCE"].ToString()), SH_NUMBER_OF_SEQUENCES = long.Parse(reader["SH_NUMBER_OF_SEQUENCES"].ToString()), SH_PRODUCT_ID = long.Parse(reader["SH_PRODUCT_ID"].ToString()), SH_PRODUCT_NAME = reader["SH_PRODUCT_NAME"].ToString(), SH_QUANTITIES_OF_CUT_PRINTED_MATERIAL_ID = long.Parse(reader["SH_QUANTITIES_OF_CUT_PRINTED_MATERIAL_ID"].ToString()), SH_SPECIFICATION_OF_CU_PRINTED_MATERIAL_ID = long.Parse(reader["SH_SPECIFICATION_OF_CU_PRINTED_MATERIAL_ID"].ToString()), SH_STOCK_ID = long.Parse(reader["SH_STOCK_ID"].ToString()), SH_STOCK_NAME = reader["SH_STOCK_NAME"].ToString(), SH_TOTAL_NUMBER_OF_BOTTELS = long.Parse(reader["SH_TOTAL_NUMBER_OF_BOTTELS"].ToString()), SH_WORK_ORDER_NUMBER = reader["SH_WORK_ORDER_NUMBER"].ToString() }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING MURAN MATERIAL PARCELS DATA " + ex.ToString()); } if (parcels.Count > 0) { for (int i = 0; i < parcels.Count; i++) { parcels_cut_printed_parcels_grid_view.Rows.Add(new string[] { (i + 1).ToString(), parcels[i].SH_CLIENT_NAME, parcels[i].SH_PRODUCT_NAME, parcels[i].SH_TOTAL_NUMBER_OF_BOTTELS.ToString(), parcels[i].SH_NUMBER_OF_SEQUENCES.ToString() }); } } }
void loadDataGridEmployees() { supply_contacts.Clear(); try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("select * from SH_SUPPLIER_COMPANY_CONTACTS where SH_SUPPLIER_COMPANY_CONTACT_ID=@id", DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@id", Mcompany.SH_ID); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { supply_contacts.Add(new SH_SUPPLIER_COMPANY_CONTACTS { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_SUPPLIER_COMPANY_CONTACT_EMAIL = reader["SH_SUPPLIER_COMPANY_CONTACT_EMAIL"].ToString(), SH_SUPPLIER_COMPANY_CONTACT_TELEPHONE = reader["SH_SUPPLIER_COMPANY_CONTACT_TELEPHONE"].ToString(), SH_SUPPLIER_COMPANY_CONTACT_NAME = reader["SH_SUPPLIER_COMPANY_CONTACT_NAME"].ToString() }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING Supplier employees Contacts " + ex.ToString()); } }
void loadPrintedMaterial(SH_PRINTED_MATERIAL_PARCEL myparcel) { try { string query = "SELECT * FROM SH_SPECIFICATION_OF_PRINTED_MATERIAL WHERE SH_ID = @SH_ID "; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_ID", myparcel.SH_SPECIFICATION_OF_PRINTED_MATERIAL_ID); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { specifPrntMaterialLst.Add(new SH_SPECIFICATION_OF_PRINTED_MATERIAL { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_FINISH = reader["SH_ITEM_FINISH"].ToString(), SH_ITEM_LENGTH = long.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_SHEET_WEIGHT = long.Parse(reader["SH_ITEM_SHEET_WEIGHT"].ToString()), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_TOTAL_GROSS_WEIGHT = double.Parse(reader["SH_ITEM_TOTAL_GROSS_WEIGHT"].ToString()), SH_ITEM_TOTAL_NET_WEIGHT = double.Parse(reader["SH_ITEM_TOTAL_NET_WEIGHT"].ToString()), SH_ITEM_TOTAL_NO_PARCELS = long.Parse(reader["SH_ITEM_TOTAL_NO_PARCELS"].ToString()), SH_ITEM_TOTAL_NO_SHEETS = long.Parse(reader["SH_ITEM_TOTAL_NO_SHEETS"].ToString()), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()) }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERRO WHILE GETTING printed material DATA FROM DB " + ex.ToString()); } }
void loadaallsizes() { sizes.Clear(); try { string query = "SELECT * FROM SH_ITEM_SIZE"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { sizes.Add(new SH_ITEM_SIZE() { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_SIZE_FIRST_DIAMETER = double.Parse(reader["SH_SIZE_FIRST_DIAMETER"].ToString()), SH_SIZE_FIRST_DIAMETER_NAME = reader["SH_SIZE_FIRST_DIAMETER_NAME"].ToString(), SH_SIZE_NAME = reader["SH_SIZE_NAME"].ToString(), SH_SIZE_SECOND_DIAMETER = double.Parse(reader["SH_SIZE_SECOND_DIAMETER"].ToString()), SH_SIZE_SECOND_DIAMETER_NAME = reader["SH_SIZE_SECOND_DIAMETER_NAME"].ToString(), SH_SIZE_SHAPE_NAME = reader["SH_SIZE_SHAPE_NAME"].ToString(), SH_SIZE_SURROUNDING = double.Parse(reader["SH_SIZE_SURROUNDING"].ToString()) }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE LOADING DB" + ex.ToString()); } }
void loadallrawmaterialparcels() { try { string query = "SELECT * FROM SH_RAW_MATERIAL_PARCEL"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { parcels.Add(new SH_RAW_MATERIAL_PARCEL() { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_LENGTH = double.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString() }); } myconnection.closeConnection(); // MessageBox.Show("GET ALL DATA"); } catch (Exception ex) { MessageBox.Show("ERROR WHILE LOADING PARCELS DATA" + ex.ToString()); } }
void getallclientandproductparcels(long client_id, long product_id) { try { string query = "SELECT * FROM SH_PRINTED_MATERIAL_PARCEL WHERE SH_ID IN ( SELECT SH_PRINTED_MATERIAL_PARCEL_ID FROM SH_PRODUCT_OF_CLIENTS_PARCELS WHERE(SH_CLIENT_ID = @SH_CLIENT_ID AND SH_CLIENT_PRODUCT_ID = @SH_CLIENT_PRODUCT_ID) AND ( SH_PRINTED_MATERIAL_PARCEL_ID NOT IN (SELECT SH_PRINTED_MATERIAL_PARCEL_ID FROM SH_EXCHANGED_PRINTED_MATERIAL_PARCELS)) )"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_CLIENT_PRODUCT_ID", product_id); cmd.Parameters.AddWithValue("@SH_CLIENT_ID", client_id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { parcels.Add(new SH_PRINTED_MATERIAL_PARCEL() { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ADDITION_DATE = DateTime.Parse(reader["SH_ADDITION_DATE"].ToString()), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_FINISH = reader["SH_ITEM_FINISH"].ToString(), SH_ITEM_LENGTH = double.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_SHEET_WEIGHT = double.Parse(reader["SH_ITEM_SHEET_WEIGHT"].ToString()), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_TOTAL_GROSS_WEIGHT = double.Parse(reader["SH_ITEM_GROSS_WEIGHT"].ToString()), SH_ITEM_TOTAL_NET_WEIGHT = double.Parse(reader["SH_ITEM_NET_WEIGHT"].ToString()), SH_ITEM_TOTAL_NO_SHEETS = long.Parse(reader["SH_ITEM_NO_SHEETS"].ToString()), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()), SH_PARCEL_NET_WEIGHT = double.Parse(reader["SH_ITEM_NET_WEIGHT"].ToString()), SH_PARCEL_NO_SHEETS = long.Parse(reader["SH_ITEM_NO_SHEETS"].ToString()), SH_PRINTER_ID = long.Parse(reader["SH_PRINTER_ID"].ToString()), SH_PRINTER_NAME = reader["SH_PRINTER_NAME"].ToString(), SH_PRINTING_PERMISSION_NUMBER = reader["SH_PRINTING_PERMISSION_NUMBER"].ToString(), SH_QUANTITIES_OF_PRINTED_MATERIAL_ID = long.Parse(reader["SH_QUANTITIES_OF_PRINTED_MATERIAL_ID"].ToString()), SH_SPECIFICATION_OF_PRINTED_MATERIAL_ID = reader["SH_SPECIFICATION_OF_PRINTED_MATERIAL_ID"].ToString(), SH_STOCK_NAME = reader["SH_STOCK_NAME"].ToString(), SH_TOTAL_NUMBER_OF_BOTTELS = long.Parse(reader["SH_TOTAL_NUMBER_OF_BOTTELS"].ToString()), SH_WORK_ORDER_NUMBER = reader["SH_WORK_ORDER_NUMBER"].ToString() }); } myconnection.closeConnection(); }catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING PRINTED PARCELS " + ex.ToString()); } }
void getallquantities() { string client_name = ""; bool client_data = false; string client_branch_name = ""; bool client_branch_data = false; if (string.IsNullOrWhiteSpace(clients_combo_box.Text)) { client_name = ""; client_data = false; } else { client_name = " AND SRPI.SH_CLIENT_ID = @SH_CLIENT_ID"; client_data = true; } if (string.IsNullOrWhiteSpace(client_branches_combo_box.Text)) { client_branch_name = ""; client_branch_data = false; } else { client_branch_name = " AND SRPI.SH_CLIENT_BRANCH_ID =@SH_CLIENT_BRANCH_ID "; client_branch_data = true; } mydata.Clear(); try { myconnection.openConnection(); string query = "SELECT SRPI.SH_CLIENT_ID , "; query += "(select cc.SH_CLIENT_COMPANY_NAME from SH_CLIENT_COMPANY cc where cc.SH_ID = SRPI.SH_CLIENT_ID ) as client_name, "; query += " (SELECT CCB.SH_CLIENT_BRANCH_NAME FROM SH_CLIENTS_BRANCHES CCB WHERE CCB.SH_ID = SRPI.SH_CLIENT_BRANCH_ID ) "; query += " AS CLIENT_BRANCH_NAME ,"; query += " SRPQI.SH_ITEM_NAME , SRPQI.SH_ITEM_CONTAINER , "; query += " sum(SRPQI.SH_NO_CONTAINERS) as number_containers , sum(SRPQI.SH_TOTAL_NO_ITEMS) as total_quantity "; query += " FROM SH_RECEIVING_PERMISSION_ITEMS_QUANTITIES_INFORMATION SRPQI "; query += " left join SH_RECEIVING_PERMISSION_INFORMATION SRPI "; query += " on SRPQI.SH_RECEIVING_PERMISSION_INFORMATION_ID = SRPI.SH_ID "; query += " where 1 = 1 " + client_name + client_branch_name; query += " group by SRPI.SH_CLIENT_ID ,SRPI.SH_CLIENT_BRANCH_ID ,"; query += " SRPQI.SH_ITEM_NAME ,SRPQI.SH_ITEM_CONTAINER "; SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); if (client_data) { cmd.Parameters.AddWithValue("@SH_CLIENT_ID", clients[clients_combo_box.SelectedIndex].SH_ID); } if (client_branch_data) { cmd.Parameters.AddWithValue("@SH_CLIENT_BRANCH_ID", client_branches[client_branches_combo_box.SelectedIndex].SH_ID); } SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { mydata.Add(new summary_receiving_information_quantity_data() { client_name = reader["client_name"].ToString(), client_branch_name = reader["CLIENT_BRANCH_NAME"].ToString(), item_name = reader["SH_ITEM_NAME"].ToString(), client_id = long.Parse(reader["SH_CLIENT_ID"].ToString()), no_containers = long.Parse(reader["number_containers"].ToString()), no_items = long.Parse(reader["total_quantity"].ToString()), container_name = reader["SH_ITEM_CONTAINER"].ToString() }); } reader.Close(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING CLIENTS SUMMARY DATA " + ex.ToString()); } if (mydata.Count > 0) { receving_permission_quantities_grid_view.Rows.Clear(); for (int i = 0; i < mydata.Count; i++) { string[] mydatavalues = new string[7]; mydatavalues[0] = (i + 1).ToString(); mydatavalues[1] = (mydata[i].client_name).ToString(); mydatavalues[2] = (mydata[i].client_branch_name).ToString(); mydatavalues[3] = (mydata[i].item_name).ToString(); mydatavalues[4] = (mydata[i].container_name).ToString(); mydatavalues[5] = (mydata[i].no_containers).ToString(); mydatavalues[6] = (mydata[i].no_items).ToString(); receving_permission_quantities_grid_view.Rows.Add(mydatavalues); } } }
private void printplasticcovertotalbalanceform_Load(object sender, EventArgs e) { long no_items = 0; long no_containers = 0; DataTable mydatatabel = new DataTable(); mydatatabel.Columns.Add("m"); mydatatabel.Columns.Add("container_name"); mydatatabel.Columns.Add("no_items_per_container"); mydatatabel.Columns.Add("no_containers"); mydatatabel.Columns.Add("total_no_items"); mydatatabel.Columns.Add("addition_date"); mydatatabel.Columns.Add("client_name"); mydatatabel.Columns.Add("pillow_color_name"); mydatatabel.Columns.Add("size_name"); mydatatabel.Columns.Add("logo_or_not"); try { myconnection.openConnection(); SqlCommand cmd = new SqlCommand("SH_GET_ALL_SH_SPECIFICATION_OF_PLASTIC_COVER", DatabaseConnection.mConnection); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); long counter = 0; while (reader.Read()) { counter++; string[] mydata = new string[10]; mydata[0] = counter.ToString(); mydata[1] = reader["SH_CONTAINER_NAME"].ToString(); mydata[2] = reader["SH_NO_ITEMS"].ToString(); mydata[3] = reader["NO_ITEMS"].ToString(); no_containers += long.Parse(reader["NO_ITEMS"].ToString()); mydata[4] = reader["TOTAL_NO_ITEMS"].ToString(); no_items += long.Parse(reader["TOTAL_NO_ITEMS"].ToString()); mydata[5] = reader["SH_ADDTION_DATE"].ToString(); mydata[6] = reader["CLIENT_NAME"].ToString(); mydata[7] = reader["PILLOW_COLOR_NAME"].ToString(); mydata[8] = reader["SIZE_NAME"].ToString(); if (long.Parse(reader["SH_LOGO_OR_NOT"].ToString()) == 0) { mydata[9] = "N"; } else { mydata[9] = "Y"; } mydatatabel.Rows.Add(mydata); } reader.Close(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHIlE GETTInG PLASTIC COVER DATA " + ex.ToString()); } ReportParameter[] myparams = new ReportParameter[3]; myparams[0] = new ReportParameter("report_presenter_name", mEmployee.SH_EMPLOYEE_NAME, false); myparams[1] = new ReportParameter("total_no_containers", no_containers.ToString(), false); myparams[2] = new ReportParameter("total_no_items", no_items.ToString(), false); this.reportViewer1.LocalReport.SetParameters(myparams); ReportDataSource rds = new ReportDataSource("DataSet1", mydatatabel); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(rds); this.reportViewer1.RefreshReport(); }
private void search_properties_Click(object sender, EventArgs e) { double testnumber = 0; bool length = false; bool width = false; bool thickness = false; bool temper = false; bool coating = false; bool code = false; bool finish = false; bool type = false; string mlength = ""; string mwidth = ""; string mthickness = ""; string mtemper = ""; string caoting = ""; string mcode = ""; string mfinish = ""; string mtype = ""; if (string.IsNullOrEmpty(item_length_text_box.Text)) { mlength = ""; } else if (double.TryParse(item_length_text_box.Text, out testnumber)) { length = true; mlength = " AND (srm.SH_ITEM_LENGTH = @SH_ITEM_LENGTH) "; } else { mlength = ""; } if (string.IsNullOrEmpty(item_width_text_box.Text)) { mwidth = ""; } else if (double.TryParse(item_width_text_box.Text, out testnumber)) { width = true; mwidth = " AND (srm.SH_ITEM_WIDTH = @SH_ITEM_WIDTH) "; } else { mwidth = ""; } if (string.IsNullOrEmpty(item_thickness_text_box.Text)) { mthickness = ""; } else if (double.TryParse(item_thickness_text_box.Text, out testnumber)) { thickness = true; mthickness = "AND (srm.SH_ITEM_THICKNESS = @SH_ITEM_THICKNESS)"; } else { mthickness = ""; } if (string.IsNullOrEmpty(item_temper_text_box.Text)) { mtemper = ""; } else { temper = true; mtemper = " AND (srm.SH_ITEM_TEMPER LIKE N'%@SH_ITEM_TEMPER' || srm.SH_ITEM_TEMPER LIKE N'%@SH_ITEM_TEMPER%' || srm.SH_ITEM_TEMPER LIKE N'@SH_ITEM_TEMPER%' )"; } if (string.IsNullOrEmpty(item_code_text_box.Text)) { mcode = ""; } else { code = true; mcode = " AND (srm.SH_ITEM_CODE LIKE N'%@SH_ITEM_CODE' ||srm.SH_ITEM_CODE LIKE N'%@SH_ITEM_CODE%' || srm.SH_ITEM_CODE LIKE N'@SH_ITEM_CODE%' )"; } if (string.IsNullOrEmpty(item_finish_text_box.Text)) { mfinish = ""; } else { finish = true; mfinish = "AND (srm.SH_ITEM_FINISH LIKE N'%@SH_ITEM_FINISH' ||srm.SH_ITEM_FINISH LIKE N'%@SH_ITEM_FINISH%' ||srm.SH_ITEM_FINISH LIKE N'@SH_ITEM_FINISH%')"; } if (string.IsNullOrEmpty(item_type_text_box.Text)) { mtype = ""; } else { type = true; mtype = "AND (srm.SH_ITEM_TYPE LIKE N'%@SH_ITEM_TYPE' || srm.SH_ITEM_TYPE LIKE N'%@SH_ITEM_TYPE%' || srm.SH_ITEM_TYPE LIKE N'@SH_ITEM_TYPE%' )"; } try { string query = "SELECT * FROM SH_RAW_MATERIAL_PARCEL srm WHERE ( TRUE " + mlength + mwidth + mthickness + mcode + mfinish + mtemper + mtype + " ) AND NOT EXISTS (SELECT * FROM SH_MINUTES_PACKAGES_EXAMINED_RAW_MATERIAL mperm where mperm.SH_ITEM_PRACEL_ID = srm.SH_ID) "; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); if (length) { cmd.Parameters.AddWithValue("", ""); } myconnection.closeConnection(); } catch (Exception) { throw; } }
void fillallsoldquantities() { mydata.Clear(); string client_name = ""; bool client_data = false; string client_branch_name = ""; bool client_branch_data = false; if (string.IsNullOrWhiteSpace(clients_combo_box.Text)) { client_name = ""; client_data = false; } else { client_name = " AND SRPI.SH_CLIENT_ID = @SH_CLIENT_ID"; client_data = true; } if (string.IsNullOrWhiteSpace(client_branches_combo_box.Text)) { client_branch_name = ""; client_branch_data = false; } else { client_branch_name = " AND SRPI.SH_CLIENT_BRANCH_ID =@SH_CLIENT_BRANCH_ID "; client_branch_data = true; } try { myconnection.openConnection(); string query = " select SRPI.SH_RECEIVING_PERMISSION_NUMBER, SRPI.SH_ADDITION_DATE, "; query += " CC.SH_CLIENT_COMPANY_NAME , CCB.SH_CLIENT_BRANCH_NAME ,SEPIQI.SH_ITEM_NAME , "; query += " SEPIQI.SH_ITEM_CONTAINER ,SEPIQI.SH_NO_ITEMS_PER_CONTAINER,SEPIQI.SH_NO_CONTAINERS ,SEPIQI.SH_TOTAL_NO_ITEMS , "; query += " SRPI.SH_DRIVER_NAME,SS.SH_STOCK_NAME , SEMP.SH_EMPLOYEE_NAME "; query += " from SH_RECEIVING_PERMISSION_ITEMS_QUANTITIES_INFORMATION SEPIQI "; query += " left join SH_RECEIVING_PERMISSION_INFORMATION SRPI "; query += " on SEPIQI.SH_RECEIVING_PERMISSION_INFORMATION_ID = SRPI.SH_ID "; query += " LEFT JOIN SH_CLIENT_COMPANY CC ON "; query += " CC.SH_ID = SRPI.SH_CLIENT_ID "; query += " LEFT JOIN SH_CLIENTS_BRANCHES CCB ON "; query += " CCB.SH_ID = SRPI.SH_CLIENT_BRANCH_ID "; query += " LEFT JOIN SH_SHAHEEN_STOCKS SS ON "; query += " SS.SH_ID = SRPI.SH_STOCK_ID "; query += " LEFT JOIN SH_EMPLOYEES SEMP ON "; query += " SEMP.SH_ID = SRPI.SH_STOCK_MAN_ID "; query += " WHERE 1=1 " + client_name + client_branch_name; query += " AND SRPI.SH_ADDITION_DATE BETWEEN @date_one AND @date_two "; SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@date_one", DateTime.Parse(start_date_one.Text)); cmd.Parameters.AddWithValue(" @date_two", DateTime.Parse(end_date_two.Text)); if (client_data) { cmd.Parameters.AddWithValue("@SH_CLIENT_ID", clients[clients_combo_box.SelectedIndex].SH_ID); } if (client_branch_data) { cmd.Parameters.AddWithValue("@SH_CLIENT_BRANCH_ID", client_branches[client_branches_combo_box.SelectedIndex].SH_ID); } SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { mydata.Add(new allsolditemsfullinformationdetails() { client_branch_name = reader["SH_CLIENT_BRANCH_NAME"].ToString(), client_name = reader["SH_CLIENT_COMPANY_NAME"].ToString(), container_name = reader["SH_ITEM_CONTAINER"].ToString(), driver_name = reader["SH_DRIVER_NAME"].ToString(), //no_carton_dividers = long.Parse(), no_containers = long.Parse(reader["SH_NO_CONTAINERS"].ToString()), no_items_per_container = long.Parse(reader["SH_NO_ITEMS_PER_CONTAINER"].ToString()), //no_pallets = long.Parse(), //no_wooden_faces = long.Parse(), receival_permission_date = DateTime.Parse(reader["SH_ADDITION_DATE"].ToString()), receival_permission_number = reader["SH_RECEIVING_PERMISSION_NUMBER"].ToString(), stock_man_name = reader["SH_EMPLOYEE_NAME"].ToString(), stock_name = reader["SH_STOCK_NAME"].ToString(), total_number_of_items = long.Parse(reader["SH_TOTAL_NO_ITEMS"].ToString()) }); } reader.Close(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING SOLD DATA " + ex.ToString()); } if (mydata.Count > 0) { total_receival_information_quantities_data_grid_view.Rows.Clear(); for (int i = 0; i < mydata.Count; i++) { string[] myvalues = new string[13]; myvalues[0] = (i + 1).ToString(); } } }
async Task autogenerateadditionpermisionnumber() { long mycount = 0; try { myconnection.openConnection(); SqlCommand cmd = new SqlCommand("SELECT (MAX(SH_ID)+1) AS lastedid FROM SH_ADDITION_PERMISSION_NUMBER_OF_PLASTIC_COVER ", DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { if (string.IsNullOrWhiteSpace(reader["lastedid"].ToString())) { reader.Close(); } else { mycount = long.Parse(reader["lastedid"].ToString()); } } reader.Close(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("Error while getting new permission number " + ex.ToString()); } if (mycount == 0) { //there is the first rows in the db string permissionnumber = "SH_"; permissionnumber += "PLASTIC_COVER-"; permissionnumber += DateTime.Now.ToString("yy"); string currentr = 1.ToString(); for (int i = 0; i < 5 - 1; i++) { permissionnumber += "0"; } permissionnumber += 1.ToString(); addition_permission_number_text_box.Text = permissionnumber; } else { string permissionnumber = "SH_"; permissionnumber += "PLASTIC_COVER-"; permissionnumber += DateTime.Now.ToString("yy"); string currentr = mycount.ToString(); for (int i = 0; i < 5 - currentr.Length; i++) { permissionnumber += "0"; } permissionnumber += mycount.ToString(); addition_permission_number_text_box.Text = permissionnumber; } }
private void printpeelofftotalbalanceform_Load(object sender, EventArgs e) { // long total_no_items = 0; long total_no_containers = 0; long total_no_pallets = 0; long total_no_cartons = 0; DataTable mydatatabel = new DataTable(); mydatatabel.Columns.Add("m"); mydatatabel.Columns.Add("item_material_type"); mydatatabel.Columns.Add("printing_type"); mydatatabel.Columns.Add("size_name"); mydatatabel.Columns.Add("client_name"); mydatatabel.Columns.Add("first_face"); mydatatabel.Columns.Add("second_face"); mydatatabel.Columns.Add("container_name"); mydatatabel.Columns.Add("no_items_per_container"); mydatatabel.Columns.Add("total_no_items"); mydatatabel.Columns.Add("usage"); mydatatabel.Columns.Add("addition_date"); try { myconnection.openConnection(); SqlCommand cmd = new SqlCommand("SH_GET_ALL_SH_SPECIFICATION_OF_PEEL_OFF", DatabaseConnection.mConnection); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); long counter = 0; while (reader.Read()) { counter++; string[] mydata = new string[12]; mydata[0] = counter.ToString(); mydata[1] = reader["SH_RAW_MATERIAL_TYPE"].ToString(); mydata[2] = reader["SH_PRINTING_TYPE_NAME"].ToString(); if (long.Parse(reader["SH_PRINTING_TYPE"].ToString()) == 0) { mydata[3] = reader["SIZE_NAME"].ToString(); mydata[4] = reader["CLIENT_NAME"].ToString(); mydata[5] = reader["CLIENT_PRODUCT_NAME"].ToString(); mydata[6] = reader["PRODUCT_SECOND_FACE"].ToString(); } else { mydata[3] = reader["SIZE_NAME"].ToString(); mydata[4] = "عام"; mydata[5] = reader["FIRST_FACE"].ToString(); mydata[6] = reader["SECOND_FACE"].ToString(); } mydata[7] = reader["SH_CONTAINER_NAME"].ToString(); if (string.Compare(reader["SH_CONTAINER_NAME"].ToString(), "بالتة") == 0) { total_no_pallets += long.Parse(reader["NUMBER_OF_CONTAINERS"].ToString()); } else { total_no_cartons += long.Parse(reader["NUMBER_OF_CONTAINERS"].ToString()); } total_no_containers += long.Parse(reader["NUMBER_OF_CONTAINERS"].ToString()); mydata[8] = (long.Parse(reader["NO_ITEMS"].ToString()) / long.Parse(reader["NUMBER_OF_CONTAINERS"].ToString())).ToString(); total_no_items += long.Parse(reader["NO_ITEMS"].ToString()); mydata[9] = reader["NO_ITEMS"].ToString(); mydata[10] = reader["SH_USAGE"].ToString(); mydata[11] = reader["SH_ADDITION_DATE"].ToString(); mydatatabel.Rows.Add(mydata); } reader.Close(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING BOTTOM INFO " + ex.ToString()); } ReportParameter[] myparams = new ReportParameter[6]; myparams[0] = new ReportParameter("total_no_items", total_no_items.ToString(), false); myparams[1] = new ReportParameter("total_no_containers", total_no_containers.ToString(), false); myparams[2] = new ReportParameter("total_no_pallets", total_no_pallets.ToString(), false); myparams[3] = new ReportParameter("total_no_cartons", total_no_cartons.ToString(), false); myparams[4] = new ReportParameter("report_presenter_name", mEmployee.SH_EMPLOYEE_NAME, false); myparams[5] = new ReportParameter("doc_title_text", "الأرصدة من المنتج التام ( إيزى أوبن )", false); this.reportViewer1.LocalReport.SetParameters(myparams); ReportDataSource rds = new ReportDataSource("DataSet1", mydatatabel); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(rds); this.reportViewer1.RefreshReport(); }
void save_raw_tin_quantites(long specification_id) { for (int i = 0; i < quantities.Count; i++) { try { string query = "INSERT INTO SH_QUANTITY_OF_RAW_MATERIAL "; query += "(SH_SPECIFICATION_OF_RAW_MATERIAL_ID, SH_ITEM_LENGTH, SH_ITEM_WIDTH,"; query += "SH_ITEM_THICKNESS, SH_ITEM_INTENSITY, SH_ITEM_TEMPER, SH_ITEM_FINISH, "; query += "SH_ITEM_COATING, SH_ITEM_TYPE,SH_ITEM_NAME, "; query += "SH_ITEM_CODE, SH_ITEM_SHEET_WEIGHT, SH_TOTAL_NUMBER_OF_PACKAGES, "; query += "SH_TOTAL_NUMBER_OF_SHEETS_OF_PACKAGE, SH_NET_WEIGHT,"; query += " SH_STOCK_NAME, SH_ADDITION_DATE, SH_ITEM_GROSS_WEIGHT, "; query += " SH_DATA_ENTRY_USER_ID, SH_DATA_ENTRY_USER_NAME, SH_DATA_ENTRY_EMPLOYEE_ID, SH_DATA_ENTRY_EMPLOYEE_NAME"; query += ") VALUES("; query += "@SH_SPECIFICATION_OF_RAW_MATERIAL_ID,@SH_ITEM_LENGTH,@SH_ITEM_WIDTH,@SH_ITEM_THICKNESS"; query += ",@SH_ITEM_INTENSITY,@SH_ITEM_TEMPER,@SH_ITEM_FINISH,@SH_ITEM_COATING,@SH_ITEM_TYPE"; query += ",@SH_ITEM_NAME,@SH_ITEM_CODE,@SH_ITEM_SHEET_WEIGHT,@SH_TOTAL_NUMBER_OF_PACKAGES,"; query += "@SH_TOTAL_NUMBER_OF_SHEETS_OF_PACKAGE,@SH_NET_WEIGHT,@SH_STOCK_NAME,@SH_ADDITION_DATE,"; query += "@SH_ITEM_GROSS_WEIGHT , "; query += " @SH_DATA_ENTRY_USER_ID, @SH_DATA_ENTRY_USER_NAME, @SH_DATA_ENTRY_EMPLOYEE_ID, @SH_DATA_ENTRY_EMPLOYEE_NAME"; query += ") SELECT SCOPE_IDENTITY() AS myidentity"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", specification_id); cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", double.Parse(item_length_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", double.Parse(item_width_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", double.Parse(item_thickness_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_INTENSITY", double.Parse(item_intensity_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", item_temper_combo_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", item_finish_combo_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_COATING", item_coating_text_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", item_type_combo_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_NAME", "صفيح"); cmd.Parameters.AddWithValue("@SH_ITEM_CODE", item_code_text_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_SHEET_WEIGHT", double.Parse(item_sheet_weight_text_box.Text)); cmd.Parameters.AddWithValue("@SH_TOTAL_NUMBER_OF_PACKAGES", quantities[i].SH_TOTAL_NUMBER_OF_PACKAGES); cmd.Parameters.AddWithValue("@SH_TOTAL_NUMBER_OF_SHEETS_OF_PACKAGE", quantities[i].SH_TOTAL_NUMBER_OF_SHEETS_OF_PACKAGE); cmd.Parameters.AddWithValue("@SH_NET_WEIGHT", quantities[i].SH_NET_WEIGHT); cmd.Parameters.AddWithValue("@SH_STOCK_NAME", quantities[i].SH_STOCK_NAME); cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", DateTime.Parse(addition_date_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_GROSS_WEIGHT", quantities[i].SH_ITEM_GROSS_WEIGHT); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_NAME ", mAccount.SH_EMP_USER_NAME); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mAccount.SH_EMP_ID); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_NAME", mAccount.SH_EMP_NAME); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { //MessageBox.Show("Quantity : "+reader["myidentity"].ToString()); save_raw_tin_packages(specification_id, i, long.Parse(reader["myidentity"].ToString()), quantities[i].SH_TOTAL_NUMBER_OF_PACKAGES); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE SAVING IN SH_QUANTITY_OF_RAW_MATERIAL" + ex.ToString()); } } }
async Task getstocksmantoexamination() { stock_men.Clear(); try { string query = "SELECT EMP.* FROM SH_EMPLOYEES EMP "; query += " LEFT JOIN SH_DEPARTEMENTS DPT ON "; query += " DPT.SH_ID = EMP.SH_DEPARTMENT_ID "; query += " WHERE DPT.SH_DEPARTEMNT_NAME LIKE N'%مخازن%' "; myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { stock_men.Add(new SH_EMPLOYEES() { SH_DATA_ENTRY_EMPLOYEE_ID = long.Parse(reader["SH_DATA_ENTRY_EMPLOYEE_ID"].ToString()), SH_DATA_ENTRY_EMPLOYEE_NAME = reader["SH_DATA_ENTRY_EMPLOYEE_NAME"].ToString(), SH_DATA_ENTRY_USER_ID = long.Parse(reader["SH_DATA_ENTRY_USER_ID"].ToString()), SH_DATA_ENTRY_USER_NAME = reader["SH_DATA_ENTRY_USER_NAME"].ToString(), SH_DEPARTMENT_ID = long.Parse(reader["SH_DEPARTMENT_ID"].ToString()), SH_DEPARTMENT_NAME = reader["SH_DEPARTMENT_NAME"].ToString(), SH_EMPLOYEE_ADDRESS = reader["SH_EMPLOYEE_ADDRESS"].ToString(), SH_EMPLOYEE_EMAIL = reader["SH_EMPLOYEE_EMAIL"].ToString(), SH_EMPLOYEE_FUNCTION_ID = long.Parse(reader["SH_EMPLOYEE_FUNCTION_ID"].ToString()), SH_EMPLOYEE_FUNCTION_NAME = reader["SH_EMPLOYEE_FUNCTION_NAME"].ToString(), SH_EMPLOYEE_GENDER = reader["SH_EMPLOYEE_GENDER"].ToString(), SH_EMPLOYEE_MOBILE = reader["SH_EMPLOYEE_MOBILE"].ToString(), SH_EMPLOYEE_NAME = reader["SH_EMPLOYEE_NAME"].ToString(), SH_EMPLOYEE_NATIONAL_ID = reader["SH_EMPLOYEE_NATIONAL_ID"].ToString(), SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_EMPLOYEMENT_DATE = DateTime.Parse(reader["SH_EMPLOYEMENT_DATE"].ToString()) }); } reader.Close(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING STOCK_MEN " + ex.ToString()); } if (stock_men.Count > 0) { monitors_one.Items.Clear(); monitors_two.Items.Clear(); monitor_one_combo_box.Items.Clear(); monitor_two_combo_box.Items.Clear(); for (int i = 0; i < stock_men.Count; i++) { monitors_one.Items.Add(stock_men[i].SH_EMPLOYEE_NAME); monitors_two.Items.Add(stock_men[i].SH_EMPLOYEE_NAME); monitor_one_combo_box.Items.Add(stock_men[i].SH_EMPLOYEE_NAME); monitor_two_combo_box.Items.Add(stock_men[i].SH_EMPLOYEE_NAME); } } }
async Task getmuranmaterialdata() { bool client = false; string client_q = ""; bool product = false; string product_q = ""; if (string.IsNullOrWhiteSpace(client_name_combo_box.Text)) { client = false; } else { client = true; client_q = "AND SH_CLIENT_ID = @SH_CLIENT_ID"; } //if (string.IsNullOrWhiteSpace(client_products_combo_box.Text)) //{ // product = false; //} //else //{ // product = true; // product_q = " AND SH_CLIENT_PRODUCT_ID = @SH_CLIENT_PRODUCT_ID"; //} try { myconnection.openConnection(); string query = "SELECT * FROM SH_SPECIFICATION_OF_MURAN_MATERIAL WHERE 1=1 " + client_q; SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); if (client) { cmd.Parameters.AddWithValue("@SH_CLIENT_ID", clients[client_name_combo_box.SelectedIndex].SH_ID); } SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { materials.Add(new client_material_balance_items() { container_name = "طرد", material_name = "صفيح مطبوع", no_of_containers = long.Parse(reader["SH_ITEM_TOTAL_NUMBER_OF_PACKAGES"].ToString()), total_no_items = long.Parse(reader["SH_ITEM_TOTAL_NUMBER_OF_SHEETS"].ToString()) }); } reader.Close(); myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING MURAN MATERIAL INFO " + ex.ToString()); } }
private void bttnSave_Click(object sender, EventArgs e) { if (WithErrors() == true) { MessageBox.Show("من فضلك اكمل باقى البيانات"); } else { if (txtTitle.Text.Trim() != "") { if (strFilePath == "") { if (ImageByteArray.Length != 0) { ImageByteArray = new byte[] { } } ; } else { Image temp = new Bitmap(strFilePath); MemoryStream strm = new MemoryStream(); temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg); ImageByteArray = strm.ToArray(); } try { string query = "INSERT INTO SH_EMPLOYEES "; query += "(SH_EMPLOYEE_NAME, SH_EMPLOYEE_NATIONAL_ID, SH_EMPLOYEE_ADDRESS, SH_EMPLOYEE_MOBILE, SH_EMPLOYEE_GENDER, SH_EMPLOYEE_EMAIL, SH_EMPLOYEMENT_DATE, SH_EMPLOYEE_FUNCTION_ID,"; query += " SH_EMPLOYEE_FUNCTION_NAME, SH_DATA_ENTRY_USER_ID,SH_DATA_ENTRY_USER_NAME, SH_DATA_ENTRY_EMPLOYEE_ID, SH_DATA_ENTRY_EMPLOYEE_NAME ,SH_DEPARTMENT_ID ,SH_DEPARTMENT_NAME ,SH_EMPLOYEE_IMAGE "; query += " , SH_SOCIAL_INSURANCE_NUMBER ,SH_HEALTH_INSURANCE_NUMBER )"; query += " VALUES(@SH_EMPLOYEE_NAME,@SH_EMPLOYEE_NATIONAL_ID,@SH_EMPLOYEE_ADDRESS,@SH_EMPLOYEE_MOBILE,@SH_EMPLOYEE_GENDER,@SH_EMPLOYEE_EMAIL,@SH_EMPLOYEMENT_DATE,@SH_EMPLOYEE_FUNCTION_ID,"; query += " @SH_EMPLOYEE_FUNCTION_NAME,@SH_DATA_ENTRY_USER_ID,@SH_DATA_ENTRY_USER_NAME,@SH_DATA_ENTRY_EMPLOYEE_ID,@SH_DATA_ENTRY_EMPLOYEE_NAME , @SH_DEPARTMENT_ID , @SH_DEPARTMENT_NAME , @SH_EMPLOYEE_IMAGE "; query += " , @SH_SOCIAL_INSURANCE_NUMBER ,@SH_HEALTH_INSURANCE_NUMBER )"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand comm = new SqlCommand(query, DatabaseConnection.mConnection); comm.Parameters.AddWithValue("@SH_EMPLOYEE_NAME", txtEmpName.Text); comm.Parameters.AddWithValue("@SH_EMPLOYEE_NATIONAL_ID", txtEmpNationalID.Text); comm.Parameters.AddWithValue("@SH_EMPLOYEE_ADDRESS", txtEmpAddress.Text); if (radioFemale.Checked == true) { comm.Parameters.AddWithValue("@SH_EMPLOYEE_GENDER", radioFemale.Text); } else if (radioMale.Checked == true) { comm.Parameters.AddWithValue("@SH_EMPLOYEE_GENDER", radioMale.Text); } else { MessageBox.Show("ادخل نوع الموظف"); } comm.Parameters.AddWithValue("@SH_EMPLOYEE_MOBILE", txtEmpMobile.Text); comm.Parameters.AddWithValue("@SH_EMPLOYEE_EMAIL", txtEmpEmail.Text); comm.Parameters.AddWithValue("@SH_EMPLOYEMENT_DATE", Convert.ToDateTime(dateTimePicker1.Text)); comm.Parameters.AddWithValue("@SH_EMPLOYEE_FUNCTION_ID", jobList[comboBoxFn.SelectedIndex].SH_ID); comm.Parameters.AddWithValue("@SH_EMPLOYEE_FUNCTION_NAME", jobList[comboBoxFn.SelectedIndex].SH_FUNCTION_NAME); comm.Parameters.AddWithValue("@SH_DEPARTMENT_ID", deptList[comboBoxDept.SelectedIndex].SH_ID); comm.Parameters.AddWithValue("@SH_DEPARTMENT_NAME", deptList[comboBoxDept.SelectedIndex].SH_DEPARTEMNT_NAME); comm.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", maccount.SH_ID); comm.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_NAME", maccount.SH_EMP_NAME); comm.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", memployee.SH_ID); comm.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_NAME", memployee.SH_EMPLOYEE_NAME); comm.Parameters.AddWithValue("@SH_EMPLOYEE_IMAGE", ImageByteArray); comm.Parameters.AddWithValue("@SH_SOCIAL_INSURANCE_NUMBER", social_insurance_number_text_box.Text); comm.Parameters.AddWithValue("@SH_HEALTH_INSURANCE_NUMBER", health_insurance_number_text_box.Text); comm.ExecuteNonQuery(); myconnection.closeConnection(); MessageBox.Show(" تم تسجيل الموظف بنجاح"); // bttnSave.Enabled = false; } catch (Exception ex) { MessageBox.Show("ERROR WHILE ADDING NEW EMPLOYEES " + ex.Message); } } } } void getDeptID() { try { string query = "select * from SH_FUNCTION where SH_DEPARTEMENT_ID=@id"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@id", deptList[comboBoxDept.SelectedIndex].SH_ID); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { jobList.Add(new SH_FUNCTION() { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_DEPARTEMENT_NAME = reader["SH_DEPARTEMENT_NAME"].ToString(), SH_DEPARTEMENT_ID = long.Parse(reader["SH_DEPARTEMENT_ID"].ToString()), SH_FUNCTION_NAME = reader["SH_FUNCTION_NAME"].ToString() }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("error in getting deptID" + ex.ToString()); } } void fillJobCombobox() { jobList.Clear(); comboBoxFn.Items.Clear(); getDeptID(); if (jobList.Count <= 0) { } else { for (int i = 0; i < jobList.Count; i++) { comboBoxFn.Items.Add(jobList[i].SH_FUNCTION_NAME); } } }
private async void save_company_btn_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(client_company_fax_number_text_box.Text) || string.IsNullOrEmpty(company_telephone_text_box.Text) || string.IsNullOrEmpty(company_telephone_text_box.Text)) { MessageBox.Show("إملاء البيانات من فضلك", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } else { if ((errorProvider1.GetError(company_telephone_text_box) == "") && (errorProvider1.GetError(company_telephone_text_box) == "")) { if (mclient == null) { //new client if (await check_if_name_exits_or_not()) { MessageBox.Show("هذا العميل تم إضافته مسبقا", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } else { string company_type_text_box = ""; if (national_client_radio_btn.Checked) { company_type_text_box = "محلى"; } else { company_type_text_box = "دولى"; } string query = "INSERT INTO SH_CLIENT_COMPANY"; query += " (SH_CLIENT_COMPANY_NAME, SH_CLIENT_COMPANY_TYPE,"; query += " SH_CLIENT_COMPANY_TELEPHONE, "; query += " SH_CLIENT_COMPANY_FAX_NUMBER,SH_CLIENT_COMPANY_MOBILE "; query += ", SH_DATA_ENTRY_USER_ID,SH_DATA_ENTRY_EMPLOYEE_ID,SH_ADDITION_DATE "; query += " ) VALUES "; query += " (@SH_CLIENT_COMPANY_NAME,@SH_CLIENT_COMPANY_TYPE,@SH_CLIENT_COMPANY_TELEPHONE , "; query += " @SH_CLIENT_COMPANY_FAX_NUMBER,@SH_CLIENT_COMPANY_MOBILE "; query += " , @SH_DATA_ENTRY_USER_ID,@SH_DATA_ENTRY_EMPLOYEE_ID,@SH_ADDITION_DATE "; query += " ) "; try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_NAME", company_name_text_box.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_TYPE", company_type_text_box); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_TELEPHONE", company_telephone_text_box.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_FAX_NUMBER", client_company_fax_number_text_box.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_MOBILE", textBoxMobile.Text); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mAccount.SH_EMP_ID); cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", DateTime.Now); cmd.ExecuteNonQuery(); myconnection.closeConnection(); MessageBox.Show("تم الحفظ بنجاح", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); company_name_text_box.Text = ""; company_telephone_text_box.Text = ""; client_company_fax_number_text_box.Text = ""; } catch (Exception ex) { MessageBox.Show("ERROR WHILE SAVING CLIENT COMPANY" + ex.ToString()); } } } else //edite client data { if (await check_if_name_exits_or_not()) { MessageBox.Show("هذا العميل تم إضافته مسبقا", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } else { string company_type_text_box = ""; if (national_client_radio_btn.Checked) { company_type_text_box = "محلى"; } else { company_type_text_box = "دولى"; } string query = " UPDATE SH_CLIENT_COMPANY SET SH_CLIENT_COMPANY_NAME = @SH_CLIENT_COMPANY_NAME, "; query += "SH_CLIENT_COMPANY_TYPE = @SH_CLIENT_COMPANY_TYPE, SH_CLIENT_COMPANY_TELEPHONE = @SH_CLIENT_COMPANY_TELEPHONE, "; query += " SH_DATA_ENTRY_USER_ID = @SH_DATA_ENTRY_USER_ID, "; query += " SH_DATA_ENTRY_EMPLOYEE_ID = @SH_DATA_ENTRY_EMPLOYEE_ID ,"; query += " SH_ADDITION_DATE = @SH_ADDITION_DATE , "; query += " SH_CLIENT_COMPANY_MOBILE = @SH_CLIENT_COMPANY_MOBILE, "; query += " SH_CLIENT_COMPANY_FAX_NUMBER = @SH_CLIENT_COMPANY_FAX_NUMBER WHERE SH_ID = @SH_ID "; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_NAME", company_name_text_box.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_TYPE", company_type_text_box); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_TELEPHONE", company_telephone_text_box.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_FAX_NUMBER", client_company_fax_number_text_box.Text); cmd.Parameters.AddWithValue("@SH_ID", mclient.SH_ID); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mAccount.SH_EMP_ID); cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", DateTime.Now); cmd.ExecuteNonQuery(); myconnection.closeConnection(); MessageBox.Show("تم التعديل بنجاح", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); company_name_text_box.Text = ""; company_telephone_text_box.Text = ""; client_company_fax_number_text_box.Text = ""; } } } else { MessageBox.Show("لا يمكن حفظ البيانات \n الرجاء التاكد من كتابة البيانات بشكل صحيح ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } } }
void updatequantitysp_id(long sp_old_id, long sp_new_id) { List <SH_QUANTITY_OF_RAW_MATERIAL> quantities = new List <SH_QUANTITY_OF_RAW_MATERIAL>(); try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("SELECT * FROM SH_QUANTITY_OF_RAW_MATERIAL WHERE SH_SPECIFICATION_OF_RAW_MATERIAL_ID = @SH_SPECIFICATION_OF_RAW_MATERIAL_ID", DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", sp_old_id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { quantities.Add(new SH_QUANTITY_OF_RAW_MATERIAL { SH_ID = long.Parse(reader["SH_ID"].ToString()) }); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING ALL QUANTITY IDs" + ex.ToString()); } //updatingwithnew sp_new_id for (int i = 0; i < quantities.Count; i++) { try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("UPDATE SH_QUANTITY_OF_RAW_MATERIAL SET SH_SPECIFICATION_OF_RAW_MATERIAL_ID = @SH_SPECIFICATION_OF_RAW_MATERIAL_ID WHERE SH_ID = @SH_ID ", DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", sp_new_id); cmd.Parameters.AddWithValue("@SH_ID", quantities[i].SH_ID); cmd.ExecuteNonQuery(); myconnection.closeConnection(); } catch (Exception) { MessageBox.Show("ERROR WHILE UPDATING QUANTITIES SP_ID"); } } List <SH_RAW_MATERIAL_PARCEL> parcels = new List <SH_RAW_MATERIAL_PARCEL>(); //getting all old parcels that have the infection ; try { DatabaseConnection MYCONNECTION = new DatabaseConnection(); MYCONNECTION.openConnection(); SqlCommand cmd = new SqlCommand("SELECT * FROM SH_RAW_MATERIAL_PARCEL WHERE SH_SPECIFICATION_OF_RAW_MATERIAL_ID = @SH_SPECIFICATION_OF_RAW_MATERIAL_ID", DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", sp_old_id); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { parcels.Add(new SH_RAW_MATERIAL_PARCEL { SH_ID = long.Parse(reader["SH_ID"].ToString()) }); } MYCONNECTION.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GEETING INFECTED PARCELS WHITH old SP_OLD_ID" + ex.ToString()); } //Correction of infected parcels for (int i = 0; i < parcels.Count; i++) { try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("UPDATE SH_RAW_MATERIAL_PARCEL SET SH_SPECIFICATION_OF_RAW_MATERIAL_ID = @SH_SPECIFICATION_OF_RAW_MATERIAL_ID WHERE SH_ID = @SH_ID ", DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", sp_new_id); cmd.Parameters.AddWithValue("@SH_ID", parcels[i].SH_ID); cmd.ExecuteNonQuery(); myconnection.closeConnection(); } catch (Exception) { MessageBox.Show("ERROR WHILE UPDATING QUANTITIES SP_ID"); } } }
long savetofirstduration_rawtin() { if (!((errorProvider1.GetError(item_length_text_box) == "") && (errorProvider1.GetError(item_width_text_box) == "") && (errorProvider1.GetError(item_thickness_text_box) == "") && (errorProvider1.GetError(item_coating_text_box) == ""))) { MessageBox.Show("لا يمكن حفظ البيانات \n الرجاء التاكد من كتابة البيانات بشكل صحيح ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } else { //MessageBox.Show("hello"); try { string query = "INSERT INTO SH_SPECIFICATION_OF_RAW_MATERIAL"; query += "(SH_ITEM_LENGTH, SH_ITEM_WIDTH, SH_ITEM_THICKNESS, SH_ITEM_TYPE, "; query += "SH_ITEM_NAME, SH_ITEM_CODE, SH_ITEM_TEMPER, SH_ITEM_FINISH, SH_ITEM_COATING,"; query += "SH_ITEM_INTENSITY,SH_ITEM_TOTAL_NUMBER_OF_PACKAGES, SH_CREATION_DATE , "; query += "SH_ITEM_TOTAL_NUMBER_OF_SHEETS , SH_TOTAL_NET_WEIGHT , SH_TOTAL_GROSS_WEIGHT "; query += ", SH_DATA_ENTRY_USER_ID, SH_DATA_ENTRY_USER_NAME, SH_DATA_ENTRY_EMPLOYEE_ID, SH_DATA_ENTRY_EMPLOYEE_NAME)"; query += " VALUES(@SH_ITEM_LENGTH ,@SH_ITEM_WIDTH,"; query += "@SH_ITEM_THICKNESS, @SH_ITEM_TYPE, @SH_ITEM_NAME, @SH_ITEM_CODE, @SH_ITEM_TEMPER , "; query += "@SH_ITEM_FINISH,@SH_ITEM_COATING,@SH_ITEM_INTENSITY,@SH_ITEM_TOTAL_NUMBER_OF_PACKAGES "; query += ", @SH_CREATION_DATE"; query += ",@SH_ITEM_TOTAL_NUMBER_OF_SHEETS , @SH_TOTAL_NET_WEIGHT , @SH_TOTAL_GROSS_WEIGHT "; query += ", @SH_DATA_ENTRY_USER_ID, @SH_DATA_ENTRY_USER_NAME, @SH_DATA_ENTRY_EMPLOYEE_ID, @SH_DATA_ENTRY_EMPLOYEE_NAME)"; query += "SELECT SCOPE_IDENTITY() AS myidentity"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", double.Parse(item_length_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", double.Parse(item_width_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", double.Parse(item_thickness_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", item_type_combo_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_NAME", "صفيح"); cmd.Parameters.AddWithValue("@SH_ITEM_CODE", item_code_text_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", item_temper_combo_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", item_finish_combo_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_COATING", item_coating_text_box.Text); cmd.Parameters.AddWithValue("@SH_ITEM_INTENSITY", double.Parse(item_intensity_text_box.Text)); cmd.Parameters.AddWithValue("@SH_CREATION_DATE", DateTime.Parse(addition_date_text_box.Text)); cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_PACKAGES", total_no_packges); cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_SHEETS", all_packages_no_sheets); cmd.Parameters.AddWithValue("@SH_TOTAL_NET_WEIGHT", (((double.Parse(item_length_text_box.Text) * double.Parse(item_width_text_box.Text) * double.Parse(item_thickness_text_box.Text)) / 1000000) * double.Parse(item_intensity_text_box.Text)) * double.Parse(all_packages_no_sheets.ToString())); cmd.Parameters.AddWithValue("@SH_TOTAL_GROSS_WEIGHT", all_packages_gross_weight); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_NAME ", mAccount.SH_EMP_USER_NAME); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mAccount.SH_EMP_ID); cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_NAME", mAccount.SH_EMP_NAME); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { // MessageBox.Show("GENERAL : "+ reader["myidentity"].ToString()); return(long.Parse(reader["myidentity"].ToString())); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("failed to save to SH_SPECIFICATION_OF_RAW_MATERIAL " + ex.ToString()); } return(0); } return(0); }