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()); }