public void UpdateOurUser(int id, string a, string b, string c, string d, string e, string f, DateTime g, string h, string i, string j, string k, string l, string m, int n, string o, string p)
{
InfoOfUsers z;
z = new InfoOfUsers();
z.UpdateUser(id, a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p);
}
public InfoOfUsers GetUserData(int a)
{
InfoOfUsers i;
i = new InfoOfUsers();
return(i.GetUser(a));
}
public string DetailsUser(int a)
{
InfoOfUsers i;
i = new InfoOfUsers();
return(i.OurUserData(a));
}
public DataTable InfoUser(int a)
{
InfoOfUsers i;
i = new InfoOfUsers();
return(i.SearchEntry(a));
}
public DataTable UsersInfo()
{
InfoOfUsers i;
i = new InfoOfUsers();
return(i.AllEntries());
}
public InfoOfUsers GetUser(int a)
{
InfoOfUsers u = new InfoOfUsers();
string query = "SelectID";
MyCon.Open();
SqlCommand cmd = new SqlCommand(query, MyCon);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", a);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
u.ID = int.Parse(reader[0].ToString());
u.Type = reader[1].ToString();
u.Password = reader[2].ToString();
u.FirstName = reader[3].ToString();
u.LastName = reader[4].ToString();
u.FatherName = reader[5].ToString();
u.BG = reader[6].ToString();
u.NIC = reader[7].ToString();
u.DOB = DateTime.Parse(reader[8].ToString());
u.PEmail = reader[9].ToString();
u.TEmail = reader[10].ToString();
u.Paddress = reader[11].ToString();
u.TAddress = reader[12].ToString();
u.City = reader[13].ToString();
u.Country = reader[14].ToString();
u.PostalCode = int.Parse(reader[15].ToString());
u.CellNo = reader[16].ToString();
}
MyCon.Close();
return(u);
}