public ReturnObjValueBackEnd DeleteBanking(List <string> lstID) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); List <CreditManagement.Models.NganHang> lst = new List <CreditManagement.Models.NganHang>(); for (int i = 0; i < lstID.Count; i++) { lst.Add(new CreditManagement.Models.NganHang { MaNH = lstID[i] }); ctx.Entry(lst[i]).State = System.Data.Entity.EntityState.Deleted; } ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd DeleteDealDetail(List <ChiTietGiaoDich> lstID) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); List <ChiTietGiaoDich> lst = new List <ChiTietGiaoDich>(); for (int i = 0; i < lstID.Count; i++) { lst.Add(new ChiTietGiaoDich { MaKH = lstID[i].MaKH, NgayGD = lstID[i].NgayGD }); ctx.Entry(lst[i]).State = System.Data.Entity.EntityState.Deleted; } ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd InsertSaveMoney(SoTietKiem objInsert) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); string maxId = ""; maxId = (from c in ctx.SoTietKiem select c.MaSTK).Max(); if (!string.IsNullOrEmpty(maxId)) { int maxCurrent = Convert.ToInt16(maxId.Substring(3, maxId.Length - 2)); int maxNext = maxCurrent + 1; string mastkaddnew = maxNext.ToString().PadLeft(4, '0'); objInsert.MaSTK = "STK" + mastkaddnew; } else { objInsert.MaSTK = "STK0001"; } ctx.SoTietKiem.Add(objInsert); ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchAllBanking() { List <CreditManagement.Models.NganHang> lst = new List <CreditManagement.Models.NganHang>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { using (var context = new BankingContext()) { lst = context.NganHang.ToList(); } retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd DeleteAccount(List <TaiKhoan> lstID) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); List <TaiKhoan> lst = new List <TaiKhoan>(); for (int i = 0; i < lstID.Count; i++) { lst.Add(new TaiKhoan { MaKH = lstID[i].MaKH, MaNV = lstID[i].MaNV, MaCN = lstID[i].MaCN }); ctx.Entry(lst[i]).State = System.Data.Entity.EntityState.Deleted; } ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchAllAccount() { List <TaiKhoan> lst = new List <TaiKhoan>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { using (var context = new BankingContext()) { lst = context.TaiKhoan.ToList(); } retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd DeleteCustomer(List <string> lstKH) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); List <KhachHang> lstKhachHang = new List <KhachHang>(); for (int i = 0; i < lstKH.Count; i++) { lstKhachHang.Add(new KhachHang { MaKH = lstKH[i] }); ctx.Entry(lstKhachHang[i]).State = System.Data.Entity.EntityState.Deleted; } ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
/// <summary> /// Lấy thông tin nhân viên dựa vào useris và password /// </summary> /// <param name="userId">user id</param> /// <param name="pass">password</param> /// <returns></returns> public ReturnObjValueBackEnd CheckLogin(string userId, string pass) { NhanVien lstTTNhanVien = new NhanVien(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { using (var ct = new BankingContext()) { var query = from user in ct.MstUser join nv in ct.NhanVien on user.USERID equals nv.MaNV where user.USERID.Equals(userId) && user.PASSWD.Equals(pass) select nv; if (query.ToList().Count > 0) { lstTTNhanVien = query.ToList()[0]; } } retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lstTTNhanVien; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd DeleteUser(List <string> lstID) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); MSTUSER userModel = new MSTUSER(); for (int i = 0; i < lstID.Count; i++) { var query = from user in ctx.MstUser where user.USERID.Equals(lstID[i]) select user; if (query.ToList().Count > 0) { userModel = query.ToList()[0]; } userModel.DELETE_YMD = DateTime.Now; UpdateUser(userModel); } retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd InsertStaff(NhanVien staff) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { string maxId = ""; var ctx = new BankingContext(); maxId = (from c in ctx.NhanVien select c.MaNV).Max(); if (!string.IsNullOrEmpty(maxId)) { int maxCurrent = Convert.ToInt16(maxId.Substring(2, maxId.Length - 2)); int maxNext = maxCurrent + 1; string manv = maxNext.ToString().PadLeft(4, '0'); staff.MaNV = "NV" + manv; } else { staff.MaNV = "NV0001"; } ctx.NhanVien.Add(staff); ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd DeleteStaff(List <string> lstMaNV) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); List <NhanVien> lstNV = new List <NhanVien>(); for (int i = 0; i < lstMaNV.Count; i++) { lstNV.Add(new NhanVien { MaNV = lstMaNV[i] }); ctx.Entry(lstNV[i]).State = System.Data.Entity.EntityState.Deleted; } ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchBankBranchesByCondition(ChiNhanhNganHang sc) { List <ChiNhanhNganHang> lst = new List <ChiNhanhNganHang>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); var query = from ct in ctx.ChiNhanhNganHang select ct; if (sc != null) { if (sc.MaCN != null) { query = query.Where(p => p.MaCN.Equals(sc.MaCN)); } if (sc.LoaiCN != null) { query = query.Where(p => p.LoaiCN.Equals(sc.LoaiCN)); } if (sc.DTNoiBo != null) { query = query.Where(p => p.DTNoiBo.Equals(sc.DTNoiBo)); } if (sc.TenCN != null) { query = query.Where(p => p.TenCN.Contains(sc.TenCN)); } if (sc.DiaChi != null) { query = query.Where(p => p.DiaChi.Contains(sc.DiaChi)); } if (sc.LoaiNH != null) { query = query.Where(p => p.LoaiNH.Equals(sc.LoaiNH)); } } lst = query.ToList(); retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchCustomerByCondition(KhachHang sc) { List <KhachHang> lstKhachhang = new List <KhachHang>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); var query = from ct in ctx.KhachHang select ct; if (sc != null) { if (sc.MaKH != null) { query = query.Where(p => p.MaKH.Equals(sc.MaKH)); } if (sc.cmnd != null) { query = query.Where(p => p.cmnd.Equals(sc.cmnd)); } if (sc.TenKH != null) { query = query.Where(p => p.TenKH.Contains(sc.TenKH)); } if (sc.SoDienThoai != null) { query = query.Where(p => p.SoDienThoai.Equals(sc.SoDienThoai)); } if (sc.NgaySinh != null) { query = query.Where(p => p.NgaySinh.Equals(sc.NgaySinh)); } if (sc.GioiTinh != null) { query = query.Where(p => p.GioiTinh.Equals(sc.GioiTinh)); } } lstKhachhang = query.ToList(); retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lstKhachhang.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchDealDetailByCondition(GiaoDich sc) { List <GiaoDich> lst = new List <GiaoDich>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); var query = from ct in ctx.GiaoDich select ct; if (sc != null) { if (sc.MaGD != null) { query = query.Where(p => p.MaGD.Equals(sc.MaGD)); } if (sc.MaKH != null) { query = query.Where(p => p.MaKH.Equals(sc.MaKH)); } if (sc.SoTien != null) { query = query.Where(p => p.SoTien.Equals(sc.SoTien)); } if (sc.NgayCapNhat != null) { query = query.Where(p => p.NgayCapNhat.Equals(sc.NgayCapNhat)); } } lst = query.ToList(); retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchBankingByCondition(CreditManagement.Models.NganHang sc) { List <CreditManagement.Models.NganHang> lst = new List <CreditManagement.Models.NganHang>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); var query = from ct in ctx.NganHang select ct; if (sc != null) { if (sc.MaNH != null) { query = query.Where(p => p.MaNH.Equals(sc.MaNH)); } if (sc.TenNH != null) { query = query.Where(p => p.TenNH.Contains(sc.TenNH)); } if (sc.LoaiNH != null) { query = query.Where(p => p.LoaiNH.Equals(sc.LoaiNH)); } } retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd UpdateDealDetail(ChiTietGiaoDich objUpdate) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); ctx.Entry(objUpdate).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd InsertDealDetail(ChiTietGiaoDich objInsert) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); ctx.ChiTietGiaoDich.Add(objInsert); ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd InsertUser(MSTUSER objInsert) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); ctx.MstUser.Add(objInsert); ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd UpdateStaff(NhanVien staff) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); ctx.Entry(staff).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd InsertBanking(CreditManagement.Models.NganHang objInsert) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); ctx.NganHang.Add(objInsert); ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd UpdateBanking(CreditManagement.Models.NganHang objUpdate) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); ctx.Entry(objUpdate).State = System.Data.Entity.EntityState.Modified; ctx.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd UpdateCustomer(KhachHang customer) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { using (var context = new BankingContext()) { context.Entry(customer).State = System.Data.Entity.EntityState.Modified; context.SaveChanges(); retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchAllDealDetail() { retObjValueBackEnd = new ReturnObjValueBackEnd(); List <ChiTietGiaoDich> lst = new List <ChiTietGiaoDich>(); try { using (var context = new BankingContext()) { lst = context.ChiTietGiaoDich.ToList(); } retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchSaveMoneyByCondition(SoTietKiem sc) { retObjValueBackEnd = new ReturnObjValueBackEnd(); List <SoTietKiem> lst = new List <SoTietKiem>(); try { var ctx = new BankingContext(); var query = from ct in ctx.SoTietKiem select ct; if (sc != null) { if (sc.MaSTK != null) { query = query.Where(p => p.MaSTK.Equals(sc.MaSTK)); } if (sc.MaKH != null) { query = query.Where(p => p.MaKH.Equals(sc.MaKH)); } if (sc.NgayTao != null) { query = query.Where(p => p.NgayTao.Equals(sc.NgayTao)); } if (sc.NgayHuy != null) { query = query.Where(p => p.NgayHuy.Equals(sc.NgayHuy)); } if (sc.MaNV != null) { query = query.Where(p => p.MaNV.Equals(sc.MaNV)); } if (sc.MaCN != null) { query = query.Where(p => p.MaCN.Equals(sc.MaCN)); } if (sc.LoaiTK != null) { query = query.Where(p => p.LoaiTK.Equals(sc.LoaiTK)); } if (sc.SoTien != null) { query = query.Where(p => p.SoTien.Equals(sc.SoTien)); } } lst = query.ToList(); retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd InsertCustomer(KhachHang customer, string manv) { retObjValueBackEnd = new ReturnObjValueBackEnd(); string macn = ""; try { using (var context = new BankingContext()) { string maxId = ""; maxId = (from c in context.KhachHang select c.MaKH).Max(); if (!string.IsNullOrEmpty(maxId)) { int maxCurrent = Convert.ToInt16(maxId.Substring(2, maxId.Length - 2)); int maxNext = maxCurrent + 1; string makh = maxNext.ToString().PadLeft(4, '0'); customer.MaKH = "KH" + makh; } else { customer.MaKH = "KH0001"; } context.KhachHang.Add(customer); context.SaveChanges(); retObjValueBackEnd.Success = true; // Lấy mã chi nhánh dựa vào mã nhân viên var query = from ct in context.NhanVien select ct; query = query.Where(p => p.MaNV.Equals(manv)); macn = query.ToList()[0].CNTrucThuoc; // Tạo tài khoản mới cho khách hàng vừa mới add mới. TaiKhoan tk = new TaiKhoan(); TaiKhoanLogic tklogic = new TaiKhoanLogic(); string maxIdTK = ""; maxIdTK = (from c in context.TaiKhoan select c.MaTK).Max(); if (!string.IsNullOrEmpty(maxIdTK)) { int maxCurrent = Convert.ToInt16(maxIdTK.Substring(2, maxId.Length - 2)); int maxNext = maxCurrent + 1; string matkaddnew = maxNext.ToString().PadLeft(4, '0'); tk.MaTK = "TK" + matkaddnew; } else { customer.MaKH = "TK0001"; } if (!string.IsNullOrEmpty(customer.cmnd)) { tk.SoTK = int.Parse(customer.cmnd); } else { tk.SoTK = 1234; } tk.MaKH = customer.MaKH; tk.NgayTao = DateTime.Now; tk.MaNV = manv; tk.MaCN = macn; tk.ChuThich = ""; tk.SoDu = 0; // add record retObjValueBackEnd = tklogic.InsertAccount(tk); // Return mã tài khoản retObjValueBackEnd.Data = tk.MaTK; return(retObjValueBackEnd); } } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
static void Main(string[] args) { NhanVienLogic nv = new NhanVienLogic(); ReturnObjValueBackEnd lst = nv.SearchAllStaff(); string a = ""; }
public ReturnObjValueBackEnd SearchAccountByCondition(TaiKhoan sc) { List <TaiKhoan> lst = new List <TaiKhoan>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); var query = from ct in ctx.TaiKhoan select ct; if (sc != null) { if (sc.MaTK != null) { query = query.Where(p => p.MaTK.Equals(sc.MaTK)); } if (sc.SoTK != null) { query = query.Where(p => p.SoTK.Equals(sc.SoTK)); } if (sc.MaKH != null) { query = query.Where(p => p.MaKH.Equals(sc.MaKH)); } if (sc.NgayTao != null) { query = query.Where(p => p.NgayTao.Equals(sc.NgayTao)); } if (sc.NgayHuy != null) { query = query.Where(p => p.NgayHuy.Equals(sc.NgayHuy)); } if (sc.MaNV != null) { query = query.Where(p => p.MaNV.Equals(sc.MaNV)); } if (sc.MaCN != null) { query = query.Where(p => p.MaCN.Equals(sc.MaCN)); } if (sc.ChuThich != null) { query = query.Where(p => p.ChuThich.Contains(sc.ChuThich)); } } lst = query.ToList(); retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
/// <summary> /// Hàm này để màn hình gọi xử lý thực thi giao dịch /// </summary> /// <param name="makh"></param> /// <param name="manv"></param> /// <param name="sotien"></param> /// <param name="noidung"></param> /// <param name="manguoinhan"></param> /// <param name="loaiGD"> /// 1: gui tien /// 2. rut tien /// 3. chuyen tien /// </param> /// <returns></returns> public ReturnObjValueBackEnd ThemMoiGiaoDich(string makh, string manv, decimal sotien, string noidung, string manguoinhan, int loaiGD) { retObjValueBackEnd = new ReturnObjValueBackEnd(); try { string macn = ""; decimal soduttk = 0; var ctx = new BankingContext(); // Lấy mã chi nhánh dựa vào mã nhân viên var query = from ct in ctx.NhanVien select ct; query = query.Where(p => p.MaNV.Equals(manv)); macn = query.ToList()[0].CNTrucThuoc; // Lấy số dư tài khoản dựa vào makh, manv, macn var queryTK = from tk in ctx.TaiKhoan where tk.MaKH.Equals(makh) && tk.MaNV.Equals(manv) && tk.MaCN.Equals(macn) select tk; soduttk = queryTK.ToList()[0].SoDu; if (loaiGD != 1) { if (soduttk < sotien) { retObjValueBackEnd.Message = "Số tiền giao dịch không hợp lệ."; retObjValueBackEnd.Success = true; return(retObjValueBackEnd); } } // add new table giaodich GiaoDich gd = new GiaoDich(); GiaoDichLogic gdLogic = new GiaoDichLogic(); gd.MaKH = makh; gd.SoTien = sotien; gd.NgayCapNhat = DateTime.Now; string maxIdGD = ""; maxIdGD = (from c in ctx.GiaoDich select c.MaGD).Max(); if (!string.IsNullOrEmpty(maxIdGD)) { int maxCurrent = Convert.ToInt16(maxIdGD.Substring(2, maxIdGD.Length - 2)); int maxNext = maxCurrent + 1; string magdaddnew = maxNext.ToString().PadLeft(4, '0'); gd.MaGD = "GD" + magdaddnew; } else { gd.MaGD = "GD0001"; } retObjValueBackEnd = gdLogic.InsertDeal(gd); if (retObjValueBackEnd.Success == false) { retObjValueBackEnd.Message = "Insert vào table giao dịch không thành công"; return(retObjValueBackEnd); } // add table ChTietGiaoDich ChiTietGiaoDich ctgd = new ChiTietGiaoDich(); CTGiaoDichLogic ctgdLogic = new CTGiaoDichLogic(); ctgd.MaGD = gd.MaGD; ctgd.MaKH = gd.MaKH; ctgd.NgayGD = gd.NgayCapNhat; ctgd.MaNV = manv; ctgd.MaCNNH = macn; ctgd.SoTienGD = sotien; ctgd.NoiDungGD = noidung; ctgd.MaTKNguoiNhan = noidung; ctgd.MaTKNguoiNhan = manguoinhan; retObjValueBackEnd = ctgdLogic.InsertDealDetail(ctgd); if (retObjValueBackEnd.Success == false) { retObjValueBackEnd.Message = "Insert vào table chi tiết giao dịch không thành công"; return(retObjValueBackEnd); } retObjValueBackEnd = ctgdLogic.InsertDealDetail(ctgd); // Cập nhật số tiền tại table TaiKoan TaiKhoan tkupdate = new TaiKhoan(); TaiKhoanLogic tkupdateLogic = new TaiKhoanLogic(); tkupdate = queryTK.ToList()[0]; tkupdate.SoDu = tkupdate.SoDu - (decimal)gd.SoTien; retObjValueBackEnd = tkupdateLogic.UpdateAccount(tkupdate); // Return mã giao dịch và số dư còn lại Transaction transaction = new Transaction(); transaction.MaGD = gd.MaGD; transaction.SoDuConLai = tkupdate.SoDu; retObjValueBackEnd.Data = transaction; return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchDealDetailByCondition(ChiTietGiaoDich sc) { List <ChiTietGiaoDich> lst = new List <ChiTietGiaoDich>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); var query = from ct in ctx.ChiTietGiaoDich select ct; if (sc != null) { if (sc.MaGD != null) { query = query.Where(p => p.MaGD.Equals(sc.MaGD)); } if (sc.MaKH != null) { query = query.Where(p => p.MaKH.Equals(sc.MaKH)); } if (sc.NgayGD != null) { query = query.Where(p => p.NgayGD.Equals(sc.NgayGD)); } if (sc.MaNV != null) { query = query.Where(p => p.MaNV.Equals(sc.MaNV)); } if (sc.MaCNNH != null) { query = query.Where(p => p.MaCNNH.Equals(sc.MaCNNH)); } if (sc.SoTienGD != null) { query = query.Where(p => p.SoTienGD.Equals(sc.SoTienGD)); } if (sc.NoiDungGD != null) { query = query.Where(p => p.NoiDungGD.Contains(sc.NoiDungGD)); } if (sc.PhiGD != null) { query = query.Where(p => p.PhiGD.Equals(sc.PhiGD)); } if (sc.TrangThai != null) { query = query.Where(p => p.TrangThai.Equals(sc.TrangThai)); } if (sc.MaTKNguoiNhan != null) { query = query.Where(p => p.MaTKNguoiNhan.Equals(sc.MaTKNguoiNhan)); } } lst = query.ToList(); retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lst.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }
public ReturnObjValueBackEnd SearchStaffByCondition(NhanVien sc) { List <NhanVien> lstNhanVien = new List <NhanVien>(); retObjValueBackEnd = new ReturnObjValueBackEnd(); try { var ctx = new BankingContext(); var query = from ct in ctx.NhanVien select ct; if (sc != null) { if (sc.MaNV != null) { query = query.Where(p => p.MaNV.Equals(sc.MaNV)); } if (sc.cmnd != null) { query = query.Where(p => p.cmnd.Equals(sc.cmnd)); } if (sc.ChucVu != null) { query = query.Where(p => p.ChucVu.Equals(sc.ChucVu)); } if (sc.TenNV != null) { query = query.Where(p => p.TenNV.Contains(sc.TenNV)); } if (sc.CNTrucThuoc != null) { query = query.Where(p => p.CNTrucThuoc.Equals(sc.CNTrucThuoc)); } if (sc.SoDienThoai != null) { query = query.Where(p => p.SoDienThoai.Equals(sc.SoDienThoai)); } if (sc.NgaySinh != null) { query = query.Where(p => p.NgaySinh.Equals(sc.NgaySinh)); } } lstNhanVien = query.ToList(); retObjValueBackEnd.Success = true; retObjValueBackEnd.Data = lstNhanVien.ToArray(); return(retObjValueBackEnd); } catch (Exception ex) { retObjValueBackEnd.Success = false; retObjValueBackEnd.Message = ex.ToString(); return(retObjValueBackEnd); throw ex; } }