long saverawmaterialquantites(long sp_id, SH_QUANTITIES_RAW_MATERIAL_SPECIFICATION_COILS myquantity)
{
// MessageBox.Show(sp_id.ToString());
string query = "INSERT INTO SH_QUANTITIES_RAW_MATERIAL_SPECIFICATION_COILS ";
query += "(SH_ITEM_WIDTH, SH_SPECIFICATION_OF_RAW_MATERIAL_COILS_ID, SH_ITEM_THICKNESS, SH_ITEM_TEMPER, SH_ITEM_COATING, SH_ITEM_FINISH, SH_ITEM_NAME, SH_ITEM_TYPE, ";
query += " SH_SUPPLIER_NAME, SH_ITEM_TOTAL_NO_COILS, SH_ITEM_TOTAL_NET_WEIGHT, SH_ITEM_TOTAL_GROSS_WEIGHT, SH_ITEM_TON_PRICE, ";
query += " SH_ITEM_TOTAL_QUANTITY_COST, SH_ITEM_STOCK_NAME, SH_ADDITION_DATE, SH_ADDING_PERMISSION_NUMBER) ";
query += " VALUES(@SH_ITEM_WIDTH,@SH_SPECIFICATION_OF_RAW_MATERIAL_COILS_ID ,@SH_ITEM_THICKNESS,";
query += "@SH_ITEM_TEMPER,@SH_ITEM_COATING,@SH_ITEM_FINISH,@SH_ITEM_NAME,@SH_ITEM_TYPE,@SH_SUPPLIER_NAME,";
query += "@SH_ITEM_TOTAL_NO_COILS,@SH_ITEM_TOTAL_NET_WEIGHT,@SH_ITEM_TOTAL_GROSS_WEIGHT,@SH_ITEM_TON_PRICE";
query += ",@SH_ITEM_TOTAL_QUANTITY_COST,@SH_ITEM_STOCK_NAME,@SH_ADDITION_DATE,@SH_ADDING_PERMISSION_NUMBER)";
query += "SELECT SCOPE_IDENTITY() AS myidentity";
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", myquantity.QuantityCoils[0].SH_ITEM_WIDTH);
cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_COILS_ID", sp_id);
cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", myquantity.QuantityCoils[0].SH_ITEM_THICKNESS);
cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", myquantity.QuantityCoils[0].SH_ITEM_TEMPER);
cmd.Parameters.AddWithValue("@SH_ITEM_COATING", myquantity.QuantityCoils[0].SH_ITEM_COATING);
cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", myquantity.QuantityCoils[0].SH_ITEM_FINISH);
cmd.Parameters.AddWithValue("@SH_ITEM_NAME", "صفيح");
cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", myquantity.QuantityCoils[0].SH_ITEM_TYPE);
cmd.Parameters.AddWithValue("@SH_SUPPLIER_NAME", supplier_text_box.Text);
// cmd.Parameters.AddWithValue("@SH_DATE_OF_SUPPLY" , "");
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NO_COILS", myquantity.SH_ITEM_TOTAL_NO_COILS);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NET_WEIGHT", myquantity.SH_ITEM_TOTAL_NET_WEIGHT);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_GROSS_WEIGHT", myquantity.SH_ITEM_TOTAL_GROSS_WEIGHT);
cmd.Parameters.AddWithValue("@SH_ITEM_TON_PRICE", 00);
// cmd.Parameters.AddWithValue("@SH_ITEM_SUPPLY_TYPE" , null);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_QUANTITY_COST", 00);
cmd.Parameters.AddWithValue("@SH_ITEM_STOCK_NAME", myquantity.QuantityCoils[0].SH_ITEM_STOCK_NAME);
cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", DateTime.Parse(addition_date_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ADDING_PERMISSION_NUMBER", adding_request_number_text_box.Text);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
return(long.Parse(reader["myidentity"].ToString()));
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE SAVING MATERIAL QUANTITIES" + ex.ToString());
}
return(0);
}
void update_sp_raw_coils_info(long sp_id, SH_QUANTITIES_RAW_MATERIAL_SPECIFICATION_COILS myquantity)
{
string query = "UPDATE SH_SPECIFICATION_OF_RAW_MATERIAL_COILS ";
query += "SET SH_ITEM_TOTAL_NET_WEIGHT = SH_ITEM_TOTAL_NET_WEIGHT + @SH_ITEM_TOTAL_NET_WEIGHT, SH_ITEM_TOTAL_GROSS_WEIGHT = SH_ITEM_TOTAL_GROSS_WEIGHT + @SH_ITEM_TOTAL_GROSS_WEIGHT ";
query += "WHERE(SH_ID = @SH_ID)";
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NET_WEIGHT", myquantity.SH_ITEM_TOTAL_NET_WEIGHT);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_GROSS_WEIGHT", myquantity.SH_ITEM_TOTAL_GROSS_WEIGHT);
cmd.Parameters.AddWithValue("@SH_ID", sp_id);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
}
catch (Exception)
{
MessageBox.Show("ERROR EHILE UPDATING SPECIFICATION TABLE VALUE");
}
}
