public HoaDonBanModel CreateItem([FromBody] HoaDonBanModel model)
{
model.Mahdb = Guid.NewGuid().ToString();
if (model.listjson_chitiet != null)
{
foreach (var item in model.listjson_chitiet)
{
item.Macthdb = Guid.NewGuid().ToString();
}
}
_hoaDonBusiness.Create(model);
return(model);
}
public HoaDonBanModel UpdateItem([FromBody] HoaDonBanModel model)
{
if (model.Mahdb != null)
{
var arrData = model.Mahdb.Split(';');
if (arrData.Length == 3)
{
var savePath = $@"assets/images/{arrData[0]}";
model.Mahdb = $"{savePath}";
SaveFileFromBase64String(savePath, arrData[2]);
}
}
_hoaDonBusiness.Update(model);
return(model);
}
public JsonResult GetbyID(string ID)
{
var hoadonban = db.HoaDonBans.FirstOrDefault(x => x.Id == ID);
var model = new HoaDonBanModel();
model.Id = hoadonban.Id;
var khachhang = db.KhachHangs.FirstOrDefault(x => x.Id == hoadonban.MaKhach);
model.TenDangNhap = khachhang.TenDangNhap;
model.DiaChi = khachhang.DiaChi;
model.SDT = khachhang.SDT;
model.TongTien = hoadonban.TongTien;
model.Email = khachhang.Email;
return(Json(model, JsonRequestBehavior.AllowGet));
}
public ActionResult Index()
{
var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION];
if (session != null)
{
var model = new HoaDonBanModel();
model.SelectChiNhanh = new SelectList(db.ChiNhanhs, "Id", "TenChiNhanh", 0);
return(View(model));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
// GET: Bill
public ActionResult CreateBill(int tongtien)
{
ViewBag.TotalMoney = tongtien;
var session = (ChuoiCuaHangTraSua.Common.UserLogin)Session[ChuoiCuaHangTraSua.Common.Constants.USER_SESSION];
var khachhang = new KhachHangDao().getById(session.UserId);
var model = new HoaDonBanModel();
model.MaKhach = khachhang.Id;
model.TongTien = tongtien;
model.DiaChi = khachhang.DiaChi;
model.HoTen = khachhang.HoTen;
model.SDT = khachhang.SDT;
model.Email = khachhang.Email;
// model.SelectChiNhanh = new SelectList(db.ChiNhanhs, "Id", "TenChiNhanh", 1);
return(View(model));
}
public ActionResult DuyetHoaDon(string mahoadon)
{
var model = new HoaDonBanModel();
var hoadonban = db.HoaDonBans.FirstOrDefault(x => x.Id == mahoadon);
model.Id = hoadonban.Id;
var khachhang = db.KhachHangs.FirstOrDefault(x => x.Id == hoadonban.MaKhach);
model.HoTen = khachhang.HoTen;
model.DiaChi = khachhang.DiaChi;
model.SDT = khachhang.SDT;
ViewBag.TotalMoney = hoadonban.TongTien;
model.SelectChiNhanh = new SelectList(db.ChiNhanhs, "Id", "TenChiNhanh", 1);
return(View(model));
}
public JsonResult ListDuyet(int?page)
{
var list = db.HoaDonBans.Where(x => x.MaKhach != 3 && x.MaKhach != 4 && x.Duyet == 1).OrderByDescending(x => x.Id).ToList();
int pageSize = 10;
var data = new List <HoaDonBanModel>();
int i = 0;
foreach (var item in list)
{
i++;
var itemmodel = new HoaDonBanModel();
itemmodel.STT = i;
itemmodel.Id = item.Id;
itemmodel.NgayBanShow = String.Format("{0:d/M/yyyy}", item.NgayBan);
var khachhang = new KhachHangDao().viewDetail(item.MaKhach);
itemmodel.TenDangNhap = khachhang.TenDangNhap;
itemmodel.DiaChi = khachhang.DiaChi;
itemmodel.SDT = khachhang.SDT;
itemmodel.TongTienShow = String.Format("{0:0,0}", item.TongTien);
itemmodel.Status = item.Duyet;
itemmodel.DaThanhToan = item.DaThanhToan;
data.Add(itemmodel);
}
if (page > 0)
{
page = page;
}
else
{
page = 1;
}
int start = (int)(page - 1) * pageSize;
ViewBag.pageCurrent = page;
int totalPage = data.Count();
float totalNumsize = (totalPage / (float)pageSize);
int numSize = (int)Math.Ceiling(totalNumsize);
ViewBag.numSize = numSize;
var datamodel = data.Skip(start).Take(pageSize);
return(Json(new { data = datamodel, pageCurrent = page, numSize = numSize }, JsonRequestBehavior.AllowGet));
}
public ActionResult DanhSachHDB_DaDuyet()
{
var list = new List <HoaDonBanModel>();
var listproduct = (from hdb in db.HoaDonBans
join kh in db.KhachHangs on hdb.MaKhach equals kh.Id
where hdb.Duyet == 1
select new
{
Id = hdb.Id,
NgayBan = hdb.NgayBan,
TenKhach = kh.HoTen,
DiaChi = kh.DiaChi,
DienThoai = kh.SDT,
KhuyenMai = hdb.GiamGia,
TongTien = hdb.TongTien,
DaDuyet = hdb.Duyet,
DaThanhToan = hdb.DaThanhToan
}).OrderByDescending(x => x.Id);
int i = 0;
foreach (var item in listproduct)
{
i++;
var model = new HoaDonBanModel();
model.Id = item.Id;
model.STT = i;
model.NgayBan = item.NgayBan;
model.HoTen = item.TenKhach;
model.DiaChi = item.DiaChi;
model.KhuyenMai = item.KhuyenMai;
model.SDT = item.DienThoai;
model.TongTien = item.TongTien;
model.Status = item.DaDuyet;
model.DaThanhToan = item.DaThanhToan;
list.Add(model);
}
return(View(list));
}
public ActionResult DanhSachHoaDon_NhanVien()
{
var session_nhanvien = (ChuoiCuaHangTraSua.Common.NhanVienLogin)Session[ChuoiCuaHangTraSua.Common.Constants.NHANVIEN_SESSION];
var model = new List <HoaDonBanModel>();
var nhanvien = db.NhanViens.FirstOrDefault(x => x.Id == session_nhanvien.UserId);
var list = db.HoaDonBans.Where(x => x.MaChiNhanh == nhanvien.MaChiNhanh && x.Duyet == 1 && x.DaThanhToan == 0).ToList();
int i = 0;
foreach (var item in list)
{
i++;
var itemmodel = new HoaDonBanModel();
itemmodel.Id = item.Id;
var khachhang = db.KhachHangs.FirstOrDefault(x => x.Id == item.MaKhach);
itemmodel.DiaChi = khachhang.DiaChi;
itemmodel.SDT = khachhang.SDT;
itemmodel.HoTen = khachhang.HoTen;
itemmodel.STT = i;
itemmodel.TongTien = item.TongTien;
model.Add(itemmodel);
}
return(View(model));
}
/// <summary>
/// To the entity.
/// </summary>
/// <param name="model">The model.</param>
/// <param name="destination">The destination.</param>
/// <returns>HoaDonBan.</returns>
public static HoaDonBan ToEntity(this HoaDonBanModel model, HoaDonBan destination)
{
return(model.MapTo(destination));
}
/// <summary>
/// To the entity.
/// </summary>
/// <param name="model">The model.</param>
/// <returns>HoaDonBan.</returns>
public static HoaDonBan ToEntity(this HoaDonBanModel model)
{
return(model.MapTo <HoaDonBanModel, HoaDonBan>());
}
public JsonResult Update(HoaDonBanModel hoadonban)
{
return(Json(dao.UpdateDuyet(hoadonban), JsonRequestBehavior.AllowGet));
}
/// <summary>
/// Posts the view.
/// </summary>
/// <param name="value">The value.</param>
public void PostView(HoaDonBanModel value)
{
currentHoaDonBanModel = value;
currentListDataTable = null;
dataGridView.Columns.Clear();
var g = new DataGridViewCheckBoxColumn {
Name = "CB", HeaderText = "", Width = 24, AutoSizeMode = DataGridViewAutoSizeColumnMode.None, ReadOnly = true
};
dataGridView.Columns.Add(g);
dataSourceDataTable = value.ChiTietHDBModel.ToDataTable();
dataSourceDataTable.AcceptChanges();
dataBindingSource.DataSource = dataSourceDataTable;
dataGridView.DataSource = dataBindingSource;
//dataGridView.DataSource = new BindingSource { DataSource = value.ChiTietHDBModel };
dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.ID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.SanPhamID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.SanPham)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.HoaDonBanID)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.HoaDonBan)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.SoHDB)].Display(false);
dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.IDModel)].Display(false);
if (dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.MaGiayDep)] != null)
{
dataGridView.Columns[Rf.Name <ChiTietHdbModel>(c => c.MaGiayDep)].DisplayIndex = 1;
}
if (value != null)
{
if (value.SoHDB != null)
{
txtMaHoaDon.Text = value.SoHDB;
}
if (value.MaNV != null)
{
txtMaNhanVien.Text = value.MaNV;
}
if (value.MaKhach != null)
{
txtMaKhach.Text = value.MaKhach;
}
if (value.NgayBan != null)
{
txtNgayBan.Text = value.NgayBan.ToDateString();
}
if (value.TongTien != null)
{
txtTongTien.Text = value.TongTien.ToString();
}
}
txtMaNhanVien.Text = AppMediator.MANHANVIEN;
dataGridView.ClearSelection();
dataGridView.CurrentCell = null;
if (isEditMode)
{
bntLuu.Enabled = false;
bntTaoMoi.Enabled = true;
bntXoa.Enabled = false;
bntLuaChon.Enabled = false;
txtMaHoaDon.Focus();
}
else
{
bntLuu.Enabled = false;
bntTaoMoi.Enabled = false;
bntXoa.Enabled = false;
}
currentModel = null;
}
public bool Update(HoaDonBanModel model)
{
return(_res.Update(model));
}
public bool Create(HoaDonBanModel model)
{
return(_res.Create(model));
}
/// <summary>
/// Handles the CellDoubleClick event of the dgv control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="DataGridViewCellEventArgs"/> instance containing the event data.</param>
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
currentModel = (HoaDonBanModel)dataGridView.CurrentSelected(currentModelList);
controller.ShowHoaDonBanView(currentModel);
}
/// <summary>
/// Handles the Click event of the bntLuaChon control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="EventArgs" /> instance containing the event data.</param>
private void bntLuaChon_Click(object sender, EventArgs e)
{
currentModel = (HoaDonBanModel)dataGridView.CurrentSelected(currentModelList);
//MessageBox.Show(currentModel.MaGiayDep);
}
/// <summary>
/// Initializes the form.
/// </summary>
/// <param name="value">The value.</param>
public void InitializeForm(HoaDonBanModel value)
{
//txtMaCV.Text = value;
}
public ActionResult CreateBill(HoaDonBanModel model)
{
var session = (ChuoiCuaHangTraSua.Common.UserLogin)Session[ChuoiCuaHangTraSua.Common.Constants.USER_SESSION];
if (session != null)
{
new KhachHangDao().Update(session.UserId, model.HoTen, model.DiaChi, model.SDT, model.Email);
// tạo idbill
DateTime now = DateTime.Now;
var idbill = session.UserId.ToString() + now.Day.ToString() + now.Hour.ToString() + now.Minute.ToString() + now.Second.ToString();
//insert order
var dao = new CartDao();
var cart = dao.GetProductsByIdUser(session.UserId);
var item = new HoaDonBan();
item.Id = idbill.ToString();
item.MaKhach = session.UserId;
item.MaNhanVien = 1;
item.DaThanhToan = 0;
item.Duyet = 0;
item.TongTien = model.TongTien;
item.NgayBan = now;
var result = new BillDao().Insert(item);
foreach (var item_hdb in cart)
{
//insert orderdetail
var ct_hdb = new ChiTietHDB();
ct_hdb.MaHDB = idbill.ToString();
var product = new ProductDao().viewDetail(item_hdb.MaSanPham);
ct_hdb.MaSanPham = item_hdb.MaSanPham;
ct_hdb.SoLuong = item_hdb.SoLuong;
ct_hdb.GiamGia = 0;
ct_hdb.ThanhTien = product.KhuyenMai * item_hdb.SoLuong;
ct_hdb.ThuocSanPham = item_hdb.ThuocSanPham;
ct_hdb.ChiTietThu = item_hdb.SanPhamThu;
new BillDao().Insert_Bill_Detail(ct_hdb);
//delete cart
dao.Delete(item_hdb.Id);
}
var khachhang = new KhachHangDao().getById(session.UserId);
string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/neworder.html"));
content = content.Replace("{{CustomerName}}", khachhang.HoTen);
content = content.Replace("{{Phone}}", khachhang.SDT);
content = content.Replace("{{Email}}", khachhang.Email);
content = content.Replace("{{Address}}", khachhang.DiaChi);
content = content.Replace("{{Total}}", String.Format("{0:0,0}", model.TongTien));
var toEmail = ConfigurationManager.AppSettings["ToEmailAddress"].ToString();
new MailHelper().SendMail(khachhang.Email, "Đơn hàng mới từ Estore", content);
new MailHelper().SendMail(toEmail, "Đơn hàng mới từ Estore", content);
ViewBag.Success1 = "Bạn vừa đặt hàng thành công, kiếm tra email của bạn";
return(RedirectToAction("Index", "SanPham"));
}
else
{
return(Redirect("/Login/Login"));
}
}
public ActionResult CreateBill(HoaDonBanModel model)
{
if (ModelState.IsValid)
{
var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION];
if (session != null)
{
new KhachHangDao().Update_KH(session.UserId, model.HoTen, model.SDT, model.Email);
// tạo idbill
DateTime now = DateTime.Now;
var idbill = session.UserId.ToString() + now.Day.ToString() + now.Hour.ToString() + now.Minute.ToString() + now.Second.ToString();
//insert order
var dao = new CartDao();
var cart = dao.GetProductsByIdUser(session.UserId);
var item = new HoaDonBan();
item.Id = idbill.ToString();
item.MaKhach = session.UserId;
item.MaNhanVien = 1;
item.DaThanhToan = 0;
item.Duyet = 0;
item.DiaChi = model.DiaChi;
item.TongTien = model.TongTien;
item.PhiShip = model.PhiShip;
item.TongTien_HoaDon = model.TongTien + model.PhiShip;
item.MaChiNhanh = model.MaChiNhanh;
item.NgayBan = now;
var result = new BillDao().Insert(item);
foreach (var item_hdb in cart)
{
//insert orderdetail
var ct_hdb = new ChiTietHDB();
ct_hdb.MaHDB = idbill.ToString();
var product = new ProductDao().viewDetail(item_hdb.MaSanPham);
ct_hdb.MaSanPham = item_hdb.MaSanPham;
ct_hdb.SoLuong = item_hdb.SoLuong;
ct_hdb.GiamGia = 0;
ct_hdb.ThanhTien = product.KhuyenMai * item_hdb.SoLuong;
ct_hdb.ThuocSanPham = item_hdb.ThuocSanPham;
ct_hdb.ChiTietThu = item_hdb.SanPhamThu;
new BillDao().Insert_Bill_Detail(ct_hdb);
//delete cart
dao.Delete(item_hdb.Id);
}
var khachhang = new KhachHangDao().getById(session.UserId);
//string content = System.IO.File.ReadAllText(Server.MapPath("~/Content/neworder.html"));
//content = content.Replace("{{CustomerName}}", khachhang.HoTen);
//content = content.Replace("{{Phone}}", khachhang.SDT);
//content = content.Replace("{{Email}}", khachhang.Email);
//content = content.Replace("{{Address}}", khachhang.DiaChi);
//content = content.Replace("{{Total}}", String.Format("{0:0,0}", model.TongTien));
try
{
//ConfigurationManager.AppSettings["ToEmailAddress"]
//var toEmail = "*****@*****.**";
//new MailHelper().SendMail(khachhang.Email, "Đơn hàng mới từ Estore", content);
//new MailHelper().SendMail(toEmail, "Đơn hàng mới từ Estore", content);
ViewBag.TotalMoney = model.TongTien;
Session[DoAn.Common.Constants.SANPHAMTHU_SESSION] = null;
var viewmodel = new DoAn.Models.Model.NguoiDung.HoaDonBanModel();
viewmodel.MaKhach = khachhang.Id;
viewmodel.TongTien = model.TongTien;
viewmodel.DiaChi = khachhang.DiaChi;
viewmodel.HoTen = khachhang.HoTen;
viewmodel.SDT = khachhang.SDT;
viewmodel.Email = khachhang.Email;
viewmodel.PhiShip = model.PhiShip;
ViewBag.Success = "Bạn vừa đặt hàng thành công";
ViewBag.MaHoaDonBan = idbill;
return(View(viewmodel));
}
catch (Exception e)
{
ViewBag.TotalMoney = model.TongTien;
var viewmodel = new DoAn.Models.Model.NguoiDung.HoaDonBanModel();
viewmodel.MaKhach = khachhang.Id;
viewmodel.TongTien = model.TongTien;
viewmodel.DiaChi = khachhang.DiaChi;
viewmodel.HoTen = khachhang.HoTen;
viewmodel.SDT = khachhang.SDT;
viewmodel.Email = khachhang.Email;
ViewBag.Error = "Gmail bạn nhập không chính xác, vui lòng kiểm tra lại";
return(View(viewmodel));
}
}
else
{
return(Redirect("/Login/Login"));
}
}
else
{
ViewBag.TotalMoney = model.TongTien;
var session = (DoAn.Common.Session.UserLogin)Session[DoAn.Common.Constants.USER_SESSION];
var khachhang = new KhachHangDao().getById(session.UserId);
var modelview = new DoAn.Models.Model.NguoiDung.HoaDonBanModel();
modelview.MaKhach = khachhang.Id;
modelview.TongTien = model.TongTien;
modelview.DiaChi = khachhang.DiaChi;
modelview.HoTen = khachhang.HoTen;
modelview.SDT = khachhang.SDT;
modelview.Email = khachhang.Email;
return(View(modelview));
}
}
