public ProneFullInformation GetProneById(int id)
{
ProneFullInformation fullInformation = new ProneFullInformation();
using (SqlConnection con = new SqlConnection(Connection.String()))
{
using (SqlCommand cmd = new SqlCommand("sp_SelectPropertyById", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
KonsumatorDbClient konsumatorDbClient = new KonsumatorDbClient();
Qytet city = new Qytet(Convert.ToInt32(reader["qytetID"]), Convert.ToString(reader["qytetEmer"]), 0);
PozicionGjeografik geo = new PozicionGjeografik(Convert.ToDouble(reader["latitude"]), Convert.ToDouble(reader["logitude"]));
Adrese adrese = new Adrese(Convert.ToString(reader["rrugeEmer"]), Convert.ToInt32(reader["nderteseNumer"]), Convert.ToInt32(reader["shkalleNumer"]),
Convert.ToInt32(reader["apartamentNumer"]), Convert.ToInt32(reader["zipCode"]));
Konsumator konsumator = new Konsumator(Convert.ToInt32(reader["idKonsumator"]), Convert.ToDouble(reader["konsumatorRating"]), Convert.ToString(reader["konsumatorPershkrim"]));
KonsumatorWithPicture konsumatorFull = konsumatorDbClient.GetKonsumatorById(konsumator.IdKonsumator);
KategoriProne kategori = new KategoriProne(0, Convert.ToString(reader["kategoriProneEmer"]), Convert.ToString(reader["kategoriPershkrim"]));
ProneInfo info = new ProneInfo(Convert.ToDouble(reader["proneRating"]));
ProneComponent comp = new ProneComponent(id, Convert.ToString(reader["proneTitull"]), Convert.ToDouble(reader["proneSiperfaqe"]), Convert.ToInt32(reader["proneNumerDhomash"]), Convert.ToInt32(reader["proneNumerBanjo"]), Convert.ToDouble(reader["pricePerMonth"]), 0, Convert.ToString(reader["pronePicturePath"]));
Photo foto = new Photo(Convert.ToString(reader["pronePicture"]), Convert.ToString(reader["pronePicturePath"]));
fullInformation = new ProneFullInformation(comp, info, kategori, konsumatorFull, adrese, geo, city, foto);
}
}
}
}
return(fullInformation);
}
public KonsumatorWithPicture GetKonsumatorById(int id)
{
KonsumatorWithPicture konsumator = new KonsumatorWithPicture();
using (SqlConnection con = new SqlConnection(Connection.String()))
{
using (SqlCommand cmd = new SqlCommand("sp_GetKonsumatorById", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Konsumator kons = new Konsumator(Convert.ToInt32(reader[0]), Convert.ToString(reader[1]), Convert.ToString(reader[2]), Convert.ToString(reader[3]), Convert.ToString(reader[4]),
Convert.ToString(reader[5]), Convert.ToString(reader[6]), Convert.ToInt32(reader[10]), Convert.ToString(reader[13]));
Photo picture = new Photo(Convert.ToString(reader["profilePicName"]), Convert.ToString(reader["profilePicPath"]));
konsumator = new KonsumatorWithPicture(kons, picture);
}
}
}
}
}
return(konsumator);
}
public ActionResult MyProfile()
{
if (Session["Perdorues"] != null)
{
Konsumator kons = new Konsumator();
try
{
kons = (Konsumator)Session["Perdorues"];
KonsumatorDbClient konsumatorClient = new KonsumatorDbClient();
KonsumatorWithPicture konsumator = konsumatorClient.GetKonsumatorById(kons.IdKonsumator);
ViewBag.Data = konsumator;
if (konsumator.picture.profilePicPath == "")
{
ViewBag.Src = "https://encrypted-tbn0.gstatic.com/images?q=tbn:ANd9GcT6CgVGg5OjY7d64jvpXLs4MsWpykLmzOa_I6ClH2zLvycZ5J2c4g";
}
else
{
ViewBag.Src = konsumator.picture.profilePicPath;
}
SearchOperations ops = new SearchOperations();
List <Prone> prona = ops.GetByUserId(kons.IdKonsumator);
ViewBag.Properties = prona;
}
catch (Exception ex)
{
ViewBag.ErrorMessage = kons.IdKonsumator + "Something went wrong! " + ex.Message;
}
}
else
{
Session["Action"] = "MyProfile";
Session["Controller"] = "Profiles";
return(RedirectToAction("LoginForm", "Login"));
}
return(View());
}
