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