private void save_new_client_product_btn_Click(object sender, EventArgs e) { bool saveornot = true; if (string.IsNullOrEmpty(product_name_text_box.Text)) { MessageBox.Show(" الرجاء ادخال إسم الصنف ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); saveornot = false; } else { if (string.IsNullOrEmpty(faces_combo_box.Text)) { MessageBox.Show("الرجاء إختيار الوجة الثانى ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); saveornot = false; } else if (!(body_radio_btn.Checked || bottom_radio_btn.Checked || head_radio_btn.Checked || twist_of_radio_btn.Checked || easy_open_rado_btn.Checked)) { MessageBox.Show("الرجاء إختيار نوع الطباعة ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); saveornot = false; } else { if (string.IsNullOrEmpty(height_text_box.Text)) { if (body_radio_btn.Checked) { MessageBox.Show("الرجاء إدخال إرتقاع العلبة", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); saveornot = false; } else { height_text_box.Text = 0.ToString(); } } //else if (string.IsNullOrEmpty(capacity_tect_box.Text)) //{ // MessageBox.Show("الرجاء إدخال السعة بالجرامات", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); // saveornot = false; //} else if (string.IsNullOrEmpty(sizes_combo_box.Text)) { MessageBox.Show("الرجاء إختيار المقاس", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); saveornot = false; } else { if (saveornot) { if (check_if_product_exists_or_not() == 1) { MessageBox.Show("هذا الصنف موجود", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } else { try { string query = "INSERT INTO SH_CLIENTS_PRODUCTS "; query += "(SH_CLIENT_NAME, SH_CLIENT_ID, SH_PRODUCT_NAME, "; query += " SH_PRINTING_TYPE, SH_BOTTLE_CAPACITY, SH_BOTTLE_HEIGHT , "; query += " SH_SECOND_FACE_ID , SH_SECOND_FACE_NAME , SH_SIZE_ID ,"; query += " SH_SIZE_NAME , SH_TWIST_SIZE_ID,SH_TWIST_SIZE_NAME, "; query += "SH_TWIST_TYPE,SH_TWIST_TYPE_ID,SH_TWIST_TYPE_KIND "; query += " , SH_DATA_ENTRY_USER_ID,SH_DATA_ENTRY_EMPLOYEE_ID,SH_ADDITION_DATE"; query += ")"; query += " VALUES(@SH_CLIENT_NAME,@SH_CLIENT_ID,@SH_PRODUCT_NAME,"; query += " @SH_PRINTING_TYPE,@SH_BOTTLE_CAPACITY,@SH_BOTTLE_HEIGHT, "; query += " @SH_SECOND_FACE_ID , @SH_SECOND_FACE_NAME , @SH_SIZE_ID , "; query += " @SH_SIZE_NAME, @SH_TWIST_SIZE_ID,@SH_TWIST_SIZE_NAME "; query += ",@SH_TWIST_TYPE,@SH_TWIST_TYPE_ID,@SH_TWIST_TYPE_KIND "; query += " , @SH_DATA_ENTRY_USER_ID,@SH_DATA_ENTRY_EMPLOYEE_ID,@SH_ADDITION_DATE"; query += " )"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_CLIENT_NAME", mclient.SH_CLIENT_COMPANY_NAME); cmd.Parameters.AddWithValue("@SH_CLIENT_ID", mclient.SH_ID); cmd.Parameters.AddWithValue("@SH_PRODUCT_NAME", product_name_text_box.Text); cmd.Parameters.AddWithValue("@SH_PRINTING_TYPE", getprintingtype()); cmd.Parameters.AddWithValue("@SH_SECOND_FACE_NAME", faces_combo_box.Text); cmd.Parameters.AddWithValue("@SH_SECOND_FACE_ID", FACES[faces_combo_box.SelectedIndex].SH_ID); if (twist_of_radio_btn.Checked) { cmd.Parameters.AddWithValue("@SH_BOTTLE_CAPACITY", 0); cmd.Parameters.AddWithValue("@SH_BOTTLE_HEIGHT", 0); cmd.Parameters.AddWithValue("@SH_SIZE_ID", 0); cmd.Parameters.AddWithValue("@SH_SIZE_NAME", 0); cmd.Parameters.AddWithValue("@SH_TWIST_SIZE_ID", twist_of_sizes[sizes_combo_box.SelectedIndex].SH_ID); cmd.Parameters.AddWithValue("@SH_TWIST_SIZE_NAME", twist_of_sizes[sizes_combo_box.SelectedIndex].SH_TWIST_OF_SIZE_VALUE); cmd.Parameters.AddWithValue("@SH_TWIST_TYPE", twist_of_types[capacity_tect_box.SelectedIndex].SH_SHORT_TITLE); cmd.Parameters.AddWithValue("@SH_TWIST_TYPE_ID", twist_of_types[capacity_tect_box.SelectedIndex].SH_ID); cmd.Parameters.AddWithValue("@SH_TWIST_TYPE_KIND", item_types[height_text_box.SelectedIndex]); } else { cmd.Parameters.AddWithValue("@SH_BOTTLE_CAPACITY", 0); cmd.Parameters.AddWithValue("@SH_BOTTLE_HEIGHT", double.Parse(height_text_box.Text)); cmd.Parameters.AddWithValue("@SH_SIZE_ID", mSizes[sizes_combo_box.SelectedIndex].SH_ID); cmd.Parameters.AddWithValue("@SH_SIZE_NAME", mSizes[sizes_combo_box.SelectedIndex].SH_SIZE_NAME); cmd.Parameters.AddWithValue("@SH_TWIST_SIZE_ID", 0); cmd.Parameters.AddWithValue("@SH_TWIST_SIZE_NAME", 0); cmd.Parameters.AddWithValue("@SH_TWIST_TYPE", 0); cmd.Parameters.AddWithValue("@SH_TWIST_TYPE_ID", 0); cmd.Parameters.AddWithValue("@SH_TWIST_TYPE_KIND", 0); } 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(); mproduct.Clear(); getallclientproducts(); productsgridview(); MessageBox.Show("تم الحفظ بنجاح", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } catch (Exception ex) { MessageBox.Show("ERROR WHILE SAVING PRODUCT FOR A CLIENT " + ex.ToString()); } } } } } } }
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 savenewquantityofmurantin(long muran_sp_id) { if (quantities.Count > 0) { for (int i = 0; i < quantities.Count; i++) { try { string query = "INSERT INTO SH_QUANTITY_OF_MURAN_MATERIAL "; query += "(SH_SPECIFICATION_OF_MURAN_MATERIAL_ID, SH_ITEM_LENGTH, SH_ITEM_WIDTH, SH_ITEM_THICKNESS, SH_ITEM_TYPE, SH_ITEM_NAME, SH_ITEM_CODE, SH_ITEM_INTENSITY,"; query += "SH_ITEM_SHEET_WEIGHT, SH_ITEM_PACKAGE_NET_WEIGHT, SH_ITEM_NUMBER_OF_PACKAGES, SH_ITEM_TOTAL_NUMBER_OF_SHEETS, SH_QUANTITY_NET_WEIGHT, SH_QUANTITY_GROSS_WEIGHT,"; query += "SH_PACKAGE_GROSS_WEIGHT, SH_CLIENT_NAME, SH_STOCK_NAME, SH_ITEM_FIRST_FACE, SH_ITEM_SECOND_FACE, SH_MURAN_TYPE,"; query += " SH_BOTTLE_CAPACITY"; query += ", SH_BOTTLE_HEIGHT , SH_SIZE_ID , SH_SIZE_NAME ) VALUES( @SH_SPECIFICATION_OF_MURAN_MATERIAL_ID , @SH_ITEM_LENGTH , @SH_ITEM_WIDTH,@SH_ITEM_THICKNESS,@SH_ITEM_TYPE,@SH_ITEM_NAME,@SH_ITEM_CODE,@SH_ITEM_INTENSITY"; query += ",@SH_ITEM_SHEET_WEIGHT,@SH_ITEM_PACKAGE_NET_WEIGHT,@SH_ITEM_NUMBER_OF_PACKAGES,@SH_ITEM_TOTAL_NUMBER_OF_SHEETS,@SH_QUANTITY_NET_WEIGHT,@SH_QUANTITY_GROSS_WEIGHT"; query += ",@SH_PACKAGE_GROSS_WEIGHT,@SH_CLIENT_NAME,@SH_STOCK_NAME,@SH_ITEM_FIRST_FACE,@SH_ITEM_SECOND_FACE,@SH_MURAN_TYPE"; query += ",@SH_BOTTLE_CAPACITY, @SH_BOTTLE_HEIGHT , @SH_SIZE_ID , @SH_SIZE_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_MURAN_MATERIAL_ID", muran_sp_id); cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", quantities[i].SH_ITEM_LENGTH); cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", quantities[i].SH_ITEM_WIDTH); cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", quantities[i].SH_ITEM_THICKNESS); cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", quantities[i].SH_ITEM_TYPE); cmd.Parameters.AddWithValue("@SH_ITEM_NAME", "صفيح"); cmd.Parameters.AddWithValue("@SH_ITEM_CODE", quantities[i].SH_ITEM_CODE); cmd.Parameters.AddWithValue("@SH_ITEM_INTENSITY", quantities[i].SH_ITEM_INTENSITY); cmd.Parameters.AddWithValue("@SH_ITEM_SHEET_WEIGHT", quantities[i].SH_ITEM_SHEET_WEIGHT); cmd.Parameters.AddWithValue("@SH_ITEM_PACKAGE_NET_WEIGHT", quantities[i].SH_ITEM_PARCEL_NET_WEIGHT); cmd.Parameters.AddWithValue("@SH_ITEM_NUMBER_OF_PACKAGES", quantities[i].SH_ITEM_NUMBER_OF_PACKAGES); cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_SHEETS", quantities[i].SH_ITEM_TOTAL_NUMBER_OF_SHEETS); cmd.Parameters.AddWithValue("@SH_QUANTITY_NET_WEIGHT", quantities[i].SH_QUANTITY_NET_WEIGHT); cmd.Parameters.AddWithValue("@SH_QUANTITY_GROSS_WEIGHT", 0); cmd.Parameters.AddWithValue("@SH_PACKAGE_GROSS_WEIGHT", 0); cmd.Parameters.AddWithValue("@SH_CLIENT_NAME", quantities[i].SH_CLIENT_NAME); cmd.Parameters.AddWithValue("@SH_STOCK_NAME", quantities[i].SH_STOCK_NAME); cmd.Parameters.AddWithValue("@SH_ITEM_FIRST_FACE", quantities[i].SH_ITEM_FIRST_FACE); cmd.Parameters.AddWithValue("@SH_ITEM_SECOND_FACE", quantities[i].SH_ITEM_SECOND_FACE); cmd.Parameters.AddWithValue("@SH_MURAN_TYPE", quantities[i].SH_MURAN_TYPE); cmd.Parameters.AddWithValue("@SH_BOTTLE_HEIGHT", quantities[i].SH_BOTTLE_HEIGHT); cmd.Parameters.AddWithValue("@SH_BOTTLE_CAPACITY", quantities[i].SH_BOTTLE_CAPACITY); cmd.Parameters.AddWithValue("@SH_SIZE_ID", quantities[i].SH_SIZE_ID); cmd.Parameters.AddWithValue("@SH_SIZE_NAME", quantities[i].SH_SIZE_NAME); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { long q_id = long.Parse(reader["myidentity"].ToString()); savemurantinparcel(muran_sp_id, q_id, quantities[i].SH_ITEM_NUMBER_OF_PACKAGES, quantities[i]); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE SAVING QUANTITIES" + ex.ToString()); } } MessageBox.Show("تم الحفظ ", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } }
private void printeasyopentotalbalanceform_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_SPECIFICATION_OF_EASY_OPEN", 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(); }
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_MOLD ", 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_MOLD-"; 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_MOLD-"; 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; } }
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); } } }
private void search_btn_Click(object sender, EventArgs e) { Cursor.Current = Cursors.WaitCursor; parcels.Clear(); mtotal_number_of_parcels = 0; mtotal_number_of_sheets = 0; mtotoal_net_weight = 0; total_number_of_sheets.Text = 0.ToString(); total_number_of_packages.Text = 0.ToString(); total_net_weight_text_box.Text = 0.ToString(); 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; bool stock = false; string mlength = ""; string mwidth = ""; string mthickness = ""; string mtemper = ""; string mcaoting = ""; string mcode = ""; string mfinish = ""; string mtype = ""; string mStock = ""; if (string.IsNullOrEmpty(item_length_text_box.Text)) { mlength = " "; } else if (double.TryParse(item_length_text_box.Text, out testnumber)) { length = true; mlength = " AND ( 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 ( 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 ( SH_ITEM_THICKNESS = @SH_ITEM_THICKNESS )"; } else { mthickness = " "; } if (string.IsNullOrEmpty(stocks_combo_box.Text)) { mStock = " "; } else { stock = true; mStock = " AND ( SH_STOCK_NAME LIKE N'%" + stocks[stocks_combo_box.SelectedIndex].SH_STOCK_NAME + "%')"; } if (string.IsNullOrEmpty(tempet_combo_box.Text)) { mtemper = " "; } else { temper = true; mtemper = " AND ( SH_ITEM_TEMPER LIKE N'%" + item_temper[tempet_combo_box.SelectedIndex] + "%')"; } if (string.IsNullOrEmpty(item_code_text_box.Text)) { mcode = " "; } else { code = true; mcode = " AND ( SH_ITEM_CODE LIKE N'%" + item_code_text_box.Text + "%')"; } if (string.IsNullOrEmpty(finish_combo_box.Text)) { mfinish = " "; } else { finish = true; mfinish = "AND ( SH_ITEM_FINISH LIKE N'%" + item_finish[finish_combo_box.SelectedIndex] + "%')"; } if (string.IsNullOrEmpty(item_types_combo_box.Text)) { mtype = " "; type = false; } else { type = true; //OR SH_ITEM_TYPE LIKE N'% @SH_ITEM_TYPE %' OR SH_ITEM_TYPE LIKE N' @SH_ITEM_TYPE %' mtype = " AND ( SH_ITEM_TYPE LIKE N'%" + item_types[item_types_combo_box.SelectedIndex] + "%' )"; } if (string.IsNullOrEmpty(coating_text_box.Text)) { mcaoting = " "; } else { coating = true; mcaoting = " AND ( SH_ITEM_COATING LIKE N'%" + item_coating[coating_text_box.SelectedIndex] + "%')"; } //+mlength + mwidth + mthickness + mcode + mfinish + mtemper + mtype + mcaoting + try { // string query = "SELECT * FROM SH_RAW_MATERIAL_PARCEL WHERE (SH_ID NOT IN (SELECT SH_RAW_MATERIAL_PARCEL_ID FROM SH_PACKAGES_DISBURSED_RAW_MATERIAL) )" + mlength + mwidth + mthickness + mcode + mfinish + mtemper + mtype + mcaoting ; string query = "SELECT * FROM SH_RAW_MATERIAL_PARCEL WHERE SH_ID not in (SELECT SH_RAW_MATERIAL_PARCEL_ID FROM SH_PACKAGES_DISBURSED_RAW_MATERIAL )" + mlength + mwidth + mthickness + mcode + mfinish + mtemper + mtype + mcaoting + mStock; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); if (length) { cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", double.Parse(item_length_text_box.Text)); } if (width) { cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", double.Parse(item_width_text_box.Text)); } if (thickness) { cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", double.Parse(item_thickness_text_box.Text)); } if (code) { // cmd.Parameters.AddWithValue("@SH_ITEM_CODE", item_code_text_box.Text); } if (temper) { // cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", item_temper[tempet_combo_box.SelectedIndex]); } if (coating) { // cmd.Parameters.AddWithValue("@SH_ITEM_COATING",item_coating[coating_text_box.SelectedIndex]); } if (finish) { // cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", item_finish[finish_combo_box.SelectedIndex]); } if (type) { //MessageBox.Show(cmd.CommandText); // cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", item_types[item_types_combo_box.SelectedIndex]); } // MessageBox.Show(cmd.Parameters.ToString()); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { mtotal_number_of_parcels += 1; mtotal_number_of_sheets += long.Parse(reader["SH_ITEM_NUMBER_OF_SHEETS"].ToString()); parcels.Add(new SH_RAW_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_GROSS_WEIGHT = Math.Round(double.Parse(reader["SH_ITEM_PARCEL_GROSS_WEIGHT"].ToString()), 1), SH_ITEM_LENGTH = Math.Round(double.Parse(reader["SH_ITEM_LENGTH"].ToString()), 1), SH_ITEM_NUMBER_OF_SHEETS = long.Parse(reader["SH_ITEM_NUMBER_OF_SHEETS"].ToString()), SH_ITEM_PARCEL_GROSS_WEIGHT = Math.Round(double.Parse(reader["SH_ITEM_PARCEL_GROSS_WEIGHT"].ToString()), 1), SH_ITEM_PARCEL_NET_WEIGHT = Math.Round(double.Parse(reader["SH_ITEM_PARCEL_NET_WEIGHT"].ToString()), 1), SH_ITEM_SHEET_WEIGHT = Math.Round(double.Parse(reader["SH_ITEM_SHEET_WEIGHT"].ToString()), 1), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_WIDTH = Math.Round(double.Parse(reader["SH_ITEM_WIDTH"].ToString()), 1), SH_STOCK_NAME = reader["SH_STOCK_NAME"].ToString(), SH_SUPPLIER_NAME = reader["SH_SUPPLIER_NAME"].ToString() }); mtotoal_net_weight += double.Parse(reader["SH_ITEM_PARCEL_NET_WEIGHT"].ToString()); } total_number_of_sheets.Text = mtotal_number_of_sheets.ToString(); total_number_of_packages.Text = mtotal_number_of_parcels.ToString(); total_net_weight_text_box.Text = String.Format("{0:0,0.0}", mtotoal_net_weight); myconnection.closeConnection(); fillparcelsgridview(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING SEARCH RESULT FORM " + ex.ToString()); } finally { Cursor.Current = Cursors.WaitCursor; } }
private void search_btn_Click(object sender, EventArgs e) { parcels.Clear(); bool length = false; bool width = false; bool thickness = false; bool code = false; bool temper = false; bool coating = false; bool finish = false; bool no_sheets = false; bool type = false; bool first_face = false; bool second_face = false; bool _size = false; bool muran_type = false; string mlength = " "; string mwidth = " "; string mthickness = " "; string mcode = " "; string mtemper = " "; string mcoating = " "; string mfinish = " "; string mtype = " "; string mno_sheets = " "; string mfirst_face = " "; string msecond_face = " "; string msize = " "; string mmuran_type = " "; double testnumber = 0; long testnum = 0; if (string.IsNullOrEmpty(first_face_combo_box.Text)) { first_face = false; } else { first_face = true; mfirst_face = " AND (smmp.SH_ITEM_FIRST_FACE LIKE N'%@SH_ITEM_FIRST_FACE' OR smmp.SH_ITEM_FIRST_FACE LIKE N'%@SH_ITEM_FIRST_FACE%' OR smmp.SH_ITEM_FIRST_FACE LIKE N'@SH_ITEM_FIRST_FACE%' ) "; } if (string.IsNullOrEmpty(second_face_combo_box.Text)) { second_face = false; } else { second_face = false; msecond_face = " AND ( smmp.SH_ITEM_SECOND_FACE LIKE N'%@SH_ITEM_SECOND_FACE' OR smmp.SH_ITEM_SECOND_FACE LIKE N'%@SH_ITEM_SECOND_FACE%' OR smmp.SH_ITEM_SECOND_FACE LIKE N'@SH_ITEM_SECOND_FACE%' )"; } if (string.IsNullOrEmpty(item_length_text_box.Text)) { length = false; } else { if (double.TryParse(item_length_text_box.Text, out testnumber)) { length = true; mlength = " AND smmp.SH_ITEM_LENGTH = @SH_ITEM_LENGTH "; MessageBox.Show("test1"); } else { length = false; } } if (string.IsNullOrEmpty(item_width_text_box.Text)) { width = false; } else { if (double.TryParse(item_width_text_box.Text, out testnumber)) { width = true; mwidth = " AND smmp.SH_ITEM_WIDTH = @SH_ITEM_WIDTH "; } else { width = false; } } if (string.IsNullOrEmpty(item_thickness_text_box.Text)) { thickness = false; } else { if (double.TryParse(item_thickness_text_box.Text, out testnumber)) { thickness = true; mthickness = " AND smmp.SH_ITEM_THICKNESS = @SH_ITEM_THICKNESS "; } else { thickness = false; } } if (string.IsNullOrEmpty(item_finish_text_box.Text)) { finish = false; } else { finish = true; mfinish = " AND smmp.SH_ITEM_FINISH LIKE N'%@SH_ITEM_FINISH' OR smmp.SH_ITEM_FINISH LIKE N'%@SH_ITEM_FINISH%' OR smmp.SH_ITEM_FINISH LIKE N'@SH_ITEM_FINISH%' "; } if (string.IsNullOrEmpty(item_coating_text_box.Text)) { coating = false; } else { coating = true; mcoating = " AND smmp.SH_ITEM_COATING LIKE N'%@SH_ITEM_COATING' OR smmp.SH_ITEM_COATING LIKE N'%@SH_ITEM_COATING%' OR smmp.SH_ITEM_COATING LIKE N'@SH_ITEM_COATING%' "; } if (string.IsNullOrEmpty(item_code_text_box.Text)) { code = false; } else { code = true; mcode = " AND smmp.SH_ITEM_CODE LIKE N'%@SH_ITEM_CODE' OR smmp.SH_ITEM_CODE LIKE N'%@SH_ITEM_CODE%' OR smmp.SH_ITEM_CODE LIKE N'@SH_ITEM_CODE%' "; } if (string.IsNullOrEmpty(item_no_sheets_text_box.Text)) { no_sheets = false; } else { if (long.TryParse(item_no_sheets_text_box.Text, out testnum)) { no_sheets = true; mno_sheets = "AND smmp.SH_ITEM_NUMBER_OF_SHEETS = @SH_ITEM_NUMBER_OF_SHEETS "; } else { no_sheets = false; } } if (body_radio_btn.Checked) { muran_type = true; mmuran_type = " AND smmp.SH_MURAN_TYPE LIKE N'%@SH_MURAN_TYPE' OR smmp.SH_MURAN_TYPE LIKE N'%@SH_MURAN_TYPE%' OR smmp.SH_MURAN_TYPE LIKE N'@SH_MURAN_TYPE%'"; } else if (bottom_radio_btn.Checked) { muran_type = true; mmuran_type = " AND smmp.SH_MURAN_TYPE LIKE N'%@SH_MURAN_TYPE' OR smmp.SH_MURAN_TYPE LIKE N'%@SH_MURAN_TYPE%' OR smmp.SH_MURAN_TYPE LIKE N'@SH_MURAN_TYPE%'"; } else { muran_type = false; } if (string.IsNullOrEmpty(sizes_combo_box.Text)) { _size = false; } else { _size = true; msize = "AND smmp.SH_SIZE_NAME LIKE N'%@SH_SIZE_NAME' OR smmp.SH_SIZE_NAME LIKE N'%@SH_SIZE_NAME%' OR smmp.SH_SIZE_NAME LIKE N'@SH_SIZE_NAME%' "; } if (string.IsNullOrEmpty(item_type_text_box.Text)) { type = false; } else { type = true; mtype = "AND smmp.SH_ITEM_TYPE LIKE N'%@SH_ITEM_TYPE' OR smmp.SH_ITEM_TYPE LIKE N'%@SH_ITEM_TYPE%' OR smmp.SH_ITEM_TYPE LIKE N'@SH_ITEM_TYPE%' "; } try { string query = "SELECT smmp.* FROM SH_MURAN_MATERIAL_PARCEL smmp WHERE ( 1 = 1) " + mlength + mwidth + mthickness + mcoating + mcode + mtemper + msize + mtype + msecond_face + mfinish + mfirst_face + mmuran_type + mno_sheets + " AND NOT EXiSTS (SELECT * FROM SH_EXCHAGED_MURAN_PARCELS semp WHERE semp.SH_MURAN_PARCEL_ID = smmp.SH_ID)"; // string query = "SELECT * FROM SH_MURAN_MATERIAL_PARCEL "; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); // MessageBox.Show(query); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); if (length) { cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", double.Parse(item_length_text_box.Text)); MessageBox.Show("test1"); } if (width) { cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", double.Parse(item_width_text_box.Text)); } if (thickness) { cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", double.Parse(item_thickness_text_box.Text)); } if (code) { cmd.Parameters.AddWithValue("@SH_ITEM_CODE", item_code_text_box.Text); } if (temper) { cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", item_temper_text_box.Text); } if (coating) { cmd.Parameters.AddWithValue("@SH_ITEM_COATING", item_coating_text_box.Text); } if (finish) { cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", item_finish_text_box.Text); } if (_size) { cmd.Parameters.AddWithValue("@SH_SIZE_NAME", sizes_combo_box.Text); } if (type) { cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", item_type_text_box.Text); } if (first_face) { cmd.Parameters.AddWithValue("@SH_ITEM_FIRST_FACE", faces[first_face_combo_box.SelectedIndex].SH_FACE_COLOR_NAME); } if (second_face) { cmd.Parameters.AddWithValue("@SH_ITEM_SECOND_FACE", second_face_combo_box.Text); } if (muran_type) { cmd.Parameters.AddWithValue("@SH_MURAN_TYPE", getmurantype()); } if (no_sheets) { cmd.Parameters.AddWithValue("@SH_ITEM_NUMBER_OF_SHEETS", long.Parse(item_no_sheets_text_box.Text)); } SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { parcels.Add(new SH_MURAN_MATERIAL_PARCEL() { SH_BOTTLE_CAPACITY = rd["SH_BOTTLE_CAPACITY"].ToString(), SH_ITEM_CODE = rd["SH_ITEM_CODE"].ToString(), SH_BOTTLE_HEIGHT = double.Parse(rd["SH_BOTTLE_HEIGHT"].ToString()), SH_CLIENT_NAME = rd["SH_CLIENT_NAME"].ToString(), SH_ID = long.Parse(rd["SH_ID"].ToString()), SH_ITEM_LENGTH = double.Parse(rd["SH_ITEM_LENGTH"].ToString()), SH_ITEM_NUMBER_OF_SHEETS = long.Parse(rd["SH_ITEM_NUMBER_OF_SHEETS"].ToString()), SH_ITEM_FIRST_FACE = rd["SH_ITEM_FIRST_FACE"].ToString(), SH_ITEM_THICKNESS = double.Parse(rd["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_SECOND_FACE = rd["SH_ITEM_SECOND_FACE"].ToString(), SH_SIZE_ID = long.Parse(rd["SH_SIZE_ID"].ToString()), SH_SIZE_NAME = rd["SH_SIZE_NAME"].ToString(), SH_MURAN_TYPE = rd["SH_MURAN_TYPE"].ToString(), SH_ITEM_PARCEL_GROSS_WEIGHT = double.Parse(rd["SH_ITEM_PACKAGE_GROSS_WEIGHT"].ToString()) }); } myconnection.closeConnection(); fillmuranparcelsgridview(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETTING MURAN PARCELS : " + ex.ToString()); } }
public void getUserPermission() { try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("getpermissionOneEmp", DatabaseConnection.mConnection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@empid", mAccount.SH_ID); SqlDataReader red = cmd.ExecuteReader(); if (red.Read()) { mPermission.SH_ID = long.Parse(red["SH_ID"].ToString()); mPermission.SH_ADD_NEW_COLOR = long.Parse(red["SH_ADD_NEW_COLOR"].ToString()); mPermission.SH_OPEN_CHANGE_PASSWORD = long.Parse(red["SH_OPEN_CHANGE_PASSWORD"].ToString()); mPermission.SH_OPEN_GETALL_EMP = long.Parse(red["SH_OPEN_REGIST_EMP"].ToString()); mPermission.SH_OPEN_MAKE_NEW_USER = long.Parse(red["SH_OPEN_MAKE_NEW_USER"].ToString()); mPermission.SH_OPEN_DISPLAY_ALLUSERS = long.Parse(red["SH_OPEN_DISPLAY_ALLUSERS"].ToString()); mPermission.SH_OPEN_SELECT_USER_PERMISION = long.Parse(red["SH_OPEN_SELECT_USER_PERMISION"].ToString()); mPermission.SH_RAW_TIN_MATERIAL = long.Parse(red["SH_RAW_TIN_MATERIAL"].ToString()); mPermission.SH_ACCOUNT_ID = long.Parse(red["SH_ACCOUNT_ID"].ToString()); mPermission.SH_ACCOUNT_NAME = red["SH_ACCOUNT_NAME"].ToString(); mPermission.SH_SHOW_ALL_CLIENTS = long.Parse(red["SH_SHOW_ALL_CLIENTS"].ToString()); mPermission.SH_OPEN_DASH_BOARD = long.Parse(red["SH_OPEN_DASH_BOARD"].ToString()); mPermission.SH_OPEN_REGIST_EMP = long.Parse(red["SH_OPEN_REGIST_EMP"].ToString()); mPermission.SH_ADD_NEW_CLIENT_COMPANY = long.Parse(red["SH_ADD_NEW_CLIENT_COMPANY"].ToString()); mPermission.SH_ADD_NEW_CLIENT_BRANCH = long.Parse(red["SH_ADD_NEW_CLIENT_BRANCH"].ToString()); mPermission.SH_ADD_NEW_SUPPLIER = long.Parse(red["SH_ADD_NEW_SUPPLIER"].ToString()); mPermission.SH_ADD_NEW_SUPPLIER_BRANCH = long.Parse(red["SH_ADD_NEW_SUPPLIER_BRANCH"].ToString()); mPermission.SH_SHOW_ALL_SUPPLIERS = long.Parse(red["SH_SHOW_ALL_SUPPLIERS"].ToString()); mPermission.SH_MAIN_TIN_STOCK = long.Parse(red["SH_MAIN_TIN_STOCK"].ToString()); mPermission.SH_ADD_NEW_RAW_TIN_FIRST_DURATION = long.Parse(red["SH_ADD_NEW_RAW_TIN_FIRST_DURATION"].ToString()); mPermission.SH_ADD_NEW_RAW_TIN = long.Parse(red["SH_ADD_NEW_RAW_TIN"].ToString()); mPermission.SH_EXCHANGE_RAW_TIN_PARCEL_NO = long.Parse(red["SH_EXCHANGE_RAW_TIN_PARCEL_NO"].ToString()); mPermission.SH_EXCHANGE_RAW_TIN_PROPERTIES = long.Parse(red["SH_EXCHANGE_RAW_TIN_PROPERTIES"].ToString()); mPermission.SH_EXCHANGE_MURAN_TIN = long.Parse(red["SH_EXCHANGE_MURAN_TIN"].ToString()); mPermission.SH_ADD_NEW_MURAN_TIN = long.Parse(red["SH_ADD_NEW_MURAN_TIN"].ToString()); mPermission.SH_ADD_NEW_PRINTED_TIN = long.Parse(red["SH_ADD_NEW_PRINTED_TIN"].ToString()); mPermission.SH_EXCHANGE_PRINTED_TIN = long.Parse(red["SH_EXCHANGE_PRINTED_TIN"].ToString()); mPermission.SH_ADD_NEW_SIZE = long.Parse(red["SH_ADD_NEW_SIZE"].ToString()); mPermission.SH_ADD_NEW_CUT_RAW_TIN = long.Parse(red["SH_ADD_NEW_CUT_RAW_TIN"].ToString()); mPermission.SH_EXCHANGE_CUT_RAW_TIN = long.Parse(red["SH_EXCHANGE_CUT_RAW_TIN"].ToString()); mPermission.SH_ADD_NEW_CUT_MURAN_TIN = long.Parse(red["SH_ADD_NEW_CUT_MURAN_TIN"].ToString()); mPermission.SH_EXCHANGE_CUT_MURAN_TIN = long.Parse(red["SH_EXCHANGE_CUT_MURAN_TIN"].ToString()); mPermission.SH_ADD_NEW_CUTTERS = long.Parse(red["SH_ADD_NEW_CUTTERS"].ToString()); mPermission.SH_SHOW_ALL_CUTTERS = long.Parse(red["SH_SHOW_ALL_CUTTERS"].ToString()); mPermission.SH_DEPARTMENT_PRODUCTION = long.Parse(red["SH_DEPARTMENT_PRODUCTION"].ToString()); mPermission.SH_ADD_NEW_STOCK_PLACE = long.Parse(red["SH_ADD_NEW_STOCK_PLACE"].ToString()); mPermission.SH_SHOW_ALL_STOCKS = long.Parse(red["SH_SHOW_ALL_STOCKS"].ToString()); mPermission.SH_DEPARTMENT_STOCKS = long.Parse(red["SH_DEPARTMENT_STOCKS"].ToString()); mPermission.SH_DEPARTMENT_SALES = long.Parse(red["SH_DEPARTMENT_SALES"].ToString()); mPermission.SH_DEPARTMENT_HR = long.Parse(red["SH_DEPARTMENT_HR"].ToString()); mPermission.SH_DEPARTMENT_PURCHASING = long.Parse(red["SH_DEPARTMENT_PURCHASING"].ToString()); mPermission.SH_DEPARTMENT_SECRETARY = long.Parse(red["SH_DEPARTMENT_SECRETARY"].ToString()); mPermission.SH_DEPARTMENT_ACCOUNTING = long.Parse(red["SH_DEPARTMENT_ACCOUNTING"].ToString()); mPermission.SH_DEPARTMENT_IT = long.Parse(red["SH_DEPARTMENT_IT"].ToString()); mPermission.SH_IT_SERVER_SETTINGS = long.Parse(red["SH_IT_SERVER_SETTINGS"].ToString()); mPermission.SH_EXCHANGE_CHANGE_BITS = long.Parse(red["SH_EXCHANGE_CHANGE_BITS"].ToString()); mPermission.SH_ADD_NEW_DEPARTMENT = long.Parse(red["SH_ADD_NEW_DEPARTMENT"].ToString()); mPermission.SH_ADD_NEW_JOB = long.Parse(red["SH_ADD_NEW_JOB"].ToString()); mPermission.SH_ADD_NEW_PRODUCT_CLIENT = long.Parse(red["SH_ADD_NEW_PRODUCT_CLIENT"].ToString()); mPermission.SH_ADD_PRODUCTION_REQUIRMENT = long.Parse(red["SH_ADD_PRODUCTION_REQUIRMENT"].ToString()); mPermission.SH_EXCHANGE_PRODUCTION_REQUIRMENT = long.Parse(red["SH_EXCHANGE_PRODUCTION_REQUIRMENT"].ToString()); mPermission.SH_ADD_CHANGE_BITS = long.Parse(red["SH_ADD_CHANGE_BITS"].ToString()); mPermission.SH_ADD_EASY_OPEN = long.Parse(red["SH_ADD_EASY_OPEN"].ToString()); mPermission.SH_EXCHANGE_EASY_OPEN = long.Parse(red["SH_EXCHANGE_EASY_OPEN"].ToString()); mPermission.SH_ADD_TIN_CANS = long.Parse(red["SH_ADD_TIN_CANS"].ToString()); mPermission.SH_EXCHANGE_TIN_CANS = long.Parse(red["SH_EXCHANGE_TIN_CANS"].ToString()); mPermission.SH_ADD_NEW_RLT = long.Parse(red["SH_ADD_NEW_RLT"].ToString()); mPermission.SH_EXCHANGE_RLT = long.Parse(red["SH_EXCHANGE_RLT"].ToString()); mPermission.SH_ADD_NEW_CUT_RAW_TIN = long.Parse(red["SH_ADD_NEW_CUT_RAW_TIN"].ToString()); mPermission.SH_ADD_NEW_CUT_PRINTED_TIN = long.Parse(red["SH_ADD_NEW_CUT_PRINTED_TIN"].ToString()); mPermission.SH_EXCHANGE_CUT_PRINTED_TIN = long.Parse(red["SH_EXCHANGE_CUT_PRINTED_TIN"].ToString()); mPermission.SH_ADD_NEW_BOTTOM = long.Parse(red["SH_ADD_NEW_BOTTOM"].ToString()); mPermission.SH_EXCHANGE_BOTTOM = long.Parse(red["SH_EXCHANGE_BOTTOM"].ToString()); mPermission.SH_DEPARTMENT_MAINTENANCE = long.Parse(red["SH_DEPARTMENT_MAINTENANCE"].ToString()); } myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHIE GETTING USER PERMISSION " + ex.ToString()); } }
private void save_btn_Click(object sender, EventArgs e) { if (string.IsNullOrWhiteSpace(client_company_conact_email_text_box.Text) || string.IsNullOrWhiteSpace(client_company_contact_name.Text) || string.IsNullOrWhiteSpace(client_company_contact_telephone_text_box.Text)) { } else { if (editeclientconctactid == 0) //new button { try { string query = "INSERT INTO SH_CLIENT_COMPANY_CONTACTS "; query += "(SH_CLIENT_COMPANY_ID, SH_CLIENT_COMPANY_CONTACT_NAME, "; query += " SH_CLIENT_COMPANY_CONTACT_TELEPHONE, SH_CLIENT_COMPANY_CONTACT_EMAIL"; query += " ,SH_DATA_ENTRY_USER_ID,SH_DATA_ENTRY_EMPLOYEE_ID,SH_ADDITION_DATE"; query += ") "; query += " VALUES(@SH_CLIENT_COMPANY_ID,@SH_CLIENT_COMPANY_CONTACT_NAME,"; query += "@SH_CLIENT_COMPANY_CONTACT_TELEPHONE,@SH_CLIENT_COMPANY_CONTACT_EMAIL ,"; query += " @SH_DATA_ENTRY_USER_ID, @SH_DATA_ENTRY_EMPLOYEE_ID, @SH_ADDITION_DATE"; query += ")"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_ID", mclient.SH_ID); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_CONTACT_NAME", client_company_contact_name.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_CONTACT_TELEPHONE", client_company_contact_telephone_text_box.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_CONTACT_EMAIL", client_company_conact_email_text_box.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(); MessageBox.Show("تم الحفظ بنجاح", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); client_company_contact_name.Text = ""; client_company_conact_email_text_box.Text = ""; client_company_contact_telephone_text_box.Text = ""; myconnection.closeConnection(); } catch (Exception ex) { MessageBox.Show("ERROR WHILE ADDING NEW CLIENT CONTACT IN DB " + ex.ToString()); } fillclientcontactsgridview(); } else // edite { try { string query = "UPDATE SH_CLIENT_COMPANY_CONTACTS"; query += " SET SH_CLIENT_COMPANY_CONTACT_NAME = @SH_CLIENT_COMPANY_CONTACT_NAME, SH_CLIENT_COMPANY_CONTACT_TELEPHONE = @SH_CLIENT_COMPANY_CONTACT_TELEPHONE, "; query += "SH_CLIENT_COMPANY_CONTACT_EMAIL = @SH_CLIENT_COMPANY_CONTACT_EMAIL WHERE SH_ID = @SH_ID"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_ID", mclient.SH_ID); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_CONTACT_NAME", client_company_contact_name.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_CONTACT_TELEPHONE", client_company_contact_telephone_text_box.Text); cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_CONTACT_EMAIL", client_company_conact_email_text_box.Text); cmd.Parameters.AddWithValue("@SH_ID", editeclientconctactid); cmd.ExecuteNonQuery(); MessageBox.Show("تم التعديل بنجاح", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); client_company_contact_name.Text = ""; client_company_conact_email_text_box.Text = ""; client_company_contact_telephone_text_box.Text = ""; myconnection.closeConnection(); editeclientconctactid = 0; } catch (Exception ex) { MessageBox.Show("ERROR WHILE EDITING CLIENT CONTACT IN DB " + ex.ToString()); } fillclientcontactsgridview(); } editeclientconctactid = 0; } }
private void printfinishedcanstotalbalanceform_Load(object sender, EventArgs e) { DataTable mydatatabel = new DataTable(); mydatatabel.Columns.Add("m"); mydatatabel.Columns.Add("client_name"); mydatatabel.Columns.Add("product_name"); //size mydatatabel.Columns.Add("size_name"); //no_cans_per_pallet mydatatabel.Columns.Add("total_number_of_pallets"); mydatatabel.Columns.Add("total_number_of_cans_per_pallet"); mydatatabel.Columns.Add("total_number_of_cans"); mydatatabel.Columns.Add("addition_date"); long total_no_pallets = 0; long total_no_cans = 0; try { myconnection.openConnection(); SqlCommand cmd = new SqlCommand("SH_GET_ALL_FINISHED_CANS", DatabaseConnection.mConnection); cmd.CommandType = CommandType.StoredProcedure; SqlDataReader reader = cmd.ExecuteReader(); long counter = 0; while (reader.Read()) { counter++; string[] mydata = new string[8]; mydata[0] = (counter).ToString(); mydata[1] = reader["SH_CLIENT_COMPANY_NAME"].ToString(); mydata[2] = reader["SH_PRODUCT_NAME"].ToString(); mydata[3] = reader["product_size"].ToString(); mydata[4] = reader["NUMBER_OF_PALLETS"].ToString(); total_no_pallets += long.Parse(reader["NUMBER_OF_PALLETS"].ToString()); mydata[5] = (long.Parse(reader["TOTAL_NO_CANS"].ToString()) / long.Parse(reader["NUMBER_OF_PALLETS"].ToString())).ToString(); total_no_cans += long.Parse(reader["TOTAL_NO_CANS"].ToString()); mydata[6] = reader["TOTAL_NO_CANS"].ToString(); mydata[7] = reader["SH_ADDITION_DATE"].ToString(); mydatatabel.Rows.Add(mydata); } reader.Close(); myconnection.closeConnection(); // MessageBox.Show("ROWS : "+mydatatabel.Rows.Count.ToString()); } catch (Exception ex) { MessageBox.Show("ERROR WHILE GETIING FINISHED CANS " + ex.ToString()); } ReportParameter[] myparm = new ReportParameter[3]; myparm[0] = new ReportParameter("total_no_pallets", total_no_pallets.ToString(), false); myparm[1] = new ReportParameter("total_no_cans", total_no_cans.ToString(), false); myparm[2] = new ReportParameter("report_presenter_name", mEmployee.SH_EMPLOYEE_NAME, false); this.reportViewer1.LocalReport.SetParameters(myparm); ReportDataSource rds = new ReportDataSource("mydataset", mydatatabel); this.reportViewer1.LocalReport.DataSources.Clear(); this.reportViewer1.LocalReport.DataSources.Add(rds); //reportViewer1.DataBind(); this.reportViewer1.LocalReport.Refresh(); this.reportViewer1.RefreshReport(); }