Esempio n. 1
0
        public bool insertBrand(DTO_NhanHieu nhanHieuDTO)
        {
            string query = "insert into NhanHieu(TenNhanHieu) values(@_TenNhanHieu)";

            SqlParameter[] sqlParameters = new SqlParameter[1];
            sqlParameters[0]       = new SqlParameter("@_TenNhanHieu", SqlDbType.NVarChar);
            sqlParameters[0].Value = nhanHieuDTO.Name;
            return(conn.executeInsertQuery(query, sqlParameters));
        }
Esempio n. 2
0
        public bool insertDevice(DTO_ThietBiSuaChua thietBiSuaChuaDTO)
        {
            string query = "insert into THIETBISUACHUA(TenThietBi, Model, MaNhanHieu) values(@_Ten,@_Model,@_BrandId)";

            SqlParameter[] sqlParameters = new SqlParameter[3];
            sqlParameters[0]       = new SqlParameter("@_Ten", SqlDbType.NVarChar);
            sqlParameters[0].Value = thietBiSuaChuaDTO.Name;
            sqlParameters[1]       = new SqlParameter("@_Model", SqlDbType.VarChar);
            sqlParameters[1].Value = thietBiSuaChuaDTO.Model;
            sqlParameters[2]       = new SqlParameter("@_BrandId", SqlDbType.VarChar);
            sqlParameters[2].Value = thietBiSuaChuaDTO.BrandID.ToString();
            return(conn.executeInsertQuery(query, sqlParameters));
        }
        public bool insertCustomer(DTO_KhachHang khachHangDTO)
        {
            string query = "insert into KhachHang(HoTen, DiaChi, SoDienThoai) values(@_HoTen, @_DiaChi, @_SDT)";

            SqlParameter[] sqlParameters = new SqlParameter[3];
            sqlParameters[0]       = new SqlParameter("@_HoTen", SqlDbType.NVarChar);
            sqlParameters[0].Value = khachHangDTO.HoTen;
            sqlParameters[1]       = new SqlParameter("@_DiaChi", SqlDbType.NVarChar);
            sqlParameters[1].Value = khachHangDTO.DiaChi;
            sqlParameters[2]       = new SqlParameter("@_SDT", SqlDbType.VarChar);
            sqlParameters[2].Value = khachHangDTO.SDT;

            return(conn.executeInsertQuery(query, sqlParameters));
        }
Esempio n. 4
0
        public bool insertRepairing(DTO_SuaChua repairDTO)
        {
            string query = "if exists (select * from YEUCAUSUACHUA where MaYeuCau = @_MaYeuCau and DaSuaChua = 0) begin insert into SUACHUA(MaYeuCau, NgayLap, TienCong, MoTaLoi) " +
                           " values(@_MaYeuCau,@_NgayLap, @_TienCong, @_MoTaLoi ) update YEUCAUSUACHUA set DaSuaChua = 1 where MaYeuCau = @_MaYeuCau end  ";

            SqlParameter[] sqlParameters = new SqlParameter[4];
            sqlParameters[0]       = new SqlParameter("@_MaYeuCau", SqlDbType.VarChar);
            sqlParameters[0].Value = repairDTO.requestID.ToString();
            sqlParameters[1]       = new SqlParameter("@_NgayLap", SqlDbType.VarChar);
            sqlParameters[1].Value = repairDTO.Date.ToString("MM-dd-yyyy");
            sqlParameters[2]       = new SqlParameter("@_TienCong", SqlDbType.VarChar);
            sqlParameters[2].Value = repairDTO.TienCong.ToString();
            sqlParameters[3]       = new SqlParameter("@_MoTaLoi", SqlDbType.NVarChar);
            sqlParameters[3].Value = repairDTO.MoTaLoi;

            return(conn.executeInsertQuery(query, sqlParameters));
        }
        public bool insertBoughtDevice(DTO_NhapThietBi nhapDTO)
        {
            string query = "insert into NHAPTHIETBI(MaYeuCau, TenThietBi, SoLuong, DonGia, NgayNhap) " +
                           " values(@_MaYeuCau,@_TenThietBi, @_SoLuong, @_DonGia, @_NgayNhap)";

            SqlParameter[] sqlParameters = new SqlParameter[5];
            sqlParameters[0]       = new SqlParameter("@_MaYeuCau", SqlDbType.VarChar);
            sqlParameters[0].Value = nhapDTO.RequestID.ToString();
            sqlParameters[1]       = new SqlParameter("@_TenThietBi", SqlDbType.NVarChar);
            sqlParameters[1].Value = nhapDTO.DeviceName;
            sqlParameters[2]       = new SqlParameter("@_SoLuong", SqlDbType.VarChar);
            sqlParameters[2].Value = nhapDTO.Quantity.ToString();
            sqlParameters[3]       = new SqlParameter("@_DonGia", SqlDbType.VarChar);
            sqlParameters[3].Value = nhapDTO.UnitPrice.ToString();
            sqlParameters[4]       = new SqlParameter("@_NgayNhap", SqlDbType.VarChar);
            sqlParameters[4].Value = nhapDTO.Date.ToString("MM-dd-yyyy");

            return(conn.executeInsertQuery(query, sqlParameters));
        }
Esempio n. 6
0
        public bool insertRequest(DTO_YeuCauSuaChua yeucauDTO)
        {
            string query = "insert into YEUCAUSUACHUA(MaKH, NgayNhan, MaMonHang, SoLuong, MoTaTinhTrang, DaSuaChua, ChiTiet) " +
                           " values(@_MaKH,@_NgayNhan,@_MaMonHang, @_SoLuong, @_MoTaTinhTrang, @_DaSuaChua, @_ChiTiet)";

            SqlParameter[] sqlParameters = new SqlParameter[7];
            sqlParameters[0]       = new SqlParameter("@_MaKH", SqlDbType.VarChar);
            sqlParameters[0].Value = yeucauDTO.MaKH.ToString();
            sqlParameters[1]       = new SqlParameter("@_NgayNhan", SqlDbType.VarChar);
            sqlParameters[1].Value = yeucauDTO.NgayNhan.ToString("MM-dd-yyyy");
            sqlParameters[2]       = new SqlParameter("@_MaMonHang", SqlDbType.VarChar);
            sqlParameters[2].Value = yeucauDTO.MaMonHang.ToString();
            sqlParameters[3]       = new SqlParameter("@_SoLuong", SqlDbType.VarChar);
            sqlParameters[3].Value = yeucauDTO.SoLuong.ToString();
            sqlParameters[4]       = new SqlParameter("@_MoTaTinhTrang", SqlDbType.NVarChar);
            sqlParameters[4].Value = yeucauDTO.MoTaTinhTrang;
            sqlParameters[5]       = new SqlParameter("@_DaSuaChua", SqlDbType.VarChar);
            sqlParameters[5].Value = yeucauDTO.DaSuaChua.ToString();
            sqlParameters[6]       = new SqlParameter("@_ChiTiet", SqlDbType.NVarChar);
            sqlParameters[6].Value = yeucauDTO.ChiTiet;

            return(conn.executeInsertQuery(query, sqlParameters));
        }