long check_if_exists_or_not(SH_QUANTITIES_OF_CUT_MURAN_MATERIAL myquantity)
{
if (specifications.Count > 0)
{
for (int i = 0; i < specifications.Count; i++)
{
if ((string.Compare(specifications[i].SH_CLIENT_NAME, myquantity.SH_CLIENT_NAME) == 0) && (specifications[i].SH_CAPACITY == myquantity.SH_CAPACITY) && (string.Compare(specifications[i].SH_FIRST_FACE, myquantity.SH_FIRST_FACE) == 0) && (string.Compare(specifications[i].SH_MURAN_TYPE, myquantity.SH_MURAN_TYPE) == 0) && (string.Compare(specifications[i].SH_SECOND_FACE, myquantity.SH_SECOND_FACE) == 0) && (specifications[i].SH_SIZE_ID == myquantity.SH_SIZE_ID))
{
return(specifications[i].SH_ID);
}
}
}
return(0);
}
void savequantity(long sp_id, SH_QUANTITIES_OF_CUT_MURAN_MATERIAL myquantity)
{
try
{
string query = "INSERT INTO SH_QUANTITIES_OF_CUT_MURAN_MATERIAL ";
query += "(SH_SPECIFICATION_OF_CUT_MURAN_MATERIAL_ID, SH_CLIENT_ID, SH_CLIENT_NAME, SH_MURAN_TYPE, SH_FIRST_FACE, SH_SECOND_FACE, SH_HEIGHT, SH_CAPACITY, SH_ADDITION_DATE,";
query += " SH_ADDITION_PERMISSION_NUMBER, SH_CUTTER_ID, SH_CUTTER_NAME, SH_STOCK_ID, SH_STOCK_NAME, SH_CUTTER_TECHNICAL_MAN, SH_TOTAL_NUMBER_OF_BOTTELS, SH_TOTAL_NUMBER_OF_PALLETS,";
query += " SH_SIZE_ID, SH_SIZE_NAME) ";
query += " VALUES(@SH_SPECIFICATION_OF_CUT_MURAN_MATERIAL_ID,@SH_CLIENT_ID,@SH_CLIENT_NAME,@SH_MURAN_TYPE,@SH_FIRST_FACE";
query += ",@SH_SECOND_FACE, @SH_HEIGHT, @SH_CAPACITY,@SH_ADDITION_DATE,@SH_ADDITION_PERMISSION_NUMBER,@SH_CUTTER_ID,@SH_CUTTER_NAME";
query += ",@SH_STOCK_ID,@SH_STOCK_NAME,@SH_CUTTER_TECHNICAL_MAN,@SH_TOTAL_NUMBER_OF_BOTTELS,@SH_TOTAL_NUMBER_OF_PALLETS,@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_CUT_MURAN_MATERIAL_ID", sp_id);
cmd.Parameters.AddWithValue("@SH_CLIENT_ID", myquantity.q_pallets[0].SH_CLIENT_ID);
cmd.Parameters.AddWithValue("@SH_CLIENT_NAME", myquantity.q_pallets[0].SH_CLIENT_NAME);
cmd.Parameters.AddWithValue("@SH_MURAN_TYPE", myquantity.q_pallets[0].SH_MURAN_TYPE);
cmd.Parameters.AddWithValue("@SH_FIRST_FACE", myquantity.q_pallets[0].SH_FIRST_FACE);
cmd.Parameters.AddWithValue("@SH_SECOND_FACE", myquantity.q_pallets[0].SH_SECOND_FACE);
cmd.Parameters.AddWithValue("@SH_HEIGHT", myquantity.q_pallets[0].SH_HEIGHT);
cmd.Parameters.AddWithValue("@SH_CAPACITY", myquantity.q_pallets[0].SH_CAPACITY);
cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", myquantity.q_pallets[0].SH_ADDTION_DATE);
cmd.Parameters.AddWithValue("@SH_ADDITION_PERMISSION_NUMBER", myquantity.q_pallets[0].SH_ADDTION_PERMISSION_NUMBER);
cmd.Parameters.AddWithValue("@SH_CUTTER_ID", myquantity.q_pallets[0].SH_CUTTER_ID);
cmd.Parameters.AddWithValue("@SH_CUTTER_NAME", myquantity.q_pallets[0].SH_CUTTER_NAME);
cmd.Parameters.AddWithValue("@SH_STOCK_ID", myquantity.q_pallets[0].SH_STOCK_ID);
cmd.Parameters.AddWithValue("@SH_STOCK_NAME", myquantity.q_pallets[0].SH_STOCK_NAME);
cmd.Parameters.AddWithValue("@SH_CUTTER_TECHNICAL_MAN", myquantity.q_pallets[0].SH_CUTTER_TECHNICAL_MAN);
cmd.Parameters.AddWithValue("@SH_TOTAL_NUMBER_OF_BOTTELS", myquantity.SH_TOTAL_NUMBER_OF_BOTTELS);
cmd.Parameters.AddWithValue("@SH_TOTAL_NUMBER_OF_PALLETS", myquantity.SH_TOTAL_NUMBER_OF_PALLETS);
cmd.Parameters.AddWithValue("@SH_SIZE_ID", myquantity.q_pallets[0].SH_SIZE_ID);
cmd.Parameters.AddWithValue("@SH_SIZE_NAME", myquantity.q_pallets[0].SH_SIZE_NAME);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
long q_id = long.Parse(reader["myidentity"].ToString());
saveparcels(sp_id, q_id, myquantity.q_pallets);
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE SACING CUT MURAN QUANTITIES " + ex.ToString());
}
}
void updatespecificationquantity(long sp_id, SH_QUANTITIES_OF_CUT_MURAN_MATERIAL myquantity)
{
try
{
string query = "UPDATE SH_SPECIFICATION_OF_CUT_MURAN_MATERIAL SET SH_TOTAL_NO_PALLETS = SH_TOTAL_NO_PALLETS + @SH_TOTAL_NO_PALLETS, SH_TOTAL_NO_BOTTELS = SH_TOTAL_NO_BOTTELS + @SH_TOTAL_NO_BOTTELS WHERE(SH_ID = @SH_ID)";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_PALLETS", myquantity.SH_TOTAL_NUMBER_OF_BOTTELS);
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_BOTTELS", myquantity.SH_TOTAL_NUMBER_OF_BOTTELS);
cmd.Parameters.AddWithValue("@SH_ID", sp_id);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE UPDATING RECORDS " + ex.ToString());
}
}
long savenewspecification(SH_QUANTITIES_OF_CUT_MURAN_MATERIAL myquantity)
{
try
{
string query = "INSERT INTO SH_SPECIFICATION_OF_CUT_MURAN_MATERIAL";
query += "(SH_CLIENT_ID, SH_CLIENT_NAME, SH_FIRST_FACE, SH_SECOND_FACE, SH_MURAN_TYPE, ";
query += " SH_HEIGHT, SH_CAPACITY, SH_TOTAL_NO_BOTTELS, SH_TOTAL_NO_PALLETS ,SH_SIZE_ID ,SH_SIZE_NAME ) ";
query += " VALUES(@SH_CLIENT_ID,@SH_CLIENT_NAME,@SH_FIRST_FACE,@SH_SECOND_FACE,@SH_MURAN_TYPE";
query += ",";
query += "@SH_HEIGHT,@SH_CAPACITY,@SH_TOTAL_NO_BOTTELS,@SH_TOTAL_NO_PALLETS , @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_CLIENT_ID", myquantity.q_pallets[0].SH_CLIENT_ID);
cmd.Parameters.AddWithValue("@SH_CLIENT_NAME", myquantity.q_pallets[0].SH_CLIENT_NAME);
cmd.Parameters.AddWithValue("@SH_FIRST_FACE", myquantity.q_pallets[0].SH_FIRST_FACE);
cmd.Parameters.AddWithValue("@SH_SECOND_FACE", myquantity.q_pallets[0].SH_SECOND_FACE);
cmd.Parameters.AddWithValue("@SH_MURAN_TYPE", myquantity.q_pallets[0].SH_MURAN_TYPE);
cmd.Parameters.AddWithValue("SH_SIZE_ID", myquantity.q_pallets[0].SH_SIZE_ID);
cmd.Parameters.AddWithValue("SH_SIZE_NAME", myquantity.q_pallets[0].SH_SIZE_NAME);
cmd.Parameters.AddWithValue("@SH_HEIGHT", myquantity.q_pallets[0].SH_HEIGHT);
cmd.Parameters.AddWithValue("@SH_CAPACITY", myquantity.q_pallets[0].SH_CAPACITY);
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_BOTTELS", myquantity.SH_TOTAL_NUMBER_OF_BOTTELS);
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_PALLETS", myquantity.SH_TOTAL_NUMBER_OF_PALLETS);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
return(long.Parse(reader["myidentity"].ToString()));
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE SAVING SPECIFICATION TO DB " + ex.ToString());
}
return(0);
}
