public static int DeleteSubPart(ProductPartReplacement subProduct)
{
int result;
MyDBConnection myConn = new MyDBConnection();
SqlConnection conn = new SqlConnection();
try
{
conn = myConn.OpenDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.DeleteSubPart";
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = subProduct.ProductID;
cmd.Parameters.Add("@SubProductID", SqlDbType.Int).Value = subProduct.SubProductID;
DbParameter returnValue = cmd.CreateParameter();
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(returnValue);
cmd.ExecuteNonQuery();
result = Convert.ToInt32(returnValue.Value);
}
finally
{
myConn.CloseDB(conn);
}
return(result);
}
protected void lnkDeleteSubProduct_OnCommand(object sender, CommandEventArgs e)
{
ProductPartReplacement subProduct = new ProductPartReplacement();
subProduct.SubProductID = Convert.ToInt32(e.CommandArgument.ToString());
subProduct.ProductID = Convert.ToInt32(productID);
//Call the AccountManager to deactivate the product
ProductManager.DeleteSubPart(subProduct);
ProductList p = new ProductList();
p.Add(product);
PopulateDetailsview(p);
}
protected void lnkSave_OnCommand(object sender, CommandEventArgs e)
{
//check if the product to be added will contain sub products
RadioButtonList rbtnContainSubProduct = (fviewProduct.FindControl("rbtnContainSubProduct") as RadioButtonList);
if (rbtnContainSubProduct.SelectedValue == "yes")
{
//get the data from the form
Product mainProduct = new Product();
GetDetailsFromFormView(mainProduct);
//save the main product to be added
mainProduct.ProductID = ProductManager.Save(mainProduct);
//Gets the selected products from the sub product gridview
List <int> subProductIDList = GetSelectedSubProductsFromGridview();
//Insert records in the Assembly table using the Main product Id and sub product ID
foreach (int subProductID in subProductIDList)
{
ProductPartReplacement prodAssembly = new ProductPartReplacement();
prodAssembly.ProductID = mainProduct.ProductID;
prodAssembly.SubProductID = subProductID;
prodAssembly.CreatedBy = User.Identity.Name.ToString();
//save the records
ProductPartReplacementManager.Save(prodAssembly);
}
}
else if (rbtnContainSubProduct.SelectedValue == "no")
{
//get the data from the form
Product product = new Product();
GetDetailsFromFormView(product);
//save the main product to be added
product.ProductID = ProductManager.Save(product);
}
//Bring the form to its initial state
ResetFieldsAndGridview();
}
protected void lnkSaveSubProductEdit_OnCommand(object sender, CommandEventArgs e)
{
//Gets the selected products from the sub product gridview
List <int> subProductIDList = GetSelectedSubProductsFromGridview();
//Insert records in the Assembly table using the Main product Id and sub product ID
foreach (int subProductID in subProductIDList)
{
ProductPartReplacement prodAssembly = new ProductPartReplacement();
prodAssembly.ProductID = product.ProductID;
prodAssembly.SubProductID = subProductID;
prodAssembly.CreatedBy = User.Identity.Name.ToString();
//save the records
ProductPartReplacementManager.Save(prodAssembly);
}
ProductList p = new ProductList();
p.Add(product);
PopulateDetailsview(p);
}
public static int Save(ProductPartReplacement prodReplacement)
{
int result;
MyDBConnection myConn = new MyDBConnection();
SqlConnection conn = new SqlConnection();
try
{
conn = myConn.OpenDB();
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "dbo.InsertProductPartReplacement";
cmd.Parameters.Add("@ProductID", SqlDbType.Int).Value = prodReplacement.ProductID;
cmd.Parameters.Add("@SubProductID", SqlDbType.Int).Value = prodReplacement.SubProductID;
cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = prodReplacement.CreatedDate;
cmd.Parameters.Add("@ModifiedDate", SqlDbType.DateTime).Value = prodReplacement.ModifiedDate;
cmd.Parameters.Add("@CreatedBy", SqlDbType.VarChar).Value = prodReplacement.CreatedBy;
cmd.Parameters.Add("@ModifiedBy", SqlDbType.VarChar).Value = prodReplacement.ModifiedBy;
DbParameter returnValue = cmd.CreateParameter();
returnValue.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(returnValue);
cmd.ExecuteNonQuery();
result = Convert.ToInt32(returnValue.Value);
cmd.Dispose();
}
finally
{
myConn.CloseDB(conn);
}
return(result);
}
public static int DeleteSubPart(ProductPartReplacement subProduct)
{
return(ProductDB.DeleteSubPart(subProduct));
}
public static int Save(ProductPartReplacement prodReplacement)
{
return(ProductPartReplacementDB.Save(prodReplacement));
}
