public IHttpActionResult insert([FromBody] DiaChiKhachHang diaChi)
{
try
{
DiaChiKhachHang dc = db.DiaChiKhachHangs.FirstOrDefault(e => e.so_dt == diaChi.so_dt &&
e.id_khach_hang == diaChi.id_khach_hang &&
e.id_xa_phuong == diaChi.id_xa_phuong &&
e.dia_chi.Equals(diaChi.dia_chi));
if (dc != null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
diaChi.trang_thai = true;
db.DiaChiKhachHangs.InsertOnSubmit(diaChi);
db.SubmitChanges();
DiaChiKhachHang tam = new DiaChiKhachHang();
tam.id = diaChi.id;
tam.id_khach_hang = diaChi.id_khach_hang;
tam.id_quan = diaChi.id_quan;
tam.id_tinh = diaChi.id_tinh;
tam.id_xa_phuong = diaChi.id_xa_phuong;
tam.loai = diaChi.loai;
tam.dia_chi = diaChi.dia_chi;
tam.so_dt = diaChi.so_dt;
tam.ten_khach_hang = diaChi.ten_khach_hang;
return(Ok(tam));
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult update([FromBody] DiaChi diaChi)
{
try
{
DiaChiKhachHang dc = db.DiaChiKhachHangs.FirstOrDefault(e => e.id == diaChi.id);
if (dc == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
if (diaChi.idQuanHuyen != null)
{
dc.id_quan = diaChi.idQuanHuyen;
}
if (diaChi.idTinh != null)
{
dc.id_tinh = diaChi.idTinh;
}
if (diaChi.idXaPhuong != null)
{
dc.id_xa_phuong = diaChi.idXaPhuong;
}
if (diaChi.loai != null)
{
dc.loai = diaChi.loai;
}
if (diaChi.diaChi != null)
{
dc.dia_chi = diaChi.diaChi;
}
if (diaChi.tenKhachHang != null)
{
dc.ten_khach_hang = diaChi.tenKhachHang;
}
if (diaChi.soDT != null)
{
dc.so_dt = diaChi.soDT;
}
db.SubmitChanges();
var tam = new
{
id = dc.id,
idKhachHang = dc.id_khach_hang,
tenKhachHang = dc.ten_khach_hang,
soDT = dc.so_dt,
idQuan = dc.id_quan,
idTinh = dc.id_tinh,
idXaPhuong = dc.id_xa_phuong,
diaChihi = dc.dia_chi,
loai = dc.loai
};
return(Ok(tam));
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
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));
}
}
public IHttpActionResult delete(int id)
{
try
{
DiaChiKhachHang dc = db.DiaChiKhachHangs.FirstOrDefault(e => e.id == id);
if (dc == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
dc.trang_thai = false;
db.SubmitChanges();
return(Ok());
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
public IHttpActionResult layMotDiaChi(int id)
{
try
{
DiaChiKhachHang dc = db.DiaChiKhachHangs.FirstOrDefault(e => e.id == id && e.trang_thai == true);
CTDiaChi tam = new CTDiaChi();
if (dc == null)
{
return(StatusCode(HttpStatusCode.NoContent));
}
tam.idXaPhuong = dc.id_xa_phuong;
tam.tenXaPhuong = db.XaPhuongs.FirstOrDefault(e => e.ma_xa_phuong == dc.id_xa_phuong).ten;
List <QuanHuyen> listQuanHuyen = db.QuanHuyens.Where(e => e.ma_tinh == dc.id_tinh).ToList().Select(e => {
e.TinhThanh = null;
e.XaPhuongs = null;
e.DiaChiKhachHangs = null;
return(e);
}).ToList();
List <XaPhuong> listXaPhuong = db.XaPhuongs.Where(e => e.ma_quan_huyen == dc.id_quan).ToList().Select(e => {
e.QuanHuyen = null;
e.DiaChiKhachHangs = null;
return(e);
}).ToList();
tam.diaChi = dc.dia_chi;
tam.id = dc.id;
tam.idKhachHang = dc.id_khach_hang;
tam.tenKhachHang = dc.ten_khach_hang;
tam.soDT = dc.so_dt;
tam.idQuanHuyen = dc.id_quan;
tam.tenQuanHuyen = db.QuanHuyens.FirstOrDefault(e => e.ma_quan_huyen == dc.id_quan).ten_quan_huyen;
tam.idTinh = dc.id_tinh;
tam.tenTinh = db.TinhThanhs.FirstOrDefault(e => e.ma_tinh == dc.id_tinh).ten;
tam.dsQuanHuyen = listQuanHuyen;
tam.dsXaPhuong = listXaPhuong;
return(Ok(tam));
}catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}
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));
}
}
