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;
}
}
