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; } }