public VisitViewercs(int ID, TextBox text) : this()
{
listView1.FullRowSelect = true;
listView1.GridLines = true;
patid = ID;
textb = text;
var res = SQLLab.GetPatientData(patid);
foreach (var order in res)
{
textBox1.Text = order.PESEL;
}
docs = SQLAdm.GetStaff("", "", "", "doc");
foreach (var order in docs)
{
comboBox3.Items.Add(order.Surname);
}
listView1.Items.Clear();
var temp = SQLRec.GetApo(patid);
foreach (var order in temp)
{
ListViewItem lvi = new ListViewItem(order.Id_Appointment.ToString());
var tmp = SQLRec.GetDocData(order.Id_Doctor);
string name = tmp.FirstOrDefault().Name + " " + tmp.FirstOrDefault().Surname;
lvi.SubItems.Add(name);
lvi.SubItems.Add(order.Date_Appointment.ToString());
lvi.SubItems.Add(SQLRec.translateRolePL(order.State.ToString()));
listView1.Items.Add(lvi);
}
}
private void button2_Click(object sender, EventArgs e)
{//zapisz i zamknij
if (comboBox1.Text != "" && comboBox2.Text != "")
{
var doc = docs.AsEnumerable <Staff>();
int docid = doc.ElementAt <Staff>(comboBox1.SelectedIndex).Id_Staff;
string culture = "mn-MN";
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(culture);
string datetosql = monthCalendar1.SelectionStart.ToShortDateString();
datetosql += " " + comboBox2.Text;
DateTime dt = DateTime.Parse(datetosql);
{
SQLRec.updateApo(apoid, SQLRec.translateRoleDB(comboBox3.Text.ToString()), docid, dt);
}
this.Controls.Clear();
this.Visible = false;
this.Parent.Hide();
textb.Text = "changed";
}
else
{
MessageBox.Show("Wprowadz poprawne informacje");
}
}
private void reload()
{
var doc = docs.AsEnumerable <Staff>();
if (dateTimePicker1.Checked == true)
{
if (comboBox3.SelectedIndex >= 0)
{
int docid = doc.ElementAt <Staff>(comboBox3.SelectedIndex).Id_Staff;
var temp = SQLRec.GetApo(patid, SQLRec.translateRoleDB(comboBox1.Text.ToString()), docid, datetostring());
listupdate(temp);
}
else
{
var temp = SQLRec.GetApo(patid, SQLRec.translateRoleDB(comboBox1.Text.ToString()), datetostring());
listupdate(temp);
}
}
else
{
if (comboBox3.SelectedIndex >= 0)
{
int docid = doc.ElementAt <Staff>(comboBox3.SelectedIndex).Id_Staff;
var temp = SQLRec.GetApo(patid, SQLRec.translateRoleDB(comboBox1.Text.ToString()), docid);
listupdate(temp);
}
else
{
var temp = SQLRec.GetApo(patid, SQLRec.translateRoleDB(comboBox1.Text.ToString()));
listupdate(temp);
}
}
}
public Edit(int ID, TextBox text) : this()
{
apoid = ID;
textb = text;
var a = SQLRec.GetApoSE(apoid);
//comboBox4.drop
var res = SQLLab.GetPatientData(a.First().Id_Patient);
foreach (var order in res)
{
textBox1.Text = order.Name;
textBox2.Text = order.Surname;
textBox3.Text = order.PESEL;
}
docs = SQLAdm.GetStaff("", "", "", "doc");
foreach (var order in docs)
{
comboBox1.Items.Add(order.Surname);
}
var doc = SQLAdm.GetStaff(a.First().Id_Doctor);
comboBox1.Text = doc.First().Name.ToString(); //lekarz
monthCalendar1.SetDate(a.First().Date_Appointment); //data
comboBox3.Text = SQLRec.translateRolePL(a.First().State.ToString()); //stan
//string time = a.First().Date_Appointment.Hour.ToString()+":" + a.First().Date_Appointment.Minute.ToString();
string time = a.First().Date_Appointment.ToString("HH:mm");
comboBox2.Text = time;//godzina
// comboBox4.DropDownStyle = ComboBoxStyle.DropDownList;
// comboBox2.Text = a.First().Date_Appointment.TimeOfDay.ToString();
}
private void button2_Click(object sender, EventArgs e)
{
if (comboBox1.SelectedIndex != -1 && comboBox2.SelectedIndex != -1)
{
string culture = "mn-MN";
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(culture);
string datetosql = monthCalendar1.SelectionStart.ToShortDateString();
datetosql += " " + comboBox2.Text;
var doc = docs.AsEnumerable <Staff>();
int docid = doc.ElementAt <Staff>(comboBox1.SelectedIndex).Id_Staff;
DateTime dt = DateTime.Parse(datetosql);
SQLRec.ExecuteAppointment(dt, docid, idrec, "", "", patid, "R");//zamiast 1 idrec
this.Controls.Clear();
this.Visible = false;
this.Parent.Hide();
textb.Text = "changed";
}
else
{
MessageBox.Show("Wybierz doktora oraz dane wizyty");
}
}
private void refresh()
{
listView1.Items.Clear();
var res = SQLRec.GetPatientsList(textBox1.Text, textBox2.Text, textBox3.Text);
foreach (var order in res)
{
ListViewItem lvi = new ListViewItem(order.Name.ToString());
lvi.SubItems.Add(order.Surname);
lvi.SubItems.Add(order.PESEL);
listView1.Items.Add(lvi);
}
}
private void button1_Click(object sender, EventArgs e)
{
listView1.Items.Clear();
var res = SQLRec.GetPatientsList(textBox1.Text, textBox2.Text, textBox3.Text);
foreach (var order in res)
{
ListViewItem lvi = new ListViewItem(order.Name.ToString());
lvi.SubItems.Add(order.Surname);
lvi.SubItems.Add(order.PESEL);
listView1.Items.Add(lvi);
}
}
private void listupdate(IQueryable <Appointment> temp)
{
listView1.Items.Clear();
foreach (var order in temp)
{
ListViewItem lvi = new ListViewItem(order.Id_Appointment.ToString());
var tmp = SQLRec.GetDocData(order.Id_Doctor);
string name = tmp.FirstOrDefault().Name + " " + tmp.FirstOrDefault().Surname;
lvi.SubItems.Add(name);
lvi.SubItems.Add(order.Date_Appointment.ToString());
lvi.SubItems.Add(SQLRec.translateRolePL(order.State.ToString()));
listView1.Items.Add(lvi);;
}
}
public Reg()
{
InitializeComponent();
listView1.Items.Clear();
var res = SQLRec.GetPatientsList("", "", "");
foreach (var order in res)
{
ListViewItem lvi = new ListViewItem(order.Name.ToString());
lvi.SubItems.Add(order.Surname);
lvi.SubItems.Add(order.PESEL);
listView1.Items.Add(lvi);
}
listView1.FullRowSelect = true;
listView1.GridLines = true;
}
private void button4_Click(object sender, EventArgs e)//show
{
if (listView1.SelectedItems.Count > 0)
{
ListViewItem item = listView1.SelectedItems[0];
var res = SQLRec.GetPatientsList(item.SubItems[0].Text.TrimEnd(), item.SubItems[1].Text.TrimEnd(), item.SubItems[2].Text.TrimEnd());
foreach (var x in res)
{
WindowPanel.Controls.Add(new VisitViewercs(x.Id_Patient, connector));
WindowPanel.Visible = true;
WindowPanel.Dock = DockStyle.Fill;
WindowPanel.BringToFront();
}
}
}
private void button2_Click(object sender, EventArgs e) //edit
{
if (textBox1.TextLength != 0 && textBox2.TextLength != 0 && textBox3.TextLength != 0 && Regex.IsMatch(textBox3.Text.ToString(), @"^(\d{11})$"))
{
SQLRec.EditPatient(id, textBox1.Text, textBox2.Text, textBox3.Text);
MessageBox.Show("Zmieniono dane pacjenta");
this.Controls.Clear();
this.Visible = false;
this.Parent.Hide();
textb.Text = "changed";
}
else
{
MessageBox.Show("Brak Danych lub błędny pesel");
}
}
/// <summary>
/// ===== EXAMPLE METHOD 1 ============
/// This method is to be used to validate user access.
/// </summary>
/// <param name="CurrentUser"></param>
/// <returns>
/// Returns true for 'granted access' and false for 'denied access'</returns>
public string CheckuserSecurityAccess(string CurrentUser)
{
string ReturnedValue = "false";
SqlConnection SQLConn = new SqlConnection();
SqlCommand SQLComm = new SqlCommand();
SqlDataReader SQLRec;
//connection string to the database
SQLConn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EmployeeDataBaseConnectionString"].ConnectionString;
//open connection
SQLConn.Open();
//stored procedure name
string SQL = "ssp_tblOperator_GetUserAccess";
SQLComm = new SqlCommand(SQL, SQLConn);
SQLComm.CommandType = CommandType.StoredProcedure;
//parameter passed
SQLComm.Parameters.AddWithValue("@CurrentUser", CurrentUser);
SQLRec = SQLComm.ExecuteReader();
try
{
if (SQLRec.Read())
{
//returned results
ReturnedValue = SQLRec.GetString(SQLRec.GetOrdinal("UserHasAccess"));
}
}
catch (Exception e)
{
ReturnedValue = e.Message;
}
//close connection
SQLRec.Close();
SQLConn.Close();
return(ReturnedValue);
}
/// <summary>
/// ===== EXAMPLE METHOD 2 ============
/// </summary>
/// This method is to be used to return a list of employee information.
/// <returns>
/// A list of employee information
/// </returns>
public List <SampleEmployeeDataModel> GetCodeSampleList()
{
List <SampleEmployeeDataModel> SampleDataModel = new List <SampleEmployeeDataModel>();
SqlConnection SQLconn = new SqlConnection();
SqlCommand SQLcomm = new SqlCommand();
SqlDataReader SQLRec;
//connection string to the database
SQLconn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EmployeeDataBaseConnectionString"].ConnectionString;
//open connection
SQLconn.Open();
//stored procedure name
string SQL = "ssp_tblEmployee_GetEmployeeInformationList";
SQLcomm = new SqlCommand(SQL, SQLconn);
SQLcomm.CommandType = CommandType.StoredProcedure;
SQLRec = SQLcomm.ExecuteReader();
//read data into the model
while (SQLRec.Read())
{
SampleDataModel.Add(new SampleEmployeeDataModel
{
ID = SQLRec.GetInt32(SQLRec.GetOrdinal("ID")),
FirstName = SQLRec.GetString(SQLRec.GetOrdinal("FirstName")),
LastName = SQLRec.GetString(SQLRec.GetOrdinal("LastName")),
DOB = SQLRec.GetDateTime(SQLRec.GetOrdinal("DOB")),
SSN = SQLRec.GetString(SQLRec.GetOrdinal("SSN")),
});
}
//close connection
SQLRec.Close();
SQLconn.Close();
return(SampleDataModel);
}
private void button3_Click(object sender, EventArgs e)//visit registarion
{
if (listView1.SelectedItems.Count > 0)
{
ListViewItem item = listView1.SelectedItems[0];
var res = SQLRec.GetPatientsList(item.SubItems[0].Text.TrimEnd(), item.SubItems[1].Text.TrimEnd(), item.SubItems[2].Text.TrimEnd());
foreach (var x in res)
{
WindowPanel.Controls.Add(new VisitRegistration(x.Id_Patient, connector, whoami));
WindowPanel.Visible = true;
WindowPanel.Dock = DockStyle.Fill;
WindowPanel.BringToFront();
}
}
else
{
MessageBox.Show("Nie wybrano pacjenta");
}
}
public Show(int ID, TextBox text) : this()
{
apoid = ID;
textb = text;
var a = SQLRec.GetApoSE(apoid);
var res = SQLLab.GetPatientData(a.First().Id_Patient);
foreach (var order in res)
{
textBox1.Text = order.Name;
textBox2.Text = order.Surname;
textBox3.Text = order.PESEL;
}
var doc = SQLAdm.GetStaff(a.First().Id_Doctor);
textBox4.Text = doc.First().Name.ToString(); //lekarz
textBox7.Text = a.First().Date_Appointment.ToString(); //data
textBox6.Text = SQLRec.translateRolePL(a.First().State.ToString()); //stan
string time = a.First().Date_Appointment.TimeOfDay.ToString();
}
