示例#1
0
 public ActionResult AddPatient()
 {
     var model = new DiseaseDetailModel()
     {
         Areas = GetAreas(),
         Disease = GetDisease()
     };
     return View(model);
 }
示例#2
0
        public ActionResult AddPatient(DiseaseDetailModel diseaseDetail)
        {
            try
            {
                if (ModelState.IsValid)
                {

                    diseaseDetail.DocId = Convert.ToInt32(Session["DocId"]);

                    diseaseDetail.PatientAddDate = DateTime.Now;
                    diseaseDetail.Save();
                    TempData["Success"] = "Patient added Successfully.";

                    ModelState.Clear();

                    // making form, emty after submission of form

                }
                else
                {
                    //empData["Error"] = "Please provide Required data.";
                }

                var model1 = new DiseaseDetailModel()
                {
                    Areas = GetAreas(),
                    Disease = GetDisease()
                };
                return View(model1);

            }
            catch (Exception ex)
            {

                throw ex;
            }
        }
示例#3
0
        /// <summary>
        /// Showing the complete record from the diseasedetails database
        /// </summary>
        /// <returns></returns>
        public List<DiseaseDetailModel> GetDiseaseDetailAll()
        {
            try
            {
                string Q_ShowAllDiseaseDetailAll = "select * from diseasedetails";

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailAll", "Assigning value to the variable");
                string cmdText = string.Format(Q_ShowAllDiseaseDetailAll);

                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<DiseaseDetailModel> diseaseDetailList = new List<DiseaseDetailModel>();

                    while (reader.Read())
                    {
                        DiseaseDetailModel diseaseDetail = new DiseaseDetailModel();

                        diseaseDetail.Id = Convert.ToInt32(reader["Id"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Id read from database");

                        diseaseDetail.DocId = Convert.ToInt32(reader["DocId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DocId read from database");

                        diseaseDetail.Age = Convert.ToInt32(reader["Age"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Age read from database");

                        diseaseDetail.Gender = ParameterFormater.UnescapeXML(reader["Gender"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Gender read from database");

                        diseaseDetail.AreaId = Convert.ToInt32(reader["AreaId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "AreaId read from database");

                        diseaseDetail.PatientAddDate = Convert.ToDateTime(reader["PatientAddDate"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Patient admit date read from database");

                        diseaseDetail.DiseaseId = Convert.ToInt32(reader["DiseaseId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DiseaseId read from database");

                        diseaseDetailList.Add(diseaseDetail);
                    }

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Checking reader has closed the connection.");
                    if (!reader.IsClosed)
                    {
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "closing database connection");
                        reader.Close();
                    }

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Object returning value");
                    return diseaseDetailList;
                }

                return null;

            }
            catch (Exception ex)
            {
                Logger.Error("DiseaseDetailModel", "GetDiseaseDetailById", "Error occured while Selecting data from disease detail for all", ex);
                throw ex;
            }
            finally
            {
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Closed sleeping connection");
                Database.KillConnections();
            }
        }
示例#4
0
        /// <summary>
        /// Showing record by ID from database DiseaseDetails
        /// </summary>
        /// <param name="diseaseDetailId"></param>
        /// <returns></returns>
        public DiseaseDetailModel GetDiseaseDetailById(int diseaseDetailId)
        {
            try
            {
                string Q_ShowDiseaseDetailById = "select * from diseasedetails where Id = {0}";

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "storing values in variable.");

                string cmdText = string.Format(Q_ShowDiseaseDetailById, diseaseDetailId);
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "storing values in variable after id check.");

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", " creating Database");
                Database db = new Database();
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Database created");

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Reading value  from Database by Id");

                DbDataReader reader = db.Select(cmdText);
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Reading value done");

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "checking database has rows!");
                if (reader.HasRows)
                {
                    DiseaseDetailModel diseaseDetail = new DiseaseDetailModel();
                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Diseasemaster object created");

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Reading database values");
                    while (reader.Read())
                    {
                        diseaseDetail.Id = Convert.ToInt32(reader["Id"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Id read from database");

                        diseaseDetail.DocId = Convert.ToInt32(reader["DocId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DocId read from database");

                        diseaseDetail.Age = Convert.ToInt32(reader["Age"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Age read from database");

                        diseaseDetail.Gender = ParameterFormater.UnescapeXML(reader["Gender"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Gender read from database");

                        diseaseDetail.AreaId = Convert.ToInt32(reader["AreaId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "AreaId read from database");

                        diseaseDetail.DiseaseId = Convert.ToInt32(reader["DiseaseId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DiseaseId read from database");

                        diseaseDetail.PatientAddDate = Convert.ToDateTime(reader["PatientAddDate"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Patient admit date read from database");
                     /*
                        diseaseDetail.PatientAddDate = ParameterFormater.UnescapeXML(reader["PatientAddDate"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "ShortAreaName read from database.");diseaseDetail.DocId = Convert.ToInt32(reader["DocId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DocId read from database");
                     */
                    }

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Checking reader has closed the connection.");
                    if (!reader.IsClosed)
                    {
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "closing database connection");
                        reader.Close();
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Connection closed");
                    }

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Object returning value");
                    return diseaseDetail;
                }

                return null;

            }
            catch (Exception ex)
            {
                Logger.Error("DiseaseDetailModel", "GetDiseaseDetailById", "Erro occured while Selecting data from disease master detail by id", ex);
                throw ex;
            }
            finally
            {
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Closed sleeping connection");
                Database.KillConnections();
            }
        }
示例#5
0
        /// <summary>
        /// Showing the complete record from the diseasedetails database
        /// </summary>
        /// <returns></returns>
        public List <DiseaseDetailModel> GetDiseaseDetailAll()
        {
            try
            {
                string Q_ShowAllDiseaseDetailAll = "select * from diseasedetails";

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailAll", "Assigning value to the variable");
                string cmdText = string.Format(Q_ShowAllDiseaseDetailAll);

                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 <DiseaseDetailModel> diseaseDetailList = new List <DiseaseDetailModel>();

                    while (reader.Read())
                    {
                        DiseaseDetailModel diseaseDetail = new DiseaseDetailModel();

                        diseaseDetail.Id = Convert.ToInt32(reader["Id"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Id read from database");

                        diseaseDetail.DocId = Convert.ToInt32(reader["DocId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DocId read from database");

                        diseaseDetail.Age = Convert.ToInt32(reader["Age"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Age read from database");

                        diseaseDetail.Gender = ParameterFormater.UnescapeXML(reader["Gender"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Gender read from database");

                        diseaseDetail.AreaId = Convert.ToInt32(reader["AreaId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "AreaId read from database");

                        diseaseDetail.PatientAddDate = Convert.ToDateTime(reader["PatientAddDate"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Patient admit date read from database");

                        diseaseDetail.DiseaseId = Convert.ToInt32(reader["DiseaseId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DiseaseId read from database");

                        diseaseDetailList.Add(diseaseDetail);
                    }

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Checking reader has closed the connection.");
                    if (!reader.IsClosed)
                    {
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "closing database connection");
                        reader.Close();
                    }

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Object returning value");
                    return(diseaseDetailList);
                }

                return(null);
            }
            catch (Exception ex)
            {
                Logger.Error("DiseaseDetailModel", "GetDiseaseDetailById", "Error occured while Selecting data from disease detail for all", ex);
                throw ex;
            }
            finally
            {
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Closed sleeping connection");
                Database.KillConnections();
            }
        }
示例#6
0
        /// <summary>
        /// Showing record by ID from database DiseaseDetails
        /// </summary>
        /// <param name="diseaseDetailId"></param>
        /// <returns></returns>

        public DiseaseDetailModel GetDiseaseDetailById(int diseaseDetailId)
        {
            try
            {
                string Q_ShowDiseaseDetailById = "select * from diseasedetails where Id = {0}";

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "storing values in variable.");

                string cmdText = string.Format(Q_ShowDiseaseDetailById, diseaseDetailId);
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "storing values in variable after id check.");

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", " creating Database");
                Database db = new Database();
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Database created");

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Reading value  from Database by Id");

                DbDataReader reader = db.Select(cmdText);
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Reading value done");

                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "checking database has rows!");
                if (reader.HasRows)
                {
                    DiseaseDetailModel diseaseDetail = new DiseaseDetailModel();
                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Diseasemaster object created");

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Reading database values");
                    while (reader.Read())
                    {
                        diseaseDetail.Id = Convert.ToInt32(reader["Id"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Id read from database");

                        diseaseDetail.DocId = Convert.ToInt32(reader["DocId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DocId read from database");

                        diseaseDetail.Age = Convert.ToInt32(reader["Age"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Age read from database");

                        diseaseDetail.Gender = ParameterFormater.UnescapeXML(reader["Gender"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Gender read from database");

                        diseaseDetail.AreaId = Convert.ToInt32(reader["AreaId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "AreaId read from database");


                        diseaseDetail.DiseaseId = Convert.ToInt32(reader["DiseaseId"]);
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DiseaseId read from database");


                        diseaseDetail.PatientAddDate = Convert.ToDateTime(reader["PatientAddDate"].ToString());
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Patient admit date read from database");

                        /*
                         * diseaseDetail.PatientAddDate = ParameterFormater.UnescapeXML(reader["PatientAddDate"].ToString());
                         * Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "ShortAreaName read from database.");diseaseDetail.DocId = Convert.ToInt32(reader["DocId"]);
                         * Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "DocId read from database");
                         */
                    }

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Checking reader has closed the connection.");
                    if (!reader.IsClosed)
                    {
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "closing database connection");
                        reader.Close();
                        Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Connection closed");
                    }

                    Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Object returning value");
                    return(diseaseDetail);
                }

                return(null);
            }
            catch (Exception ex)
            {
                Logger.Error("DiseaseDetailModel", "GetDiseaseDetailById", "Erro occured while Selecting data from disease master detail by id", ex);
                throw ex;
            }
            finally
            {
                Logger.Debug("DiseaseDetailModel", "GetDiseaseDetailById", "Closed sleeping connection");
                Database.KillConnections();
            }
        }