//StudentLogin jinan
public static StudentType StudentLogin(string email = "", string password = "", int tzOs = 0, string conStr = "")
{
StudentType student = null;
using (SqlConnection con = new SqlConnection(conStr))
{
SqlCommand cmd = new SqlCommand("sp_ManageUsers", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Mode", Value = "Login"
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Email", Value = email
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Password", Value = password
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@ObjEntityId", Value = 2
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@TimeZoneOffset", Value = tzOs
});
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
student = new StudentType(rdr);
}
}
con.Close();
}
return(student);
}
public static User Login(EntityType type, string email = "", string password = "", int tzOs = 0, string conStr = "")
{
User user = null;
switch (type)
{
case EntityType.Tutor:
user = TutorLogin(email, password, tzOs, conStr);
break;
case EntityType.Student:
user = StudentLogin(email, password, tzOs, conStr);
break;
case EntityType.Parent:
user = ParentLogin(email, password, tzOs, conStr);
break;
case EntityType.School:
user = SchoolLogin(email, password, tzOs, conStr);
break;
}
using (SqlConnection con = new SqlConnection(conStr))
{
SqlCommand cmd = new SqlCommand("sp_ManageUsers", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Mode", Value = "CheckLogin"
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Email", Value = email
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@Password", Value = password
});
cmd.Parameters.Add(new SqlParameter()
{
ParameterName = "@TimeZoneOffset", Value = tzOs
});
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
//jinan
rdr.Read();
if (rdr["EntityType"] != DBNull.Value)
{
byte entityType = Convert.ToByte(rdr["EntityType"]);
type = (EntityType)entityType;
switch (type)
{
case EntityType.Tutor:
user = new TutorType(rdr);
break;
case EntityType.Student:
user = new StudentType(rdr);
break;
case EntityType.Parent:
//user = ParentLogin(email, password, conStr);
break;
case EntityType.School:
//user = SchoolLogin(email, password, conStr);
break;
}
}
}
}
return(user);
}
