internal static List <Accountant_Information> getAccountNumbers(CreateAccountOptions?accountType)
{
// bool result = false;
if (accountType == null)
{
return(null);
}
try
{
var acctype = accountType.ToString();
SqlConnection connection = null;
string query = null;
connection = new SqlConnection("Data Source=k8bjlaohq3.database.windows.net;Initial Catalog=ivrbot_db;Integrated Security=False;User ID=datareadserver;Password=Astrani@2016;Connect Timeout=60;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
connection.Open();
MessagesController.accountnumlist = new List <Accountant_Information>();
Accountant_Information accountantinf;
string selectquery = "Select AccountNumber from [dbo].[Accountant_Information] where AccountType='" + acctype + "'";
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = selectquery;
cmd.Connection = connection;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
accountantinf = new Accountant_Information();
// accountantinf.AccountNumber = Convert.ToInt64(reader["AccountNumber"]);
accountantinf.AccountNumber = reader["AccountNumber"].ToString();
MessagesController.accountnumlist.Add(accountantinf);
}
}
//connection.Close();
}
return(MessagesController.accountnumlist);
}
catch (Exception ex)
{
}
return(null);
}
internal static string checkingCurrentAccountBalance(string accountNumber, string pIN)
{
if (accountNumber == null && pIN == null)
{
return(null);
}
try
{
SqlConnection connection = null;
string query = null;
connection = new SqlConnection("Data Source=k8bjlaohq3.database.windows.net;Initial Catalog=ivrbot_db;Integrated Security=False;User ID=datareadserver;Password=Astrani@2016;Connect Timeout=60;Encrypt=False;TrustServerCertificate=True;ApplicationIntent=ReadWrite;MultiSubnetFailover=False");
connection.Open();
MessagesController.accountnumlist = new List <Accountant_Information>();
Accountant_Information accountantinf = new Accountant_Information();
string selectquery = "Select Current_Balance from [dbo].[Accountant_Information] where AccountNumber=" + accountNumber + "AND PinNo=" + pIN;// where AccountType="+accountType;
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = selectquery;
cmd.Connection = connection;
SqlDataReader reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
accountantinf.Balance = reader["Current_Balance"].ToString();
}
}
//connection.Close();
}
return(accountantinf.Balance);
}
catch (Exception ex)
{
}
return(null);
}
