public static void UpdateNhaCungCap(NhaCungCapModel nhaCC) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("update NHACUNGCAP set TENNCC=@tenNCC, DIACHI = @diaChi, DIENTHOAI = @dienThoai, MAKHUVUC = @maKhuVuc, EMAIL = @email WHERE MANCC = @maNCC", nhaCC); } }
public static void RemoveNhaCungCap(NhaCungCapModel nhaCC) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { cnn.Execute("DELETE FROM NHACUNGCAP WHERE MANCC = @maNCC", nhaCC); } }
public static long SaveNhaCungCap(NhaCungCapModel nhaCC) { using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString())) { long lastRowID = (long)cnn.ExecuteScalar("insert into NHACUNGCAP(TENNCC,DIACHI,DIENTHOAI, MAKHUVUC, EMAIL) values (@tenNCC,@diaChi,@dienThoai, @maKhuVuc, @email); SELECT last_insert_rowid()", nhaCC); //lastRowID dùng để xác định ID của một hàng vừa được thêm vào. return(lastRowID); } }