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 LoginCompletition(Konsumator konsumator)
{
bool flag = false;
Konsumator kons = new Konsumator();
KonsumatorDbClient konsumatorDbClient = new KonsumatorDbClient();
try
{
flag = konsumatorDbClient.CheckLogin(konsumator);
if (flag == true)
{
kons = konsumatorDbClient.GetLoginSession(konsumator);
Session["Perdorues"] = kons;
Konsumator konsumues = (Konsumator)Session["Perdorues"];
ViewBag.ErrorMessage = "Login u krye me sukses! " + "Welcome, " + konsumues.UserName;
if (Session["Action"] != null && Session["Controller"] != null)
{
return(RedirectToAction((String)Session["Action"], (String)Session["Controller"]));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
else
{
ViewBag.ErrorMessage = "Login deshtoi! ";
}
}
catch (SqlException ex)
{
ViewBag.ErrorMessage = "Something went wrong ! " + ex.StackTrace;
}
return(View());
}
public ActionResult InsertAddress(FormCollection collection)
{
if (Session["Perdorues"] != null)
{
Konsumator kons = (Konsumator)Session["Perdorues"];
int id = kons.IdKonsumator;
String rrugeEmer = collection["rrugeTxt"];
int ndertese = Convert.ToInt32(collection["nderteseTxt"]);
int shkalle = Convert.ToInt32(collection["shkalleTxt"]);
int apartament = Convert.ToInt32(collection["apartamentTxt"]);
int shtetid = Convert.ToInt32(collection["shtetiTxt"]);
int qytetId = Convert.ToInt32(collection["qytetiTxt"]);
int zipCode = Convert.ToInt32(collection["ziptTxt"]);
Adrese adrese = new Adrese(rrugeEmer, ndertese, shkalle, apartament, shtetid, qytetId, zipCode);
try
{
KonsumatorDbClient consDbClient = new KonsumatorDbClient();
consDbClient.AddAdress(id, adrese);
return(Json(new { status = "success", message = "address added!" }));
}
catch (Exception ex)
{
return(Json(new { status = "error", message = "something went wrong! " + ex.Message }));
}
}
else
{
Session["Action"] = "AddAddress";
Session["Controller"] = "Profiles";
return(RedirectToAction("LoginForm", "Login"));
}
}
public ActionResult UploadPicture(HttpPostedFileBase file)
{
try
{
Photo foto = new Photo();
Konsumator kons = (Konsumator)Session["Perdorues"];
string fileName = Path.GetFileNameWithoutExtension(file.FileName);
string extension = Path.GetExtension(file.FileName);
fileName = fileName + extension;
foto.profilePicPath = "~/Images/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Images/"), fileName);
foto.profilePicName = fileName;
file.SaveAs(fileName);
KonsumatorDbClient client = new KonsumatorDbClient();
client.UpdatePicture(kons.IdKonsumator, foto);
ViewBag.ErroMessage = "Picture updated!";
return(Json(new { data = new { status = "success", message = "Picture updated!" } }));
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "Something went wrong! " + ex.Message;
return(Json(new { data = new { status = "error", message = "Something went wrong! " + ex.Message } }));
}
}
public bool CheckLogin(Konsumator konsumator)
{
bool flag = false;
using (SqlConnection con = new SqlConnection(Connection.String()))
{
using (SqlCommand cmd = new SqlCommand("sp_CheckLogin", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = konsumator.Email;
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = konsumator.Password;
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
flag = true;
}
else
{
flag = false;
}
}
}
}
return(flag);
}
public ActionResult OrderProcess(FormCollection collection)
{
ViewBag.ErrorMessage = "Waiting...";
if (Session["Perdorues"] != null)
{
Konsumator perdorues = (Konsumator)Session["Perdorues"];
int idBleres = perdorues.IdKonsumator;
int idShites = Convert.ToInt32(collection["idShites"]);
ViewBag.UserNameShites = collection["userNameShites"];
ViewBag.UserNameBleres = perdorues.UserName;
double pricePerMonth = Convert.ToDouble(collection["pricePerMonth"]);
double totali = Convert.ToDouble(collection["totali"]);
int sasiaMuajve = Convert.ToInt32(collection["sasiaTxt"]);
int idProne = Convert.ToInt32(collection["proneId"]);
DateTime startDate = DateTime.Now;
DateTime endDate = DateTime.Now.AddMonths(sasiaMuajve);
String description = perdorues.UserName + " porositi shtepine me id : " + idProne + " nga pronari : " + idShites + " nga data : " + startDate + " deri me + " + endDate + ".";
ProneComponent comp = new ProneComponent(idProne);
Rental rent = new Rental(idBleres, idShites, startDate);
RentalDetails details = new RentalDetails(pricePerMonth, idProne, sasiaMuajve, startDate, endDate, description, totali);
Order order = new Order(comp, rent, details);
OrderClient orderClient = new OrderClient();
if (idBleres != idShites)
{
try
{
orderClient.InsertOrder(order);
ViewBag.ErrorMessage = "Order proccessed successfully!";
return(Json(new { data = new { status = "success", message = (String)ViewBag.ErrorMessage } }));
}
catch (Exception ex)
{
ViewBag.ErrorMessage = "Something went wrong! " + ex.Message + " Stacktrace: " + ex.StackTrace;
return(Json(new { data = new { status = "failure", message = (String)ViewBag.ErrorMessage } }));
}
}
else
{
ViewBag.ErrorMessage = "The property is yours you cannot order it!";
return(Json(new { data = new { status = "failure", message = (String)ViewBag.ErrorMessage } }));
}
}
else
{
Session["Action"] = "OrderProcess";
Session["Controller"] = "Order";
return(RedirectToAction("LoginForm", "Login"));
}
}
public ActionResult AddCreditCard()
{
if (Session["Perdorues"] != null)
{
Konsumator kon = (Konsumator)Session["Perdorues"];
}
else
{
Session["Action"] = "AddCreditCard";
Session["Controller"] = "Profiles";
return(RedirectToAction("LoginForm", "Login"));
}
return(View());
}
public ActionResult PostData(FormCollection collection)
{
double latitude = Convert.ToDouble(collection["latitude"]);
double logitude = Convert.ToDouble(collection["logitude"]);
Debug.WriteLine(latitude + " " + logitude);
PozicionGjeografik pozicion = new PozicionGjeografik(latitude, logitude);
Photo image = new Photo("Name", "Here");
String rrugeEmer = collection["rrugeEmerTxt"];
int nderteseNumer = Convert.ToInt32(collection["nderteseNumeTxt"]);
int shkalle = Convert.ToInt32(collection["shkalleNumerTxt"]);
int apartament = Convert.ToInt32(collection["apartamentNumerTxt"]);
int shtet = Convert.ToInt32(collection["shtetSelect"]);
int qytet = Convert.ToInt32(collection["qytetSelect"]);
int zipCode = Convert.ToInt32(collection["zipCodeTxt"]);
Adrese adrese = new Adrese(rrugeEmer, nderteseNumer, shkalle, apartament, shtet, qytet, zipCode);
double rating = Convert.ToDouble(collection["ratingTxt"]);
int select = Convert.ToInt32(collection["selectCategory"]);
ProneInfo proneInfo = new ProneInfo(rating, select);
String proneTitull = collection["proneTitullTxt"];
double sip = Convert.ToDouble(collection["proneSiperfaqeTxt"]);
int nrDh = Convert.ToInt32(collection["proneNumerDhomashTxt"]);
int nrB = Convert.ToInt32(collection["proneNumerBanjoTxt"]);
int eLire = Convert.ToInt32(collection["elireSelect"]);
double cmimPerMuaj = Convert.ToDouble(collection["cmimPerMuajTxt"]);
ProneComponent prone = new ProneComponent(proneTitull, sip, nrDh, nrB, eLire, cmimPerMuaj);
try
{
Konsumator konsumator = (Konsumator)Session["Perdorues"];
ProneRegistrationDbClient proneRegDbClient = new ProneRegistrationDbClient();
proneRegDbClient.Insert(pozicion, adrese, proneInfo, prone, konsumator.IdKonsumator, image);
ViewBag.ErrorMessage = "Publikimi u krye me sukses!";
return(Json(new { status = "success", message = ViewBag.ErrorMessage }));
}
catch (SqlException ex)
{
ViewBag.ErrorMessage = "Publikimi deshtoi! " + ex.Message;
return(Json(new { status = "error", message = ViewBag.ErrorMessage }));
}
}
public void InsertWithoutPhoto(Konsumator konsumator)
{
using (SqlConnection con = new SqlConnection(Connection.String()))
{
using (SqlCommand cmd = new SqlCommand("ShtoPerdoruesPaFoto", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@userName", SqlDbType.VarChar).Value = konsumator.UserName;
cmd.Parameters.Add("@emer", SqlDbType.VarChar).Value = konsumator.Emer;
cmd.Parameters.Add("@mbiemer", SqlDbType.VarChar).Value = konsumator.Mbiemer;
cmd.Parameters.Add("@telefon", SqlDbType.VarChar).Value = konsumator.Telefon;
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = konsumator.Email;
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = konsumator.Password;
cmd.Parameters.Add("@konsumatorPershkrim", SqlDbType.VarChar).Value = konsumator.KonsumatorPershkrim;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
}
public ActionResult CompleteProneRegistration(ProneComponent prone)
{
if (Session["Perdorues"] != null)
{
TempData["prone"] = prone;
try
{
try
{
Photo image = (Photo)TempData["Image"];
string fileName = Path.GetFileNameWithoutExtension(image.ImageFile.FileName);
string extension = Path.GetExtension(image.ImageFile.FileName);
fileName = fileName + extension;
image.profilePicPath = "~/Images/" + fileName;
fileName = Path.Combine(Server.MapPath("~/Images/"), fileName);
image.ImageFile.SaveAs(fileName);
Konsumator konsumator = (Konsumator)Session["Perdorues"];
ProneRegistrationDbClient proneRegDbClient = new ProneRegistrationDbClient();
proneRegDbClient.Insert((PozicionGjeografik)TempData["pozicioni"], (Adrese)TempData["adresa"], (ProneInfo)TempData["info"], (ProneComponent)TempData["prone"], konsumator.IdKonsumator, image);
ViewBag.ErrorMessage = "Publikimi u krye me sukses!";
}
catch (NullReferenceException ex)
{
ViewBag.ErrorMessage = "Something went wrong! " + ex.Message;
}
}
catch (SqlException ex)
{
ViewBag.ErrorMessage = "Publikimi deshtoi! " + ex.Message;
}
}
else
{
Session["Action"] = "CompleteProneRegistration";
Session["Controller"] = "Publish";
return(RedirectToAction("NotLogged", "Login"));
}
return(View());
}
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());
}
public ActionResult AddAddress()
{
if (Session["Perdorues"] != null)
{
QytetDbClient qdbClient = new QytetDbClient();
ViewBag.Cities = qdbClient.GetCities();
ShtetDbClient shdbClient = new ShtetDbClient();
ViewBag.Countries = shdbClient.GetCountries();
Konsumator kon = (Konsumator)Session["Perdorues"];
int id = kon.IdKonsumator;
}
else
{
Session["Action"] = "AddAddress";
Session["Controller"] = "Profiles";
return(RedirectToAction("LoginForm", "Login"));
}
return(View());
}
public ActionResult CreditCardInsertion(FormCollection collection)
{
if (Session["Perdorues"] != null)
{
try
{
Konsumator kon = (Konsumator)Session["Perdorues"];
int id = kon.IdKonsumator;
String cardHolder = collection["cardHolderTxt"];
String cardNumber = collection["cardNumberTxt"];
String month = collection["monthTxt"];
String year = collection["yearTxt"];
string date = "01/" + month + "/" + year;
DateTime dateDb = Convert.ToDateTime(date);
String secCode = collection["securityCodeTxt"];
String zipcode = collection["zipCodeTxt"];
CreditCard card = new CreditCard(cardHolder, cardNumber, dateDb, secCode, zipcode);
KonsumatorDbClient dbClient = new KonsumatorDbClient();
dbClient.AddCreditCard(id, card);
return(Json(new { status = "success", message = "credit card inserted!" }));
}
catch (Exception ex)
{
return(Json(new { status = "failed", message = "something went wrong! " + ex.Message }));
}
}
else
{
Session["Action"] = "CreditCardInsertion";
Session["Controller"] = "Profiles";
return(RedirectToAction("LoginForm", "Login"));
}
}
public Konsumator GetLoginSession(Konsumator konsumator)
{
Konsumator kons = new Konsumator();
int counter = 0;
using (SqlConnection con = new SqlConnection(Connection.String()))
{
using (SqlCommand cmd = new SqlCommand("sp_CheckLogin", con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@email", SqlDbType.VarChar).Value = konsumator.Email;
cmd.Parameters.Add("@password", SqlDbType.VarChar).Value = konsumator.Password;
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
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]));
counter++;
}
}
}
}
}
if (counter == 0)
{
kons = null;
}
return(kons);
}
public ActionResult AddProfilePic(Konsumator konsumator)
{
TempData["konsumator"] = konsumator;
return(View());
}
