コード例 #1
0
ファイル: DLProduct.cs プロジェクト: Anshul0305/lotas
        public int deleteProduct(EntProduct objent)
        {
            string ConnectionString = ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;
            SqlConnection conn = new SqlConnection(ConnectionString);
            conn.Open();
            SqlCommand cmd = new SqlCommand("Usp_DeleteProduct", conn);
            cmd.CommandType = CommandType.StoredProcedure;

                cmd.Parameters.AddWithValue("@ProductID", objent.ProductName);
                int result = cmd.ExecuteNonQuery();
                conn.Close();
                cmd.Dispose();
                conn.Close();
                conn.Dispose();
                return result;
        }
コード例 #2
0
ファイル: BLProduct.cs プロジェクト: Anshul0305/lotas
 public int deleteSupplier(EntProduct objent)
 {
     DLProduct objdl = new DLProduct();
        int result = objdl.deleteProduct(objent);
        return result;
 }
コード例 #3
0
 //public DataTable BindFullGrid()
 //{
 //    DLSaleProductTransaction objDAL = new DLSaleProductTransaction();
 //    return objDAL.BindFullGrid();
 //}
 public int deleteSupplier(EntProduct objent)
 {
     DLSaleProductTransaction objdl = new DLSaleProductTransaction();
        int result = objdl.deleteProduct(objent);
        return result;
 }