public static int Insert(NhanVien employee) { provider = new DataProvider(); provider.Connect(); string cmdStr = "Execute proc_AddEmployee N'" + employee.HoTen + "', " + "'" + employee.NgaySinh.ToString("yyyy-MM-dd") + "', " + "N'" + employee.GioiTinh + "', " + "N'" + employee.DiaChi + "', " + "'" + employee.SoDienThoai + "', " + "'" + employee.NgayVaoLam.ToString("yyyy-MM-dd") + "', " + "N'" + employee.ChucVu + "', " + employee.Luong; int result = provider.ExecuteNonQuery(cmdStr); provider.Disconnect(); return(result); }
public static void thuephong(string maphong) { string query = string.Format("usp_thuephongmoi @map ={0}", maphong); var u = DataProvider.ExecuteNonQuery(query); }
public static void PhucHoiDuLieu(string path) { string sql = "use master alter database [QuanLiTraSua] set Single_User with Rollback Immediate Restore database [QuanLiTraSua] from disk = N'" + path + "' with replace alter database [QuanLiTraSua] set Multi_User"; DataProvider.ExecuteNonQuery(sql); }
public static void CheckOut(int idBill, int GiamGia, float tongtien) { string query = "UPDATE dbo.HoaDon SET ngayra = GETDATE(), thanhtoan = 1" + ", giamgia = " + GiamGia + ", tongtien = " + tongtien + " WHERE id = " + idBill; DataProvider.ExecuteNonQuery(query); }
public static bool UpDateAccount(string username, string dislayname, string pass1, string pass2) { int kq = (int)DataProvider.ExecuteNonQuery("EXEC dbo.UpdateAccount @username , @displayname , @pass1 , @pass2", new object[] { username, dislayname, pass1, pass2 }); return(kq > 0); }
public static void InsertBill(int idbanan) { DataProvider.ExecuteNonQuery("EXEC InsertBill @idbanan", new object[] { idbanan }); }
public bool ThemHoaDonKhongTheKH(HoaDonDTO dto) { string sql = "insert into HoaDon values(GETDATE(), " + dto.TongTien + "," + dto.TienGiam + ", " + dto.TienThanhToan + ", NULL, " + dto.NVLapHD + ")"; return(dp.ExecuteNonQuery(sql)); }
public bool PhanCong(CTCaLamViecDTO dto) { string sql = "insert into CTCaLamViec values(" + dto.MaCa + "," + dto.MaNV + ",N'" + dto.CV + "')"; return(dp.ExecuteNonQuery(sql)); }
public static void DeleteBillInfoByIdFood(int idfood) { string truyvan = string.Format("DELETE dbo.ChiTietHoaDon WHERE idthucan = {0}", idfood); DataProvider.ExecuteNonQuery(truyvan); }
public static void InsertBillInfo(int idhoadon, int idthucan, int soluong) { DataProvider.ExecuteNonQuery("EXEC InsertBillInfo @idhoadon , @idthucan , @soluong", new object[] { idhoadon, idthucan, soluong }); }
public static void CapNhatChiPhi(int machiphi) { string query = string.Format("usp_updatechiphi @machiphi={0}", machiphi); var u = DataProvider.ExecuteNonQuery(query); }