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); }