public async Task <Response> RemoveBank(BankVM bank)
{
try
{
var DTO = await _db.Banks.Where(x => x.Id == bank.Id).FirstOrDefaultAsync();
_db.Banks.Remove(DTO);
int result = await _db.SaveChangesAsync();
if (result == 1)
{
// Mapper.Initialize(cfg => cfg.CreateMap<User, UserVM>());
return(GenericResponses <int> .ResponseStatus(false, Constant.MSGRecordFound, (int)Constant.httpStatus.Ok, result));
}
else
{
return(GenericResponses <int> .ResponseStatus(true, Constant.MSGFailed, (int)Constant.httpStatus.NoContent, result));
}
}
catch (Exception e)
{
return(GenericResponses <int> .ResponseStatus(true, e.Message, (int)Constant.httpStatus.NoContent, 0));
}
}
public Task <List <BankVM> > GetSearchResultAsync(BankVM entity, int pageNum, int pageSize)
{
return(Task.Run(() =>
{
int rowCount;
var q = from b in bankRepo.GetPaged <int>(pageNum, pageSize, p => p.ID, false, out rowCount).Where(x => x.ArName.Contains(entity.ArName))
select new BankVM
{
ID = b.ID,
Code = b.Code,
ArName = b.ArName,
LatName = b.LatName,
CurrencyID = b.CurrencyID,
AccountNo = b.AccountNo,
Notes = b.Notes,
NationID = b.NationID,
GovID = b.GovID,
TownID = b.TownID,
VillageID = b.VillageID,
AddedBy = b.AddedBy,
AddedOn = b.AddedOn,
UpdatedBy = b.UpdatedBy,
UpdatedOn = b.UpdatedOn,
Disable = b.Disable,
AddressNotes = b.AddressNotes,
};
return q.ToList();
}));
}
public Task <bool> deleteBankSync(BankVM entity)
{
return(Task.Run(() => {
Bank bank = new Bank();
{
bank.ID = entity.ID;
bank.Code = entity.Code;
bank.ArName = entity.ArName;
bank.LatName = entity.LatName;
bank.CurrencyID = entity.CurrencyID;
bank.AccountNo = entity.AccountNo;
bank.Notes = entity.Notes;
bank.NationID = entity.NationID;
bank.GovID = entity.GovID;
bank.TownID = entity.TownID;
bank.VillageID = entity.VillageID;
bank.AddedBy = entity.AddedBy;
bank.AddedOn = entity.AddedOn;
bank.UpdatedBy = entity.UpdatedBy;
bank.UpdatedOn = entity.UpdatedOn;
bank.Disable = entity.Disable;
bank.AddressNotes = entity.AddressNotes;
};
bankRepo.Delete(bank, bank.ID);
return true;
}));
}
public async Task <JsonResult> RemoveBank(BankVM bank)
{
Response r = await Repository.RemoveBank(bank);
// List<UserVM> employees = ((IEnumerable)r.Value).Cast<UserVM>().ToList(); ;
return(Json(r, JsonRequestBehavior.AllowGet));
}
public async Task <Response> AddBank(BankVM bank)
{
var Dto = Mapper.Map <BankVM, Bank>(bank);
Bank Exist = await _db.Banks.Where(x => x.Bank1.Trim() == bank.Bank1.Trim()).FirstOrDefaultAsync();
if (Exist != null)
{
return(GenericResponses <int> .ResponseStatus(true, Constant.MDGNoAlreadyExist, (int)Constant.httpStatus.NoContent, 0));
}
_db.Banks.Add(Dto);
int result = await _db.SaveChangesAsync();
if (result == 1)
{
// Mapper.Initialize(cfg => cfg.CreateMap<User, UserVM>());
return(GenericResponses <int> .ResponseStatus(false, Constant.MSGRecordFound, (int)Constant.httpStatus.Ok, result));
}
else
{
return(GenericResponses <int> .ResponseStatus(true, Constant.MDGNoLoginFailed, (int)Constant.httpStatus.NoContent, result));
}
}
public OperationResult Insert(BankVM model)
{
try
{
Bank bank = _BankRepository.Entities.FirstOrDefault(c => c.BankCode == model.BankCode.Trim());
if (bank != null)
{
return(new OperationResult(OperationResultType.Warning, "数据库中已经存在相同的银行信息，请修改后重新提交！"));
}
if (model.BankName == null || model.BankName.Trim() == "")
{
return(new OperationResult(OperationResultType.Warning, "开户银行名称不能为空，请修改后重新提交！"));
}
var entity = new Bank
{
BankCode = model.BankCode,
BankName = model.BankName,
UpdateDate = DateTime.Now
};
_BankRepository.Insert(entity);
return(new OperationResult(OperationResultType.Success, "新增数据成功！"));
}
catch
{
return(new OperationResult(OperationResultType.Error, "新增数据失败，数据库插入数据时发生了错误!"));
}
}
public async Task <IHttpActionResult> deleteBank(BankVM bank)
{
var result = await bankService.deleteBankSync(bank);
await LogData(bank.Code.ToString(), bank.ID.ToString());
return(Ok(result));
}
public ActionResult Add()
{
if ((string)Session["user"] != "admin")
{
return(RedirectToAction("../Home/Login"));
}
BankVM bankVM = new BankVM();
bankVM.Banks = _bankManager.GetAll();
return(View(bankVM));
}
public async Task <IHttpActionResult> insertBank(BankVM bank)
{
var result = await bankService.insertBankSync(bank);
await LogData(bank.Code.ToString(), result.ToString());
if (result != 0)
{
return(Ok(true));
}
return(Ok(false));
}
public ActionResult Add(BankVM bankVM)
{
Bank bank = Mapper.Map <Bank>(bankVM);
if (_bankManager.Add(bank))
{
TempData["saved"] = "Bank added successfully!";
return(RedirectToAction("Add"));
}
TempData["failed"] = "Failed to add";
return(View());
}
public ActionResult Update(BankVM bankVM)
{
Bank bank = Mapper.Map <Bank>(bankVM);
if (_bankManager.Update(bank))
{
TempData["updated"] = "Updated successfully";
return(RedirectToAction("Add"));
}
TempData["failed"] = "Failed to update";
return(View());
}
public dynamic PutBank(BankVM B)
{
var bank = db.Banks.Find(B.Id);
bank.NameA = B.NameA;
bank.NameE = B.NameA;
var result = db.SaveChanges() > 0 ? true : false;
return(new
{
result = result
});
}
public ActionResult Details(int id)
{
if ((string)Session["user"] != "admin")
{
return(RedirectToAction("../Home/Login"));
}
StudentManager studentManager = new StudentManager();
var bank = _bankManager.GetById(id);
BankVM bankVM = Mapper.Map <BankVM>(bank);
bankVM.BankAccounts = studentManager.GetByBank(id);
return(View(bankVM));
}
public dynamic PostBank(BankVM B)
{
db.Banks.Add(new Bank
{
NameA = B.NameA,
NameE = B.NameE
});
var result = db.SaveChanges() > 0 ? true : false;
return(new
{
result = result
});
}
public void AddBank(BankVM model)
{
if (model.Id == 0)
{
Bank b = new Bank();
b.BankName = model.BankName;
b.Branch = model.Branch;
_context.Banks.Add(b);
}
else
{
var bank = _context.Banks.Where(x => x.Id == model.Id).FirstOrDefault();
bank.BankName = model.BankName;
bank.Branch = model.Branch;
_context.Entry(bank).State = EntityState.Modified;
}
_context.SaveChanges();
}
public OperationResult Update(BankVM model)
{
try
{
Bank bank = _BankRepository.Entities.FirstOrDefault(c => c.BankCode == model.BankCode.Trim());
if (bank == null)
{
throw new Exception();
}
bank.BankName = model.BankName;
bank.BankCode = model.BankCode;
bank.UpdateDate = DateTime.Now;
_BankRepository.Update(bank);
return(new OperationResult(OperationResultType.Success, "更新数据成功！"));
}
catch
{
return(new OperationResult(OperationResultType.Error, "更新数据失败!"));
}
}
public void AddBank(BankVM model)
{
_iPayment.AddBank(model);
}
