public List <LookUp> GetRegions()
{
MySqlConnection con = new MySqlConnection(DbCon.connectionString);
MySqlCommand cmd;
MySqlDataReader dr = null;
string query = "SELECT lKey,lValue FROM region ORDER BY lkey ASC";
List <LookUp> lList = new List <LookUp>();
LookUp lo;
lo = new LookUp();
try
{
con.Open();
cmd = new MySqlCommand(query, con);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
lo = new LookUp();
lo.LKey = dr.GetInt32(0).ToString();
lo.LValue = dr.GetString(1);
lList.Add(lo);
}
}
}
catch (MySqlException ex)
{
// new AuditLogService().AddAuditLog("Lookup Error Regions", userId, new UserService().GetUserName(userId), ex.Message, DateTime.Now);
String errorString = ex.Message;
}
catch (Exception ex)
{
// new AuditLogService().AddAuditLog("Lookup Error Regions", userId, new UserService().GetUserName(userId), ex.Message, DateTime.Now);
String errorString = ex.Message;
}
finally
{
dr.Close();
con.Close();
}
return(lList);
}
public List <LookUp> GetAllPaymetype()
{
MySqlConnection con = new MySqlConnection(DbCon.connectionString);
MySqlCommand cmd;
MySqlDataReader dr = null;
string query = "SELECT `lKey`, `lValue` FROM `paymenttype`";
List <LookUp> lList = new List <LookUp>();
LookUp lo;
lo = new LookUp();
try
{
con.Open();
cmd = new MySqlCommand(query, con);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
lo = new LookUp();
lo.LKey = dr.GetString(1);
lo.LValue = dr.GetString(0);
lList.Add(lo);
}
}
}
catch (MySqlException ex)
{
//new AuditLogService().AddAuditLog("Lookup Error Title", userId, new UserService().GetUserName(userId), ex.Message, DateTime.Now);
//String errorString = ex.Message;
}
catch (Exception ex)
{
//new AuditLogService().AddAuditLog("Lookup Error Title", userId, new UserService().GetUserName(userId), ex.Message, DateTime.Now);
//String errorString = ex.Message;
}
finally
{
dr.Close();
con.Close();
}
return(lList);
}
public List <LookUp> GetAcademicLevels()
{
MySqlConnection con = new MySqlConnection(DbCon.connectionString);
MySqlCommand cmd;
MySqlDataReader dr = null;
string query = string.Format("SELECT lkey,lvalue FROM academiclevel ");
List <LookUp> lList = new List <LookUp>();
LookUp lo;
lo = new LookUp();
try
{
con.Open();
cmd = new MySqlCommand(query, con);
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
lo = new LookUp();
lo.LKey = dr.GetString(1);
lo.LValue = dr.GetString(1);
lList.Add(lo);
}
}
}
catch (MySqlException ex)
{
// new AuditLogService().AddAuditLog("Lookup Error employment status", userId, new UserService().GetUserName(userId), ex.Message, DateTime.Now);
String errorString = ex.Message;
}
catch (Exception ex)
{
// new AuditLogService().AddAuditLog("Lookup Error employment status", userId, new UserService().GetUserName(userId), ex.Message, DateTime.Now);
String errorString = ex.Message;
}
finally
{
dr.Close();
con.Close();
}
return(lList);
}
