public string ProductInser_dal(ProductMaster_prop l_ProductMaster_prop)
 {
     try
     {
         return(SqlHelper.ExecuteDataset(com.con, "usp_ProductMaster_INSERT", new object[] { l_ProductMaster_prop.ProductName }).Tables[0].Rows[0][0].ToString());
     }
     catch (Exception Ex)
     {
         throw Ex;
     }
 }
        public DataTable ProductSearch_dal(ProductMaster_prop ProductMasterprop)
        {
            try
            {
                return(SqlHelper.ExecuteDataset(com.con, "usp_Product_Search", new object[] { ProductMasterprop.ProductName }).Tables[0]);
            }

            catch (Exception Ex)
            {
                throw Ex;
            }
        }
 public DataTable ProductSearch_bal(ProductMaster_prop ProductMasterprop)
 {
     try
     {
         DataTable dt = ProductMasterdal.ProductSearch_dal(ProductMasterprop);
         return(dt);
     }
     catch (Exception Ex)
     {
         ErrMessage = Ex.Message;
         return(null);
     }
 }
 public string ProductMasterInsert_bal(ProductMaster_prop l_ProductMaster)
 {
     try
     {
         string strMsg = ProductMasterdal.ProductInser_dal(l_ProductMaster);
         return(strMsg);
     }
     catch (Exception Ex)
     {
         ErrMessage = Ex.Message;
         return("");
     }
 }