public GenericResponse <BranchContract> DeleteBranchById(BranchRequest request) { DbOperation dbOperation = new DbOperation(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@BranchId", request.DataContract.Id), }; try { var dbResponse = dbOperation.spExecuteScalar("COR.del_BranchDeleteById", parameters); return(new GenericResponse <BranchContract>() { IsSuccess = true }); } catch (Exception) { return(new GenericResponse <BranchContract>() { ErrorMessage = "DeleteBranchById işlemi başarısız oldu!", IsSuccess = false }); //throw; } }
public GenericResponse <RemittanceContract> DoNewRemittanceTransaction(RemittanceRequest request) { DbOperation dbOperation = new DbOperation(); SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@SenderAccountNumber", request.DataContract.SenderAccountNumber), new SqlParameter("@SenderAccountSuffix", request.DataContract.SenderAccountSuffix), new SqlParameter("@ReceiverAccountNumber", request.DataContract.ReceiverAccountNumber), new SqlParameter("@ReceiverAccountSuffix", request.DataContract.ReceiverAccountSuffix), new SqlParameter("@TransferAmount", request.DataContract.TransferAmount), new SqlParameter("@TransactionDate", request.DataContract.TransactionDate), new SqlParameter("@TransactionStatus", request.DataContract.TransactionStatus), new SqlParameter("@TransactionDescription", request.DataContract.TransactionDescription), }; try { var response = dbOperation.spExecuteScalar("TRN.ins_DoNewRemittance", sqlParameters); return(new GenericResponse <RemittanceContract>() { IsSuccess = true, Value = new RemittanceContract() }); } catch (Exception) { return(new GenericResponse <RemittanceContract>() { IsSuccess = false, ErrorMessage = "DoNewRemittanceTransaction operasyonu başarısız!", Value = null }); throw; } }
public GenericResponse <BranchContract> UpdateBranchDetailsById(BranchRequest request) { DbOperation dbOperation = new DbOperation(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("Id", request.DataContract.Id), new SqlParameter("@BranchName", request.DataContract.BranchName), new SqlParameter("@Adress", request.DataContract.Adress), new SqlParameter("CityId", request.DataContract.CityId), new SqlParameter("MailAdress", request.DataContract.MailAdress), new SqlParameter("PhoneNumber", request.DataContract.PhoneNumber) }; try { var dbResponse = dbOperation.spExecuteScalar("COR.upd_UpdateBranchDetailsById", parameters); return(new GenericResponse <BranchContract>() { IsSuccess = true }); } catch (Exception) { return(new GenericResponse <BranchContract>() { ErrorMessage = "UpdateBranchDetailsById fonksiyonu başarısız", IsSuccess = false }); } }
public GenericResponse <BranchContract> AddNewBranch(BranchRequest request) { request.DataContract.DateOfLaunch = DateTime.Now; DbOperation dbOperation = new DbOperation(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@BranchName", request.DataContract.BranchName), new SqlParameter("@Adress", request.DataContract.Adress), new SqlParameter("@CityId", request.DataContract.CityId), new SqlParameter("@DateOfLaunch", request.DataContract.DateOfLaunch), new SqlParameter("@MailAdress", request.DataContract.MailAdress), new SqlParameter("@PhoneNumber", request.DataContract.PhoneNumber), }; try { var dbResponse = Convert.ToInt32(dbOperation.spExecuteScalar("COR.ins_AddNewBranch", parameters)); return(new GenericResponse <BranchContract>() { IsSuccess = true }); } catch (Exception) { return(new GenericResponse <BranchContract>() { ErrorMessage = "AddNewBranch fonksiyonu başarısız", IsSuccess = false }); //throw; } }
public GenericResponse <AccountContract> UpdateAccountDetailsById(AccountRequest request) { DbOperation dbOperation = new DbOperation(); SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@Id", request.DataContract.Id), new SqlParameter("@CustomerId", request.DataContract.CustomerId), new SqlParameter("@AdditionNo", request.DataContract.AdditionNo), new SqlParameter("@CurrencyId", request.DataContract.CurrencyId), new SqlParameter("@Balance", request.DataContract.Balance), new SqlParameter("@BranchId", request.DataContract.BranchId), new SqlParameter("@IBAN", request.DataContract.IBAN), new SqlParameter("@IsActive", request.DataContract.IsActive), new SqlParameter("@DateOfDeactivation", request.DataContract.DateOfDeactivation) //nullable in db side }; try { var response = dbOperation.spExecuteScalar("CUS.upd_UpdateAccountDetailsById", sqlParameters); return(new GenericResponse <AccountContract>() { IsSuccess = true, Value = new AccountContract() }); } catch (Exception) { return(new GenericResponse <AccountContract>() { IsSuccess = false, ErrorMessage = "UpdateAccountDetailsById operasyonu başarısız." }); throw; } }
public GenericResponse <AccountContract> AddNewAccount(AccountRequest request) //New response { request.DataContract.DateOfFormation = DateTime.Now; DbOperation dbOperation = new DbOperation(); SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@BranchId", request.DataContract.BranchId), new SqlParameter("@CustomerId", request.DataContract.CustomerId), new SqlParameter("@AdditionNo", request.DataContract.AdditionNo), new SqlParameter("@CurrencyId", request.DataContract.CurrencyId), new SqlParameter("@Balance", request.DataContract.Balance), new SqlParameter("@IBAN", request.DataContract.IBAN), new SqlParameter("@IsActive", request.DataContract.IsActive), new SqlParameter("@FormedUserId", request.DataContract.FormedUserId), new SqlParameter("@DateOfFormation", request.DataContract.DateOfFormation) }; try { var response = dbOperation.spExecuteScalar("CUS.ins_AddNewAccount", sqlParameters); return(new GenericResponse <AccountContract>() { IsSuccess = true, Value = new AccountContract() }); } catch (Exception) { return(new GenericResponse <AccountContract>() { IsSuccess = false, ErrorMessage = "AddNewAccount operasyonu başarısız oldu." }); throw; } }
public GenericResponse <DepositWithdrawalContract> DoNewDepositWithdrawalTransfer(DepositWithdrawalRequest request) { DbOperation dbOperation = new DbOperation(); SqlParameter[] sqlParameters = new SqlParameter[] { new SqlParameter("@TransferType", request.DataContract.TransferType), new SqlParameter("@TransferBranchId", request.DataContract.TransferBranchId), new SqlParameter("@AccountNumber", request.DataContract.AccountNumber), new SqlParameter("@AccountSuffix", request.DataContract.AccountSuffix), new SqlParameter("@TransferDate", request.DataContract.TransferDate), new SqlParameter("@TransferAmount", request.DataContract.TransferAmount), new SqlParameter("@TransferDescription", request.DataContract.TransferDescription), new SqlParameter("@FormedUserId", request.DataContract.FormedUserId), new SqlParameter("@CurrencyId", request.DataContract.CurrencyId), }; try { var response = dbOperation.spExecuteScalar("TRN.ins_AddNewDepositWithdrawal", sqlParameters); return(new GenericResponse <DepositWithdrawalContract>() { IsSuccess = true, Value = new DepositWithdrawalContract() }); } catch (Exception) { return(new GenericResponse <DepositWithdrawalContract>() { IsSuccess = false, ErrorMessage = "DoNewRemittanceTransaction operasyonu başarısız!", Value = null }); throw; } }
public GenericResponse <CustomerContract> UpdateCustomerbyId(CustomerRequest request) { DbOperation dbOperation = new DbOperation(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("CustomerId", request.DataContract.CustomerId), new SqlParameter("@CustomerName", request.DataContract.CustomerName), new SqlParameter("@CustomerLastName", request.DataContract.CustomerLastName), new SqlParameter("@CitizenshipId", request.DataContract.CitizenshipId), new SqlParameter("@MotherName", request.DataContract.MotherName), new SqlParameter("@FatherName", request.DataContract.FatherName), new SqlParameter("@PlaceOfBirth", request.DataContract.PlaceOfBirth), new SqlParameter("@DateOfBirth", request.DataContract.DateOfBirth), new SqlParameter("@JobId", request.DataContract.JobId), new SqlParameter("@EducationLvId", request.DataContract.EducationLvId), new SqlParameter("@BranchId", request.DataContract.BranchId) }; try { var response = dbOperation.spExecuteScalar("CUS.upd_UpdateCustomerbyId", parameters); //TO-DO: DataContract'taki telefon numaraları ve email adresleri için işlem yapılmıyor. Eklenecek. return(new GenericResponse <CustomerContract>() { IsSuccess = true }); } catch (Exception) { return(new GenericResponse <CustomerContract>() { IsSuccess = false, ErrorMessage = "UpdateCustomerbyId isteği başarısız oldu." }); } }
public GenericResponse <CustomerContract> CustomerAdd(CustomerRequest request) { Business.Banking.Email emailBusiness = new Email(); Business.Banking.Phone phoneBusiness = new Phone(); DbOperation dbOperation = new DbOperation(); SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@CustomerName", request.DataContract.CustomerName), new SqlParameter("@CustomerLastName", request.DataContract.CustomerLastName), new SqlParameter("@CitizenshipId", request.DataContract.CitizenshipId), new SqlParameter("@MotherName", request.DataContract.MotherName), new SqlParameter("@FatherName", request.DataContract.FatherName), new SqlParameter("@PlaceOfBirth", request.DataContract.PlaceOfBirth), new SqlParameter("@DateOfBirth", request.DataContract.DateOfBirth), new SqlParameter("@JobId", request.DataContract.JobId), new SqlParameter("@EducationLvId", request.DataContract.EducationLvId), new SqlParameter("@BranchId", request.DataContract.BranchId) }; try { int id = Convert.ToInt32(dbOperation.spExecuteScalar("CUS.ins_AddNewCustomer", parameters)); if (request.DataContract.Emails != null) { try { foreach (CustomerEmailContract email in request.DataContract.Emails) { emailBusiness.EmailAdd(new CustomerEmailContract() { CustomerId = id, EmailType = email.EmailType, MailAdress = email.MailAdress }); } } catch (Exception) { return(new GenericResponse <CustomerContract>() { IsSuccess = false, ErrorMessage = "EmailAdd operasyonu başarısız!" }); } } if (request.DataContract.PhoneNumbers != null) { try { foreach (CustomerPhoneContract phone in request.DataContract.PhoneNumbers) { phoneBusiness.PhoneAdd(new CustomerPhoneContract() { CustomerId = id, PhoneType = phone.PhoneType, PhoneNumber = phone.PhoneNumber }); } } catch (Exception) { return(new GenericResponse <CustomerContract>() { IsSuccess = false, ErrorMessage = "PhoneNumberAdd operasyonu başarısız!" }); } } return(new GenericResponse <CustomerContract>() { Value = new CustomerContract { CustomerId = id }, IsSuccess = true }); } catch (Exception) { return(new GenericResponse <CustomerContract>() { IsSuccess = false, ErrorMessage = "CustomerAdd isteği başarısız." }); } }