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