public List<Pwallet> getPwalletListDetailsByID(string ID)
{
List<Pwallet> list = new List<Pwallet>();
SqlConnection connection = new SqlConnection(this.Connect());
SqlCommand command = new SqlCommand("SELECT * FROM pwallet WHERE ID='" + ID + "' ", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
Pwallet pwallet2 = new Pwallet();
pwallet2.ID = Convert.ToInt64(reader["ID"]).ToString();
pwallet2.applicantID = reader["applicantID"].ToString();
pwallet2.validationID = reader["validationID"].ToString();
pwallet2.stage = reader["stage"].ToString();
pwallet2.status = reader["status"].ToString();
pwallet2.data_status = reader["data_status"].ToString();
pwallet2.amt = reader["amt"].ToString();
pwallet2.reg_date = reader["reg_date"].ToString();
Pwallet item = pwallet2;
list.Add(item);
}
reader.Close();
return list;
}
public Pwallet getPwalletDetailsByID(string ID)
{
Pwallet pwallet = new Pwallet();
pwallet.ID = "";
pwallet.applicantID = "";
pwallet.validationID = "";
pwallet.stage = "";
pwallet.status = "";
pwallet.data_status = "";
pwallet.amt = "";
pwallet.reg_date = "";
SqlConnection connection = new SqlConnection(this.Connect());
SqlCommand command = new SqlCommand("SELECT * FROM pwallet WHERE ID='" + ID + "' ", connection);
connection.Open();
SqlDataReader reader = command.ExecuteReader(CommandBehavior.CloseConnection);
while (reader.Read())
{
pwallet.ID = reader["ID"].ToString();
pwallet.applicantID = reader["applicantID"].ToString();
pwallet.validationID = reader["validationID"].ToString();
pwallet.stage = reader["stage"].ToString();
pwallet.status = reader["status"].ToString();
pwallet.data_status = reader["data_status"].ToString();
pwallet.amt = reader["amt"].ToString();
pwallet.reg_date = reader["reg_date"].ToString();
}
reader.Close();
return pwallet;
}
