public List<String> StagewiseReport()
{
List<string> StagewiseList = new List<string>();
DatabaseAccessForReporting ReportingObj = new DatabaseAccessForReporting();
StagewiseList = ReportingObj.StageWiseReport();
return StagewiseList;
}
public List<ActionModel> treatmentHistory(string number)
{
List<ActionModel> customerData = new List<ActionModel>();
DatabaseAccessForReporting ReportingObj = new DatabaseAccessForReporting();
customerData = ReportingObj.searchTreatment(number);
return (customerData);
}
public List<SearchModel> reporting(string custName, string Zip)
{
List<SearchModel> customerData = new List<SearchModel>();
DatabaseAccessForReporting ReportingObj = new DatabaseAccessForReporting();
customerData=ReportingObj.Search(custName,Zip);
return customerData;
}
public List<SearchModel> Disconnected()
{
List<SearchModel> customerData = new List<SearchModel>();
DatabaseAccessForReporting ReportingObj = new DatabaseAccessForReporting();
customerData = ReportingObj.SearchByDisconnected();
return customerData;
}
public List<SearchModel> Delinquent()
{
List<SearchModel> customerData = new List<SearchModel>();
DatabaseAccessForReporting ReportingObj = new DatabaseAccessForReporting();
customerData = ReportingObj.SearchByDelinquent();
return customerData;
}
void validate()
{
try
{
OracleConnection conn = new OracleConnection();
conn.ConnectionString = connString;
conn.Open();
DatabaseAccessForReporting obj = new DatabaseAccessForReporting();
obj.EstablishConnection();
OracleCommand command = new OracleCommand("Select role from finlogin where username= :username and password= :password", conn);
command.Parameters.Add(":username", finUserName);
command.Parameters.Add(":password", finPwd);
finDept = command.ExecuteScalar().ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
void validate()
{
try
{
OracleConnection conn = new OracleConnection();
conn.ConnectionString = connString;
conn.Open();
DatabaseAccessForReporting obj = new DatabaseAccessForReporting();
obj.EstablishConnection();
OracleCommand command = new OracleCommand("Select role from finlogin where username= :username and password= :password", conn);
command.Parameters.Add(":username", finUserName);
command.Parameters.Add(":password", finPwd);
finDept = command.ExecuteScalar().ToString();
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
public void populatingDb()
{
DatabaseAccessForReporting ReportingObj = new DatabaseAccessForReporting();
ReportingObj.populatingCustomerDb();
}