public async Task <IActionResult> Put(int id, [FromBody] ThuHocPhiDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.ThuHocPhis.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.IdKhoanThuCoDinh = model.IdKhoanThuCoDinh; user.IdKhoanThuDichVu = model.IdKhoanThuDichVu; user.IdKhoanThuBanHang = model.IdKhoanThuBanHang; user.IdHocKy = model.IdHocKy; user.IdKhoanChiMienGiam = model.IdKhoanChiMienGiam; user.SoLuong1 = model.SoLuong1; user.SoLuong2 = model.SoLuong2; user.SoLuong3 = model.SoLuong3; user.NgayThu = model.NgayThu; user.IdNguoiThu = model.IdNguoiThu; user.IdHocSinh = model.IdHocSinh; user.IdHinhThucThu = model.IdHinhThucThu; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] LoaiSanPhamDTO model) { using (var context = new UserProfileDbContext()) { context.LoaiSanPhams.Add(new LoaiSanPham { Id = model.Id, TenLoaiSanPham = model.TenLoaiSanPham }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task<IActionResult> Delete(int id) { using (var context = new UserProfileDbContext()) { var user = await context.ChiTietPhieuThus.FindAsync(id); if (user == null) return NotFound(); context.Entry(user).State = EntityState.Deleted; return Ok(await context.SaveChangesAsync()); } }
public async Task <IActionResult> Post([FromBody] TinhChatKhoanThuDTO model) { using (var context = new UserProfileDbContext()) { context.TinhChatKhoanThus.Add(new TinhChatKhoanThu { Id = model.Id, TenTinhChatKhoanThu = model.TenTinhChatKhoanThu }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <bool> UserActivation(UserActivationDto activationDto) { using (var _activateTrans = _userProfileDbContext.Database.BeginTransaction()) { var activate = await _userProfileDbContext.UserActivationModel.FirstOrDefaultAsync(a => a.ActivationCode == activationDto.ActivationCode && a.UserModelId == activationDto.UserId); if (activate != null) { //check if code has expired var checkTime = activate.ExpiresAt >= (DateTime.UtcNow) ? true : false; if (checkTime) { //delete the code from the database _userProfileDbContext.Remove(activate); await _userProfileDbContext.SaveChangesAsync(); //update user table with statuses var user = await _userProfileDbContext.UserModel.FirstOrDefaultAsync(u => u.Id == activationDto.UserId); if (user != null) { user.IsActivated = true; user.IsActive = true; _userProfileDbContext.Entry(user).State = EntityState.Modified; await _userProfileDbContext.SaveChangesAsync(); } //commit to database _activateTrans.Commit(); return(true); } return(false); } } return(false); }
public async Task <IActionResult> Put(int id, [FromBody] TinhChatKhoanThuDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.TinhChatKhoanThus.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.TenTinhChatKhoanThu = model.TenTinhChatKhoanThu; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] BaoCaoCongNoDTO model) { using (var context = new UserProfileDbContext()) { context.BaoCaoCongNos.Add(new BaoCaoCongNo { Id = model.Id, CongNoHocPhi = model.CongNoHocPhi, CongNoDichVu = model.CongNoDichVu, TongCongNo = model.TongCongNo, IdHocSinh = model.IdHocSinh }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] KhoanChiDTO model) { using (var context = new UserProfileDbContext()) { context.KhoanChis.Add(new KhoanChi { Id = model.Id, TenKhoanChi = model.TenKhoanChi, ThuTu = model.ThuTu, SuDung = model.SuDung, IdLoaiKhoanChi = model.IdLoaiKhoanChi }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] KhoanChiMienGiamDTO model) { using (var context = new UserProfileDbContext()) { context.KhoanChiMienGiams.Add(new KhoanChiMienGiam { Id = model.Id, TenKhoanChiMienGiam = model.TenKhoanChiMienGiam, SoTienMienGiam = model.SoTienMienGiam, GhiChu = model.GhiChu, IdKhoanChi = model.IdKhoanChi }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] HocSinhDTO model) { using (var context = new UserProfileDbContext()) { context.HocSinhs.Add(new HocSinh { Id = model.Id, TenHocSinh = model.TenHocSinh, NgaySinh = model.NgaySinh, GioiTinh = model.GioiTinh, IdLop = model.IdLop }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task<IActionResult> Put(int id, [FromBody] ChiTietPhieuThuDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.ChiTietPhieuThus.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) return NotFound(); user.Id = model.Id; user.TongTien = model.TongTien; user.KhauTru = model.KhauTru; user.DaThu = model.DaThu; user.SoTienBangChu = model.SoTienBangChu; user.IdHocSinh = model.IdHocSinh; return Ok(await context.SaveChangesAsync()); } }
public async Task <IActionResult> Post([FromBody] PhieuThuDTO model) { using (var context = new UserProfileDbContext()) { context.PhieuThus.Add(new PhieuThu { Id = model.Id, NgayThu = model.NgayThu, TongTien = model.TongTien, IdNguoiThu = model.IdNguoiThu, IdChiTietPhieuThu = model.IdChiTietPhieuThu }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Delete(int id) { using (var context = new UserProfileDbContext()) { var user = await context.TinhChatKhoanThus.FindAsync(id); if (user == null) { return(NotFound()); } context.Entry(user).State = EntityState.Deleted; return(Ok(await context.SaveChangesAsync())); } }
public async Task<IActionResult> Post([FromBody] ChiTietPhieuThuDTO model) { using (var context = new UserProfileDbContext()) { context.ChiTietPhieuThus.Add(new ChiTietPhieuThu { Id = model.Id, TongTien = model.TongTien, KhauTru = model.KhauTru, DaThu = model.DaThu, SoTienBangChu = model.SoTienBangChu, IdHocSinh = model.IdHocSinh }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return Ok(await context.SaveChangesAsync()); } }
public async Task <IActionResult> Put(int id, [FromBody] LoaiKhoanChiDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.LoaiKhoanChis.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.TenLoaiKhoanChi = model.TenLoaiKhoanChi; user.ThuTu = model.ThuTu; user.SuDung = model.SuDung; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] BaoCaoDangKyDichVuDTO model) { using (var context = new UserProfileDbContext()) { context.BaoCaoDangKyDichVus.Add(new BaoCaoDangKyDichVu { Id = model.Id, DonGia = model.DonGia, SoLuong = model.SoLuong, ThanhTien = model.ThanhTien, IdHocSinh = model.IdHocSinh, IdKhoanThuDichVu = model.IdKhoanThuDichVu }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] KhoanChiMienGiamDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.KhoanChiMienGiams.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.TenKhoanChiMienGiam = model.TenKhoanChiMienGiam; user.SoTienMienGiam = model.SoTienMienGiam; user.GhiChu = model.GhiChu; user.IdKhoanChi = model.IdKhoanChi; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] PhieuThuDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.PhieuThus.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.NgayThu = model.NgayThu; user.TongTien = model.TongTien; user.IdNguoiThu = model.IdNguoiThu; user.IdChiTietPhieuThu = model.IdChiTietPhieuThu; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] BaoCaoCongNoDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.BaoCaoCongNos.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.CongNoHocPhi = model.CongNoHocPhi; user.CongNoDichVu = model.CongNoDichVu; user.TongCongNo = model.TongCongNo; user.IdHocSinh = model.IdHocSinh; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] HocSinhDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.HocSinhs.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.TenHocSinh = model.TenHocSinh; user.NgaySinh = model.NgaySinh; user.GioiTinh = model.GioiTinh; user.IdLop = model.IdLop; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] BaoCaoDangKyDichVuDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.BaoCaoDangKyDichVus.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.DonGia = model.DonGia; user.SoLuong = model.SoLuong; user.ThanhTien = model.ThanhTien; user.IdHocSinh = model.IdHocSinh; user.IdKhoanThuDichVu = model.IdKhoanThuDichVu; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] KeHoachThuDTO model) { using (var context = new UserProfileDbContext()) { context.KeHoachThus.Add(new KeHoachThu { Id = model.Id, SoTien = model.SoTien, GhiChu = model.GhiChu, SoLuongHocSinh = model.SoLuongHocSinh, BatBuoc = model.BatBuoc, IdHocKy = model.IdHocKy, IdKhoi = model.IdKhoi, IdHinhThucThu = model.IdHinhThucThu, IdKhoanThuCoDinh = model.IdKhoanThuCoDinh, }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] KhoanThuBanHangDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.KhoanThuBanHangs.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.TenSanPham = model.TenSanPham; user.DonGia = model.DonGia; user.ThuTu = model.ThuTu; user.SuDung = model.SuDung; user.IdLoaiKhoanThu = model.IdLoaiKhoanThu; user.IdLoaiSanPham = model.IdLoaiSanPham; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] UserProfileDTO model) { using (var context = new UserProfileDbContext()) { context.UserProfiles.Add(new UserProfile { Id = model.Id, Username = model.Username, Email = model.Email, Firstname = model.Firstname, Lastname = model.Lastname, Address = model.Address, City = model.City, Country = model.Country, Salary = model.Salary, AboutMe = model.AboutMe }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] KhoanThuDichVuDTO model) { using (var context = new UserProfileDbContext()) { context.KhoanThuDichVus.Add(new KhoanThuDichVu { Id = model.Id, TenKhoanThuDichVu = model.TenKhoanThuDichVu, DonGia = model.DonGia, ThuTu = model.ThuTu, DonGiaTra = model.DonGiaTra, GhiChu = model.GhiChu, SuDung = model.SuDung, TinhTheoNgay = model.TinhTheoNgay, TraLaiKhiVang = model.TraLaiKhiVang, IdLoaiKhoanThu = model.IdLoaiKhoanThu }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] KeHoachThuDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.KeHoachThus.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.SoTien = model.SoTien; user.GhiChu = model.GhiChu; user.SoLuongHocSinh = model.SoLuongHocSinh; user.BatBuoc = model.BatBuoc; user.IdHocKy = model.IdHocKy; user.IdKhoi = model.IdKhoi; user.IdHinhThucThu = model.IdHinhThucThu; user.IdKhoanThuCoDinh = model.IdKhoanThuCoDinh; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] KhoanThuDichVuDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.KhoanThuDichVus.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.TenKhoanThuDichVu = model.TenKhoanThuDichVu; user.DonGia = model.DonGia; user.ThuTu = model.ThuTu; user.DonGiaTra = model.DonGiaTra; user.GhiChu = model.GhiChu; user.SuDung = model.SuDung; user.TinhTheoNgay = model.TinhTheoNgay; user.TraLaiKhiVang = model.TraLaiKhiVang; user.IdLoaiKhoanThu = model.IdLoaiKhoanThu; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Put(int id, [FromBody] UserProfileDTO model) { using (var context = new UserProfileDbContext()) { var user = await context.UserProfiles.FirstOrDefaultAsync(x => x.Id.Equals(id)); if (user == null) { return(NotFound()); } user.Id = model.Id; user.Username = model.Username; user.Email = model.Email; user.Firstname = model.Firstname; user.Lastname = model.Lastname; user.Address = model.Address; user.City = model.City; user.Country = model.Country; user.Salary = model.Salary; user.AboutMe = model.AboutMe; return(Ok(await context.SaveChangesAsync())); } }
public async Task <IActionResult> Post([FromBody] ThuHocPhiDTO model) { using (var context = new UserProfileDbContext()) { context.ThuHocPhis.Add(new ThuHocPhi { Id = model.Id, IdKhoanThuCoDinh = model.IdKhoanThuCoDinh, IdKhoanThuDichVu = model.IdKhoanThuDichVu, IdKhoanThuBanHang = model.IdKhoanThuBanHang, IdHocKy = model.IdHocKy, IdKhoanChiMienGiam = model.IdKhoanChiMienGiam, SoLuong1 = model.SoLuong1, SoLuong2 = model.SoLuong2, SoLuong3 = model.SoLuong3, NgayThu = model.NgayThu, IdNguoiThu = model.IdNguoiThu, IdHocSinh = model.IdHocSinh, IdHinhThucThu = model.IdHinhThucThu }); //context.Database.ExecuteSqlCommand("SET IDENTITY_INSERT [dbo].[UserProfiles] ON"); return(Ok(await context.SaveChangesAsync())); } }