public List <DM_CATEGORY> getDataSource() { List <DM_CATEGORY> list = new List <DM_CATEGORY>(); DM_CATEGORY obj = null; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = " Use [rbi] Select [DMCategoryID]" + ",[DMCategoryName]" + "From [rbi].[dbo].[DM_CATEGORY] "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new DM_CATEGORY(); obj.DMCategoryID = reader.GetInt32(0); obj.DMCategoryName = reader.GetString(1); list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(list); }
public void edit(DM_CATEGORY obj) { DAL.edit(obj.DMCategoryID, obj.DMCategoryName); }
public void delete(DM_CATEGORY obj) { DAL.delete(obj.DMCategoryID); }
public void add(DM_CATEGORY obj) { DAL.add(obj.DMCategoryID, obj.DMCategoryName); }