public DoctorDashboard ViewDoctorDashboardData(DoctorDashboard doctordashboard) { DoctorDashboadData dashboarddata = new DoctorDashboadData(); DataSet dataSet = new DataSet(); DoctorDashboard locald = new DoctorDashboard(); locald.UserID = ApplicationManager.LoggedInUser.UserID; try { dataSet = dashboarddata.ViewDoctorDashboardData(locald); if (dataSet.Tables["DoctorDashboard"].Rows.Count > 0) { locald.ApprovedApplication = dataSet.Tables["DoctorDashboard"].Rows[0]["APPROVED"].ToString(); locald.RejectedApplication = dataSet.Tables["DoctorDashboard"].Rows[0]["REJECTED"].ToString(); locald.PendingApplicaion = dataSet.Tables["DoctorDashboard"].Rows[0]["PENDING"].ToString(); locald.NAApplication = dataSet.Tables["DoctorDashboard"].Rows[0]["NA"].ToString(); } } catch (SqlException sqlEx) { locald.responseDetail.responseType = ResponseType.Error; locald.responseDetail.ResponseMessage = sqlEx.Message; } catch (Exception ex) { locald.responseDetail.responseType = ResponseType.Error; locald.responseDetail.ResponseMessage = ApplicationManager.GenericErrorMessage; LoggerHelper.WriteToLog(ex); } return(locald == null ? new DoctorDashboard() : locald); }
public DataSet ViewDoctorDashboardData(DoctorDashboard doctordashboad) { DataSet dataSet = new DataSet(); try { string storedProcedure = "pSRGg_DoctorDashboad"; string parameterName = "@aXMLString"; string parameterValue = ObjectHelper.GetXMLFromObject(doctordashboad); sqlCommand = new SqlCommand(storedProcedure, sqlConnection); sqlCommand.Parameters.AddWithValue(parameterName, parameterValue); sqlCommand.CommandType = CommandType.StoredProcedure; sqlConnection.Open(); sqlDataAdapter.SelectCommand = sqlCommand; sqlDataAdapter.Fill(dataSet); dataSet.Tables[0].TableName = "DoctorDashboard"; } catch (Exception) { throw; } finally { sqlConnection.Close(); } return(dataSet); }
public ActionResult DoctorDashboard() { DoctorDashboadService dashboardService = new DoctorDashboadService(); DoctorDashboard doctordashboard = new DoctorDashboard(); doctordashboard = dashboardService.ViewDoctorDashboardData(new DoctorDashboard()); return(View("DoctorDashboard", doctordashboard)); }
public List <DoctorDashboardClass> Overallnewexist(string Fromdate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.Overallnewexist(Fromdate)); }
public List <DoctorDashboardClass> Patientwaitinginterval(string Fromdate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.Patientwaitinginterval(Fromdate)); }
public List <DoctorDashboardClass> Referedtowhom(string Fromdate, string Todate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.Referedtowhom(Fromdate, Todate)); }
public List <DoctorDashboardClass> Agegroupforpatients(string Fromdate, string Todate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.Agegroupforpatients(Fromdate, Todate)); }
public List <DoctorDashboardClass> PatientCategory(string Fromdate, string Todate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.PatientCategory(Fromdate, Todate)); }
public List <DoctorDashboardClass> Gender(string Fromdate, string Todate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.Gender(Fromdate, Todate)); }
public List <DoctorDashboardClass> Sharesinlab(string Fromdate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.Sharesinlab(Fromdate)); }
public List <DoctorDashboardClass> Doctorsharepharmacy(string Fromdate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.Doctorsharepharmacy(Fromdate)); }
public List <DoctorDashboardClass> Surgerydetails(string Fromdate) { DoctorDashboard ddob = new DoctorDashboard(); return(ddob.Surgerydetails(Fromdate)); }