async Task <long> save_new_plastic_cover_quantities(long sp_id, SH_PLASTIC_COVER_DATA mydata)
{
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SH_SAVE_NEW_PLASTIC_COVER_QUANTITIES", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_PLASTIC_COVER_ID", sp_id);
cmd.Parameters.AddWithValue("@SH_SUPPLIER_ID", mydata.supplier.SH_ID);
cmd.Parameters.AddWithValue("@SH_SUPPLIER_BRANCH_ID", mydata.supplier_branch.SH_ID);
cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", mydata.addition_date);
cmd.Parameters.AddWithValue("@SH_ADDITION_PERMISSION_NUMBER", mydata.addition_permission_number);
cmd.Parameters.AddWithValue("@SH_CONTAINER_NAME", mydata.container_name);
cmd.Parameters.AddWithValue("@SH_NO_OF_ITEMS_PER_CONTAINER", mydata.no_items_per_container);
cmd.Parameters.AddWithValue("@SH_NO_OF_CONTAINERS", mydata.no_of_containers);
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_ITEMS", mydata.total_no_items());
SqlDataReader reader = cmd.ExecuteReader();
long myid = 0;
if (reader.Read())
{
myid = long.Parse(reader["myidentity"].ToString());
}
reader.Close();
myconnection.closeConnection();
return(myid);
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE ADDING NEW PLASTIC COVER QIANTITIES " + ex.ToString());
}
return(0);
}
async Task <long> save_new_specification(SH_PLASTIC_COVER_DATA mydata)
{
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SH_INSERT_NEW_PLASTIC_COVER_SPECIFICATION", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SH_CLIENT_ID", mydata.client.SH_ID);
cmd.Parameters.AddWithValue("@SH_SIZE_ID", mydata.size.SH_ID);
cmd.Parameters.AddWithValue("@SH_LOGO_OR_NOT", mydata.logo_or_not);
cmd.Parameters.AddWithValue("@SH_NO_OF_CONTAINERS", mydata.no_of_containers);
cmd.Parameters.AddWithValue("@SH_CONTAINER_NAME", mydata.container_name);
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_ITEMS", mydata.total_no_items());
cmd.Parameters.AddWithValue("@SH_PILLOW_COLOR_ID", mydata.pillow_color.SH_ID);
SqlDataReader reader = cmd.ExecuteReader();
long myid = 0;
if (reader.Read())
{
myid = long.Parse(reader["myidentity"].ToString());
}
reader.Close();
myconnection.closeConnection();
return(myid);
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE ADDING NEW SPECIFICATION " + ex.ToString());
}
return(0);
}
async Task upsate_specifications(long sp_id, SH_PLASTIC_COVER_DATA mydata)
{
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SH_UPDATE_PLASTIC_COVER_SPECIFICATION_QUANTITIES", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SH_NO_OF_CONTAINERS", mydata.no_of_containers);
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_ITEMS", mydata.total_no_items());
cmd.Parameters.AddWithValue("@SH_SP_ID", sp_id);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE UPDATING SPECIFICATIONS " + ex.ToString());
}
}
async Task save_plastic_cover_containers(long qu_id, SH_PLASTIC_COVER_DATA mydata)
{
try
{
myconnection.openConnection();
for (int i = 0; i < mydata.no_of_containers; i++)
{
SqlCommand cmd = new SqlCommand("SH_SAVE_NEW_PLASTIC_COVER_CONTAINER", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SH_QUANTITY_OF_PLASTIC_COVER_ID", qu_id);
cmd.Parameters.AddWithValue("@SH_CONTAINER_NAME", mydata.container_name);
cmd.Parameters.AddWithValue("@SH_ADDTION_DATE", mydata.addition_date);
cmd.Parameters.AddWithValue("@SH_NO_ITEMS", mydata.no_items_per_container);
cmd.Parameters.AddWithValue("@SH_ADDITION_PERMISSION_NUMBER", mydata.addition_permission_number);
cmd.ExecuteNonQuery();
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE SAVING NEW PLASTIC COVER CONTAINERS " + ex.ToString());
}
}
async Task <long> check_if_specification_exists_or_not(SH_PLASTIC_COVER_DATA mydata)
{
await loadallspecifications();
try
{
// MessageBox.Show(specifications.Count.ToString());
if (specifications.Count > 0)
{
for (int i = 0; i < specifications.Count; i++)
{
if (specifications[i].SH_CLIENT_ID == mydata.client.SH_ID && specifications[i].SH_LOGO_OR_NOT == mydata.logo_or_not && specifications[i].SH_SIZE_ID == mydata.size.SH_ID && string.Compare(specifications[i].SH_CONTAINER_NAME, mydata.container_name) == 0 && specifications[i].SH_PILLOW_COLOR_ID == mydata.pillow_color.SH_ID)
{
return(specifications[i].SH_ID);
}
}
}
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHIlE ADDING CHEckiNG NEW SPECiFIcATIONS" + ex.ToString());
}
return(0);
}
