async Task <long> savenewspecifications(SH_PLASTIC_MOLD_DATA mydata)
{
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SH_SAVE_NEW_PLASTIC_MOLD_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_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_number_of_items());
cmd.Parameters.AddWithValue("@SH_MOLD_TYPE_ID", mydata.mold_types.SH_ID);
cmd.Parameters.AddWithValue("@SH_PILLOW_COLOR_ID", mydata.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 SAVING NEW SPECIFICATIONS DATA " + ex.ToString());
}
return(0);
}
async Task <long> check_if_specification_exists_or_not(SH_PLASTIC_MOLD_DATA mydata)
{
await loadallplasticmoldspecifications();
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_MOLD_TYPE_ID == mydata.mold_types.SH_ID && specifications[i].SH_PILLOW_COLOR_ID == mydata.color.SH_ID && specifications[i].SH_SIZE_ID == mydata.size.SH_ID && string.Compare(specifications[i].SH_CONTAINER_NAME, mydata.container_name) == 0)
{
return(specifications[i].SH_ID);
}
}
}
return(0);
}
async Task update_specification(long sp_id, SH_PLASTIC_MOLD_DATA mydata)
{
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SH_UPDATE_SPECIFICATION_DATA", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_ITEMS", mydata.total_number_of_items());
cmd.Parameters.AddWithValue("@SH_NO_OF_CONTAINERS", mydata.no_of_containers);
cmd.Parameters.AddWithValue("@SH_SP_ID", sp_id);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE UPDATING SPECIFICATION DATA " + ex.ToString());
}
}
async Task save_containers(long q_id, SH_PLASTIC_MOLD_DATA mydata)
{
try
{
myconnection.openConnection();
for (int i = 0; i < mydata.no_of_containers; i++)
{
SqlCommand cmd = new SqlCommand("SH_SAVE_NEW_PLASTIC_MOLD_CONTAINER", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SH_CONTAINER_NAME", mydata.container_name);
cmd.Parameters.AddWithValue("@SH_QUANTITY_OF_PLASTIC_MOLD_ID", q_id);
cmd.Parameters.AddWithValue("@SH_NO_ITEMS", mydata.no_of_items_per_container);
cmd.Parameters.AddWithValue("@SH_ADDTION_DATE", mydata.Addition_date);
cmd.Parameters.AddWithValue("@SH_ADDITION_PERMISSION_NUMBER", mydata.addition_permission_number);
cmd.ExecuteNonQuery();
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE ADDING NEW CONTAINERS " + ex.ToString());
}
}
async Task <long> savenewquantity(long sp_id, SH_PLASTIC_MOLD_DATA mydata)
{
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SH_SAVE_PLASTIC_MOLD_QUANTITY", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_PLASTIC_MOLD_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_of_items_per_container);
cmd.Parameters.AddWithValue("@SH_NO_OF_CONTAINERS", mydata.no_of_containers);
cmd.Parameters.AddWithValue("@SH_TOTAL_NO_ITEMS", mydata.total_number_of_items());
cmd.Parameters.AddWithValue("@SH_STOCK_ID", mydata.stock.SH_ID);
cmd.Parameters.AddWithValue("@SH_STOCK_MAN_ID", mydata.stock_man.SH_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mEmployee.SH_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID);
long q_id = 0;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
q_id = long.Parse(reader["myidentity"].ToString());
}
reader.Close();
myconnection.closeConnection();
return(q_id);
}
catch (Exception EX)
{
MessageBox.Show("ERROR WHILE ADDING NEW QUANTITY " + EX.ToString());
}
return(0);
}
