private void addData(HoaDonXuat hdxObj)
{
hdxObj.Mahd = txtMahd.Text.Trim();
hdxObj.NgayLap = txtNgayLap.Text.Trim();
hdxObj.NguoiLap = cboNvl.SelectedValue.ToString();
hdxObj.KhachHang = cboKh.SelectedValue.ToString();
}
public IHttpActionResult PutHoaDonXuat(int id, HoaDonXuat hoaDonXuat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != hoaDonXuat.IDHoaDonXuat)
{
return(BadRequest());
}
db.Entry(hoaDonXuat).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!HoaDonXuatExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public List <HoaDonXuat> GetHoaDonXuat(string sql)
{
dp.connect();
List <HoaDonXuat> list = new List <HoaDonXuat>();
{
int soluong, dongia;
string maxuat, manv, makh, tenxe;
try
{
SqlDataReader dr = dp.ExecuteReader(sql);
while (dr.Read())
{
maxuat = dr.GetString(0);
manv = dr.GetString(1);
makh = dr.GetString(2);
tenxe = dr.GetString(4);
soluong = dr.GetInt32(5);
dongia = dr.GetInt32(6);
HoaDonXuat em = new HoaDonXuat(maxuat, manv, makh, tenxe, soluong, dongia);
list.Add(em);
}
dr.Close();
return(list);
}
catch (SqlException ex)
{
throw ex;
}
finally { dp.disconnect(); }
}
}
private void saveData()
{
//save data to chitietHDN
ChiTietHDX ctHDX = new ChiTietHDX();
ctHDX.IDHDX = mIDHDX;
ctHDX.IDSP = (long)cboSanPham.EditValue;
ctHDX.SoLuong = Convert.ToDouble(txtSoLuong.Text.Trim());
ctHDX.DonGia = Convert.ToDouble(txtDonGia.Text.Trim());
ctHDX.VAT = Convert.ToDouble(txtVAT.Text.Trim());
//save data to SanPham: so luong nhap va gia nhap.
SanPham sp = db.SanPhams.FirstOrDefault(x => x.ID == ctHDX.IDSP);
sp.SoLuong = sp.SoLuong - ctHDX.SoLuong;
if (sp.SoLuong < 0)
{
MsgUtil.MessageThongBao("Số lượng sản phẩm này trong kho không đủ để xuất! Vui lòng kiểm tra lại.");
return;
}
sp.GiaBan = ctHDX.DonGia * (1 + (Double)ctHDX.VAT / 100);
//save data to HDN
HoaDonXuat hd = db.HoaDonXuats.FirstOrDefault(x => x.ID == ctHDX.IDHDX);
hd.TongTien = hd.TongTien + sp.GiaBan * ctHDX.SoLuong;
db.ChiTietHDXes.Add(ctHDX);
db.SaveChanges();
loadDatatoGrid();
MsgUtil.MessageThemSuccess();
}
private void btThem_Click(object sender, EventArgs e)
{
string maxuat, manv, makh, tenxe;
int soluong, dongia;
maxuat = txtMaXuat.Text.Trim();
manv = txtMaNV.Text.Trim();
makh = txtMaKH.Text.Trim();
tenxe = txtTenXe.Text.Trim();
soluong = int.Parse(txtSoLuong.Text.Trim());
dongia = int.Parse(txtDonGia.Text.Trim());
HoaDonXuat emp = new HoaDonXuat(maxuat, manv, makh, tenxe, soluong, dongia);
try
{
int i = new HoaDonXuatBUS().Add(emp);
dgvHoaDonXuat.DataSource = GetHoaDonXuat();
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
try
{
QuanLyBanHangEntities db = new QuanLyBanHangEntities();
if (validate.CheckTextBoxisEmpty(txtMaHDX) &&
checkExistMaHDX(db))
{
HoaDonXuat hdx = new HoaDonXuat();
hdx.IDTK = MsgUtil.userID;
hdx.MaHDX = txtMaHDX.Text.Trim();
hdx.NgayXuat = dtNgayXuat.Value;
if (txtKhachHang.Text.Length > 0)
{
hdx.TenKhachHang = txtKhachHang.Text.Trim();
}
if (txtDienThoai.Text.Length > 0)
{
hdx.DienThoai = txtDienThoai.Text.Trim();
}
db.HoaDonXuats.Add(hdx);
db.SaveChanges();
loadDatatoGrid();
MsgUtil.MessageThemSuccess();
}
}
catch (Exception v_e)
{
MsgUtil.MessageThongBao("Lỗi " + v_e);
}
}
void getDulieu(HoaDonXuat hdxobj)
{
hdxobj.Mahd = txtMahd.Text.Trim();
hdxobj.NgayLap = txtNgayLap.Text.Trim();
hdxobj.NguoiLap = cboNvl.Text.Trim();
hdxobj.KhachHang = cboKh.Text.Trim();
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
HoaDonXuat hoaDonXuat = await db.HoaDonXuats.FindAsync(id);
db.HoaDonXuats.Remove(hoaDonXuat);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public void ghiFile(ArrayList arrayList)
{
StreamWriter streamWriter = new StreamWriter(path);
foreach (HoaDonXuat HoaDonXuat in arrayList)
{
streamWriter.WriteLine(HoaDonXuat.ToString());
}
streamWriter.Close();
}
private bool checkExistMaHDX(QuanLyBanHangEntities db)
{
HoaDonXuat dhx = db.HoaDonXuats.FirstOrDefault(x => x.MaHDX == txtMaHDX.Text.Trim());
if (dhx == null)
{
return(true);
}
MsgUtil.MessageThongBao("Mã đơn hóa đơn đã tồn tại!");
return(false);
}
public IHttpActionResult GetHoaDonXuat(int id)
{
HoaDonXuat hoaDonXuat = db.HoaDonXuats.Find(id);
if (hoaDonXuat == null)
{
return(NotFound());
}
return(Ok(hoaDonXuat));
}
public IHttpActionResult PostHoaDonXuat(HoaDonXuat hoaDonXuat)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.HoaDonXuats.Add(hoaDonXuat);
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = hoaDonXuat.IDHoaDonXuat }, hoaDonXuat));
}
public async Task <ActionResult> Edit([Bind(Include = "MaHDXuat,NgayXuat,MaKH,TongTien")] HoaDonXuat hoaDonXuat)
{
if (ModelState.IsValid)
{
db.Entry(hoaDonXuat).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", hoaDonXuat.MaKH);
return(View(hoaDonXuat));
}
// GET: HoaDonXuat/Create
public ActionResult Create()
{
HoaDonXuat model = new HoaDonXuat()
{
NgayXuat = DateTime.Now,
};
ViewBag.MaNV = new SelectList(db.NhanViens, "MaNV", "TenNV");
ViewBag.LoaiSanPham = new SelectList(db.LoaiGiays, "MaLG", "TenLG");
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH");
return(View(model));
}
// GET: HoaDonXuat/Delete/5
public async Task <ActionResult> Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HoaDonXuat hoaDonXuat = await db.HoaDonXuats.FindAsync(id);
if (hoaDonXuat == null)
{
return(HttpNotFound());
}
return(View(hoaDonXuat));
}
public IHttpActionResult DeleteHoaDonXuat(int id)
{
HoaDonXuat hoaDonXuat = db.HoaDonXuats.Find(id);
if (hoaDonXuat == null)
{
return(NotFound());
}
db.HoaDonXuats.Remove(hoaDonXuat);
db.SaveChanges();
return(Ok(hoaDonXuat));
}
// GET: HoaDonXuat/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HoaDonXuat hoaDonXuat = await db.HoaDonXuats.FindAsync(id);
if (hoaDonXuat == null)
{
return(HttpNotFound());
}
ViewBag.MaKH = new SelectList(db.KhachHangs, "MaKH", "TenKH", hoaDonXuat.MaKH);
return(View(hoaDonXuat));
}
public IHttpActionResult Delete(int id)
{
using (QuanLyCoffeeDbContext entities = new QuanLyCoffeeDbContext())
{
HoaDonXuat hdx = entities.HoaDonXuats.Find(id);
if (hdx == null)
{
return(NotFound());
}
entities.HoaDonXuats.Remove(hdx);
entities.SaveChanges();
return(Ok("Deleted successfully"));
}
}
public int Add(HoaDonXuat emp)
{
//ktra rang buoc tự nhiên
if (emp.MaXuat == "")
{
return(-2); // khong thanh cong se return -2, thành công sẽ return 1 trong DataProvider
}
try
{
return(new HoaDonXuatDAO().Add(emp));
}
catch (SqlException ex)
{
throw ex;
}
}
// GET: HoaDonXuat/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
HoaDonXuat hoaDonXuat = await db.HoaDonXuats.FindAsync(id);
if (hoaDonXuat == null)
{
return(HttpNotFound());
}
ViewData["CT_HoaDonXuat"] = await db.CT_HoaDonXuat.Where(t => t.MaHDXuat == id).ToListAsync();
return(View(hoaDonXuat));
}
public ActionResult EditHoaDonXuat(HoaDonXuatJson hdx)
{
try
{
HoaDonXuat temp = db.HoaDonXuat.Where(n => n.MaHDX == hdx.MaHDX).SingleOrDefault();
temp.MaNV = hdx.MaNV; temp.MaKH = hdx.MaKH;
temp.NgayXuat = Convert.ToDateTime(hdx.NgayXuat);
temp.BacSi = hdx.BacSi; temp.DVCT = hdx.DVCT;
db.Entry(temp).State = EntityState.Modified;
db.SaveChanges();
return(Json(new { success = true, message = "Sửa thành công" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { success = false, message = "Sửa không thành công, lỗi: " + e.Message }, JsonRequestBehavior.AllowGet));
}
}
public async Task <JsonResult> CreateConfirmed(HoaDonXuat info, string json1)
{
string msg = "ok";
//HoaDonNhap info = /*JsonConvert.DeserializeObject<HoaDonNhap>(json0);*/ new HoaDonNhap();
List <CT_HoaDonXuat> cT_HoaDonXuats = JsonConvert.DeserializeObject <List <CT_HoaDonXuat> >(json1);
try
{
//Lấy giá tiền
var maGiays = cT_HoaDonXuats.Select(t => t.MaGiay).ToArray();
var giays = await db.Giays.Where(t => maGiays.Contains(t.MaGiay)).ToArrayAsync();
foreach (var giay in giays)
{
var cT_HoaDonXuat = cT_HoaDonXuats.Where(t => t.MaGiay == giay.MaGiay).FirstOrDefault();
cT_HoaDonXuat.Gia = giay.Gia;
}
info.TongTien = cT_HoaDonXuats.Select(t => (decimal)t.SoLuong * t.Gia).Sum();
db.HoaDonXuats.Add(info);
await db.SaveChangesAsync();
foreach (var cT_HoaDonXuat in cT_HoaDonXuats)
{
cT_HoaDonXuat.MaHDXuat = info.MaHDXuat;
}
db.CT_HoaDonXuat.AddRange(cT_HoaDonXuats);
await UpdateCount(cT_HoaDonXuats, -1);
await db.SaveChangesAsync();
}
catch (Exception ex)
{
msg = "fail";
}
return(Json(new { msg = msg }));
}
public bool AddData(HoaDonXuat hdObj)
{
cmd.CommandText = "insert into tb_HoaDonBan (MaHD, MaThe, NgayLap, NhanVien) values ('" + hdObj.Mahd + "','" + hdObj.KhachHang + "', CONVERT (date,'" + hdObj.NgayLap + "',103),'" + hdObj.NguoiLap + "')";
cmd.CommandType = CommandType.Text;
cmd.Connection = con.Connection;
try
{
con.OpenConn();
cmd.ExecuteNonQuery();
return(true);
}
catch (Exception ex)
{
string mex = ex.Message;
cmd.Dispose();
con.CloseConn();
}
return(false);
}
public IHttpActionResult Update(HoaDonXuatDTO hdx)
{
using (QuanLyCoffeeDbContext entities = new QuanLyCoffeeDbContext())
{
HoaDonXuat hd = entities.HoaDonXuats.Find(hdx.HoaDonXuatID);
if (hdx == null)
{
return(NotFound());
}
hd.HoaDonXuatID = hdx.HoaDonXuatID;
hd.BanID = hdx.BanID;
hd.DaThanhToan = hdx.DaThanhToan;
hd.HinhThucThanhToan = hdx.HinhThucThanhToan;
hd.TongTien = hdx.TongTien;
hd.TenKhachHang = hdx.TenKhachHang;
entities.SaveChanges();
return(Ok(hdx));
}
}
private void btnThemHoaDon_Click(object sender, EventArgs e)
{
int idNPP = listNPP.Where(x => x.Key == cbNPP.Text).SingleOrDefault().Value;
HoaDonXuat hoaDonXuat = new HoaDonXuat(txtMaHoaDonXuat.Text, DateTime.Now.ToString(), txtMaNhanVien
.Text, "ghi", idNPP.ToString());
hoaDonXuat.SaveToDatabase();
foreach (ListViewItem item in lsvChiTiet.Items)
{
ChiTietHoaDonXuat chiTietHoaDonXuat = new ChiTietHoaDonXuat(txtMaHoaDonXuat.Text, item.SubItems[0].Text, item.SubItems[3].Text, txtMaLo.Text, item.SubItems[2].Text);
chiTietHoaDonXuat.SaveToDatabase();
HangHoa.UpdateAmount(Convert.ToInt32(item.SubItems[0].Text), Convert.ToInt32(item.SubItems[2].Text) * -1);
}
this.Close();
mainForm.LoadToDataGridView();
}
public ActionResult XacnhanXoa(string MaHD, string MaSP)
{
ChiTietHoaDonXuat cthdx = db.ChiTietHoaDonXuats.SingleOrDefault(n => n.MaHD == MaHD && n.MaSP == MaSP);
HoaDonXuat hd = db.HoaDonXuats.SingleOrDefault(n => n.MaHD == MaHD);
SanPham sanpham = db.SanPhams.SingleOrDefault(n => n.MaSp == cthdx.MaSP);
if (cthdx != null)
{
db.ChiTietHoaDonXuats.Remove(cthdx);
//db.SaveChanges();
sanpham.SoLuongTon = sanpham.SoLuongTon + cthdx.SoLuong;
db.Entry(sanpham).State = System.Data.Entity.EntityState.Modified;
// db.SaveChanges();
db.HoaDonXuats.Remove(hd);
db.SaveChanges();
ViewBag.Thanhcong = "Xóa Thành Công Hóa đơn";
}
return(View());
}
public int Add(HoaDonXuat emp)
{
List <SqlParameter> paras = new List <SqlParameter>();
paras.Add(new SqlParameter("@maxuat", emp.MaXuat));
paras.Add(new SqlParameter("@manv", emp.MaNV));
paras.Add(new SqlParameter("@makh", emp.MaKH));
paras.Add(new SqlParameter("@tenxe", emp.TenXe));
paras.Add(new SqlParameter("@soluong", emp.SoLuong));
paras.Add(new SqlParameter("@dongia", emp.DonGia));
try
{
return(dp.ExcuteNonQuery("ThemHoaDonXuat", System.Data.CommandType.StoredProcedure, paras));
// " ten thu tuc " , loại , danh sach
}
catch (SqlException ex)
{
throw ex;
}
}
public void themHoaDon(String pMaHD, String maNV, String maKH, DateTime NgayXuat, int tongTien)
{
//HoaDonXuat hd = new HoaDonXuat();
//hd.maHD_Xuat = pMaHD;
//hd.maNV = maNV;
//hd.maKH = maKH;
//hd.ngay_xuat = NgayXuat;
//hd.tong_tien = tongTien;
HoaDonXuat hd = new HoaDonXuat()
{
maHD_Xuat = pMaHD,
maNV = maNV,
maKH = maKH,
ngay_xuat = NgayXuat,
tong_tien = tongTien,
};
data.HoaDonXuats.InsertOnSubmit(hd);
data.SubmitChanges();
}
public ActionResult ThemMoi(HoaDonXuat hd)
{
if (ModelState.IsValid)
{
HoaDonXuat countHD = db.HoaDonXuats.SingleOrDefault(n => n.MaHD == hd.MaHD);
if (countHD != null)
{
ViewBag.KiemtraMa = "Mã Hóa Đơn đã có hãy nhập lại hoặc đi đến chỉnh sửa";
}
else
{
db.HoaDonXuats.Add(hd);
db.SaveChanges();
return(RedirectToAction("ThemChiTietHD", "HoaDonXuat"));
}
}
ViewBag.MaKho = new SelectList(db.Khoes.ToList(), "MaKho", "TenKho");
ViewBag.MaNV = new SelectList(db.NhanViens.ToList(), "MaNV", "TenNV");
ViewBag.MaKH = new SelectList(db.NhaCungCaps.ToList(), "MaKH", "TenKH");
return(View());
}
private void Frm_CTHDX_Load(object sender, EventArgs e)
{
lbMaHDX.Text = Frm_HDX.mahdx.ToString();
CTHDX cthdx = kn.CTHDXes.Where(s => s.MaHDX == Frm_HDX.mahdx).FirstOrDefault();
HoaDonXuat hdx = kn.HoaDonXuats.Where(s => s.MaHDX == Frm_HDX.mahdx).FirstOrDefault();
SanPham tensp = kn.SanPhams.Where(s => s.MaSP == cthdx.MaSP).FirstOrDefault();
lbTenSP.Text = tensp.TenSP;
KhachHang tenkh = kn.KhachHangs.Where(s => s.MaKH == hdx.MaKH).FirstOrDefault();
lbTenKH.Text = tenkh.TenKH;
lbNgayXuat.Text = hdx.NgayXuat.ToString();
NhanVien tennv = kn.NhanViens.Where(s => s.MaNV == hdx.MaNV).FirstOrDefault();
lbTenNV.Text = tennv.TenNV;
txtSoLuong.Text = cthdx.Soluong.ToString();
txtGia.Text = tensp.Gia.ToString();
txtGia.Enabled = false;
txtSoLuong.Enabled = false;
}
