public ActionResult sendLoginCheck(mainLogin instance)
{
sqlcon.ConnectionString = "Data Source=DESKTOP-7U8UBCP\\SQLEXPRESS;Initial Catalog=DiaryDB;Integrated Security=True";
sqlcon.Open();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandText = "select * from admin_table where login_name='" + instance.User + "' and login_pass='******'";
sqldr = sqlcmd.ExecuteReader();
if (sqldr.Read())
{
sqlcon.Close();
return(View("Working"));
}
else
{
sqlcon.Close();
return(View("Invalid"));
}
}
public ActionResult sendLoginCheck(mainLogin instance)
{
sqlcon.ConnectionString = "Data Source=DESKTOP-HKD1BEO\\SQLEXPRESS;Initial Catalog=Interior;Integrated Security=True";
sqlcon.Open();
sqlcmd.Connection = sqlcon;
sqlcmd.CommandText = "select * from Login where UserId='" + instance.User + "' and Password='******'";
sqldr = sqlcmd.ExecuteReader();
if (sqldr.Read())
{
sqlcon.Close();
return(View("Working"));
}
else
{
sqlcon.Close();
return(View("Invalid"));
}
}