public IEnumerable<SelectListItem> GetDisease() { var diseaseModel = new DiseaseMasterModel(); var disease = diseaseModel.GetDiseaseMasterAll().Select(x => new SelectListItem { Value = x.Id.ToString(), Text = x.DiseaseName }); return new SelectList(disease, "Value", "Text"); }
/// <summary> /// Showing complete record from database /// </summary> /// <returns></returns> public List <DiseaseMasterModel> GetDiseaseMasterAll() { try { string Q_ShowAllDiseaseMasterDetail = "select * from diseasemaster"; Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Assigning value to the variable"); string cmdText = string.Format(Q_ShowAllDiseaseMasterDetail); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Creating database"); Database db = new Database(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Database created"); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "reading data from database"); DbDataReader reader = db.Select(cmdText); if (reader.HasRows) { List <DiseaseMasterModel> diseaseMasterList = new List <DiseaseMasterModel>(); while (reader.Read()) { DiseaseMasterModel diseaseMas = new DiseaseMasterModel(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Id read from database"); diseaseMas.Id = Convert.ToInt32(reader["Id"]); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "DiseaseName read from database."); diseaseMas.DiseaseName = ParameterFormater.UnescapeXML(reader["DiseaseName"].ToString()); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "ShortAreaName read from database."); diseaseMas.ShortDiseaseName = ParameterFormater.UnescapeXML(reader["DiseaseShortName"].ToString()); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Adding object to list"); diseaseMasterList.Add(diseaseMas); } Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Checking reader has closed the connection."); if (!reader.IsClosed) { Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "closing database connection"); reader.Close(); } Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Object returning value"); return(diseaseMasterList); } return(null); } catch (Exception ex) { Logger.Error("DiseaseMasterModel", "GetDiseaseMasterAll", "Erro occured while Selecting data from disease master detail for all", ex); throw ex; } finally { Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Closed sleeping connection"); Database.KillConnections(); } }
/// <summary> /// Showing complete record from database /// </summary> /// <returns></returns> public List<DiseaseMasterModel> GetDiseaseMasterAll() { try { string Q_ShowAllDiseaseMasterDetail = "select * from diseasemaster"; Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Assigning value to the variable"); string cmdText = string.Format(Q_ShowAllDiseaseMasterDetail); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Creating database"); Database db = new Database(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Database created"); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "reading data from database"); DbDataReader reader = db.Select(cmdText); if (reader.HasRows) { List<DiseaseMasterModel> diseaseMasterList = new List<DiseaseMasterModel>(); while (reader.Read()) { DiseaseMasterModel diseaseMas = new DiseaseMasterModel(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Id read from database"); diseaseMas.Id = Convert.ToInt32(reader["Id"]); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "DiseaseName read from database."); diseaseMas.DiseaseName = ParameterFormater.UnescapeXML(reader["DiseaseName"].ToString()); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "ShortAreaName read from database."); diseaseMas.ShortDiseaseName = ParameterFormater.UnescapeXML(reader["DiseaseShortName"].ToString()); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Adding object to list"); diseaseMasterList.Add(diseaseMas); } Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Checking reader has closed the connection."); if (!reader.IsClosed) { Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "closing database connection"); reader.Close(); } Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Object returning value"); return diseaseMasterList; } return null; } catch (Exception ex) { Logger.Error("DiseaseMasterModel", "GetDiseaseMasterAll", "Erro occured while Selecting data from disease master detail for all", ex); throw ex; } finally { Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterAll", "Closed sleeping connection"); Database.KillConnections(); } }
/// <summary> /// Showing the record from database by id /// </summary> /// <param name="diseaseMasterId"></param> /// <returns></returns> public DiseaseMasterModel GetDiseaseMasterById(int diseaseMasterId) { try { string Q_ShowDiseaseMasterDetail = "select * from diseasemaster where Id = {0}"; Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "storing values in variable."); string cmdText = string.Format(Q_ShowDiseaseMasterDetail, diseaseMasterId); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "storing values in variable after id check."); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", " creating Database"); Database db = new Database(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Database created"); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Reading value from Database by Id"); DbDataReader reader = db.Select(cmdText); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Reading value done"); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "checking database has rows!"); if (reader.HasRows) { DiseaseMasterModel diseaseMaster = new DiseaseMasterModel(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Diseasemaster object created"); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Reading database values"); while (reader.Read()) { diseaseMaster.Id = Convert.ToInt32(reader["Id"]); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Id read from database"); diseaseMaster.DiseaseName = ParameterFormater.UnescapeXML(reader["DiseaseName"].ToString()); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Areaname read from database"); diseaseMaster.ShortDiseaseName = ParameterFormater.UnescapeXML(reader["ShortDiseaseName"].ToString()); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "ShortAreaName read from database."); } Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Checking reader has closed the connection."); if (!reader.IsClosed) { Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "closing database connection"); reader.Close(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Connection closed"); } Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Object returning value"); return(diseaseMaster); } return(null); } catch (Exception ex) { Logger.Error("DiseaseMasterModel", "GetDiseaseMasterById", "Erro occured while Selecting data from disease master detail by id", ex); throw ex; } finally { Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Closed sleeping connection"); Database.KillConnections(); } }
/// <summary> /// Showing the record from database by id /// </summary> /// <param name="diseaseMasterId"></param> /// <returns></returns> public DiseaseMasterModel GetDiseaseMasterById(int diseaseMasterId) { try { string Q_ShowDiseaseMasterDetail = "select * from diseasemaster where Id = {0}"; Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "storing values in variable."); string cmdText = string.Format(Q_ShowDiseaseMasterDetail, diseaseMasterId); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "storing values in variable after id check."); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", " creating Database"); Database db = new Database(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Database created"); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Reading value from Database by Id"); DbDataReader reader = db.Select(cmdText); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Reading value done"); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "checking database has rows!"); if (reader.HasRows) { DiseaseMasterModel diseaseMaster = new DiseaseMasterModel(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Diseasemaster object created"); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Reading database values"); while (reader.Read()) { diseaseMaster.Id = Convert.ToInt32(reader["Id"]); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Id read from database"); diseaseMaster.DiseaseName = ParameterFormater.UnescapeXML(reader["DiseaseName"].ToString()); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Areaname read from database"); diseaseMaster.ShortDiseaseName = ParameterFormater.UnescapeXML(reader["ShortDiseaseName"].ToString()); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "ShortAreaName read from database."); } Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Checking reader has closed the connection."); if (!reader.IsClosed) { Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "closing database connection"); reader.Close(); Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Connection closed"); } Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Object returning value"); return diseaseMaster; } return null; } catch (Exception ex) { Logger.Error("DiseaseMasterModel", "GetDiseaseMasterById", "Erro occured while Selecting data from disease master detail by id", ex); throw ex; } finally { Logger.Debug("DiseaseMasterModel", "GetDiseaseMasterById", "Closed sleeping connection"); Database.KillConnections(); } }