public ActionResult UnosPodataka(WebAplikacijaMvc.Models.Dnevnica model)
{
//SqlConnection con = new SqlConnection("Server=tcp:pr4fbh2l9a.database.windows.net,1433;Database=webappsAFRofs7vo;User ID=username_id;Password=password;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;");
//SqlCommand cmd = new SqlCommand();
//cmd.Connection = con;
//cmd.CommandText = "INSERT Dnevnica VALUES ("
// + model.DnevnicaID + ", '"
// + model.KorisnikID + "', '"
// + model.Polaziste + "'), '"
// + model.Odrediste + "'), '"
// + model.VrijemePolaska + "'), '"
// + model.VrijemeDolaska + "');";
//con.Open();
//cmd.ExecuteNonQuery();
//con.Close();
//string SQLConectionString = "[YourConnectionString]";
//using (SqlConnection connection = new SqlConnection("Server=tcp:pr4fbh2l9a.database.windows.net,1433;Database=WebApplicationMvc11475;User ID=username_id;Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;"))
//{
// SqlCommand command = new SqlCommand();
// command.Connection = connection;
// command.CommandType = System.Data.CommandType.Text;
// command.CommandText = @"INSERT Table1 VALUES (543, 'Luka', 'Risek');";
//}
//String a = model.Ime;
return(View());
}
//ovaj princip funkcionira
public ActionResult UnosPodataka(WebAplikacijaMvc.Models.Dnevnica model)
{
//SqlConnection con = new SqlConnection("Server=tcp:pr4fbh2l9a.database.windows.net,1433;Database=Database;User ID=username_id;Password=password;Trusted_Connection=False;Encrypt=True;Connection Timeout=30;");
SqlConnection con = new SqlConnection(WebConfigurationManager.AppSettings["SqlDatabaseConnectionString"]);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
//cmd2.CommandText = "select KorisnikID from korisnik where Ime = '" + User.Identity.GetUserName() + "'";
//insert Korisnik values((select KorisnikID from korisnik where Ime = 'mrisek'), 'fg','fg', 1);
cmd.CommandText = "insert Dnevnica values((select KorisnikID from korisnik where KorisnickoIme = '"
+ User.Identity.GetUserName() + "'), '"
+ model.Odrediste + "', '"
+ model.Polaziste + "', '"
+ model.VrijemePolaska + "', '"
+ model.VrijemeDolaska + "');";
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//string SQLConectionString = "[YourConnectionString]";
//using (SqlConnection connection = new SqlConnection("Server=tcp:pr4fbh2l9a.database.windows.net,1433;Database=WebApplicationMvc11475;User ID=username_id;Password={your_password_here};Trusted_Connection=False;Encrypt=True;Connection Timeout=30;"))
//{
// SqlCommand command = new SqlCommand();
// command.Connection = connection;
// command.CommandType = System.Data.CommandType.Text;
// command.CommandText = @"INSERT Table1 VALUES (543, 'Luka', 'Risek');";
//}
//String a = model.Ime;
return(View());
}