Hi
In below code while dr.read i have given wrong value docentr . Error message should get displayed and quit the application.
docentry = (rdr["docentr"]).ToString();
Function is being called from here
if (!Page.IsPostBack)
{
if (Common.CommonFunction.AuthenticatedUser().Item1) // Check if the user is authenticated
{
hdfLoginId.Value = Common.CommonFunction.GetUserInfo().Item1;
var userId = Common.CommonFunction.GetUserInfo().Item2;
var userRole = Common.CommonFunction.GetUserInfo().Item3;
GetData();
}
}
public static Tuple<String,String, String, Boolean> GetUserInfo()
{
try
{
//1 - Docentry
//2 - User ID
//3 - User Role
//4 - User Active
using (SqlConnection con = new SqlConnection(Common.CommonFunction.cnn_Live))
{
SqlCommand cmd = new SqlCommand("select userid from users where userid = '" + (AuthenticatedUser().Item3) + "'", con);
cmd.CommandType = CommandType.Text;
con.Open();
string userid = "";
object result = cmd.ExecuteScalar();
if (result != null)
{
userid = result.ToString();
SqlCommand cmd0 = new SqlCommand("select top 1 * from users where userid = '" + userid + "'", con);
cmd0.CommandType = CommandType.Text;
string docentry = "";
string userrole = "";
string status = "";
SqlDataReader rdr = cmd0.ExecuteReader();
while (rdr.Read())
{
docentry = (rdr["docentr"]).ToString();
userrole = rdr["UserRole"].ToString();
status = rdr["Status"].ToString();
}
return Tuple.Create(docentry,userid, userrole, Convert.ToBoolean(status));
}
else
{
return Tuple.Create(string.Empty,string.Empty, "User", false);
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
return Tuple.Create(string.Empty, string.Empty, string.Empty, false);
}
}
Thanks