private void FillViewCard(int id)
{
string sqlString = "SELECT BASE_CALENDAR.*,CONVERT(VARCHAR(10),BASE_CALENDAR.STARTDATE,105) AS DATA, CONVERT(VARCHAR(5),BASE_CALENDAR.STARTDATE,114) AS DALLE,CONVERT(VARCHAR(5),BASE_CALENDAR.ENDDATE,114) AS ALLE, ";
sqlString += "(ACCOUNT.SURNAME+' '+ACCOUNT.NAME) AS USERNAME ";
sqlString += "FROM BASE_CALENDAR LEFT OUTER JOIN ACCOUNT ON BASE_CALENDAR.UID = ACCOUNT.UID WHERE BASE_CALENDAR.ID=" + id;
ViewAppointmentForm.DataSource = DatabaseConnection.CreateDataset(sqlString);
ViewAppointmentForm.DataBind();
}
private void FillViewCard(int id)
{
string sqlString = "SELECT BASE_EVENTS.*, ";
sqlString += "(ACCOUNT.SURNAME+' '+ACCOUNT.NAME) AS USERNAME, (CREATEDBY.SURNAME+' '+CREATEDBY.NAME) AS CREATEUTE ";
sqlString += "FROM BASE_EVENTS LEFT OUTER JOIN ACCOUNT ON BASE_EVENTS.UID = ACCOUNT.UID LEFT OUTER JOIN ACCOUNT AS CREATEDBY ON BASE_EVENTS.CREATEDBYID = CREATEDBY.UID WHERE BASE_EVENTS.ID=" + id;
Trace.Warn("ma", sqlString);
ViewAppointmentForm.DataSource = DatabaseConnection.CreateDataset(sqlString);
ViewAppointmentForm.DataBind();
ViewAppointmentForm.Visible = true;
AppointmentCard.Visible = false;
}
private void btnViewPatientApts_Click(object sender, EventArgs e)
{
if (this.patientDataGridView.SelectedRows.Count == 0)
{
MessageBox.Show(this, Resources.MainForm_buttonAddAppointment_Click_Please_select_a_user,
Resources.MainForm_buttonAddAppointment_Click_Error, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
var patientId = ((Patient)this.patientDataGridView.SelectedRows[0].DataBoundItem).PatientId;
var patientApts = new ViewAppointmentForm(patientId);
patientApts.ShowDialog();
}
}
private void FillViewCard(int id)
{
string sqlString = "SELECT BASE_CALENDAR.*,CONVERT(VARCHAR(10),BASE_CALENDAR.STARTDATE,105) AS DATA, CONVERT(VARCHAR(5),BASE_CALENDAR.STARTDATE,114) AS DALLE,CONVERT(VARCHAR(5),BASE_CALENDAR.ENDDATE,114) AS ALLE, " +
"(ACCOUNT.SURNAME+' '+ACCOUNT.NAME) AS USERNAME " +
"FROM BASE_CALENDAR LEFT OUTER JOIN ACCOUNT ON BASE_CALENDAR.UID = ACCOUNT.UID WHERE BASE_CALENDAR.ID=@ID AND BASE_CALENDAR.UID=@UID";
DbSqlParameterCollection p = new DbSqlParameterCollection();
p.Add(new DbSqlParameter("@ID", id));
p.Add(new DbSqlParameter("@UID", ((UC.ImpersonateUser != 0) ? UC.ImpersonateUser : UC.UserId)));
DataSet d = DatabaseConnection.SecureCreateDataset(sqlString, p);
if (d.Tables[0].Rows.Count > 0)
{
ViewAppointmentForm.DataSource = d;
ViewAppointmentForm.DataBind();
ViewAppointmentForm.Visible = true;
AppointmentCard.Visible = false;
}
else
{
Response.Redirect("/today.aspx?logoff=true");
}
}
private void buttonViewAppointments_Click(object sender, EventArgs e)
{
var viewAppointments = new ViewAppointmentForm();
viewAppointments.ShowDialog();
}
