public int GetIDByUserName(string name, string role)
{
using (var cn = DbConnSingleton.getDbInstance().GetDBConnection())
{
var searchString = "";
if (role.Equals(UserTypes.Student.ToString().ToLower()))
{
searchString = "Select s.id from Student s join credentials cr on s.email = cr.email AND cr.username = @u";
}
else
if (role.Equals(UserTypes.Company_Rep.ToString().ToLower()))
{
searchString = "Select c.company_id from company_rep c join credentials cr on c.email = cr.email AND cr.username = @u";
}
var cmd = new MySqlCommand(searchString, cn);
cmd.Parameters
.Add(new MySqlParameter("@u", MySqlDbType.String))
.Value = name;
string reader = cmd.ExecuteScalar().ToString();
if (!reader.Equals(null))
{
cmd.Dispose();
return(Convert.ToInt32(reader.ToString()));
}
else
{
cmd.Dispose();
return(0);
}
}
}
public static DbConnSingleton getDbInstance()
{
if (dbInstance == null)
{
dbInstance = new DbConnSingleton();
}
return(dbInstance);
}
