long savenewcoilspacification(SH_COILS_RAW_MATERIAL any_sample_coil) { try { string query = "INSERT INTO SH_SPECIFICATION_OF_RAW_MATERIAL_COILS "; query += "(SH_ITEM_WIDTH, SH_ITEM_THICKNESS, SH_ITEM_NAME, SH_ITEM_TYPE, SH_ITEM_FINISH, SH_ITEM_COATING, SH_ITEM_TEMPER, SH_ITEM_TOTAL_NET_WEIGHT, SH_ITEM_TOTAL_GROSS_WEIGHT) "; query += "VALUES(@SH_ITEM_WIDTH,@SH_ITEM_THICKNESS,@SH_ITEM_NAME,@SH_ITEM_TYPE,@SH_ITEM_FINISH,@SH_ITEM_COATING,@SH_ITEM_TEMPER,@SH_ITEM_TOTAL_NET_WEIGHT,@SH_ITEM_TOTAL_GROSS_WEIGHT)"; query += "SELECT SCOPE_IDENTITY() AS myidentity"; DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection); cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", any_sample_coil.SH_ITEM_WIDTH); cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", any_sample_coil.SH_ITEM_THICKNESS); cmd.Parameters.AddWithValue("@SH_ITEM_NAME", "صفيح"); cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", any_sample_coil.SH_ITEM_TYPE); cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", any_sample_coil.SH_ITEM_FINISH); cmd.Parameters.AddWithValue("@SH_ITEM_COATING", any_sample_coil.SH_ITEM_COATING); cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", any_sample_coil.SH_ITEM_TEMPER); cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NET_WEIGHT", any_sample_coil.SH_ITEM_TOTAL_NET_WEIGHT); cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_GROSS_WEIGHT", any_sample_coil.SH_ITEM_TOTAL_GROSS_WEIGHT); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { return(long.Parse(reader["myidentity"].ToString())); } myconnection.closeConnection(); } catch (Exception) { MessageBox.Show("ERROR WHILE SAVING COIL SPACIFICATION"); } return(0); }
long check_raw_material_existance_sp(SH_COILS_RAW_MATERIAL anycoil) { List <SH_SPECIFICATION_OF_RAW_MATERIAL_COILS> all_sp = new List <SH_SPECIFICATION_OF_RAW_MATERIAL_COILS>(); if (string.IsNullOrEmpty(item_width_text_box.Text) && string.IsNullOrEmpty(item_thickness_text_box.Text) && string.IsNullOrEmpty(item_temper_combo_box.Text) && string.IsNullOrEmpty(item_type_combo_box.Text) && string.IsNullOrEmpty(item_finish_combo_box.Text)) { } else { double mynum; long mydidnum; if ((!string.IsNullOrEmpty(supplier_text_box.Text)) && double.TryParse(item_width_text_box.Text, out mynum) && long.TryParse(adding_request_number_text_box.Text, out mydidnum) && double.TryParse(item_thickness_text_box.Text, out mynum)) { try { DatabaseConnection myconnection = new DatabaseConnection(); myconnection.openConnection(); SqlCommand cmd = new SqlCommand("SELECT * FROM SH_SPECIFICATION_OF_RAW_MATERIAL_COILS ", DatabaseConnection.mConnection); SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { all_sp.Add(new SH_SPECIFICATION_OF_RAW_MATERIAL_COILS { SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_FINISH = reader["SH_ITEM_FINISH"].ToString(), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()) }); } myconnection.closeConnection(); for (int i = 0; i < all_sp.Count; i++) { if ((string.Compare(all_sp[i].SH_ITEM_FINISH, anycoil.SH_ITEM_FINISH) == 0) && (string.Compare(all_sp[i].SH_ITEM_COATING, anycoil.SH_ITEM_COATING) == 0) && (string.Compare(all_sp[i].SH_ITEM_TEMPER, anycoil.SH_ITEM_TEMPER) == 0) && (all_sp[i].SH_ITEM_WIDTH == anycoil.SH_ITEM_WIDTH) && (all_sp[i].SH_ITEM_THICKNESS == anycoil.SH_ITEM_THICKNESS)) { return(all_sp[i].SH_ID); } } } catch (Exception ex) { MessageBox.Show("ERROR WHILE CHECKING RAW MATERIAL EXISTANCE" + ex.ToString()); } } else { MessageBox.Show("الرجاء إدخال المعلومات بشكل صحيح", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading); } } return(0); }
bool check_if_there_is_coils_with_the_same_gross_and_net(SH_COILS_RAW_MATERIAL anycoil) { if (raw_coils.Count > 0) { for (int i = 0; i < raw_coils.Count; i++) { if ((raw_coils[i].SH_ITEM_TOTAL_NET_WEIGHT == anycoil.SH_ITEM_TOTAL_NET_WEIGHT) && (raw_coils[i].SH_ITEM_TOTAL_GROSS_WEIGHT == anycoil.SH_ITEM_TOTAL_GROSS_WEIGHT)) { return(true); } } } else { return(false); } return(false); }