public ActionResult Login(string userName, string password) { try { if (!string.IsNullOrEmpty(userName) && !string.IsNullOrEmpty(password)) { DoctorDetailsModel dbm = new DoctorDetailsModel().UserAuthentication(userName, password); if (dbm != null) { Session["DocName"] = dbm.UserName; Session["DocId"] = dbm.Id; return RedirectToAction("AddPatient", "Disease"); } else { TempData["Error"] = "Invalid Username or Password."; } } else { TempData["Error"] = "Please enter Username or Password."; } } catch (Exception ex) { throw ex; } return View(); }
public DoctorDetailsModel GetDoctorDetailByUserName(string userName) { try { string Q_ShowDoctorDetailByUserName = "******"; Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "storing values in variable."); string cmdText = string.Format(Q_ShowDoctorDetailByUserName, userName); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "storing values in variable after id check."); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", " creating Database"); Database db = new Database(); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Database created"); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Reading value from Database by Id"); DbDataReader reader = db.Select(cmdText); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Reading value done"); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "checking database has rows!"); if (reader.HasRows) { DoctorDetailsModel doctorDetails = new DoctorDetailsModel(); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "DoctorDetail object created"); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Reading database values"); while (reader.Read()) { doctorDetails.Id = Convert.ToInt32(reader["Id"]); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Id read from database"); doctorDetails.DoctorName = ParameterFormater.UnescapeXML(reader["DoctorName"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Doctor Name read from database"); doctorDetails.Department = ParameterFormater.UnescapeXML(reader["Department"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Department read from database"); doctorDetails.MobileNumber = Convert.ToInt64(reader["MobileNumber"]); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Mobile Number read from database"); doctorDetails.Address = ParameterFormater.UnescapeXML(reader["Address"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Address read from database"); doctorDetails.AreaId = Convert.ToInt32(reader["AreaId"]); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "AreaId read from database"); doctorDetails.UserName = ParameterFormater.UnescapeXML(reader["Username"].ToString()); doctorDetails.Password = ParameterFormater.UnescapeXML(reader["Password"].ToString()); doctorDetails.CreateDate = Convert.ToDateTime(reader["CreatedDate"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Create 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("DoctorDetailsModel", "GetDiseaseDetailById", "Checking reader has closed the connection."); if (!reader.IsClosed) { Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailById", "closing database connection"); reader.Close(); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailById", "Connection closed"); } Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailById", "Object returning value"); return(doctorDetails); } return(null); } catch (Exception ex) { Logger.Error("DoctorDetailsModel", "GetDiseaseDetailById", "Erro occured while Selecting data from disease master detail by id", ex); throw ex; } finally { Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailById", "Closed sleeping connection"); Database.KillConnections(); } }
/// <summary> /// Showing the complete record from the diseasedetails database /// </summary> /// <returns></returns> public List <DoctorDetailsModel> GetDoctorDetailAll() { try { string Q_ShowAllDoctorDetail = "select * from doctordetails"; Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Assigning value to the variable"); string cmdText = string.Format(Q_ShowAllDoctorDetail); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Creating database"); Database db = new Database(); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Database created"); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "reading data from database"); DbDataReader reader = db.Select(cmdText); if (reader.HasRows) { List <DoctorDetailsModel> diseaseDetailList = new List <DoctorDetailsModel>(); while (reader.Read()) { DoctorDetailsModel doctorDetail = new DoctorDetailsModel(); doctorDetail.Id = Convert.ToInt32(reader["Id"]); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Id read from database"); doctorDetail.DoctorName = ParameterFormater.UnescapeXML(reader["DoctorName"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Gender read from database"); doctorDetail.Department = ParameterFormater.UnescapeXML(reader["Department"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "DoctorName read from database"); doctorDetail.MobileNumber = Convert.ToInt64(reader["MobileNumber"]); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "MobileNumber read from database"); doctorDetail.Address = ParameterFormater.UnescapeXML(reader["Address"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Address read from database"); doctorDetail.AreaId = Convert.ToInt32(reader["AreaId"]); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "AreaId read from database"); doctorDetail.UserName = ParameterFormater.UnescapeXML(reader["Username"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Username read from database"); doctorDetail.Password = ParameterFormater.UnescapeXML(reader["Password"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Password read from database"); doctorDetail.CreateDate = Convert.ToDateTime(reader["CreatedDate"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Patient admit date read from database"); diseaseDetailList.Add(doctorDetail); } Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Checking reader has closed the connection."); if (!reader.IsClosed) { Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "closing database connection"); reader.Close(); } Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Object returning value"); return(diseaseDetailList); } return(null); } catch (Exception ex) { Logger.Error("DoctorDetailsModel", "GetDiseaseDetailAll", "Error occured while Selecting data from disease detail for all", ex); throw ex; } finally { Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Closed sleeping connection"); Database.KillConnections(); } }
public ActionResult Registration() { var model = new DoctorDetailsModel() { Areas = GetAreas() }; return View(model); }
public ActionResult Registration(DoctorDetailsModel doctorDetailsModel) { try { if (ModelState.IsValid) { DoctorDetailsModel dbm = new DoctorDetailsModel().GetDoctorDetailByUserName(doctorDetailsModel.UserName); if (dbm == null) { doctorDetailsModel.CreateDate = DateTime.Now; doctorDetailsModel.Save(); TempData["Success"] = "You have successfully registered"; ModelState.Clear(); //making form empty after submission of the data. var model1 = new DoctorDetailsModel() { Areas = GetAreas() }; return View(model1); } else { TempData["Error"] = "User Name already exist. Please choose another User name."; } } } catch (Exception ex) { throw ex; } var model = new DoctorDetailsModel() { Areas = GetAreas() }; return View(model); }
/// <summary> /// Showing the complete record from the diseasedetails database /// </summary> /// <returns></returns> public List<DoctorDetailsModel> GetDoctorDetailAll() { try { string Q_ShowAllDoctorDetail = "select * from doctordetails"; Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Assigning value to the variable"); string cmdText = string.Format(Q_ShowAllDoctorDetail); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Creating database"); Database db = new Database(); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Database created"); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "reading data from database"); DbDataReader reader = db.Select(cmdText); if (reader.HasRows) { List<DoctorDetailsModel> diseaseDetailList = new List<DoctorDetailsModel>(); while (reader.Read()) { DoctorDetailsModel doctorDetail = new DoctorDetailsModel(); doctorDetail.Id = Convert.ToInt32(reader["Id"]); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Id read from database"); doctorDetail.DoctorName = ParameterFormater.UnescapeXML(reader["DoctorName"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Gender read from database"); doctorDetail.Department = ParameterFormater.UnescapeXML(reader["Department"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "DoctorName read from database"); doctorDetail.MobileNumber = Convert.ToInt64(reader["MobileNumber"]); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "MobileNumber read from database"); doctorDetail.Address = ParameterFormater.UnescapeXML(reader["Address"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Address read from database"); doctorDetail.AreaId = Convert.ToInt32(reader["AreaId"]); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "AreaId read from database"); doctorDetail.UserName = ParameterFormater.UnescapeXML(reader["Username"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Username read from database"); doctorDetail.Password = ParameterFormater.UnescapeXML(reader["Password"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Password read from database"); doctorDetail.CreateDate = Convert.ToDateTime(reader["CreatedDate"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Patient admit date read from database"); diseaseDetailList.Add(doctorDetail); } Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Checking reader has closed the connection."); if (!reader.IsClosed) { Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "closing database connection"); reader.Close(); } Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Object returning value"); return diseaseDetailList; } return null; } catch (Exception ex) { Logger.Error("DoctorDetailsModel", "GetDiseaseDetailAll", "Error occured while Selecting data from disease detail for all", ex); throw ex; } finally { Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailAll", "Closed sleeping connection"); Database.KillConnections(); } }
public DoctorDetailsModel UserAuthentication(string userName, string password) { try { string Q_CheckUserName = "******"; Logger.Debug("DoctorDetailsModel", "UserAuthentication", "storing values in variable."); string cmdText = string.Format(Q_CheckUserName, ParameterFormater.FormatParameter(userName), ParameterFormater.FormatParameter(password)); Database db = new Database(); DbDataReader reader = db.Select(cmdText); if (reader.HasRows) { DoctorDetailsModel doctorDetails = new DoctorDetailsModel(); while (reader.Read()) { doctorDetails.Id = Convert.ToInt32(reader["Id"]); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Id read from database"); doctorDetails.DoctorName = ParameterFormater.UnescapeXML(reader["DoctorName"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Doctor Name read from database"); doctorDetails.Department = ParameterFormater.UnescapeXML(reader["Department"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Department read from database"); doctorDetails.MobileNumber = Convert.ToInt64(reader["MobileNumber"]); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Mobile Number read from database"); doctorDetails.Address = ParameterFormater.UnescapeXML(reader["Address"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Address read from database"); doctorDetails.AreaId = Convert.ToInt32(reader["AreaId"]); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "AreaId read from database"); doctorDetails.UserName = ParameterFormater.UnescapeXML(reader["Username"].ToString()); doctorDetails.Password = ParameterFormater.UnescapeXML(reader["Password"].ToString()); doctorDetails.CreateDate = Convert.ToDateTime(reader["CreatedDate"].ToString()); Logger.Debug("DoctorDetailsModel", "GetDoctorDetailById", "Create 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("DoctorDetailsModel", "GetDiseaseDetailById", "Checking reader has closed the connection."); if (!reader.IsClosed) { Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailById", "closing database connection"); reader.Close(); Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailById", "Connection closed"); } Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailById", "Object returning value"); return doctorDetails; } return null; } catch (Exception ex) { Logger.Error("DoctorDetailsModel", "GetDiseaseDetailById", "Erro occured while Selecting data from disease master detail by id", ex); throw ex; } finally { Logger.Debug("DoctorDetailsModel", "GetDiseaseDetailById", "Closed sleeping connection"); Database.KillConnections(); } }