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