public static Mem_MemberCategory GetMem_MemberCategoryByID(int id) { Mem_MemberCategory mem_MemberCategory = new Mem_MemberCategory(); SqlMem_MemberCategoryProvider sqlMem_MemberCategoryProvider = new SqlMem_MemberCategoryProvider(); mem_MemberCategory = sqlMem_MemberCategoryProvider.GetMem_MemberCategoryByID(id); return(mem_MemberCategory); }
public int InsertMem_MemberCategory(Mem_MemberCategory mem_MemberCategory) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("IEB_InsertMem_MemberCategory", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Mem_MemberCategoryID", SqlDbType.Int).Direction = ParameterDirection.Output; cmd.Parameters.Add("@Mem_MemberCategoryName", SqlDbType.NVarChar).Value = mem_MemberCategory.Mem_MemberCategoryName; cmd.Parameters.Add("@Details", SqlDbType.NText).Value = mem_MemberCategory.Details; connection.Open(); int result = cmd.ExecuteNonQuery(); return((int)cmd.Parameters["@Mem_MemberCategoryID"].Value); } }
public Mem_MemberCategory GetMem_MemberCategoryFromReader(IDataReader reader) { try { Mem_MemberCategory mem_MemberCategory = new Mem_MemberCategory ( (int)reader["Mem_MemberCategoryID"], reader["Mem_MemberCategoryName"].ToString(), reader["Details"].ToString() ); return(mem_MemberCategory); } catch (Exception ex) { return(null); } }
public static bool UpdateMem_MemberCategory(Mem_MemberCategory mem_MemberCategory) { SqlMem_MemberCategoryProvider sqlMem_MemberCategoryProvider = new SqlMem_MemberCategoryProvider(); return(sqlMem_MemberCategoryProvider.UpdateMem_MemberCategory(mem_MemberCategory)); }
public static int InsertMem_MemberCategory(Mem_MemberCategory mem_MemberCategory) { SqlMem_MemberCategoryProvider sqlMem_MemberCategoryProvider = new SqlMem_MemberCategoryProvider(); return(sqlMem_MemberCategoryProvider.InsertMem_MemberCategory(mem_MemberCategory)); }