/*
Frontend page: Report Page
Title: Get active account details of (Super Admin/ Admin)
Designed: Irfan Mam
User story: DFP-446
Developed: Irfan MAM
Date created: 6/23/2016
*/
public List<Account> GetAccountDetails(int companyIdORBranchId, int userRole)
{
List<Account> Accounts = new List<Account>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
// if user is super admin pass company id for companyIdORBranchId
// if user is a admin pass branch id for companyIdORBranchId
paramertList.Add(new object[] { "@comp_or_branch_id", companyIdORBranchId });
paramertList.Add(new object[] { "@user_role", userRole });
// calling stored procedure
DataSet dataSet = dataHandler.GetDataSet("GetAccountDetailsByUserRole", paramertList);
// biding data to list
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
Account account = new Account();
account.LoanId = Convert.ToInt32(dataRow["loan_id"]);
account.LoanCode = dataRow["loan_code"].ToString();
account.BranchId = Convert.ToInt32(dataRow["branch_id"]);
account.LoanNumber = dataRow["loan_number"].ToString();
account.BranchName = dataRow["branch_name"].ToString();
account.PatBranchName = dataRow["nr_branch_name"].ToString();
account.LoanAmount = Convert.ToDecimal(dataRow["loan_amount"].ToString());
account.UsedAmount = Convert.ToDecimal(dataRow["used_amount"].ToString());
account.ActiveUnits = Convert.ToInt32(dataRow["active_units"]);
account.PatBranchAddress1 = dataRow["branch_address_1"].ToString();
account.PatBranchAddress2 = dataRow["branch_address_2"].ToString();
account.PatCity = dataRow["city"].ToString();
Accounts.Add(account);
}
}
// returning the List of account details of relevant user (Super Admin/ Admin)
return Accounts;
}
/*
Frontend page: Report Page
Title: Get active account details of Users who has report rights(User/ Dealer User)
Designed: Irfan Mam
User story: DFP-474
Developed: Irfan MAM
Date created: 6/29/2016
*/
public List<Account> GetAccountDetailsForUser( int userId)
{
List<Account> Accounts = new List<Account>();
DataHandler dataHandler = new DataHandler();
List<object[]> paramertList = new List<object[]>();
// add user id to parameter list
paramertList.Add(new object[] { "@user_id", userId });
// calling stored procedure
DataSet dataSet = dataHandler.GetDataSet("GetAccountDetailsByUserId", paramertList);
// biding data to list
if (dataSet != null && dataSet.Tables.Count != 0)
{
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
Account account = new Account();
account.LoanId = Convert.ToInt32(dataRow["loan_id"]);
account.LoanNumber = dataRow["loan_number"].ToString();
account.LoanCode = dataRow["loan_code"].ToString();
account.PatBranchName = dataRow["branch_name"].ToString();
account.LoanAmount = Convert.ToDecimal(dataRow["loan_amount"].ToString());
account.UsedAmount = Convert.ToDecimal(dataRow["used_amount"].ToString());
account.ActiveUnits = Convert.ToInt32(dataRow["active_units"]);
account.PatBranchAddress1 = dataRow["branch_address_1"].ToString();
account.PatBranchAddress2 = dataRow["branch_address_2"].ToString();
account.PatCity = dataRow["city"].ToString();
account.userReportRights = dataRow["report_rights"].ToString();
Accounts.Add(account);
}
}
// returning the List of account details of relevant user
return Accounts;
}