public static string addNewUser(StudentsLogin SL)
{
int rt = 0;
SqlParameter[] param =
{
new SqlParameter("@encusersname", Encryption.Encrypt(SL.Encusersname.Trim(), Encryption.key)),
new SqlParameter("@encpassword", Encryption.Encrypt(SL.encpassword, Encryption.key)),
new SqlParameter("@usertype", SL.usertype),
new SqlParameter("@studentname", SL.studentname),
new SqlParameter("@FatherName", SL.FatherName),
new SqlParameter("@PhoneNo", SL.PhoneNo),
new SqlParameter("@Address", SL.Address),
new SqlParameter("@photopath", SL.photopath),
new SqlParameter("@fatherphoneno", SL.fatherphoneno),
new SqlParameter("@olstdfk", SL.olstdfk),
new SqlParameter("@studentid", SL.studentid),
new SqlParameter("@classid", SL.classid),
new SqlParameter("@sectionid", SL.sectionid),
new SqlParameter("@Session", SL.Session),
new SqlParameter("@StudentNo", SL.StudentNo),
new SqlParameter("@isbloked", SL.isbloked),
};
if (LoginBLL.checkUserAlreadyExists(SL.Encusersname) == 0)
{
string sql = "insert into StudentsLogin (encusersname,encpassword,usertype,studentname,FatherName,PhoneNo,Address,photopath,fatherphoneno,olstdfk,studentid,classid,sectionid,Session,StudentNo,isbloked) values (@encusersname,@encpassword,@usertype,@studentname,@FatherName,@PhoneNo,@Address,@photopath,@fatherphoneno,@olstdfk,@studentid,@classid,@sectionid,@Session,@StudentNo,@isbloked)";
if (GeneralBLL.SqlHelperConnection == 1)
{
rt = SqlHelper.ExecuteNonQuery(SqlHelper.Connect, CommandType.Text, sql, param);
}
else
{
rt = SqlHelper.ExecuteNonQuery(SqlHelper.Connect2, CommandType.Text, sql, param);
}
}
return(rt.ToString());
}
public static StudentsLogin userDetail(string UserID)
{
StudentsLogin UserLog = new StudentsLogin();
SqlParameter[] param =
{
new SqlParameter("@UserID", UserID),
};
DataSet ds = new DataSet();
if (GeneralBLL.SqlHelperConnection == 1)
{
ds = SqlHelper.ExecuteDataset(SqlHelper.Connect, CommandType.Text, "select * from studentslogin where OLSLOGINID=@UserID ", param);
}
else
{
ds = SqlHelper.ExecuteDataset(SqlHelper.Connect2, CommandType.Text, "select * from studentslogin where OLSLOGINID=@UserID ", param);
}
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
UserLog.OLSLOGINID = dr["OLSLOGINID"].ToString();
UserLog.Encusersname = Encryption.Decrypt(dr["Encusersname"].ToString(), Encryption.key);
UserLog.encpassword = Encryption.Decrypt(dr["encpassword"].ToString(), Encryption.key);
UserLog.studentid = dr["studentid"].ToString();
UserLog.studentname = dr["studentname"].ToString();
UserLog.StudentNo = dr["StudentNo"].ToString();
UserLog.FatherName = dr["FatherName"].ToString();
UserLog.fatherphoneno = dr["fatherphoneno"].ToString();
UserLog.classid = dr["classid"].ToString();
UserLog.sectionid = dr["sectionid"].ToString();
UserLog.Session = dr["Session"].ToString();
UserLog.PhoneNo = dr["PhoneNo"].ToString();
UserLog.photopath = dr["photopath"].ToString();
UserLog.usertype = dr["usertype"].ToString();
UserLog.isbloked = dr["isbloked"].ToString();
UserLog.IsOn = dr["IsOn"].ToString();
}
else
{
UserLog.OLSLOGINID = "0";
UserLog.Encusersname = "0";
UserLog.encpassword = "******";
UserLog.studentid = "0";
UserLog.studentname = "0";
UserLog.StudentNo = "0";
UserLog.FatherName = "0";
UserLog.fatherphoneno = "0";
UserLog.classid = "0";
UserLog.sectionid = "0";
UserLog.Session = "0";
UserLog.PhoneNo = "0";
UserLog.photopath = "0";
UserLog.usertype = "0";
UserLog.isbloked = "0";
UserLog.IsOn = "0";
}
return(UserLog);
}
public static string userLoginCheck(string UN, string PW)
{
StudentsLogin UserLog = new StudentsLogin();
string returnUrl = "none";
//HttpContext.Current.Session["Login"] = "******"; // for Admin
//returnUrl = "admin.aspx";
SqlParameter[] param =
{
new SqlParameter("@encusersname", Encryption.Encrypt(UN, Encryption.key)),
new SqlParameter("@encpassword", Encryption.Encrypt(PW, Encryption.key)),
};
DataSet ds = new DataSet();
if (GeneralBLL.SqlHelperConnection == 1)
{
ds = SqlHelper.ExecuteDataset(SqlHelper.Connect, CommandType.Text, "select * from studentslogin where encusersname=@encusersname and encpassword=@encpassword", param);
}
else
{
ds = SqlHelper.ExecuteDataset(SqlHelper.Connect2, CommandType.Text, "select * from studentslogin where encusersname=@encusersname and encpassword=@encpassword", param);
}
if (ds.Tables[0].Rows.Count > 0)
{
DataRow dr = ds.Tables[0].Rows[0];
UserLog.OLSLOGINID = dr["OLSLOGINID"].ToString();
UserLog.Encusersname = Encryption.Decrypt(dr["Encusersname"].ToString(), Encryption.key);
UserLog.encpassword = Encryption.Decrypt(dr["encpassword"].ToString(), Encryption.key);
UserLog.studentid = dr["studentid"].ToString();
UserLog.studentname = dr["studentname"].ToString();
//UserLog.StudentNo = dr["StudentNo"].ToString();
// UserLog.FatherName = dr["FatherName"].ToString();
UserLog.fatherphoneno = dr["fatherphoneno"].ToString();
UserLog.classid = dr["classid"].ToString();
UserLog.sectionid = dr["sectionid"].ToString();
UserLog.Session = dr["Session"].ToString();
// UserLog.PhoneNo = dr["PhoneNo"].ToString();
UserLog.photopath = dr["photopath"].ToString();
UserLog.usertype = dr["usertype"].ToString();
UserLog.isbloked = dr["isbloked"].ToString();
// UserLog.IsOn = dr["IsOn"].ToString();
int type = Convert.ToInt32(dr["usertype"].ToString());
HttpContext.Current.Session["StudentID"] = dr["studentid"].ToString();
HttpContext.Current.Session["CID"] = dr["classid"].ToString();
HttpContext.Current.Session["UN"] = Encryption.Decrypt(dr["Encusersname"].ToString(), Encryption.key);
HttpContext.Current.Session["UserID"] = dr["OLSLOGINID"].ToString();
if (type.Equals(0))
{
HttpContext.Current.Session["Login"] = "******"; // for student
returnUrl = "Exam.aspx";
}
else if (type.Equals(1))
{
HttpContext.Current.Session["Login"] = "******"; // for Admin
returnUrl = "Admin.aspx";
}
else if (type.Equals(2))
{
HttpContext.Current.Session["Login"] = "******"; // for Teacher
returnUrl = "teacher.aspx";
}
}
//else
//{
// UserLog.OLSLOGINID = "0";
// UserLog.Encusersname = "0";
// UserLog.encpassword = "******";
// UserLog.studentid = "0";
// UserLog.studentname = "0";
// UserLog.StudentNo = "0";
// UserLog.FatherName = "0";
// UserLog.fatherphoneno = "0";
// UserLog.classid = "0";
// UserLog.sectionid = "0";
// UserLog.Session = "0";
// UserLog.PhoneNo = "0";
// UserLog.photopath = "0";
// UserLog.usertype = "0";
// UserLog.isbloked = "0";
// UserLog.IsOn = "0";
//}
return(returnUrl);
}
