public int UpdateBank(BankDTO data)
{
Bank dataToUpdate = BankRequestFormatter.ConvertRespondentInfoFromDTO(data);
var res = _unitOfWork.BankRepository.Update(dataToUpdate);
return(res);
}
public IList <BankDTO> GetBanks()
{
SAPbobsCOM.Recordset lObjResults = (SAPbobsCOM.Recordset)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
IList <BankDTO> lLstObjBanks = new List <BankDTO>();
try
{
string lStrQuery = this.GetSQL("GetBanks");
lObjResults.DoQuery(lStrQuery);
if (lObjResults.RecordCount > 0)
{
for (int i = 0; i < lObjResults.RecordCount; i++)
{
BankDTO lObjBank = new BankDTO();
lObjBank.BankCode = lObjResults.GetColumnValue <string>("BankCode");
lObjBank.BankName = lObjResults.GetColumnValue <string>("BankName");
lLstObjBanks.Add(lObjBank);
lObjResults.MoveNext();
}
}
return(lLstObjBanks);
}
catch (Exception e)
{
LogUtility.WriteError(string.Format("[BankDAO - GetBanks] Error al obtener los bancos: {0}", e.Message));
throw new Exception(string.Format("Error al obtener los bancos: {0}", e.Message));
}
finally
{
MemoryUtility.ReleaseComObject(lObjResults);
}
}
public IList <BankDTO> GetBanks()
{
SAPbobsCOM.Recordset lObjResults = (SAPbobsCOM.Recordset)DIApplication.Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.BoRecordset);
IList <BankDTO> lLstObjBanks = new List <BankDTO>();
try
{
string lStrQuery = this.GetSQL("GetBanks");
lObjResults.DoQuery(lStrQuery);
if (lObjResults.RecordCount > 0)
{
for (int i = 0; i < lObjResults.RecordCount; i++)
{
BankDTO lObjBank = new BankDTO();
lObjBank.BankCode = lObjResults.GetColumnValue <string>("BankCode");
lObjBank.BankName = lObjResults.GetColumnValue <string>("BankName");
lLstObjBanks.Add(lObjBank);
lObjResults.MoveNext();
}
}
return(lLstObjBanks);
}
catch (Exception e)
{
LogService.WriteError("GetBanks (GetFilterssVouchers): " + e.Message);
LogService.WriteError(e);
return(lLstObjBanks);
}
finally
{
MemoryUtility.ReleaseComObject(lObjResults);
}
}
public async Task <List <BankDTO> > GetBankntList(string ConnectionString)
{
await Task.Run(() =>
{
banklist = new List <BankDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select t1.recordid,case when (accountnumber is null or coalesce(accountnumber,'')='') then bankname else bankname||' - '|| accountnumber end as bankname,bankbranch,sum(coalesce(bankbookbalance,0)) as bankbookbalance,sum(coalesce(bankbookbalance,0))+sum(coalesce(passbookbalance,0)) passbookbalance from tblmstbank t1 left join (select t1.recordid,coalesce(sum( coalesce(debitamount,0)-coalesce(creditamount,0)),0) as bankbookbalance from tblmstbank t1 join tbltranstotaltransactions t2 on t1.bankaccountid=t2.parentid group by t1.recordid)t2 on t1.recordid=t2.recordid left join (select depositedbankid,sum(passbookbalance)passbookbalance from (select bankid depositedbankid,paidamount as passbookbalance from tbltranspaymentreference where clearstatus ='N' union all select depositedbankid,-totalreceivedamount as passbookbalance from tbltransreceiptreference where depositstatus ='P' and clearstatus='N' )x group by depositedbankid)t3 on t1.recordid=t3.depositedbankid where statusid=" + Convert.ToInt32(Status.Active) + " group by t1.recordid,bankname||' - '|| accountnumber ,bankbranch,t1.accountnumber,t1.bankname order by bankname;"))
{
while (dr.Read())
{
BankDTO _BankDTO = new BankDTO();
_BankDTO.pdepositbankname = _BankDTO.pbankname = Convert.ToString(dr["bankname"]);
_BankDTO.pdepositbankid = _BankDTO.pbankid = Convert.ToInt64(dr["recordid"]);
_BankDTO.pbranchname = Convert.ToString(dr["bankbranch"]);
_BankDTO.pbankbalance = Convert.ToDecimal(dr["bankbookbalance"]);
_BankDTO.pbankpassbookbalance = Convert.ToDecimal(dr["passbookbalance"]);
banklist.Add(_BankDTO);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(banklist);
}
public ActionResult CreateBank([Bind("Id", "SwiftBic", "SuspenseAccount", "CbaccountNo")] BankDTO bank)
{
try
{
Bank newBank = new Bank();
if (bank != null)
{
newBank = new Bank
{
Id = bank.Id,
SwiftBic = bank.SwiftBic,
SuspenseAccount = bank.SuspenseAccount,
CbaccountNo = bank.CbaccountNo,
EntityState = EntityState.Added
};
_businessLayer.AddBank(newBank);
}
return(Ok(newBank));
}
catch (Exception ex)
{
throw new Exception(ex.Message);
//return new JsonResult(new { HttpStatusCode = NotFound(HttpStatusCode.BadRequest), ex.Message });
}
}
public BankDTO CreateBank(BankDTO bank)
{
BankDTO dto = _service.CreateBank(bank.Name).ToDTO();
_service.Save();
return(dto);
}
public async Task <List <BankDTO> > GetDebitCardNumbers(string ConnectionString)
{
await Task.Run(() =>
{
bankdebitcardslist = new List <BankDTO>();
try
{
using (NpgsqlDataReader dr = NPGSqlHelper.ExecuteReader(ConnectionString, CommandType.Text, "select t2.bankid,bankname,cardnumber from tblmstbank t1 join tblmstbankdebitcarddtls t2 on t1.recordid=t2.bankid where t2.statusid=" + Convert.ToInt32(Status.Active) + " order by cardnumber;"))
{
while (dr.Read())
{
BankDTO _BankDebitCardsDTO = new BankDTO
{
pCardNumber = Convert.ToString(dr["cardnumber"]),
pbankname = Convert.ToString(dr["bankname"]),
pbankid = Convert.ToInt64(dr["bankid"]),
};
bankdebitcardslist.Add(_BankDebitCardsDTO);
}
}
}
catch (Exception ex)
{
throw ex;
}
});
return(bankdebitcardslist);
}
public IActionResult UpdateAccount(int Id, [FromBody] BankDTO bankDTO)
{
try
{
if (bankDTO == null || Id != bankDTO.Id)
{
return(BadRequest(ModelState));
}
var bankObj = _mapper.Map <Bank>(bankDTO); //Converting the received DTO to db obj
if (!_IbankRepo.UpdateAccount(bankObj)) //IBankRepository's Method
{
ModelState.AddModelError("", $"Something happened while updating the record {bankObj.AccountNumber}");
return(StatusCode(500, ModelState));
}
return(NoContent()); //204 status-code, With Path we don't retun any obj
}
catch (Exception e)
{
throw new Exception("Updated Account Error :", e);
}
}
public BankDTO InsertBank(BankDTO data)
{
Bank dataToInsert = new Bank();
dataToInsert = BankRequestFormatter.ConvertRespondentInfoFromDTO(data);
return(BankRequestFormatter.ConvertRespondentInfoToDTO(_unitOfWork.BankRepository.Create(dataToInsert)));
}
public void UpdateBank(BankDTO bank)
{
try
{
using (var unitOfWork = unitOfWorkManager.NewUnitOfWork())
{
try
{
var entity = mapper.Map <Bank>(bank);
bankRepository.Add(entity);
unitOfWork.Commit();
}
catch (Exception)
{
unitOfWork.Rollback();
throw;
}
}
}
catch (DbEntityValidationException dbEx)
{
var sb = new StringBuilder();
foreach (var validationError in dbEx.EntityValidationErrors.SelectMany(entityValidationErrors => entityValidationErrors.ValidationErrors))
{
sb.Append("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage);
}
throw new Exception(sb.ToString());
}
}
// GET: Banks/Edit/5
public ActionResult Edit(int id)
{
BankDTO bankByID = _bankService.GetBankId(id);
bankByID.BankAddedDateNP = !String.IsNullOrEmpty(Convert.ToString(bankByID.BankAddedDate)) ? NepEngDate.EngToNep(Convert.ToDateTime(bankByID.BankAddedDate)) : null;
return(View(bankByID));
}
public void TestBankDTO()
{
Bank bank = new Bank {
Id = 1, Name = "Cyril"
};
BankDTO dto = bank.ToDTO();
Assert.AreEqual(1, dto.Id);
}
public ActionResult Edit(BankDTO data)
{
data.BankAddedDate = !String.IsNullOrEmpty(data.BankAddedDateNP) ? Convert.ToDateTime(NepEngDate.NepToEng(data.BankAddedDateNP)) : data.BankAddedDate;
BankDTO bankData = new BankDTO();
int reOffice = _bankService.UpdateBank(data);
ViewBag.success = String.Format("Bank Updated");
ModelState.Clear();
return(View(bankData));
}
internal static void Handle(DbContext dbContext, OnBankCreatedEventArgs args)
{
var bankDto = new BankDTO
{
Id = ((Shared.Identity)args.Bank.Id).Id,
Address = args.Bank.Address,
ManagerId = ((Shared.Identity)args.Bank.Manager.Id).Id
};
dbContext.Banks.Add(bankDto);
dbContext.SaveChanges();
}
public static Bank ConvertRespondentInfoFromDTO(BankDTO bankDTO)
{
Mapper.CreateMap <BankDTO, Bank>().ConvertUsing(
m =>
{
return(new Bank
{
BankId = m.BankId,
BankName = m.BankName,
BankAddedDate = m.BankAddedDate,
BankStatus = m.BankStatus
});
});
return(Mapper.Map <BankDTO, Bank>(bankDTO));
}
public static void Create()
{
Console.WriteLine("Enter bank name:");
var name = Console.ReadLine();
Console.WriteLine("Enter bank swift:");
var swift = Console.ReadLine();
var bank = new BankDTO()
{
Name = name, Swift = swift
};
var _mapper = SetupMapper();
DalEF.Concrete.BankDalEf bankDal = new DalEF.Concrete.BankDalEf(_mapper);
bankDal.CreateBank(bank);
}
public ActionResult AddNewBank(BankDTO model)
{
if (!ModelState.IsValid)
return View(model);
try
{
model.SetCreateNewLog("System");
bankService.CreateNewBank(model.BankCode, model.BankName, "Dimas");
return RedirectToAction("Index");
}
catch (Exception ex)
{
AddErrors(new[] { ex.Message });
return View(model);
}
}
public BankDTO ToDTO(BankEntity ef)
{
BankDTO dto = new BankDTO();
dto.Answer = ef.Answer;
dto.ClassId = ef.ClassId;
dto.ClassName = ef.BankClass.Title;
dto.CreateDateTime = ef.CreateDateTime;
dto.Id = ef.Id;
dto.ItemA = ef.ItemA;
dto.ItemB = ef.ItemB;
dto.ItemC = ef.ItemC;
dto.ItemD = ef.ItemD;
dto.ItemE = ef.ItemE;
dto.Subject = ef.Subject;
return(dto);
}
public int Add(BankDTO dto)
{
using (MyDbContext ctx = new MyDbContext())
{
BankEntity ef = new BankEntity();
ef.Answer = dto.Answer;
ef.ClassId = dto.ClassId;
ef.ItemA = dto.ItemA;
ef.ItemB = dto.ItemB;
ef.ItemC = dto.ItemC;
ef.ItemD = dto.ItemD;
ef.ItemE = dto.ItemE;
ef.Subject = dto.Subject;
ctx.Banks.Add(ef);
ctx.SaveChanges();
return(ef.Id);
}
}
/// <summary>
/// Get the list of banks from db
/// </summary>
/// <returns></returns>
public List <BankDTO> GetBankList()
{
List <Bank> listBank = _businessLayer.GetAllBanks().ToList();
List <BankDTO> list = new List <BankDTO>();
foreach (Bank b in listBank)
{
BankDTO bankDTO = new BankDTO
{
Id = b.Id,
Name = b.FinancialInstitution.InstitutionName,
SwiftBic = b.SwiftBic,
SuspenseAccount = b.SuspenseAccount,
CbaccountNo = b.CbaccountNo
};
list.Add(bankDTO);
}
return(list);
}
public IActionResult Index()
{
List <string> reportList = new List <string> {
"Transaction Summary Report",
"Transaction Details Report",
"Bill Payment Summary Report",
"Bill Payment Details Report",
"Govt Fund Disbursement Summary Report",
"Govt Fund Disbursement Details Report",
"Salary Disbursement Summary Report",
"Salary Disbursement Details Report",
"Net Debit Cap Management Report",
"Settlement Status Report (Settled Transactions)",
"Settlement Status Report (Unsettled Transactions)",
"Dispute Management Summary Report",
"Dispute Management Details Report",
"Transaction Report(Sent)",
"Transaction Report(Received)",
"Settlement Report"
};
List <Bank> listBank = _businessLayer.GetAllBanks().ToList();
List <BankDTO> list = new List <BankDTO>();
foreach (Bank b in listBank)
{
BankDTO bankDTO = new BankDTO
{
Id = b.Id,
Name = b.FinancialInstitution.InstitutionName,
SwiftBic = b.SwiftBic,
SuspenseAccount = b.SuspenseAccount,
CbaccountNo = b.CbaccountNo
};
list.Add(bankDTO);
}
ViewBag.banklist = list;
ViewBag.reportList = reportList;
return(View());
}
public IActionResult Index()
{
List <Bank> listBank = _businessLayer.GetAllBanks().ToList();
List <BankDTO> list = new List <BankDTO>();
foreach (Bank b in listBank)
{
BankDTO bankDTO = new BankDTO
{
Id = b.Id,
Name = b.FinancialInstitution.InstitutionName,
SwiftBic = b.SwiftBic,
SuspenseAccount = b.SuspenseAccount,
CbaccountNo = b.CbaccountNo
};
list.Add(bankDTO);
}
ViewBag.banklist = list;
return(View());
}
public ActionResult Create(BankDTO data)
{
data.BankAddedDate = !String.IsNullOrEmpty(data.BankAddedDateNP) ? Convert.ToDateTime(NepEngDate.NepToEng(data.BankAddedDateNP)) : data.BankAddedDate;
BankDTO bankData = new BankDTO();
try
{
BankDTO resBankDTO = new BankDTO();
resBankDTO = _bankService.InsertBank(data);
ViewBag.success = String.Format("New Bank Added");
ModelState.Clear();
return(View(bankData));
}
catch (Exception Ex)
{
ViewBag.error = Ex.Message;
return(View(bankData));
}
}
public ActionResult Edit(BankDTO dto)
{
/*if (string.IsNullOrEmpty(dto.Subject) || string.IsNullOrEmpty(dto.Answer) || string.IsNullOrEmpty(dto.ItemA) || string.IsNullOrEmpty(dto.ItemB))
* {
* return Json(new AjaxResult { Status = "error", ErrorMsg = "修改失败！" });
* }*/
var data = bankService.Edit(dto);
if (data > 0)
{
return(Json(new AjaxResult {
Status = "ok"
}));
}
else
{
return(Json(new AjaxResult {
Status = "error", ErrorMsg = "修改失败！"
}));
}
}
public int Edit(BankDTO dto)
{
using (MyDbContext ctx = new MyDbContext())
{
BaseService <BankEntity> bs = new BaseService <BankEntity>(ctx);
var data = bs.GetById(dto.Id);
if (data == null)
{
return(0);
}
data.Answer = dto.Answer;
data.ClassId = dto.ClassId;
data.ItemA = dto.ItemA;
data.ItemB = dto.ItemB;
data.ItemC = dto.ItemC;
data.ItemD = dto.ItemD;
data.ItemE = dto.ItemE;
data.Subject = dto.Subject;
ctx.SaveChanges();
return(data.Id);
}
}
public ActionResult Add(BankDTO dto)
{
if (string.IsNullOrEmpty(dto.Subject) || string.IsNullOrEmpty(dto.Answer) || string.IsNullOrEmpty(dto.ItemA) || string.IsNullOrEmpty(dto.ItemB))
{
return(Json(new AjaxResult {
Status = "error", ErrorMsg = "添加失败！"
}));
}
var data = bankService.Add(dto);
if (data > 0)
{
return(Json(new AjaxResult {
Status = "ok"
}));
}
else
{
return(Json(new AjaxResult {
Status = "error", ErrorMsg = "添加失败！"
}));
}
}
public IActionResult CreateAccount([FromBody] BankDTO bankDTO)
{
try
{
if (bankDTO == null)
{
return(BadRequest(ModelState));
}
if (_IbankRepo.AccountExists(bankDTO.AccountNumber))
{
ModelState.AddModelError("", "Bank Account Exixts");
return(StatusCode(404, ModelState));
}
//We have [required] field in the model
//so don't need ModelState.IsValid to check
var bankObj = _mapper.Map <Bank>(bankDTO); //Converting the received DTO to db obj
if (!_IbankRepo.CreateAccount(bankObj))
{
ModelState.AddModelError("", $"Something happened while saving the record {bankObj.AccountNumber}");
return(StatusCode(500, ModelState));
}
//return Ok();
//CreatedAtrouted gives 201 statuscode and displays the new created obj
//It uses the HHTPGET byt Id method from previous and passes the new ID
return(CreatedAtRoute("GetAccountById", new { Id = bankObj.Id }, bankObj));
}
catch (Exception e)
{
throw new Exception("Created Account Error :", e);
}
}
public BankDTO UpdateBank(BankDTO bank)
{
//BankDTO dto = _service.UpdateBank(bank.Name).ToDTO();
_service.Save();
return(bank);
}
public Bank Map(BankDTO dto)
{
if (dto == null) return null;
var bank = Mapper.Map<BankDTO, Bank>(dto);
return bank;
}
