public CCategories AddCategory(string strCategory) { try { CDatabase Database = new CDatabase(); CCategories Category = new CCategories(); int intCategoryID = Database.InsertCategory(strCategory); if (intCategoryID > 0) { Category.intCategoryID = intCategoryID; Category.strCategory = strCategory; Category.ActionStatus = CCategories.ActionStatusTypes.CategoryAdded; } else { Category.ActionStatus = CCategories.ActionStatusTypes.CategoryAddFailed; } return(Category); } catch (Exception ex) { throw new Exception(ex.Message); } }
// Get User \/ public List <CCategories> GetCategories(int intCategoryID = 0) { SqlConnection Connection = new SqlConnection(); List <CCategories> CategoryList = new List <CCategories>(); try { if (OpenDBConnection(ref Connection) == 0) { SqlDataAdapter da = new SqlDataAdapter("uspSelectCategory", Connection); da.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure; DataSet ds = new DataSet(); if (intCategoryID != 0) { SetParameter(ref da, "@intCategoryID", intCategoryID, SqlDbType.Int); } else { SetParameter(ref da, "@intCategoryID", null, SqlDbType.Int); } try { da.Fill(ds); foreach (DataTable dt in ds.Tables) { foreach (DataRow dr in dt.Rows) { CCategories Category = new CCategories(); Category.intCategoryID = Convert.ToInt32((dr["intCategoryID"])); Category.strCategory = (dr["strCategory"]).ToString(); CategoryList.Add(Category); } } } finally { CloseDBConnection(ref Connection); } } // return CategoryList; return(CategoryList); } catch (Exception ex) { throw new Exception(ex.Message); } }
public int AddAddress(CAddress Address) { try { CDatabase Database = new CDatabase(); CCategories Category = new CCategories(); int intAddressID = Database.InsertAddress(Address); return(intAddressID); } catch (Exception ex) { throw new Exception(ex.Message); } }
// Insert Category \ public int InsertCategory(string strCategory) { try { SqlConnection Connection = null; if (OpenDBConnection(ref Connection) == 0) { CCategories category = new CCategories(); int intReturnID = 0; SqlCommand cm = new SqlCommand("uspAddCategory", Connection); SetParameter(ref cm, "@strCategory", strCategory, SqlDbType.VarChar); SetParameter(ref cm, "ReturnValue", 0, SqlDbType.Int, Direction: ParameterDirection.ReturnValue); cm.ExecuteReader(); CloseDBConnection(ref Connection); if (!Convert.IsDBNull(cm.Parameters["ReturnValue"].Value)) { intReturnID = (int)cm.Parameters["ReturnValue"].Value; } return(intReturnID); //success } else { return(-1); // No database connection } } catch (Exception ex) { throw new Exception(ex.Message); } }