// GET: Supplier
public ActionResult DashBoard()
{
using (KIITEntities db = new KIITEntities())
{
DashView model = new DashView();
model.TotOrd = db.PatientOrderDetails.Count();
model.DelOrd = db.PatientOrderDetails.Where(a => a.OrderStatus == "Delivered").Count();
model.DisOrd = db.PatientOrderDetails.Where(a => a.OrderStatus == "Dispatched").Count();
model.ReqOrd = db.PatientOrderDetails.Where(a => a.OrderStatus == "Requested").Count();
return(View(model));
}
}
/// <summary>
/// 로딩작업
/// </summary>
/// <param name="obj"></param>
private void OnLoaded(object obj)
{
try
{
// 0.화면객체인스턴스화
if (obj == null)
{
return;
}
var values = (object[])obj;
//1. 화면객체 인스턴스
dashView = values[0] as DashView;
// 4.초기조회
Hashtable param = new Hashtable();
var sYm = Convert.ToDateTime(DateTime.Today).ToString("yyyyMM");
param.Add("sqlId", "SelectDashChart1List");
param.Add("pYm", sYm);
param.Add("id", Logs.strLogin_ID);
DataTable dt = BizUtil.SelectList(param);
// Create an empty chart.
ChartControl chart1 = dashView.ctDash1;
// Bind a chart to a data source.
chart1.DataSource = dt;
dashView.srX_TIT11.Points.Clear();
dashView.srX_TIT12.Points.Clear();
dashView.srX_TIT11.Visible = false;
dashView.srX_TIT12.Visible = true;
foreach (DataRow row in dt.Rows)
{
SeriesPoint point = new SeriesPoint(row["NAM"].ToString(), Convert.ToDouble(row["DATA_VAL"]));
SeriesPoint point2 = new SeriesPoint(row["NAM"].ToString(), Convert.ToDouble(row["DATA_VAL2"]));
dashView.srX_TIT11.Points.Add(point);
dashView.srX_TIT12.Points.Add(point2);
dashView.ctDash1.Legend.Visibility = Visibility.Collapsed;
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
// GET: Patient
public ActionResult DashBoard()
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
DashView model = new DashView();
int pid = db.Patients.Where(a => a.MemberId == memid).Select(a => a.PatientId).SingleOrDefault();
model.App = db.DoctorAppointments.Where(a => a.PatientId == pid).Count();
model.AprApp = db.DoctorAppointments.Where(a => (a.PatientId == pid) && (a.AppointmentStatus == "Accept")).Count();
model.RejApp = db.DoctorAppointments.Where(a => (a.PatientId == pid) && (a.AppointmentStatus == "Reject")).Count();
model.ProcApp = db.DoctorAppointments.Where(a => (a.PatientId == pid) && (a.AppointmentStatus == "Requested")).Count();
model.TotOrd = db.PatientOrderDetails.Where(a => a.PatientId == pid).Count();
model.DelOrd = db.PatientOrderDetails.Where(a => (a.PatientId == pid) && (a.OrderStatus == "Delivered")).Count();
model.ReqOrd = db.PatientOrderDetails.Where(a => (a.PatientId == pid) && (a.OrderStatus == "Requested") || (a.OrderStatus == "Dispatched")).Count();
return(View(model));
}
}
// GET: Doctor
public ActionResult DashBoard()
{
int memid = Convert.ToInt32(Session["Memberid"]);
using (KIITEntities db = new KIITEntities())
{
DashView model = new DashView();
string doceid = db.MemberLogins.Where(a => a.MemberId == memid).Select(a => a.EmailId).SingleOrDefault();
int docid = db.Doctors.Where(a => a.MemberId == memid).Select(a => a.DoctorId).SingleOrDefault();
model.App = db.DoctorAppointments.Where(a => a.DoctorId == docid).Count();
model.AprApp = db.DoctorAppointments.Where(a => (a.AppointmentStatus == "Accept") && (a.DoctorId == docid)).Count();
model.RejApp = db.DoctorAppointments.Where(a => (a.AppointmentStatus == "Reject") && (a.DoctorId == docid)).Count();
model.ProcApp = db.DoctorAppointments.Where(a => (a.AppointmentStatus == "Requested") && (a.DoctorId == docid)).Count();
model.Inbox = db.Inboxes.Where(a => a.ToEmailId == doceid).Count();
model.RInbox = db.Inboxes.Where(a => (a.ToEmailId == doceid) && (a.IsRead == true)).Count();;
model.URInbox = db.Inboxes.Where(a => (a.ToEmailId == doceid) && (a.IsRead == false)).Count();;
return(View(model));
}
}
