public async Task <ActionResult <QuanHuyen> > PostQuanHuyen(QuanHuyen quanHuyen)
{
_context.QuanHuyens.Add(quanHuyen);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetQuanHuyen", new { id = quanHuyen.id }, quanHuyen));
}
public async Task <IActionResult> PutQuanHuyen(int id, QuanHuyen quanHuyen)
{
if (id != quanHuyen.id)
{
return(BadRequest());
}
_context.Entry(quanHuyen).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!QuanHuyenExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
private void Add_DoanVien_Click(object sender, RoutedEventArgs e)
{
Add = true;
Add_DoanVien.IsEnabled = false;
Mod_DoanVien.IsEnabled = false;
SQLiteConnection sqlite_conn = new SQLiteConnection("Data source = QuanLyDoanVien.db");
SQLiteCommand sqlite_com = new SQLiteCommand();
sqlite_conn.Open();
sqlite_com = sqlite_conn.CreateCommand();
sqlite_com.CommandText = "SELECT Max(ID) FROM DoanVien";
MaDoanVien.Text = (Convert.ToInt32(sqlite_com.ExecuteScalar()) + 1).ToString();
HoVaTen.IsEnabled = NgaySinh.IsEnabled = QueQuan.IsEnabled =
GioiTinh.IsEnabled = ChiDoan.IsEnabled = ChucVu.IsEnabled = ToDanPho.IsEnabled =
PhuongXa.IsEnabled = QuanHuyen.IsEnabled = TinhThanh.IsEnabled = NgayVaoDang.IsEnabled =
NgayVaoDoan.IsEnabled = TinhTrang.IsEnabled = CMND.IsEnabled = Email.IsEnabled =
DienThoai.IsEnabled = DanToc.IsEnabled = TonGiao.IsEnabled = HoanCanh.IsEnabled = TrinhDo.IsEnabled
= true;
HoVaTen.Clear();
NgaySinh.Clear(); QueQuan.Clear();
GioiTinh.Clear(); ChiDoan.Clear(); ChucVu.Clear(); ToDanPho.Clear();
PhuongXa.Clear(); QuanHuyen.Clear(); TinhThanh.Clear(); NgayVaoDang.Clear();
NgayVaoDoan.Clear(); TinhTrang.Clear(); CMND.Clear(); Email.Clear();
DienThoai.Clear(); DanToc.Clear(); TonGiao.Clear(); HoanCanh.Clear(); TrinhDo.Clear();
}
public IHttpActionResult allDS(int page, int size)
{
try
{
List <DiaChiKhachHang> ldc = db.DiaChiKhachHangs.Where(e => e.trang_thai == true).ToList().ToPagedList(page, size).ToList();
if (ldc.Count == 0)
{
return(StatusCode(HttpStatusCode.NotFound));
}
List <dynamic> list = new List <dynamic>();
for (int i = 0; i < ldc.Count; i++)
{
TinhThanh tinh = db.TinhThanhs.FirstOrDefault(x => x.ma_tinh == ldc[i].id_tinh);
QuanHuyen quan = db.QuanHuyens.FirstOrDefault(x => x.ma_quan_huyen == ldc[i].id_quan);
XaPhuong xa = db.XaPhuongs.FirstOrDefault(x => x.ma_xa_phuong == ldc[i].id_xa_phuong);
string diaChi = "" + ldc[i].dia_chi + ", " + xa.ten + ", " + quan.ten_quan_huyen + ", " + tinh.ten;
var tam = new
{
idDiaChi = ldc[i].id,
tenKhachHang = ldc[i].ten_khach_hang,
idKhachHang = ldc[i].id_khach_hang,
soDT = ldc[i].so_dt,
diaChi = diaChi,
};
list.Add(tam);
}
return(Ok(list));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
protected virtual void QuanHuyenModelPrepare(QuanHuyenModel model, QuanHuyen quanhuyen, bool isEdit)
{
if (quanhuyen != null)
{
model.Id = quanhuyen.Id;
model.Ten = quanhuyen.Ten;
model.Ma = quanhuyen.Ma;
model.ProvinceID = quanhuyen.ProvinceID;
var provinceinfo = _stateProvinceService.GetStateProvinceById(model.ProvinceID);
model.TenTinh = provinceinfo.Name;
}
if (isEdit)
{
var states = _stateProvinceService.GetStateProvincesByCountryId(NhaXesController.CountryID);
if (states.Count > 0)
{
foreach (var s in states)
{
model.AvailableStates.Add(new SelectListItem {
Text = s.Name, Value = s.Id.ToString(), Selected = (s.Id == model.ProvinceID)
});
}
}
}
}
public List <QuanHuyen> xoaQuanHuyen(int qh)
{
QuanHuyen qh_db = ctx.QuanHuyens.Where(x => x.MaQuan == qh).SingleOrDefault();
ctx.QuanHuyens.Remove(qh_db);
ctx.SaveChanges();
return(ctx.QuanHuyens.ToList());
}
public ActionResult DeleteConfirmed(string id)
{
QuanHuyen quanHuyen = db.QuanHuyens.Find(id);
db.QuanHuyens.Remove(quanHuyen);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public QuanHuyen suaQuanHuyen(QuanHuyen qh)
{
QuanHuyen qh_db = ctx.QuanHuyens.Where(x => x.MaQuan == qh.MaQuan).SingleOrDefault();
qh_db.TenQuan = qh.TenQuan;
ctx.SaveChanges();
return(qh);
}
public DiaDiem()
{
ten = new TenDiaDiem();
dichvu = new DichVu();
duong = new Duong();
phuong = new Phuong();
quanhuyen = new QuanHuyen();
tinhthanh = new TinhThanh();
}
public static QuanHuyenDTO FromEntity(QuanHuyen item)
{
return(new QuanHuyenDTO()
{
Id = item.Id,
TenQuanHuyen = item.TenQuanHuyen,
XaPhuong = item.XaPhuong?.Select(XaPhuongDTO.FromEntity),
TinhThanh = item.TinhThanh != null?TinhThanhDTO.FromEntity(item.TinhThanh) : null,
});
}
public virtual void Delete(QuanHuyen _item)
{
if (_item == null)
{
throw new ArgumentNullException("QuanHuyen");
}
_tableRepository.Delete(_item);
DeleteDiaDiem(_item.Id, ENLoaiDiaDiem.QuanHuyen);
}
public ActionResult Edit([Bind(Include = "ID,TenQuanHuyen,ThanhPho_ID")] QuanHuyen quanHuyen)
{
if (ModelState.IsValid)
{
db.Entry(quanHuyen).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ThanhPho_ID = new SelectList(db.ThanhPhoes, "ID", "TenThanhPho", quanHuyen.ThanhPho_ID);
return(View(quanHuyen));
}
public async Task <IActionResult> PostQuanHuyen([FromBody] QuanHuyen quanhuyen)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.QuanHuyens.Add(quanhuyen);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetQuanHuyen", new { id = quanhuyen.QuanHuyenId }, quanhuyen));
}
public virtual void Update(QuanHuyen _item)
{
if (_item == null)
{
throw new ArgumentNullException("QuanHuyen");
}
_tableRepository.Update(_item);
var tinh = _tinhRepository.GetById(_item.ProvinceID);
InsertOrUpdateDiaDiem(_item.Id, ENLoaiDiaDiem.QuanHuyen, _item.Ten + " - " + tinh.Name);
}
public ActionResult Create([Bind(Include = "ID,TenQuanHuyen,ThanhPho_ID")] QuanHuyen quanHuyen)
{
if (ModelState.IsValid)
{
db.QuanHuyens.Add(quanHuyen);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ThanhPho_ID = new SelectList(db.ThanhPhoes, "ID", "TenThanhPho", quanHuyen.ThanhPho_ID);
return(View(quanHuyen));
}
public IHttpActionResult getHoaDon(int id) //id
{
try
{
HienThiDonHang ctDonHang = new HienThiDonHang();
string diaChi = "";
DonDatHang donHang = db.DonDatHangs.FirstOrDefault(x => x.id_don_hang == id);
DiaChiKhachHang dc = db.DiaChiKhachHangs.FirstOrDefault(x => x.id == donHang.id_dia_chi);
TinhThanh tinh = db.TinhThanhs.FirstOrDefault(x => x.ma_tinh == dc.id_tinh);
QuanHuyen quan = db.QuanHuyens.FirstOrDefault(x => x.ma_quan_huyen == dc.id_quan);
XaPhuong xa = db.XaPhuongs.FirstOrDefault(x => x.ma_xa_phuong == dc.id_xa_phuong);
if (donHang == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
ctDonHang.idDonDatHang = donHang.id_don_hang;
ctDonHang.trangThai = db.TinhTrangDonHangs.FirstOrDefault(x => x.id_tinh_trang == donHang.id_tinh_trang).tinh_trang_don_hang;
ctDonHang.ngayLap = donHang.ngay_lap.ToShortDateString();
ctDonHang.tenNguoiNhan = db.KhachHangs.FirstOrDefault(x => x.id_khach_hang == donHang.id_khach_hang).ten_nguoi_dung;
ctDonHang.soDT = "0" + donHang.so_dt_nguoi_nhan;
diaChi = "" + dc.dia_chi + ", " + xa.ten + ", " + quan.ten_quan_huyen + ", " + tinh.ten;
ctDonHang.diaChi = diaChi;
// add danh sach san pham
List <ChiTietDonHang> list = db.ChiTietDonHangs.Where(x => x.id_don_hang == id).ToList();
List <DSSanPham> lDanhSanPham = new List <DSSanPham>();
for (int i = 0; i < list.Count; i++)
{
DSSanPham dsp = new DSSanPham();
dsp.soLuong = list[i].so_luong;
dsp.tongGia = (float)list[i].tong_tien;
dsp.giaKM = (float)list[i].gia_km;
//gan san pham
SanPham tam = db.SanPhams.FirstOrDefault(x => x.id_san_pham == list[i].id_san_pham);
SanPham sp = new SanPham();
sp.id_san_pham = tam.id_san_pham;
sp.id_danh_muc = tam.id_danh_muc;
sp.mo_ta = tam.mo_ta;
sp.phan_tram_km = tam.phan_tram_km;
sp.ten_sp = tam.ten_sp;
sp.url_hinh_chinh = "http://www.3anhem.somee.com" + tam.url_hinh_chinh;
sp.gia_sp = tam.gia_sp;
sp.gia_km = tam.gia_km;
dsp.sanPham = sp;
lDanhSanPham.Add(dsp);
}
ctDonHang.danhSachHang = lDanhSanPham;
return(Ok(ctDonHang));
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
// GET: Admin/District/Details/5
public ActionResult Details(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
QuanHuyen quanHuyen = db.QuanHuyens.Find(id);
if (quanHuyen == null)
{
return(HttpNotFound());
}
return(View(quanHuyen));
}
// GET: Admin/District/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
QuanHuyen quanHuyen = db.QuanHuyens.Find(id);
if (quanHuyen == null)
{
return(HttpNotFound());
}
ViewBag.ThanhPho_ID = new SelectList(db.ThanhPhoes, "ID", "TenThanhPho", quanHuyen.ThanhPho_ID);
return(View(quanHuyen));
}
public SinhVienViewModel() : base()
{
sinhVien = new SinhVien();
quanHuyen = new QuanHuyen();
nganhHoc = new NganhHoc();
XacNhan = new RelayCommand(
param => true, param => XacNhanLuuSinhVien());
NhapLai = new RelayCommand(
param => true, param => NhapLaiThongTinSinhVien());
LoadDanhMucTinhThanh();
LoadDanhMucQuanHuyen();
LoadDanhMucDTUT();
LoadDanhMucKhoa();
LoadDanhMucNganhHoc();
}
private void btnThem_Click(object sender, EventArgs e)
{
ResetForm();
//Nếu độ dài lớn hơn 10 thì chỉ lấy 10 ký tự đầu tiên
if (txtMaQuanHuyen.Text.Length > 10)
{
txtMaQuanHuyen.Text = txtMaQuanHuyen.Text.Substring(0, 10);
}
if (txtMaQuanHuyen.Text.Equals(""))
{
lbl_MaPhuongXa.Text = "Vui lòng nhập mã quận huyện!";
return;
}
else if (txtTenQuanHuyen.Text.Equals(""))
{
lbl_TenPhuongXa.Text = "Vui lòng nhập tên quận huyện!";
return;
}
else if (comboBox_TenTinhThanh.SelectedValue.ToString().Equals(""))
{
lbl_TenTinhThanh.Text = "Vui lòng chọn tên tỉnh thành!";
return;
}
else if (DungChung.qhBO.Exist(txtMaQuanHuyen.Text))
{
lbl_MaPhuongXa.Text = "Mã quận huyện đã tồn tại!";
return;
}
else
{
QuanHuyen qh = new QuanHuyen();
qh.MaQuanHuyen = txtMaQuanHuyen.Text;
qh.TenQuanHuyen = txtTenQuanHuyen.Text;
qh.MaTinhThanh = comboBox_TenTinhThanh.SelectedValue.ToString();
DungChung.Db.QuanHuyens.InsertOnSubmit(qh);
DungChung.Db.SubmitChanges();
DungChung.frmMain.QLQuanHuyen_Load();
MessageBox.Show("Đã thêm quận huyện!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
public ActionResult Create(QuanHuyenModel model, bool continueEditing)
{
if (!_permissionService.Authorize(StandardPermissionProvider.QLDanhMuc))
{
return(AccessDeniedView());
}
if (ModelState.IsValid)
{
var quanhuyen = new QuanHuyen();
quanhuyen.Ma = model.Ma;
quanhuyen.Ten = model.Ten;
quanhuyen.ProvinceID = model.ProvinceID;
_quanhuyenService.Insert(quanhuyen);
SuccessNotification(_localizationService.GetResource("Admin.chonve.quanhuyen.themmoithanhcong"));
return(continueEditing ? RedirectToAction("Edit", new { id = quanhuyen.Id }) : RedirectToAction("List"));
}
return(View(model));
}
public IHttpActionResult getListHoaDon([FromBody] PhanTrang phanTrang)
{
try
{
//
List <DonDatHang> list = db.DonDatHangs.Where(x => x.id_khach_hang == phanTrang.id).ToPagedList(phanTrang.trang, phanTrang.size).ToList();
List <HTListHoaDon> lhd = new List <HTListHoaDon>();
if (list == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
for (int i = 0; i < list.Count; i++)
{
HTListHoaDon hoaDonTam = new HTListHoaDon();
// tao dia chi noi nhan hang
DiaChiKhachHang dc = db.DiaChiKhachHangs.FirstOrDefault(e => e.id == list[i].id_dia_chi);
TinhThanh tinh = db.TinhThanhs.FirstOrDefault(x => x.ma_tinh == dc.id_tinh);
QuanHuyen quan = db.QuanHuyens.FirstOrDefault(x => x.ma_quan_huyen == dc.id_quan);
XaPhuong xa = db.XaPhuongs.FirstOrDefault(x => x.ma_xa_phuong == dc.id_xa_phuong);
string diaChi = "" + dc.dia_chi + ", " + xa.ten + ", " + quan.ten_quan_huyen + ", " + tinh.ten;
hoaDonTam.id = list[i].id_don_hang;
hoaDonTam.KhachHang = db.KhachHangs.FirstOrDefault(e => e.id_khach_hang == list[i].id_khach_hang).ten_nguoi_dung;
hoaDonTam.TinhTrang = db.TinhTrangDonHangs.FirstOrDefault(e => e.id_tinh_trang == list[i].id_tinh_trang).tinh_trang_don_hang;
hoaDonTam.ngayLap = list[i].ngay_lap.ToShortDateString();
hoaDonTam.DiaChi = diaChi;
hoaDonTam.soDT = list[i].so_dt_nguoi_nhan;
hoaDonTam.tongGia = (float)list[i].tong_tien;
hoaDonTam.ghiChu = list[i].ghi_chu;
lhd.Add(hoaDonTam);
}
return(Ok(lhd));
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public List <QuanHuyen> ReadItemsByTinhThanh(int tinhThanh)
{
List <QuanHuyen> quanHuyens = new List <QuanHuyen>();
DataTable dataTable = new DataTable();
try
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
OleDbCommand command = new OleDbCommand(
"SELECT * FROM QUAN_HUYEN WHERE TinhThanh=@matinhthanh " +
"ORDER BY TenQuanHuyen ASC", connection);
command.Parameters.Add("@matinhthanh", OleDbType.Numeric).Value = tinhThanh;
OleDbDataAdapter oleDbDataAdapter = new OleDbDataAdapter(command);
oleDbDataAdapter.Fill(dataTable);
}
catch (Exception ex)
{
throw ex;
}
finally
{
connection.Close();
}
foreach (DataRow row in dataTable.Rows)
{
QuanHuyen quanHuyen = new QuanHuyen();
quanHuyen.MaQuanHuyen = int.Parse(row["MaQuanHuyen"].ToString());
quanHuyen.TenQuanHuyen = row["TenQuanHuyen"].ToString();
quanHuyen.TinhThanh = int.Parse(row["TinhThanh"].ToString());
quanHuyen.ThongTin = row["ThongTin"].ToString();
quanHuyens.Add(quanHuyen);
}
return(quanHuyens);
}
public QuanHuyen themQuanHuyen(QuanHuyen qh)
{
ctx.QuanHuyens.Add(qh);
ctx.SaveChanges();
return(qh);
}
private void FrmSuaNK_Load(object sender, EventArgs e)
{
var pp = from s in FrmMain._danhSachNhanKhau
where s.MaNhanKhau.Equals(FrmMain.MaNhanKhau)
select s;
_nk = pp.First();
xa3 = bo.get(_nk.QueQuan);
xa2 = bo.get(_nk.NoiThuongTruTruocKhiChuyenDen);
xa1 = bo.get(_nk.NoiLamViec);
DsXa3 = bo.getList(xa3.MaQuanHuyen);
DsXa2 = bo.getList(xa2.MaQuanHuyen);
DsXa1 = bo.getList(xa1.MaQuanHuyen);
huyen3 = huyenBo.get(xa3.MaQuanHuyen);
huyen2 = huyenBo.get(xa2.MaQuanHuyen);
huyen1 = huyenBo.get(xa1.MaQuanHuyen);
DsHuyen3 = huyenBo.getList(huyen3.MaTinhThanh);
DsHuyen2 = huyenBo.getList(huyen2.MaTinhThanh);
DsHuyen1 = huyenBo.getList(huyen1.MaTinhThanh);
CboTinh1.DataSource = DsTinh1;
CboTinh2.DataSource = DsTinh2;
CboTinh3.DataSource = DsTinh3;
CboTinh1.DisplayMember = "TenTinhThanh";
CboTinh2.DisplayMember = "TenTinhThanh";
CboTinh3.DisplayMember = "TenTinhThanh";
CboTinh1.ValueMember = "MaTinhThanh";
CboTinh2.ValueMember = "MaTinhThanh";
CboTinh3.ValueMember = "MaTinhThanh";
Cboxa3.DataSource = DsXa3;
Cboxa2.DataSource = DsXa2;
CboXa1.DataSource = DsXa1;
Cboxa3.DisplayMember = "TenPhuongXa";
Cboxa2.DisplayMember = "TenPhuongXa";
CboXa1.DisplayMember = "TenPhuongXa";
Cboxa3.ValueMember = "MaPhuongXa";
Cboxa2.ValueMember = "MaPhuongXa";
CboXa1.ValueMember = "MaPhuongXa";
CboHuyen1.DataSource = DsHuyen1;
Cbohuyen2.DataSource = DsHuyen2;
Cbohuyen3.DataSource = DsHuyen3;
CboHuyen1.DisplayMember = "TenQuanHuyen";
Cbohuyen2.DisplayMember = "TenQuanHuyen";
Cbohuyen3.DisplayMember = "TenQuanHuyen";
CboHuyen1.ValueMember = "MaQuanHuyen";
Cbohuyen2.ValueMember = "MaQuanHuyen";
Cbohuyen3.ValueMember = "MaQuanHuyen";
CboTenHoKhau.DataSource = FrmMain._danhSachHoKhau;
CboTenHoKhau.DisplayMember = "TenChuHo";
CboTenHoKhau.ValueMember = "MaHoKhau";
Cboxa3.SelectedValue = _nk.QueQuan;
Cboxa2.SelectedValue = _nk.NoiThuongTruTruocKhiChuyenDen;
CboXa1.SelectedValue = _nk.NoiLamViec;
CboHuyen1.SelectedValue = huyen1.MaQuanHuyen;
Cbohuyen2.SelectedValue = huyen2.MaQuanHuyen;
Cbohuyen3.SelectedValue = huyen3.MaQuanHuyen;
var q1 = from s in DsXa3
where s.MaPhuongXa.Equals(_nk.QueQuan)
select s;
var q2 = from s in DsXa2
where s.MaPhuongXa.Equals(_nk.NoiThuongTruTruocKhiChuyenDen)
select s;
var q3 = from s in DsXa1
where s.MaPhuongXa.Equals(_nk.NoiLamViec)
select s;
if (_nk.GioiTinh != null && _nk.GioiTinh.Value.Equals("1"))
{
CboGioiTinh.Text = "Nam";
}
else
{
CboGioiTinh.Text = "Nữ";
}
CboDanToc.Text = _nk.DanToc;
txtHoTen.Text = _nk.TenNhanKhau;
txtTenKhac.Text = _nk.TenThuongGoi;
txtCMND.Text = _nk.CMND;
txtNgheNghiep.Text = _nk.NgheNghiep;
txtTonGiao.Text = _nk.TonGiao;
if (_nk.NgaySinh != null)
{
DTPKNgaySinh.Value = _nk.NgaySinh.Value;
}
if (_nk.NgayChuyenDen != null)
{
DTPKChuyenDenNgay.Value = _nk.NgayChuyenDen.Value;
}
}
public IHttpActionResult danhSach(int id)
{
try
{
List <DiaChiKhachHang> list = db.DiaChiKhachHangs.Where(e => e.id_khach_hang == id && e.trang_thai == true).ToList().Select(e => { e.DonDatHangs = null; return(e); }).ToList();
List <dynamic> ldt = new List <dynamic>();
if (list.Count == 0)
{
return(StatusCode(HttpStatusCode.NoContent));
}
for (int i = 0; i < list.Count; i++)
{
List <QuanHuyen> listQuanHuyen = db.QuanHuyens.Where(e => e.ma_tinh == list[i].id_tinh).ToList();
List <dynamic> listQuan = new List <dynamic>();
for (int j = 0; j < listQuanHuyen.Count; j++)
{
var a = new
{
ma_quan_huyen = listQuanHuyen[i].ma_quan_huyen,
ten_quan_huyen = listQuanHuyen[i].ten_quan_huyen,
loai = listQuanHuyen[i].loai,
ma_tinh = listQuanHuyen[i].ma_tinh,
};
listQuan.Add(a);
}
List <XaPhuong> listXaPhuong = db.XaPhuongs.Where(e => e.ma_quan_huyen == list[i].id_quan).ToList();
List <dynamic> lx = new List <dynamic>();
for (int k = 0; k < listXaPhuong.Count; k++)
{
var b = new
{
ma_quan_huyen = listXaPhuong[k].ma_quan_huyen,
ten = listXaPhuong[i].ten,
loai = listXaPhuong[i].loai,
ma_xa_phuong = listXaPhuong[i].ma_xa_phuong,
};
lx.Add(b);
}
TinhThanh tinh = db.TinhThanhs.FirstOrDefault(x => x.ma_tinh == list[i].id_tinh);
QuanHuyen quan = db.QuanHuyens.FirstOrDefault(x => x.ma_quan_huyen == list[i].id_quan);
XaPhuong xa = db.XaPhuongs.FirstOrDefault(x => x.ma_xa_phuong == list[i].id_xa_phuong);
string diaChi = list[i].dia_chi + ", " + xa.ten + ", " + quan.ten_quan_huyen + ", " + tinh.ten;
var tam = new
{
idXaPhuong = list[i].id_xa_phuong,
tenXaPhuong = xa.ten,
diaChi = list[i].dia_chi,
id = list[i].id,
idKhachHang = list[i].id_khach_hang,
tenKhachHang = list[i].ten_khach_hang,
soDT = list[i].so_dt,
idQuanHuyen = list[i].id_quan,
tenQuanHuyen = quan.ten_quan_huyen,
idTinh = list[i].id_tinh,
tenTinh = tinh.ten,
diaChiCuThe = list[i].dia_chi + ", " + xa.ten + ", " + quan.ten_quan_huyen + ", " + tinh.ten,
dsQuanHuyen = listQuan,
dsXaPhuong = lx
};
ldt.Add(tam);
}
return(Ok(ldt));
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public async Task CreateQuanHuyen(QuanHuyen quanHuyen)
{
await _quanHuyenRepository.AddAsync(quanHuyen);
}
public async Task UpdateQuanHuyen(QuanHuyen quanHuyen)
{
await _quanHuyenRepository.UpdateAsync(quanHuyen);
}
/// <summary>
/// Create a new QuanHuyen object.
/// </summary>
/// <param name="quanID">Initial value of quanID.</param>
public static QuanHuyen CreateQuanHuyen(int quanID)
{
QuanHuyen quanHuyen = new QuanHuyen();
quanHuyen.quanID = quanID;
return quanHuyen;
}
public IActionResult SuaQuanHuyen(QuanHuyen qh)
{
_quanhuyenRepository.suaQuanHuyen(qh);
return(RedirectToAction("QuanHuyenInformation"));
}
/// <summary>
/// There are no comments for QuanHuyen in the schema.
/// </summary>
public void AddToQuanHuyen(QuanHuyen quanHuyen)
{
base.AddObject("QuanHuyen", quanHuyen);
}
public IActionResult SuaQuanHuyen(int id)
{
QuanHuyen qh = _quanhuyenRepository.timkiemQH_theoid(id);
return(View("QuanHuyenEdited", qh));
}
