public ActionResult search(string curr) { if (curr == "") { return(RedirectToAction("Index")); } List <Models.rates> rates = new List <Models.rates>(); SqlConnectionStringBuilder constr = new SqlConnectionStringBuilder("Data Source=DESKTOP-N9AAJ82\\SKERDI;Initial Catalog=KEMBIM_VALUTOR;Integrated Security=True"); string qrstr = "select * from RATES where curr1 ='" + curr + "' or curr2 = '" + curr + "'"; using (SqlConnection con = new SqlConnection(constr.ConnectionString)) { SqlCommand cmd = new SqlCommand(qrstr, con); con.Open(); using (SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.SingleResult)) { while (reader.Read()) { Models.rates rate = new Models.rates(); rate.RateId = (int)reader["RATE_ID"]; rate.Curr1 = (string)reader["CURR1"]; rate.Curr2 = (string)reader["CURR2"]; rate.Rate = (double)reader["RATE"]; rates.Add(rate); } } } return(View("Index", rates)); }
public ActionResult exchange(int RateId) { Models.rates rate = new Models.rates(); rate.RateId = RateId; SqlConnectionStringBuilder constr = new SqlConnectionStringBuilder("Data Source=DESKTOP-N9AAJ82\\SKERDI;Initial Catalog=KEMBIM_VALUTOR;Integrated Security=True"); string qrstr = "select curr1, curr2, rate from rates where rate_id = " + RateId + ""; using (SqlConnection con = new SqlConnection(constr.ConnectionString)) { SqlCommand cmd = new SqlCommand(qrstr, con); con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { reader.Read(); rate.Curr1 = (string)reader[0]; rate.Curr2 = (string)reader[1]; rate.Rate = (double)reader[2]; reader.Close(); } } ViewBag.noval = false; ViewBag.transcomplete = false; return(View("../Shared/exchange", rate)); }
public ActionResult Index() { List <Models.rates> rates = new List <Models.rates>(); SqlConnectionStringBuilder constr = new SqlConnectionStringBuilder("Data Source=DESKTOP-N9AAJ82\\SKERDI;Initial Catalog=KEMBIM_VALUTOR;Integrated Security=True"); string qrstr = "select * from rates"; using (SqlConnection con = new SqlConnection(constr.ConnectionString)) { SqlCommand cmd = new SqlCommand(qrstr, con); con.Open(); using (SqlDataReader reader = cmd.ExecuteReader(System.Data.CommandBehavior.SingleResult)) { while (reader.Read()) { Models.rates rate = new Models.rates(); rate.RateId = (int)reader["RATE_ID"]; rate.Curr1 = (string)reader["CURR1"]; rate.Curr2 = (string)reader["CURR2"]; rate.Rate = (double)reader["RATE"]; rates.Add(rate); } } if (ViewBag.transcomplete == null) { ViewBag.transcomplete = false; } return(View(rates)); } }
public ActionResult userdetails() { if (Session["user_id"] != null) { Models.users user = new Models.users(); SqlConnectionStringBuilder constr = new SqlConnectionStringBuilder("Data Source=DESKTOP-N9AAJ82\\SKERDI;Initial Catalog=KEMBIM_VALUTOR;Integrated Security=True"); string qrstr = "select name,surname,username,birthday,email,password from users where user_id = '" + Session["user_id"] + "'"; using (SqlConnection con = new SqlConnection(constr.ConnectionString)) { SqlCommand cmd = new SqlCommand(qrstr, con); con.Open(); using (SqlDataReader reader = cmd.ExecuteReader()) { reader.Read(); try { user.Name = (string)reader[0]; } catch (Exception) { } try { user.Surname = (string)reader[1]; } catch (Exception) { } try { user.Username = (string)reader[2]; } catch (Exception) { } try { user.Birthday = (string)reader[3]; } catch (Exception) { } try { user.Email = (string)reader[4]; } catch (Exception) { } reader.Close(); } //------------------------------------Favorites------------------------------------------------------------------------ List <Models.rates> ratesf = new List <Models.rates>(); string qrFavStr = "SELECT RATES.RATE_ID AS rate_id,CURR1 AS curr1,CURR2 AS curr2,RATE AS rate FROM RATES INNER JOIN FAVORITES ON RATES.RATE_ID = FAVORITES.RATE_ID WHERE USER_ID = '" + Session["user_id"] + "'"; SqlCommand cmdFav = new SqlCommand(qrFavStr, con); using (SqlDataReader readerf = cmdFav.ExecuteReader(System.Data.CommandBehavior.SingleResult)) { while (readerf.Read()) { Models.rates ratef = new Models.rates(); ratef.RateId = (int)readerf["rate_id"]; ratef.Curr1 = (string)readerf["curr1"]; ratef.Curr2 = (string)readerf["curr2"]; ratef.Rate = (double)readerf["rate"]; ratesf.Add(ratef); } } ViewBag.fav = ratesf; } return(View("userdetails", user)); } return(RedirectToAction("../Home/Index")); }