Ejemplo n.º 1
0
        public async Task <ActionResult <XaPhuong> > PostXaPhuong(XaPhuong xaPhuong)
        {
            _context.xaPhuongs.Add(xaPhuong);
            await _context.SaveChangesAsync();

            return(CreatedAtAction("GetXaPhuong", new { id = xaPhuong.MaXaPhuong }, xaPhuong));
        }
Ejemplo n.º 2
0
 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));
     }
 }
Ejemplo n.º 3
0
        public async Task <IActionResult> PutXaPhuong(int id, XaPhuong xaPhuong)
        {
            if (id != xaPhuong.MaXaPhuong)
            {
                return(BadRequest());
            }

            _context.Entry(xaPhuong).State = EntityState.Modified;

            try
            {
                await _context.SaveChangesAsync();
            }
            catch (DbUpdateConcurrencyException)
            {
                if (!XaPhuongExists(id))
                {
                    return(NotFound());
                }
                else
                {
                    throw;
                }
            }

            return(NoContent());
        }
Ejemplo n.º 4
0
 public static XaPhuongDTO FromEntity(XaPhuong item)
 {
     return(new XaPhuongDTO()
     {
         Id = item.Id,
         TenXaPhuong = item.TenXaPhuong,
         QuanHuyen = item.QuanHuyen != null?QuanHuyenDTO.FromEntity(item.QuanHuyen) : null,
     });
 }
Ejemplo n.º 5
0
 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));
     }
 }
Ejemplo n.º 6
0
        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));
            }
        }
Ejemplo n.º 7
0
 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));
     }
 }
Ejemplo n.º 8
0
 public async Task UpdateXaPhuong(XaPhuong xaPhuong)
 {
     await _xaPhuongRepository.UpdateAsync(xaPhuong);
 }
Ejemplo n.º 9
0
 public async Task CreateXaPhuong(XaPhuong xaPhuong)
 {
     await _xaPhuongRepository.AddAsync(xaPhuong);
 }