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));
}
