protected override object GetDataFromDataRow(DataTable dt, int i) { TuKhoaDichVu tkdv = new TuKhoaDichVu(); tkdv.MaTuKhoaDichVu = (int)dt.Rows[i]["MaTuKhoaDichVu"]; tkdv.TenTuKhoaDichVu = dt.Rows[i]["TenTuKhoaDichVu"].ToString(); tkdv.MaDichVu = (int)dt.Rows[i]["MaDichVu"]; return((object)tkdv); }
public bool insertTuKhoaDichVu(TuKhoaDichVu bl) { try { connect(); string insertCommand = "INSERT INTO TUKHOADICHVU VALUES(N'" + bl.TenTuKhoaDichVu + "', '" + bl.MaDichVu + "')"; executeNonQuery(insertCommand); disconnect(); return(true); } catch (Exception e) { return(false); } }
public bool updateTuKhoaDichVu(TuKhoaDichVu tkdv) { try { connect(); string updateCommand = string.Format("UPDATE TUKHOADICHVU SET TenTuKhoaDichVu = N'" + tkdv.TenTuKhoaDichVu + "' WHERE MaTuKhoaDichVu = " + tkdv.MaTuKhoaDichVu); executeNonQuery(updateCommand); disconnect(); return(true); } catch (Exception e) { return(false); } }
public List <TuKhoaTraVe> getTuKhoaDichVu(string tukhoa) { try { connect(); string query = "SELECT * FROM TUKHOADICHVU"; adapter = new SqlDataAdapter(query, connection); DataSet dataset = new DataSet(); adapter.Fill(dataset); ArrayList ls = ConvertDataSetToArrayList(dataset); List <TuKhoaTraVe> arr = new List <TuKhoaTraVe>(); //List<int> dem = new List<int>(); foreach (Object o in ls) { TuKhoaDichVu tt = (TuKhoaDichVu)o; TuKhoaTraVe dv = new TuKhoaTraVe(); ApproximatString A = new ApproximatString(tt.TenTuKhoaDichVu); int C = A.SoSanh(tukhoa); if (C != -1) { if (arr.Count == 0) { dv.ma = tt.MaDichVu; dv.saiso = C; dv.bang = 1; arr.Add(dv); } else { for (int i = 0; i < arr.Count; i++) { if (arr[i].saiso > C) { dv.ma = tt.MaDichVu; dv.saiso = C; dv.bang = 1; if (arr[i].ma != dv.ma) { arr.Insert(i, dv); } else { arr[i] = dv; } i = arr.Count; } } } } } disconnect(); return(arr); } catch (Exception e) { return(null); } }