public void LoadProfile()
{
Data data = null;
DataRowCollection dr;
Province province;
City city;
Neighborhood neighborhood;
try
{
data = new Data(ConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString());
List <MySqlParameter> p = new List <MySqlParameter>()
{
new MySqlParameter()
{
ParameterName = "@p_id_user", MySqlDbType = MySqlDbType.VarChar, Size = 36, Direction = ParameterDirection.Input, Value = this.Id
},
};
dr = data.ExecuteQuery("SP_SEL_USER_PROFILE", p).Tables[0].Rows;
Name = dr[0]["Name"].ToString();
MiddleName = dr[0]["MiddleName"].ToString();
LastName = dr[0]["LastName"].ToString();
Address1 = dr[0]["Address1"].ToString();
Address2 = dr[0]["Address2"].ToString();
ZipCode = dr[0]["ZipCode"].ToString();
EMail = dr[0]["EMail"].ToString();
Password = dr[0]["Password"].ToString();
province = new Province();
province.Id = Convert.ToInt16(dr[0]["province_Id"].ToString());
Province = province;
city = new City();
city.Id = Convert.ToInt16(dr[0]["city_Id"].ToString());
City = city;
neighborhood = new Neighborhood();
neighborhood.Id = Convert.ToInt16(dr[0]["neighborhood_Id"].ToString());
Neighborhood = neighborhood;
}
catch (Exception ex)
{
throw ex;
}
finally
{
data.CloseConnection();
data = null;
dr = null;
province = null;
city = null;
neighborhood = null;
}
}
public List <Neighborhood> GetNeighborhoodByCity(int idCity)
{
Data data = null;
DataSet ds;
List <Neighborhood> neighborhoods = null;
Neighborhood neighborhood = null;
try
{
data = new Data(ConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString());
List <MySqlParameter> p = new List <MySqlParameter>()
{
new MySqlParameter()
{
ParameterName = "@p_id_city", MySqlDbType = MySqlDbType.Int16, Size = 0, Direction = ParameterDirection.Input, Value = idCity
},
};
ds = data.ExecuteQuery("SP_SEL_NEIGHBORHOOD_BY_CITY", p);
neighborhoods = new List <Neighborhood>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
neighborhood = new Neighborhood();
neighborhood.Id = Convert.ToInt16(dr["Id"].ToString());
neighborhood.Name = dr["Name"].ToString();
neighborhoods.Add(neighborhood);
}
return(neighborhoods);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (data != null)
{
data.CloseConnection();
}
data = null;
neighborhoods = null;
neighborhood = null;
ds = null;
}
}
public User(string id, string name, string middlename, string lastname, string address1, string address2, Province province, City city, Neighborhood neighborhood, string zipcode, string email, string password)
{
this.Id = id;
this.Name = name;
this.MiddleName = middlename;
this.LastName = lastname;
this.Address1 = address1;
this.Address2 = address2;
this.Province = province;
this.City = city;
this.Neighborhood = neighborhood;
this.ZipCode = zipcode;
this.EMail = email;
this.Password = password;
}
public List <Job> GetJobsByNeighborhood(Neighborhood neighborhood, string userId)
{
Data data = null;
DataRowCollection dr;
try
{
data = new Data(ConfigurationManager.ConnectionStrings["MySqlConnectionString"].ToString());
List <MySqlParameter> p = new List <MySqlParameter>()
{
new MySqlParameter()
{
ParameterName = "@p_neighborhood_id", Value = neighborhood.Id
},
new MySqlParameter()
{
ParameterName = "@p_user_id", Value = userId
},
};
dr = data.ExecuteQuery("SP_SEL_JOBS_BY_NEIGHBORHOOD", p).Tables[0].Rows;
return(FillListOfJobs(dr));
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (data != null)
{
data.CloseConnection();
}
data = null;
dr = null;
}
}