public ActionResult Register(AkunPasien akunUSER) { connectionString(); conn.Open(); com.Connection = conn; com.CommandText = "Insert into akun_pasien (nama,nik,username,password,role) values ('" + akunUSER.nama + "','" + akunUSER.nik + "','" + akunUSER.username + "','" + akunUSER.password + "',5)"; dr = com.ExecuteReader(); if (dr.Read()) { conn.Close(); return(View("DaftarForm")); } else { conn.Close(); return(View("Login")); } }
public ActionResult Verify(AkunPasien akunUSER) { connectionString(); conn.Open(); com.Connection = conn; com.CommandText = "Select * from akun_pasien where username='******' and password='******' and role=5"; dr = com.ExecuteReader(); if (dr.Read()) { conn.Close(); return(View("Home")); } else { conn.Close(); return(View("Login")); } }