public static void UpdateKhachHang(KhachHangModel KhachHang) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("update KhachHang set TENKH = @TenKH,DIACHI = @DiaChi ,SDT = @SDT, MAKHUVUC = @MaKhuVuc ,EMAIL = @Email WHERE MAKH = @MaKH", KhachHang); } }
public static void RemoveKhachHang(KhachHangModel KhachHang) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("DELETE FROM KhachHang WHERE MAKH=@MaKH", KhachHang); } }
public static long SaveKhachHang(KhachHangModel khachHang) { Console.WriteLine(khachHang.MaKH); using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { long lastRowID = (long)cnn.ExecuteScalar("insert into KhachHang(TENKH,DIACHI,SDT,MAKHUVUC,EMAIL) values (@TenKH,@DiaChi,@SDT,@MaKhuVuc,@Email); SELECT last_insert_rowid()", khachHang); //lastRowID dùng để xác định ID của một hàng vừa được thêm vào. return(lastRowID); } }