public Shipper Get(int id)
{
Shipper s = new Shipper();
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter("@id", id)
};
SqlDataReader reader = helper.GetData("Select * from Shippers where ShipperID=@id", CommandType.Text, parameters);
while (reader.Read())
{
s.CompanyName = reader["CompanyName"].ToString();
s.Phone = reader["Phone"].ToString();
s.ShipperID = Convert.ToInt32(reader["ShipperID"]);
}
return(s);
}
public Category Get(int id)
{
Category s = new Category();
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter("@id", id)
};
SqlDataReader reader = helper.GetData("Select * from Categories where CategoryID=@id", CommandType.Text, parameters);
while (reader.Read())
{
s.CategoryName = reader[nameof(s.CategoryName)].ToString();
s.Description = reader[nameof(s.Description)].ToString();
s.Picture = reader[nameof(s.Picture)].ToString();
s.CategoryID = Convert.ToInt32(reader[nameof(s.CategoryID)]);
}
return(s);
}
public ApplicationUser Get(int id)
{
ApplicationUser user = new ApplicationUser();
string cmdText = "Select * from ApplicationUser where Id=@id";
List <SqlParameter> parameters = new List <SqlParameter>
{
new SqlParameter("@id", id)
};
var reader = helper.GetData(cmdText, CommandType.Text, parameters);
while (reader.Read())
{
user.FullName = reader[nameof(user.FullName)].ToString();
user.UserName = reader[nameof(user.UserName)].ToString();
user.Password = reader[nameof(user.Password)].ToString();
user.Email = reader[nameof(user.Email)].ToString();
user.Id = Convert.ToInt32(reader[nameof(user.Id)]);
}
return(user);
}