private void cmbDaiLy_SelectionChangeCommitted(object sender, EventArgs e)
{
_currentDaiLy = DaiLyManager.find(int.Parse(cmbDaiLy.SelectedValue.ToString()));
txbMaSoDaiLy.Text = _currentDaiLy.MaSoDaiLy + "";
loadSach();
cmbDaiLy.Enabled = false;
}
public ActionResult Edit(DaiLy model, FormCollection collection)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
if (DaiLyManager.edit(model))
{
putSuccessMessage("Cập nhật thành công");
return(RedirectToAction("Details", new { id = model.MaSoDaiLy }));
}
else
{
putErrorMessage("Cập nhật thất bại");
}
}
else
{
putModelStateFailErrors(ModelState);
}
return(View(model));
}
catch (Exception ex)
{
putErrorMessage(ex.Message);
return(RedirectToAction("Edit", new { id = model.MaSoDaiLy }));
}
}
public ActionResult Create()
{
DaiLy dl = new DaiLy();
dl.MaDaiLy = getMaDaiLy();
return(View(dl));
}
// GET: DaiLy/Create
public ActionResult Create()
{
var model = new DaiLy();
setAlertMessage();
return(View(model));
}
//Khi Chọn Đại lý từ Danh Mục Đại lý
private void gdvDMDaiLy_SelectionChanged(object sender, EventArgs e)
{
int index = ((DataGridView)sender).CurrentRow.Index;
_currentDaiLy = (((DataGridView)sender).DataSource as List <DaiLy>)[index];
selectDaiLy(_currentDaiLy);
}
public void insert_Daily(DaiLy a)
{
QLVESODataContext db = new QLVESODataContext();
db.DaiLies.InsertOnSubmit(a);
db.SubmitChanges();
}
public ActionResult Create(DaiLy model)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
var result = DaiLyManager.add(model);
if (result != 0)
{
putSuccessMessage("Thâm thành công");
return(RedirectToAction("Details", new { id = result }));
}
else
{
putErrorMessage("Thêm thất bại");
}
}
else
{
putModelStateFailErrors(ModelState);
}
return(View(model));
}
catch (Exception ex)
{
putErrorMessage(ex.Message);
return(RedirectToAction("Create"));
}
}
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);
}
}
public static bool edit(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(false); //Nếu đại lý không tồn tại
}
dl.ten = daily.TenDaiLy;
dl.diachi = daily.DiaChi;
dl.sodienthoai = daily.SoDienThoai;
dl.sotaikhoan = daily.SoTaiKhoan;
dl.trangthai = daily.TrangThai;
dl.nganhang = daily.NganHang;
db.SubmitChanges();
return(true);
}
}catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(false);
}
}
//Khi thêm Đại lý
private void btnThem_Click(object sender, EventArgs e)
{
DialogResult dialogResult = MessageBox.Show("Bạn có muốn thêm đại lý", "Thông báo", MessageBoxButtons.YesNo);
if (dialogResult == DialogResult.Yes)
{
if (!txbTenDaiLy.Text.Equals("") && !txbDiaChi.Text.Equals("") && !txbSoDienThoai.Text.Equals("") && !txbSoTaiKhoan.Text.Equals(""))
{
DaiLy dl = new DaiLy();
dl.TenDaiLy = txbTenDaiLy.Text;
dl.DiaChi = txbDiaChi.Text;
dl.SoDienThoai = txbSoDienThoai.Text;
dl.SoTaiKhoan = txbSoTaiKhoan.Text;
dl.NganHang = txbNganHang.Text.ToString();
if (DaiLyManager.add(dl) != 0)
{
MessageBox.Show("Đã thêm đại lý thành công");
}
else
{
MessageBox.Show("Không thêm được, đại lý đã tồn tại ");
}
}
else
{
MessageBox.Show("Bạn chưa nhập đầy đủ thông tin");
}
}
else if (dialogResult == DialogResult.No)
{
return;
}
}
//public IActionResult LayThongTinDL(int id)
//{
// List<LoaiVeSo> list = vsc.LoaiVeSo.ToList();
// DaiLy daily = vsc.DaiLy.Where(dl => dl.MaDl == id).SingleOrDefault();
// ViewBag.ThongTinDL = daily;
// return PartialView("ThemSLDK", list);
//}
public IActionResult ModalSLDK(string ma)
{
DaiLy daily = vsc.DaiLy.Where(dl => dl.MaDl == int.Parse(ma)).SingleOrDefault();
List <LoaiVeSo> list = vsc.LoaiVeSo.ToList();
ViewBag.ThongTinDL = daily;
return(PartialView("ThemSLDK", list));
}
public static void UpdateDaiLy(this DaiLy daiLy, DaiLyViewModel daiLyVm)
{
daiLy.Id = daiLyVm.Id;
daiLy.TenDaiLy = daiLyVm.TenDaiLy;
daiLy.SoDienThoai = daiLyVm.SoDienThoai;
daiLy.DiaChi = daiLyVm.DiaChi;
daiLy.TrangThai = true;
}
public ActionResult DeleteConfirmed(int id)
{
DaiLy daiLy = db.DaiLies.Find(id);
db.DaiLies.Remove(daiLy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult ThongTinDangKy(string ma)
{
List <LoaiVeSo> list = context.LoaiVeSo.ToList();
DaiLy daily = context.DaiLy.Where(dl => dl.MaDaiLy == ma).SingleOrDefault();
ViewBag.ThongTinDaiLy = daily;
return(PartialView("DangKyPartialView", list));
}
public void delete_DaiLy(string Madaily)
{
QLVESODataContext db = new QLVESODataContext();
DaiLy b = db.DaiLies.Where(a => a.MaDaiLy == Madaily).Single();
db.DaiLies.DeleteOnSubmit(b);
db.SubmitChanges();
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
DaiLy daiLy = await db.DaiLys.FindAsync(id);
db.DaiLys.Remove(daiLy);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public ActionResult DeleteConfirmed(string id)
{
DaiLy daily = db.DaiLy.Find(id);
daily.Flag = false;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public JsonResult GetPropertiesTheoDoiNo(string request)
{
List <string> results = new List <string>();
foreach (string pro in DaiLy.searchKeysTheoDoiNo())
{
results.Add(request + pro);
}
return(Json(results, JsonRequestBehavior.AllowGet));
}
public ActionResult ThemMoi(DaiLy _DaiLy)
{
if (ModelState.IsValid)
{
db.DaiLies.Add(_DaiLy);
db.SaveChanges();
}
//return RedirectToAction("Index");
return(View());
}
public ActionResult DeleteConfirmed(string id)
{
DaiLy dl = db.DaiLies.Find(id);
dl.Flag = false;
TempData["notice"] = "Successfully delete";
TempData["tensanpham"] = dl.TenDaiLy;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult ChinhSua(DaiLy _DaiLy)
{
if (!ModelState.IsValid)
{
return(View());
}
db.Entry(_DaiLy).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public IActionResult ThongTinCongNo(string ma)
{
List <CongNo> dsCongNo = context.CongNo.Where(cn => cn.IdDaiLyNavigation.MaDaiLy == ma)
.Include(cn => cn.IdDaiLyNavigation)
.ToList();
DaiLy daily = context.DaiLy.Where(dl => dl.MaDaiLy == ma).SingleOrDefault();
ViewBag.DaiLy = daily;
return(PartialView("ChiTietCongNoPartialView", dsCongNo));
}
public ActionResult Edit([Bind(Include = "MaDaiLy,TenDaiLy,SoNo")] DaiLy daiLy)
{
if (ModelState.IsValid)
{
db.Entry(daiLy).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(daiLy));
}
public bool Update(DaiLy daily)
{
using (MySqlConnection db = new MySqlConnection(
_configuration.GetConnectionString("ConnectionString")))
{
var sqlQuery = "UPDATE daily SET ma_dai_ly = @MaDaiLy, ten_dai_ly = @TenDaiLy WHERE id = @Id";
return(db.Execute(sqlQuery, daily) > 0);
}
return(false);
}
public async Task <ActionResult> Edit([Bind(Include = "MaDL,TenDL,DiaChi,DienThoai,Quan,NgayTiepNhan,TienNo,MaLoaiDL,MaLoaiDaiLy")] DaiLy daiLy)
{
if (ModelState.IsValid)
{
db.Entry(daiLy).State = EntityState.Modified;
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
return(View(daiLy));
}
public void selectDaiLy(DaiLy daily)
{
if (daily != null)
{
lbMaSoDaiLy.Text = daily.MaSoDaiLy.ToString();
lbTenDaiLy.Text = daily.TenDaiLy;
lbTienSachDaiLy.Text = String.Format(_cultureInfo, "{0:c}", daily.TongTienXuatTheoThang);
lbConNoDaiLy.Text = String.Format(_cultureInfo, "{0:c}", daily.TongTienNoThang);
lbDaThuDaiLy.Text = String.Format(_cultureInfo, "{0:c}", daily.TongTienXuatTheoThang - daily.TongTienNoThang);
}
}
public ActionResult Xoa(string _MaDaiLy)
{
DaiLy dl = db.DaiLies.SingleOrDefault(n => n.MaDaiLy == _MaDaiLy);
if (dl == null)
{
Response.StatusCode = 404;
return(null);
}
return(View(dl));
}
public ActionResult Create([Bind(Include = "MaDaiLy,TenDaiLy,SoNo")] DaiLy daiLy)
{
if (ModelState.IsValid)
{
db.DaiLies.Add(daiLy);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(daiLy));
}
public void update_Daily(DaiLy a)
{
QLVESODataContext db = new QLVESODataContext();
DaiLy b = db.DaiLies.Where(x => x.MaDaiLy == a.MaDaiLy).Single();
b.TenDaiLy = a.TenDaiLy;
b.SDT = a.SDT;
b.DiaChi = a.DiaChi;
b.flag = a.flag;
db.SubmitChanges();
}
public ActionResult CapNhatDaiLy(DaiLyViewModel model)
{
if (ModelState.IsValid)
{
var edittedDaiLy = new DaiLy();
edittedDaiLy.UpdateDaiLy(model);
daiLyService.Update(edittedDaiLy);
daiLyService.Save();
}
return(View(model));
}
