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