public static List<DOChonPhongVan> getDanhSach() { List<DOChonPhongVan> arr = new List<DOChonPhongVan>(); DatabaseFB db = DABase.getDatabase(); DbCommand select = db.GetSQLStringCommand("select * from BANG_CHON_PV"); IDataReader reader = db.ExecuteReader(select); while (reader.Read()) { DOChonPhongVan bcpv = new DOChonPhongVan((int)reader["ID"], reader["NAME"].ToString()); arr.Add(bcpv); } return arr; }
public static bool Update(DOChonPhongVan ChonPhongVan) { try { string sql = "UPDATE BANG_CHON_PV SET " + "NAME = @NAME " + "WHERE ID = @ID"; DatabaseFB db = DABase.getDatabase(); DbCommand cmd = db.GetSQLStringCommand(sql); db.AddInParameter(cmd, "@ID", DbType.Int64, ChonPhongVan.getID()); db.AddInParameter(cmd, "@NAME", DbType.String, ChonPhongVan.getName()); int iCmd = db.ExecuteNonQuery(cmd); if (iCmd > 0) return true; return false; } catch (Exception ex) { throw new Exception(ex.Message); } }
public static bool Insert(DOChonPhongVan ChonPhongVan) { try { string sql = "INSERT INTO BANG_CHON_PV " + "(ID,NAME) VALUES " + "(@ID,@NAME)"; DatabaseFB db = DABase.getDatabase(); DbCommand cmd = db.GetSQLStringCommand(sql); db.AddInParameter(cmd, "@ID", DbType.Int64, ChonPhongVan.getID()); db.AddInParameter(cmd, "@NAME", DbType.String, ChonPhongVan.getName()); int iCmd = db.ExecuteNonQuery(cmd); if (iCmd > 0) return true; return false; } catch (Exception ex) { throw new Exception(ex.Message); } }