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."
});
}
}
