public static ArrayList GetReqs()
{
ArrayList ReqList = new ArrayList();
Connections con = new Connections();
string strConnString = con.GetConnString();
using (SqlConnection SqlCon = new SqlConnection(strConnString))
{
SqlCommand SqlComm = new SqlCommand("", SqlCon);
SqlCon.Open();
string query = string.Format("SELECT * FROM account_req ORDER BY req_no DESC");
SqlComm.CommandText = query;
SqlDataReader reader = SqlComm.ExecuteReader();
while (reader.Read())
{
int req_no = reader.GetInt32(0);
string account_type = reader.GetString(1);
string sub_account = reader.GetString(2);
string title = reader.GetString(3);
string fname = reader.GetString(4);
string mname = reader.GetString(5);
string lname = reader.GetString(6);
string address = reader.GetString(7);
string pin = reader.GetString(8);
int state = reader.GetInt32(9);
int city = reader.GetInt32(10);
int branch = reader.GetInt32(11);
string gender = reader.GetString(12);
string maritalStatus = reader.GetString(13);
DateTime birthdate = reader.GetDateTime(14);
string email = reader.GetString(15);
string phone_no = reader.GetString(16);
string mob_no = reader.GetString(17);
string aadhaar_no = reader.GetString(18);
DateTime req_date = reader.GetDateTime(19);
string status = reader.GetString(20);
CustReq custReq = new CustReq(req_no, account_type, sub_account, title, fname, mname, lname, address, pin, state, city, branch, gender, maritalStatus, birthdate, email, phone_no, mob_no, aadhaar_no, req_date, status);
ReqList.Add(custReq);
}
return(ReqList);
}
}
public static CustReq GetCustReqAllDataById(int CustReqId)
{
Connections con = new Connections();
string strConnString = con.GetConnString();
using (SqlConnection SqlCon = new SqlConnection(strConnString))
{
SqlCommand SqlComm = new SqlCommand("", SqlCon);
SqlCon.Open();
string query = string.Format("SELECT req_no, account_type, sub_account, title, fname, mname, lname, address, pin, StateName, CityName, branch_name, gender, maritalStatus, birthdate, email, phone_no, mob_no, aadhaar_no, req_date, status FROM account_req JOIN BranchStates ON StateID=state JOIN BranchCities ON CityID=city JOIN branch_details ON branch_code=branch WHERE req_no='{0}'", CustReqId);
SqlComm.CommandText = query;
SqlDataReader reader = SqlComm.ExecuteReader();
CustReq ReqDataById = null;
while (reader.Read())
{
int req_no = reader.GetInt32(0);
string account_type = reader.GetString(1);
string sub_account = reader.GetString(2);
string title = reader.GetString(3);
string fname = reader.GetString(4);
string mname = reader.GetString(5);
string lname = reader.GetString(6);
string address = reader.GetString(7);
string pin = reader.GetString(8);
string state = reader.GetString(9);
string city = reader.GetString(10);
string branch = reader.GetString(11);
string gender = reader.GetString(12);
string maritalStatus = reader.GetString(13);
DateTime birthdate = reader.GetDateTime(14);
string email = reader.GetString(15);
string phone_no = reader.GetString(16);
string mob_no = reader.GetString(17);
string aadhaar_no = reader.GetString(18);
DateTime req_date = reader.GetDateTime(19);
string status = reader.GetString(20);
ReqDataById = new CustReq(req_no, account_type, sub_account, title, fname, mname, lname, address, pin, state, city, branch, gender, maritalStatus, birthdate, email, phone_no, mob_no, aadhaar_no, req_date, status);
}
return(ReqDataById);
}
}