public async Task <List <DataPoint> > GetRaports(string accountnumber, string procedure)
{
try
{
List <DataPoint> Data = null;
for (int i = 0; i < Months.Length; i++)
{
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, procedure, CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@Month", i + 1);
cmd.Parameters.AddWithValue("@AccountNumber", accountnumber);
SqlDataReader sdr = await cmd.ExecuteReaderAsync();
if (sdr.HasRows)
{
if (Data == null)
{
Data = new List <DataPoint>();
}
while (await sdr.ReadAsync())
{
Data.Add(new DataPoint(Months[i], decimal.Parse(sdr["Value"].ToString())));
}
}
}
}
return(Data);
}
catch (Exception)
{
throw;
}
}
public async Task <List <Transfer> > GetTransfers(string accountnumber)
{
try
{
List <Transfer> transfers = null;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_GetLastTransfers", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@Accountnumber", accountnumber);
SqlDataReader sdr = await cmd.ExecuteReaderAsync();
if (sdr.HasRows)
{
transfers = new List <Transfer>();
while (await sdr.ReadAsync())
{
Transfer obj = new Transfer();
obj.Amount = double.Parse(sdr["Amount"].ToString());
obj.Description = sdr["Description"].ToString();
transfers.Add(obj);
}
}
}
return(transfers);
}
catch (Exception)
{
throw;
}
}
public async Task <List <SavingAccounts> > ReadSaving(string email)
{
try
{
List <SavingAccounts> checkingAccounts = null;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_GetSavingAccount_ByEmail", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@Email", email);
SqlDataReader sdr = await cmd.ExecuteReaderAsync();
if (sdr.HasRows)
{
checkingAccounts = new List <SavingAccounts>();
while (await sdr.ReadAsync())
{
SavingAccounts obj = new SavingAccounts();
obj.AccountId = int.Parse(sdr["ID"].ToString());
obj.Account = new Accounts();
obj.Account.Id = int.Parse(sdr["ID"].ToString());
obj.Account.AccountNumber = sdr["AccountNumber"].ToString();
obj.Account.CardNumber = sdr["CardNumber"].ToString();
checkingAccounts.Add(obj);
}
}
return(checkingAccounts);
}
}
catch (Exception)
{
return(null);
}
}
public async Task <List <WithDrawal> > GetWithDrawals(string accountnumber)
{
try
{
List <WithDrawal> withDrawals = null;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_GetLastWithDrawals", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@Accountnumber", accountnumber);
SqlDataReader sdr = await cmd.ExecuteReaderAsync();
if (sdr.HasRows)
{
withDrawals = new List <WithDrawal>();
while (await sdr.ReadAsync())
{
WithDrawal obj = new WithDrawal();
obj.Amount = double.Parse(sdr["Amount"].ToString());
obj.Description = sdr["Description"].ToString();
obj.ExecutionDate = Convert.ToDateTime(sdr["ExecutionDate"]);
withDrawals.Add(obj);
}
}
}
return(withDrawals);
}
catch (Exception)
{
throw;
}
}
public async Task <List <Deposit> > GetDeposits(int id)
{
try
{
List <Deposit> deposits = null;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_ListTransaction_Deposit", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@ClientID", id);
SqlDataReader sdr = await cmd.ExecuteReaderAsync();
if (sdr.HasRows)
{
deposits = new List <Deposit>();
while (await sdr.ReadAsync())
{
deposits.Add(GetObject(sdr));
}
}
}
return(deposits);
}
catch (Exception)
{
throw;
}
}
public async Task <ActionResult <Transfer> > Insert(Transfer obj)
{
try
{
int value = 0;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_MakeTransfer", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@FullName", obj.FullName);
cmd.Parameters.AddWithValue("@ClientID", obj.ClientID);
cmd.Parameters.AddWithValue("@ExecutionDate", obj.ExecutionDate);
cmd.Parameters.AddWithValue("@Description", obj.Description);
cmd.Parameters.AddWithValue("@CardNumber", obj.CardNumber);
cmd.Parameters.AddWithValue("@AccountNumber", obj.AccountNumber);
cmd.Parameters.AddWithValue("@ToAccountNumber", obj.ToAccountNumber);
cmd.Parameters.AddWithValue("@Amount", obj.Amount);
value = await DataConnection.GetValue(cmd);
}
return(await DataConnection.Result(value, obj));
}
catch (Exception)
{
throw;
}
}
public async Task <List <PayCredit> > PayCredits(string email)
{
try
{
List <PayCredit> payCredits = null;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_GetPayCredits", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@Email", email);
SqlDataReader sdr = await cmd.ExecuteReaderAsync();
if (sdr.HasRows)
{
payCredits = new List <PayCredit>();
while (await sdr.ReadAsync())
{
payCredits.Add(new PayCredit(sdr["FullName"].ToString(), sdr["ClientName"].ToString(), Convert.ToDateTime(sdr["ExecutionDate"].ToString()),
sdr["CardNumber"].ToString(), sdr["AccountNumber"].ToString(), sdr["Description"].ToString(), double.Parse(sdr["Amount"].ToString()), sdr["CreditNumber"].ToString()));
}
}
}
return(payCredits);
}
catch (Exception)
{
throw;
}
}
public async Task <List <Credits> > MyCredits(string email)
{
try
{
List <Credits> credits = null;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_GetCredits_ByEmail", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@Email", email);
SqlDataReader sdr = await cmd.ExecuteReaderAsync();
if (sdr.HasRows)
{
credits = new List <Credits>();
while (await sdr.ReadAsync())
{
Credits obj = new Credits();
obj.Id = int.Parse(sdr["ID"].ToString());
obj.CreditNumber = sdr["CreditNumber"].ToString();
credits.Add(obj);
}
}
}
return(credits);
}
catch (Exception)
{
throw;
}
}
public async Task <PayCredit> PayCredit(PayCredit payCredit)
{
try
{
int value = 0;
using (var con = await DataConnection.Connection())
{
var cmd = DataConnection.Command(con, "sp_PayCredit", CommandType.StoredProcedure);
cmd.Parameters.AddWithValue("@FullName", payCredit.FullName);
cmd.Parameters.AddWithValue("@ClientID", payCredit.ClientID);
cmd.Parameters.AddWithValue("@CardNumber", payCredit.CardNumber);
cmd.Parameters.AddWithValue("@AccountNumber", payCredit.AccountNumber);
cmd.Parameters.AddWithValue("@CreditNumber", payCredit.CreditNumber);
cmd.Parameters.AddWithValue("@Amount", payCredit.Amount);
cmd.Parameters.AddWithValue("@Description", payCredit.Description);
value = await DataConnection.GetValue(cmd);
}
return(await DataConnection.Result(value, payCredit));
}
catch (Exception)
{
throw;
}
}
