protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
id = Convert.ToInt32(Request.QueryString["pID"]);
if (!new AppointmentDAO().rowsExist())
{
new AppointmentDAO().addRows();
}
new AppointmentDAO().adjust();
ArrayList arrList = new ArrayList();
for (int i = 0; i < 7; i++)
{
arrList.Add(System.DateTime.Today.AddDays(i).ToString("dd-MM-yyyy"));
}
ddlDate.DataSource = arrList;
ddlDate.DataBind();
SqlDataReader DR = new DoctorDAO().getDoctors();
while (DR.Read())
{
ddlDoctor.Items.Add(DR[0].ToString());
}
string[] d = new string[3];
string app = "";
d = new AppointmentDAO().find(id);
app += "Doctor's Name: " + d[0] + "\n";
app += "Patient's Name: " + new PatientDAO().getName(id) + "\n";
app += "Date: " + d[1] + "\n";
app += "Time: " + d[2] + "\n";
Appoint.InnerText = app;
}
}
public HttpResponseMessage BuscarPorNombre([FromUri] string nombre)
{
try
{
var personas = DoctorDAO.ConsultarPorNombre(nombre);
if (personas != null)
{
return(Request.CreateResponse(HttpStatusCode.OK, personas));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound,
new
{
Mensaje = $"No se encontro la persona con id {nombre}"
}));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError,
new
{
Mensaje = ex.Message
}));
}
}
public HttpResponseMessage Eiminar([FromUri] int id)
{
try
{
var personas = DoctorDAO.Eliminar(id);
if (personas == 1)
{
return(Request.CreateResponse(HttpStatusCode.OK, personas));
}
else
{
return(Request.CreateResponse(HttpStatusCode.NotFound,
new
{
Mensaje = $"No se encontro la persona con id {id}"
}));
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError,
new
{
Mensaje = ex.Message
}));
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
user = Session["User"].ToString();
if (user == "admin")
{
ddlDoctor.Visible = true;
lblDoctor.Visible = true;
DataSet dsDoctor = new DoctorDAO().getDocs();
ddlDoctor.DataSource = dsDoctor;
ddlDoctor.DataTextField = "name";
ddlDoctor.DataValueField = "docID";
ddlDoctor.DataBind();
}
else
{
ddlDoctor.Visible = false;
lblDoctor.Visible = false;
}
DataSet dsPatient = new PatientDAO().getPatients();
ddlPatient.DataSource = dsPatient;
ddlPatient.DataTextField = "Name";
ddlPatient.DataValueField = "ID";
ddlPatient.DataBind();
DataSet dsTreatment = new TreatmentDAO().getAllTreatments();
ddlTreatment.DataSource = dsTreatment;
ddlTreatment.DataTextField = "Name";
ddlTreatment.DataValueField = "Name";
ddlTreatment.DataBind();
ddlTreatment.Items.Insert(0, "Please select a treatment");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
id = Convert.ToInt32(Request.QueryString["pID"]);
if (!new AppointmentDAO().rowsExist())
{
new AppointmentDAO().addRows();
}
new AppointmentDAO().adjust();
ArrayList arrList = new ArrayList();
for (int i = 0; i < 7; i++)
{
arrList.Add(System.DateTime.Today.AddDays(i).ToString("dd-MM-yyyy"));
}
ddlDate.DataSource = arrList;
ddlDate.DataBind();
SqlDataReader DR = new DoctorDAO().getDoctors();
while (DR.Read())
{
ddlDoctor.Items.Add(DR[0].ToString());
}
}
}
public void adjust()
{
for (int i = 1; i < 6; i++)
{
if (prevDay(i))
{
c.sqlConn.Open();
string date = DateTime.Today.AddDays(-i).ToString("dd-MM-yyyy");
string query = "Delete from Appointment where Date='" + date + "'";
string name = "";
c.sqlComm = new SqlCommand(query, c.sqlConn);
c.sqlComm.ExecuteNonQuery();
SqlDataReader DR = new DoctorDAO().getDoctors();
while (DR.Read())
{
name = DR[0].ToString();
date = System.DateTime.Today.AddDays(i).ToString("dd-MM-yyyy");
query = "INSERT INTO Appointment (Name, Date) values ('" + name + "','" + date + "')";
c.sqlComm = new SqlCommand(query, c.sqlConn);
c.sqlComm.ExecuteNonQuery();
}
}
}
c.sqlConn.Close();
}
protected void Fetch_Click(object sender, EventArgs e)
{
string name = ddlName.SelectedValue.ToString();
DataSet D = new DoctorDAO().getInfo(name);
tbID.Text = D.Tables[0].Rows[0]["DocId"].ToString();
tbSalary.Text = D.Tables[0].Rows[0]["Salary"].ToString();
}
protected void ddlDoctor_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlDoctor.SelectedValue != "Please select a doctor")
{
DataSet ds = new DoctorDAO().getInfoID(Convert.ToInt32(ddlDoctor.SelectedValue));
Name.Text = ds.Tables[0].Rows[0]["name"].ToString();
Name.Enabled = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
SqlDataReader DR = new DoctorDAO().getDoctors2();
while (DR.Read())
{
ddlName.Items.Add(DR[0].ToString());
}
}
}
public HttpResponseMessage ObternerTodos()
{
try
{
var personas = DoctorDAO.ConsultarTodos();
return(Request.CreateResponse(HttpStatusCode.OK, personas));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError,
new
{
Mensaje = ex.Message
}));
}
}
public HttpResponseMessage Actualizar([FromBody] Doctor doctor)
{
try
{
var personaCreada = DoctorDAO.Actualizar(doctor);
return(Request.CreateResponse(HttpStatusCode.OK, personaCreada));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.InternalServerError,
new
{
Mensaje = ex.Message
}));
}
}
public void addRows()
{
c.SqlConn.Open();
string query = "", date = "", name = "";
SqlDataReader dr = new DoctorDAO().getDoctors();
while (dr.Read())
{
name = dr[0].ToString();
for (int i = 0; i < 7; i++)
{
date = System.DateTime.Today.AddDays(i).ToString("dd-MM-yyyy");
query = "INSERT INTO Appointment (Name, Date) values ('" + name + "','" + date + "')";
c.sqlComm = new SqlCommand(query, c.SqlConn);
c.sqlComm.ExecuteNonQuery();
}
}
c.SqlConn.Close();
}
protected void btnAppointmentDoc_Click(object sender, EventArgs e)
{
ddlDoctor1.Visible = true;
ddlDate1.Visible = false;
ddlPatient1.Visible = false;
lblMessage.Text = "";
gvAppointments.DataSource = null;
gvAppointments.DataBind();
DataSet ds = new DoctorDAO().getDocs();
if (ds.Tables[0].Rows.Count > 0)
{
ddlDoctor1.DataSource = ds;
ddlDoctor1.DataTextField = "name";
ddlDoctor1.DataValueField = "name";
ddlDoctor1.DataBind();
ddlDoctor1.Items.Insert(0, "Please select a doctor");
}
}
protected void btnConfirm_Click(object sender, EventArgs e)
{
if (ddlTreatment.SelectedValue != "Please select a treatment")
{
string treatment = ddlTreatment.SelectedValue;
int pID = Convert.ToInt32(ddlPatient.SelectedValue);
user = Session["User"].ToString();
int dID;
if (user == "admin")
{
dID = Convert.ToInt32(ddlDoctor.SelectedValue);
}
else
{
dID = new DoctorDAO().getID(user);
}
string tooth = ddlTooth.SelectedValue;
int quantity = 1;
int cost = Convert.ToInt32(txtCost.Text);
int paid = 0;
if (new TreatmentPlanningDAO().createTreatmentPlan(new TreatmentPlanningDTO(treatment, pID, dID, tooth, quantity, cost, paid)))
{
lblMessage.Text = "Treatment plan created";
lblMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
lblMessage.Text = "Treatment planning not created";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
else
{
lblMessage.Text = "Please select a valid treatment";
lblMessage.ForeColor = System.Drawing.Color.Red;
}
}
public AppointmentBDO GetAppointment(int id)
{
AppointmentBDO appointmentBDO = null;
using (var PHEntities = new PublicHospitalEntities())
{
var appointmentObj = (from a in PHEntities.Appointment
where a.id == id
select a).FirstOrDefault();
if (appointmentObj != null)
{
patientDAO = new PatientDAO();
doctorDAO = new DoctorDAO();
appointmentBDO = new AppointmentBDO()
{
id = appointmentObj.id,
time = Convert.ToDateTime(appointmentObj.time),
serviceType = appointmentObj.serviceType,
patient = patientDAO.GetPatient(appointmentObj.idPatient.Value),
doctor = doctorDAO.GetDoctor(appointmentObj.idDoctor.Value),
rowVersion = appointmentObj.rowVersion
};
}
}
return appointmentBDO;
}
private void mostrarRegistrosDoctor(object sender, EventArgs e)
{
DoctorDAO dao = new DoctorDAO();
vista.TablaBuscar.DataSource = dao.mostarRegistros(vista.txtBuscar.Text);
}
public DoctorBLL()
{
_doctorDAO = new DoctorDAO();
}