public ActionResult Index(Gospodarstvo add) { DatabaseController dbCtrl = new DatabaseController(); dbCtrl.getConnection(); //AddGospodarstva obj = new AddGospodarstva(); string s1 = "Insert into [dbo].[gospodarstva] (ime,prezime,kontakt,email,lozinka) values (@Ime,@Prezime,@Kontakt,@Email,@Lozinka)"; SqlCommand sqlcomm = new SqlCommand(s1); sqlcomm.Parameters.AddWithValue("@Ime", add.Ime); sqlcomm.Parameters.AddWithValue("@Prezime", add.Prezime); sqlcomm.Parameters.AddWithValue("@Kontakt", add.Kontakt); sqlcomm.Parameters.AddWithValue("@Email", add.Email); sqlcomm.Parameters.AddWithValue("@Lozinka", add.Lozinka); dbCtrl.executeCommand(sqlcomm); return(View(add)); }
public ActionResult Register(Gospodarstvo add) { DatabaseController dbCtrl = new DatabaseController(); dbCtrl.getConnection(); string s1 = "Insert into [dbo].[gospodarstva] (ime,prezime,kontakt,email,lozinka) values (@Ime,@Prezime,@Kontakt,@Email,@Lozinka)"; string s2 = "Select * from [dbo].[gospodarstva] where email=@Email"; SqlCommand sql = new SqlCommand(s2); sql.Parameters.AddWithValue("@Email", add.Email); SqlDataReader sdr = dbCtrl.executeSdr(sql); if (sdr.Read()) { ViewBag.Message = "Taj email je vec zauzet"; return(View()); } else { sdr.Close(); SqlCommand sqlcomm = new SqlCommand(s1); sqlcomm.Parameters.AddWithValue("@Ime", add.Ime); sqlcomm.Parameters.AddWithValue("@Prezime", add.Prezime); sqlcomm.Parameters.AddWithValue("@Kontakt", add.Kontakt); sqlcomm.Parameters.AddWithValue("@Email", add.Email); sqlcomm.Parameters.AddWithValue("@Lozinka", add.Lozinka); dbCtrl.executeCommand(sqlcomm); ViewBag.Message = "Uspješno ste se registrirali. Možete se prijaviti."; /*if(!ModelState.IsValid) * { * return View(add); * }*/ return(View("Index")); } }
public ActionResult Index(Gospodarstvo login) { DatabaseController dbCtrl = new DatabaseController(); dbCtrl.getConnection(); string s1 = "Select email,lozinka from [dbo].[gospodarstva] where email=@Email and lozinka=@Lozinka "; SqlCommand sqlcomm = new SqlCommand(s1); sqlcomm.Parameters.AddWithValue("@Email", login.Email); sqlcomm.Parameters.AddWithValue("@Lozinka", login.Lozinka); SqlDataReader sdr = dbCtrl.executeSdr(sqlcomm); if (sdr.Read()) { Session["id"] = login.Id.ToString(); return(RedirectToAction("Welcome")); } else { ViewData["Message"] = "Unijeli ste pogrešne podatke."; } return(View()); }