public int AddDomain_Insert_Update_Delete(BAL_AddProduct baproduct)
{
try
{
con.Open();
cmd = new SqlCommand("SP_Add_Product", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@Domain_Name", baproduct.Domain_Name);
cmd.Parameters.AddWithValue("@PAN_Card", baproduct.PAN_Card);
cmd.Parameters.AddWithValue("@Adhar_Card", baproduct.Adhar_Card);
cmd.Parameters.AddWithValue("@Passport", baproduct.Passport);
cmd.Parameters.AddWithValue("@Address_Proof", baproduct.Address_Proof);
cmd.Parameters.AddWithValue("@Seven_Twevel", baproduct.Seven_Twevel);
cmd.Parameters.AddWithValue("@Form_16", baproduct.Form_16);
cmd.Parameters.AddWithValue("@Dealer_Lisence", baproduct.Dealer_Lisence);
cmd.Parameters.AddWithValue("@Other_ID_Proof", baproduct.Other_ID_Proof);
cmd.Parameters.AddWithValue("@No_Documents", baproduct.No_Documents);
cmd.Parameters.AddWithValue("@Cmp_ID_Proof", baproduct.Cmp_ID_Proof);
cmd.Parameters.AddWithValue("@S_Status", baproduct.S_Status);
cmd.Parameters.AddWithValue("@C_Date", baproduct.C_Date);
int i = cmd.ExecuteNonQuery();
return(i);
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
public int Save_Insert_Update_Delete(BAL_AddProduct baproduct)
{
try
{
con.Open();
cmd = new SqlCommand("SP_Save", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@Domain_ID", baproduct.Domain_ID);
cmd.Parameters.AddWithValue("@Product_ID", baproduct.Product_ID);
cmd.Parameters.AddWithValue("@Brand_ID", baproduct.Brand_ID);
cmd.Parameters.AddWithValue("@P_Category", baproduct.P_Category);
cmd.Parameters.AddWithValue("@Model_No_ID", baproduct.Model_No_ID);
cmd.Parameters.AddWithValue("@Color_ID", baproduct.Color_ID);
cmd.Parameters.AddWithValue("@Narration", baproduct.Narration);
cmd.Parameters.AddWithValue("@Price", baproduct.Price);
cmd.Parameters.AddWithValue("@S_Status", baproduct.S_Status);
cmd.Parameters.AddWithValue("@C_Date", baproduct.C_Date);
int i = cmd.ExecuteNonQuery();
return(i);
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}
public int AddBrand_Insert_Update_Delete(BAL_AddProduct baproduct)
{
try
{
con.Open();
cmd = new SqlCommand("SP_ADDBrand", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Flag", 1);
cmd.Parameters.AddWithValue("@Product_ID", baproduct.Product_ID);
cmd.Parameters.AddWithValue("@Brand_Name", baproduct.Brand_Name);
cmd.Parameters.AddWithValue("@S_Status", baproduct.S_Status);
cmd.Parameters.AddWithValue("@C_Date", baproduct.C_Date);
int i = cmd.ExecuteNonQuery();
return(i);
}
catch (Exception)
{
throw;
}
finally { con.Close(); }
}