public static int add(DaiLy daily)
{
try
{
using (EntitiesDataContext db = new EntitiesDataContext())
{
DAILY dl;
dl = (from d in db.DAILies
where d.masodaily.Equals(daily.MaSoDaiLy)
select d).SingleOrDefault();
if (dl != null)
{
return(0); //Nếu đại lý đã tồn tại
}
dl = new DAILY()
{
ten = daily.TenDaiLy,
diachi = daily.DiaChi,
sodienthoai = daily.SoDienThoai,
sotaikhoan = daily.SoTaiKhoan,
nganhang = daily.NganHang,
masonguoidung = daily.MaSoNguoiDung
};
db.DAILies.InsertOnSubmit(dl);
db.SubmitChanges();
return(dl.masodaily);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(0);
}
}
private void SuaDaiLy_Click(object sender, EventArgs e)
{
string dailyID = txtMaDaiLy.Text;
DAILY daily = db.DAILies.Where(p => p.MaDaiLy == dailyID).SingleOrDefault();
if (daily == null)
{
MessageBox.Show("Mã đại lý không tồn tại");
return;
}
else
{
daily.MaDaiLy = dailyID;
daily.TenDaiLy = txtTenDaiLy.Text;
daily.MaLoaiDaiLy = int.Parse(cbLoai.Text);
daily.SDT = txtSoDienThoai.Text;
daily.DiaChi = txtDiaChi.Text;
daily.Quan = cbQuan.Text;
daily.NgayTiepNhan = DateTime.Parse(txtNgayTiepNhan.Text);
db.SaveChanges();
LoadDataDaiLy();
MessageBox.Show("Cập nhật đại lý thành công");
}
}
private void btnTim_Click(object sender, EventArgs e)
{
if (txtMaDL.Text != "")
{
string MaDL = txtMaDL.Text;
MaDL = MaDL.TrimEnd();
DAILY temp = DaiLyBUS.Instance.GetByID(MaDL);
if (temp != null)
{
dgvDSDL.DataSource = null;
DaiLyBUS.Instance.GetByID(MaDL, dgvDSDL);
dgvDSDL.Columns[0].HeaderCell.Value = "Mã ĐL";
dgvDSDL.Columns[1].HeaderCell.Value = "Tên đại lý";
dgvDSDL.Columns[2].HeaderCell.Value = "Điện thoại";
dgvDSDL.Columns[3].HeaderCell.Value = "Địa chỉ";
dgvDSDL.Columns[4].HeaderCell.Value = "Ngày tiếp nhận";
dgvDSDL.Columns[5].HeaderCell.Value = "Email";
dgvDSDL.Columns[6].HeaderCell.Value = "Tiền nợ";
dgvDSDL.Columns[7].HeaderCell.Value = "Mã Loại ĐL";
dgvDSDL.Columns[8].HeaderCell.Value = "Mã Quận";
}
else
{
dgvDSDL.DataSource = null;
MessageBox.Show("Không Tìm Thấy Đại lý!", "Thông Báo");
}
}
else
{
MessageBox.Show("Phải Nhập Mã Đại Lý Tìm Kiếm!", "Thông Báo");
}
}
public int?InsertDaiLy(string tendl, string diachi, string dienthoai, int maquan, int loaidl)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
DAILY dl = new DAILY
{
TENDL = tendl,
DIACHI = diachi,
DIENTHOAI = dienthoai,
NGAYTIEPNHAN = DateTime.Now,
MAQUAN = maquan,
LOAIDL = loaidl,
TINHTRANG = 1, // 1: đang hoạt động, 0: đã dẹp tiệm
SONO = 0
};
context.DAILies.Add(dl);
context.SaveChanges();
return(dl.MADL);
}
}
catch
{
return(null);
}
}
public ActionResult DeleteConfirmed(int id)
{
DAILY daily = db.DAILies.Find(id);
db.DAILies.Remove(daily);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void ThemDaiLy_Click(object sender, EventArgs e)
{
//string dailyID = txtMaDaiLy.Text;
//DAILY daily = db.DAILies.Where(p => p.MaDaiLy == dailyID).SingleOrDefault();
//if (daily != null)
//{
// MessageBox.Show("Mã đại lý đã tồn tại");
// return;
//}
//else if (String.IsNullOrEmpty(MaDaiLy))
//{
// MessageBox.Show("Mã đại lý không được để trống");
// return;
//}
//else
//{
// daily = new DAILY();
// daily.MaDaiLy = txtMaDaiLy.Text;
// daily.MaLoaiDaiLy = int.Parse(cbLoai.Text);
// daily.DiaChi = txtDiaChi.Text;
// daily.Quan = cbQuan.Text;
// daily.SDT = txtSoDienThoai.Text;
// daily.NgayTiepNhan = DateTime.Parse(txtNgayTiepNhan.Text);
// db.DAILies.Add(daily);
// db.SaveChanges();
// LoadDataDaiLy();
// MessageBox.Show("Thêm đại lý thành công");
//}
string dailyID = txtMaDaiLy.Text;
DAILY daily = db.DAILies.Where(p => p.MaDaiLy == dailyID).SingleOrDefault();
if (daily != null)
{
MessageBox.Show("Mã đại lý đã tồn tại");
return;
}
if (daily == null)
{
DAILY p = new DAILY()
{
MaDaiLy = dailyID,
TenDaiLy = txtTenDaiLy.Text,
MaLoaiDaiLy = int.Parse(cbLoai.Text),
SDT = txtSoDienThoai.Text,
DiaChi = txtDiaChi.Text,
Quan = cbQuan.Text,
NgayTiepNhan = DateTime.Parse(txtNgayTiepNhan.Text)
};
db.DAILies.Add(p);
db.SaveChanges();
LoadDataDaiLy();
MessageBox.Show("Thêm đại lý thành công");
}
}
public bool update(DAILY entity)
{
var cat = dbContext.DAILies.Find(entity.MADAILY);
cat.MADAILY = entity.MADAILY;
cat.TENDAILY = entity.TENDAILY;
dbContext.SaveChanges();
return(true);
}
public ActionResult Edit([Bind(Include = "MaDL,Ten,DiaChi,SoDT,TrangThai")] DAILY daily)
{
if (ModelState.IsValid)
{
db.Entry(daily).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(daily));
}
public DaiLy(DAILY daily)
{
MaSoDaiLy = daily.masodaily;
TenDaiLy = daily.ten;
DiaChi = daily.diachi;
SoDienThoai = daily.sodienthoai;
SoTaiKhoan = daily.sotaikhoan;
TrangThai = daily.trangthai;
MaSoNguoiDung = daily.masonguoidung;
NganHang = daily.nganhang;
}
public ActionResult Edit([Bind(Include = "MaDL,MaLoai,Ten,SoDT,DiaChi,isXoa")] DAILY dAILY)
{
if (ModelState.IsValid)
{
dAILY.isXoa = false;
db.Entry(dAILY).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(dAILY));
}
public ActionResult Create([Bind(Include = "MaDL,Ten,DiaChi,SoDT,TrangThai")] DAILY daily)
{
if (ModelState.IsValid)
{
db.DAILies.Add(daily);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(daily));
}
private void cmbMaDL_SelectedIndexChanged(object sender, EventArgs e)
{
//lấy đại lý theo ID
DAILY dl = DaiLyBUS.Instance.GetByID(cmbMaDL.Text);
//gán các giá trị
lbTenDaiLy.Text = dl.TenDaiLy;
lblMail.Text = dl.MaDaiLy;
lbSoDienThoai.Text = dl.DienThoai;
lblDiaChi.Text = dl.DiaChi;
}
private void XoaDaiLy_Click(object sender, EventArgs e)
{
string dailyID = txtMaDaiLy.Text;
DAILY daily = db.DAILies.Where(p => p.MaDaiLy == dailyID).SingleOrDefault();
if (daily != null)
{
db.DAILies.Remove(daily);
db.SaveChanges();
LoadDataDaiLy();
MessageBox.Show("Xoá đại lý thành công");
}
}
public ActionResult Create([Bind(Include = "MaDL,MaLoai,Ten,SoDT,DiaChi,isXoa")] DAILY dAILY)
{
if (ModelState.IsValid)
{
dAILY.isXoa = false;
db.DAILies.Add(dAILY);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.LoaiDaiLy = db.LOAIDAILies.ToList();
return(View(dAILY));
}
public ActionResult SuaDaiLy(DAILY dl)
{
var daily = db.DAILies.SingleOrDefault(n => n.MaDL == dl.MaDL);
if (daily != null)
{
daily.Ten = dl.Ten;
daily.DiaChi = dl.DiaChi;
daily.SoDT = dl.SoDT;
daily.TrangThai = dl.TrangThai;
db.SaveChanges();
}
return(RedirectToAction("Index", "QuanLyDaiLy"));
}
// GET: /QuanLyDL/Delete/
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DAILY daily = db.DAILies.Find(id);
if (daily == null)
{
return(HttpNotFound());
}
return(View(daily));
}
//insert
public bool Insert(DAILY dl)
{
using (QLDLDataContext db = new QLDLDataContext())
{
try
{
db.DAILies.InsertOnSubmit(dl);
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}
//insert
public bool Insert(string tenDaiLy, string sdt, string diaChi, DateTime ngayTiepNhan, string email, int tienNo, int maLDL, string maQuan)
{
string maDL = DaiLyDAO.Instance.CreateCode();
DAILY temp = new DAILY();
temp.MaDaiLy = maDL;
temp.TenDaiLy = tenDaiLy;
temp.DienThoai = sdt;
temp.DiaChi = diaChi;
temp.NgayTiepNhan = ngayTiepNhan;
temp.Email = email;
temp.TienNo = tienNo;
temp.MaLoaiDaiLy = maLDL;
temp.MaQuan = maQuan;
return(DaiLyDAO.Instance.Insert(temp));
}
public bool RemoveDaiLy(int madl)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == madl);
context.DAILies.Remove(daily);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
public ActionResult Delete(int id)
{
if (Session["username"] == null)
{
return(RedirectToAction("Login", "TaiKhoans"));
}
DAILY dAILY = db.DAILies.Find(id);
if (dAILY == null)
{
return(HttpNotFound());
}
dAILY.isXoa = true;
db.Entry(dAILY).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
// GET: DAILies/Edit/5
public ActionResult Edit(int?id)
{
if (Session["username"] == null)
{
return(RedirectToAction("Login", "TaiKhoans"));
}
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DAILY dAILY = db.DAILies.Find(id);
if (dAILY == null)
{
return(HttpNotFound());
}
return(View(dAILY));
}
private void btnTim_Click(object sender, EventArgs e)
{
string MaPT = txtMaPhieuThu.Text;
MaPT = MaPT.TrimEnd();
if (MaPT != "")
{
PHIEUTHUTIEN temp = PhieuThuTienBUS.Instance.GetByID(MaPT);
if (temp != null)
{
//gán thông tin phiếu thu
txtTien.Text = temp.SoTienThu.ToString();
dTPK.Value = temp.NgayThuTien.Value;
cmbMaDL.Text = temp.MaDaiLy;
//gán thông tin đại lý
DAILY dl = DaiLyBUS.Instance.GetByID(temp.MaDaiLy);
lbTenDaiLy.Text = dl.TenDaiLy;
lblMail.Text = dl.MaDaiLy;
lbSoDienThoai.Text = dl.DienThoai;
lblDiaChi.Text = dl.DiaChi;
btnLuuPT.Enabled = false;
btnInPhieu.Enabled = true;
}
else
{
//gán thông tin phiếu thu
txtTien.Text = "";
dTPK.Value = DateTime.Today;
cmbMaDL.Text = "";
//gán thông tin đại lý
lbTenDaiLy.Text = "";
lblMail.Text = "";
lbSoDienThoai.Text = "";
lblDiaChi.Text = "";
MessageBox.Show("Không Tìm Thấy Phiếu Thu", "Thông Báo");
}
}
else
{
MessageBox.Show("Phải Điền Ma Phiếu Thu", "Thông Báo");
}
}
public bool InsertPhieuThu(PHIEUTHUTIEN pt)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == pt.MADL);
daily.SONO -= pt.SOTIEN;
context.PHIEUTHUTIENs.Add(pt);
context.SaveChanges();
return(true);
}
}
catch
{
return(false);
}
}
private void btnThem_Click(object sender, EventArgs e)
{
string MaDaiLy = txtMaDaiLy.Text;
string TenDaiLy = txtTenDaiLy.Text;
string SDT = txtSDT.Text;
string DiaChi = txtDiaChi.Text;
string Email = txtEmail.Text;
string MaLoaiDaiLy = cbbMaLoaiDaiLy.Text;
string Quan = cbbQuan.Text;
string QuanOrdinal = cbbQuanOrdinal.Text;
string NgayTiepNhan = dtNgayTiepNhan.Text;
DAILY daily = db.DAILies.Where(l => l.MaDaiLy == MaDaiLy).SingleOrDefault();
if (daily != null)
{
MessageBox.Show("Mã Lớp Học Đã Tồn Tại");
return;
}
else if (String.IsNullOrEmpty(MaDaiLy) || String.IsNullOrEmpty(TenDaiLy))
{
MessageBox.Show("Không Được Để Tên Lớp Trống");
return;
}
else
{
daily = new DAILY();
daily.MaDaiLy = MaDaiLy;
daily.TenDaiLy = TenDaiLy;
daily.MaLoaiDL = MaLoaiDaiLy;
daily.SDT = SDT;
daily.DiaChi = DiaChi;
daily.Quan = Quan;
daily.Email = Email;
daily.QuanPOS = QuanOrdinal;
db.DAILies.Add(daily);
LoadDaiLy();
MessageBox.Show("Thêm Lớp Học Mới Thành Công");
}
}
public ActionResult XuatSach(DAILY dl, FormCollection f)
{
PHIEUXUAT px = new PHIEUXUAT();
px.MaDL = int.Parse(f["MaDL"].ToString());
String[] temp = f["NgayXuat"].ToString().Split('-');
DateTime date = new DateTime(int.Parse(temp[2]), int.Parse(temp[1]), int.Parse(temp[0]));
px.NgayXuat = date;
px.TrangThai = false;
db.PHIEUXUATs.Add(px);
db.SaveChanges();
int?TongTien = 0;
foreach (CT_PhieuXuatViewModel ct in Session["DS_Sach"] as List <CT_PhieuXuatViewModel> )
{
CT_PHIEUXUAT ctpx = new CT_PHIEUXUAT();
ctpx.MaPX = px.MaPX;
ctpx.MaSach = ct.MaSach;
ctpx.SLXuat = ct.SLXuat;
ctpx.DonGia = ct.DonGia;
ctpx.ThanhTien = ctpx.SLXuat * ctpx.DonGia;
TongTien += ctpx.ThanhTien;
db.CT_PHIEUXUAT.Add(ctpx);
}
px.TongTien = TongTien;
db.SaveChanges();
CONGNO_DL congno = new CONGNO_DL();
congno.MaDL = dl.MaDL;
congno.ThoiGian = new DateTime(int.Parse(temp[2]), int.Parse(temp[1]), int.Parse(temp[0]));
congno.TienDaTra = 0;
congno.TienNo = px.TongTien;
db.CONGNO_DL.Add(congno);
db.SaveChanges();
Session.Clear();
return(RedirectToAction("Index"));
}
public ActionResult ThemBaoCao(DAILY dl, FormCollection f)
{
BAOCAODL bc = new BAOCAODL();
bc.MaDL = int.Parse(f["MaDL"].ToString());
bc.NgayLap = date;
bc.NgayBD = datebd;
bc.NgayKT = datekt;
bc.TinhTrang = true;
db.BAOCAODLs.Add(bc);
db.SaveChanges();
int?TongTien = 0;
foreach (CT_BaoCaoDaiLyViewModel ct in Session["DS_BaoCao_DaiLy"] as List <CT_BaoCaoDaiLyViewModel> )
{
CT_BAOCAODL ctbc = new CT_BAOCAODL();
ctbc.MaBCDL = bc.MaBCDL;
ctbc.MaSach = ct.MaSach;
ctbc.SoLuongBan = ct.SoLuongBan;
ctbc.DonGiaBan = ct.DonGiaBan;
ctbc.ThanhTien = ctbc.SoLuongBan * ctbc.DonGiaBan;
TongTien += ctbc.ThanhTien;
db.CT_BAOCAODL.Add(ctbc);
}
bc.ThanhToan = TongTien;
db.SaveChanges();
CONGNO_DL congno = new CONGNO_DL();
congno.MaDL = int.Parse(f["MaDL"].ToString());
congno.ThoiGian = date;
congno.TienDaTra = bc.ThanhToan;
congno.TienNo = 0;
db.CONGNO_DL.Add(congno);
db.SaveChanges();
Session.Clear();
return(RedirectToAction("Index"));
}
public bool UpdateDaiLy(int madl, string tendl, string diachi, string dienthoai, int maquan, int loaidl)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == madl);
daily.TENDL = tendl;
daily.DIACHI = diachi;
daily.DIENTHOAI = dienthoai;
daily.MAQUAN = maquan;
daily.LOAIDL = loaidl;
context.SaveChanges();
return(true);
}
}
catch (Exception e)
{
System.Console.Out.WriteLine(e.ToString());
return(false);
}
}
//update
public bool Update(string maDL, DAILY dl)
{
using (QLDLDataContext db = new QLDLDataContext())
{
DAILY temp = db.DAILies.Where(p => p.MaDaiLy == maDL).FirstOrDefault();
temp.TenDaiLy = dl.TenDaiLy;
temp.DienThoai = dl.DienThoai;
temp.DiaChi = dl.DiaChi;
temp.NgayTiepNhan = dl.NgayTiepNhan;
temp.Email = dl.Email;
temp.TienNo = dl.TienNo;
temp.MaLoaiDaiLy = dl.MaLoaiDaiLy;
temp.MaQuan = dl.MaQuan;
try
{
db.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
}
public bool InsertPhieuXuat(CTPX[] arr_ctpx, PHIEUXUATHANG pxh)
{
try
{
using (QLDLEntities context = new QLDLEntities())
{
// do EF ko hỗ trợ auto increase primary key khi bị chiếu tới nên dùng thủ công
context.Database.ExecuteSqlCommand("insert into phieuxuathang(madl,ngaylap,tongtien,sotientra,conlai,nguoixuat) values({0},{1},{2},{3},{4},{5});",
pxh.MADL, DateTime.Now, pxh.TONGTIEN, pxh.SOTIENTRA, pxh.CONLAI, pxh.NGUOIXUAT);
DAILY daily = context.DAILies.FirstOrDefault(dl => dl.MADL == pxh.MADL);
daily.SONO += (pxh.TONGTIEN - pxh.SOTIENTRA);
context.SaveChanges();
/// lấy mã phiếu cuối cùng (dòng mới vừa nhập) nếu hệ thống chạy song song là tạch :((
int value = int.Parse(context.PHIEUXUATHANGs
.OrderByDescending(p => p.MAPHIEU)
.Select(r => r.MAPHIEU)
.First().ToString());
// tạo các chi tiết phiếu xuất
foreach (CTPX ct in arr_ctpx)
{
ct.MAPHIEU = value;
context.CTPXes.Add(ct);
}
context.SaveChanges();
return(true);
}
}
catch (Exception e)
{
Console.WriteLine("---------------------------------------------------------");
Console.WriteLine("{0}", e);
return(false);
}
}
private void OnAdd()
{
try
{
Daily dl = new Daily();
using (var db = new QUANLYCACDAILYEntities())
{
DAILY temp = new DAILY();
temp.MaDaiLy = dl.txt_madaily.ToString();
temp.MaDinhMuc = dl.cb_madinhmuc.SelectedItem.ToString();
temp.MaHopDong = dl.txt_mahopdong.ToString();
temp.NgayLap = DateTime.Parse(dl.dp_ngaylap.ToString());
temp.CMND = dl.txt_cmnd.ToString();
temp.HoTenChuDaiLy = dl.txt_hotenchudaily.ToString();
temp.NgaySinh = DateTime.Parse(dl.dp_ngaysinh.ToString());
temp.CapDaiLy = dl.txt_cap.ToString();
temp.TenDaiLy = dl.txt_tendaily.ToString();
temp.NoiDung = dl.txt_noidung.ToString();
db.DAILies.Add(temp);
}
}
catch { }
}
