private DataTable GetData()
{
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("(Select Vendor.Name, RecvdDate, ExpiryDate, QtyRcvd, Comments from MedicineReceived join Vendor on " +
"Vendor.idVendor = MedicineReceived.idVendor where idMedicine = " + InventoryView.SetID + ")", false, null);
return(ds.Tables[0]);
}
public SearchPatient()
{
InitializeComponent();
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select MR_No, Patient.Name, FatherOrHusband from Patient", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
dataGridView1.DataSource = ds.Tables[0];
}
}
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("select Type.Name from Type where idType in (select Type from Medicine where Medicine.Name like '" + textBox4.Text + "')", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
comboBox1.DisplayMember = "Name";
comboBox1.ValueMember = "Name";
comboBox1.DataSource = ds.Tables[0];
}
}
}
public InventoryView()
{
InitializeComponent();
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select idMedicine, Medicine.Name, Quantity, Type.Name from Medicine " +
"join Type on Medicine.Type = Type.idType", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
dataGridView1.DataSource = ds.Tables[0];
}
}
}
private void button1_Click_1(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Please insert vendor's name.");
}
else
{
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("select Name from Vendor where Name = '" + textBox1.Text + "'", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("This vendor already exists.");
}
else
{
int insert = _sqlSetup.SetData("Insert into Vendor(idVendor, Name) values " +
"((Select Top 1 idVendor from Vendor order by idVendor desc) +1,'"
+ textBox1.Text + "')", false, null);
MessageBox.Show("Vendor Added.");
this.Close();
AddMedicineStock fm = new AddMedicineStock();
fm.Show();
}
}
}
}
public NewMedicine()
{
InitializeComponent();
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select Name from Type", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
comboBox1.DisplayMember = "Name";
comboBox1.ValueMember = "Name";
comboBox1.DataSource = ds.Tables[0];
}
}
}
public DosageHistory()
{
InitializeComponent();
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("select idAppointment, Name, Date from Appointment join Doctors on " +
"Doctors.idDoctors = Appointment.idDoctors where idAppointment like '" + textBox1.Text +
"%' and MR_No = " + PharmacySearch.SetMR + " and Datepart(dayofyear,Date) = " +
"DatePart(dayofyear,GetDate())", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
dataGridView1.DataSource = ds.Tables[0];
}
}
}
public PharmacySearch()
{
InitializeComponent();
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select idAppointment AS 'Appointment ID', Appointment.MR_No, " +
"Patient.Name AS 'Patient Name', Doctors.[Name] AS 'Doctor', Convert( varchar, Time, 8)" +
" as 'Time' from Appointment join Patient on Appointment.MR_No = Patient.MR_No join" +
" Doctors on Appointment.idDoctors = Doctors.idDoctors where Convert(varchar, Date, 6) =" +
" Convert(varchar, GETDATE(), 6) order by Time", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
dataGridView1.DataSource = ds.Tables[0];
}
}
}
public NewAppointment()
{
InitializeComponent();
dateTimePicker2.Format = DateTimePickerFormat.Time;
dateTimePicker2.ShowUpDown = true;
textBox2.Text = SearchPatient.SetMrNo.ToString();
textBox1.Text = SearchPatient.SetPatientName;
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select Age as age from Patient where Name like '" + textBox1.Text + "' and MR_No = " + textBox2.Text + "", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
textBox4.Text = ds.Tables[0].Rows[0]["age"].ToString();
}
}
}
private void button1_Click_1(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("Information Missing!");
}
string userid = textBox1.Text;
string password = textBox2.Text;
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select username, pw, isDoctor, isReceptionist, isAdmin, isPharmacist from Users where username='******'and pw='" + textBox2.Text + "'", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["isDoctor"].ToString() == "True")
{
this.Hide();
DoctorView fm = new DoctorView();
fm.Show();
}
else if (ds.Tables[0].Rows[0]["isReceptionist"].ToString() == "True")
{
this.Hide();
ReceptionView fm = new ReceptionView();
fm.Show();
}
else if (ds.Tables[0].Rows[0]["isAdmin"].ToString() == "True")
{
this.Hide();
AdminView fm = new AdminView();
fm.Show();
}
else if (ds.Tables[0].Rows[0]["isPharmacist"].ToString() == "True")
{
this.Hide();
PharmacyView fm = new PharmacyView();
fm.Show();
}
}
else
{
MessageBox.Show("Invalid Login. Please check username and password");
}
}
else
{
MessageBox.Show("Invalid Login. Please check username and password");
}
}
private void Auto()
{
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("select Name from Vendor where Name like '" + textBox1.Text + "%'", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
coll.Add(ds.Tables[0].Rows[i]["Name"].ToString());
}
}
}
textBox1.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox1.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox1.AutoCompleteCustomSource = coll;
}
public DoctorPresc()
{
InitializeComponent();
textBox1.Enabled = false;
textBox2.Enabled = false;
dataGridView1.Enabled = false;
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select MR_No, Doctors.Name as DName from Appointment " +
"join Doctors on Appointment.idDoctors = Doctors.idDoctors where idAppointment = " + ConsultationForm.appt + " and MR_No = " +
DoctorView.MR + " and Date = '" + ConsultationForm.date + "'", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
textBox1.Text = ds.Tables[0].Rows[0]["MR_No"].ToString();
textBox2.Text = ds.Tables[0].Rows[0]["DName"].ToString();
}
}
DisplayData();
}
public ViewPatient()
{
InitializeComponent();
DataSet ds = new DataSet();
textBox1.Text = SearchPatient.SetMrNo.ToString();
textBox2.Text = SearchPatient.SetPatientName;
ds = _sqlSetup.GetData("Select Patient.Age as PAge, Patient.FatherOrHusband as PFa, Patient.CNIC as PCNIC, Patient.Address as PAdd, Patient.Cell_No as PCell, City.Name as CName, Province.Name as ProvName from Patient, City, Province where Patient.idCity = City.idCity and City.idProvince = Province.idProvince and Patient.Name like '" + textBox2.Text + "' and Patient.MR_No = " + Convert.ToInt32(textBox1.Text), false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
textBox6.Text = ds.Tables[0].Rows[0]["PAge"].ToString();
textBox3.Text = ds.Tables[0].Rows[0]["PFa"].ToString();
textBox4.Text = ds.Tables[0].Rows[0]["PCNIC"].ToString();
textBox5.Text = ds.Tables[0].Rows[0]["PAdd"].ToString();
textBox8.Text = ds.Tables[0].Rows[0]["PCell"].ToString();
textBox7.Text = ds.Tables[0].Rows[0]["CName"].ToString();
comboBox1.Text = ds.Tables[0].Rows[0]["ProvName"].ToString();
}
}
}
public PharmacyPrescription()
{
InitializeComponent();
textBox1.Enabled = false;
textBox2.Enabled = false;
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select MR_No, Doctors.Name as DName from Appointment " +
"join Doctors on Appointment.idDoctors = Doctors.idDoctors where idAppointment = " + DosageHistory.SetApp + " and MR_No = " +
PharmacySearch.SetMR + " and Date = '" + DosageHistory.SetDate + "'", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
textBox1.Text = ds.Tables[0].Rows[0]["MR_No"].ToString();
textBox2.Text = ds.Tables[0].Rows[0]["DName"].ToString();
}
else
{
MessageBox.Show("No appointments found.");
}
}
DisplayData();
}
private void ViewTodaysAppointment_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select idAppointment, Appointment.MR_No, Patient.Name as 'Patient', Doctors.[Name] as 'Doctor', " +
"Convert( varchar, Time, 8) as 'Time' from Appointment join Patient on Appointment.MR_No =" +
" Patient.MR_No join Doctors on Appointment.idDoctors = Doctors.idDoctors where " +
"Convert(varchar, Date, 6) = Convert(varchar, GETDATE(), 6) order by Time", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
dataGridView1.DataSource = ds.Tables[0];
}
}
}
private void EditConsultationDetails_Load(object sender, EventArgs e)
{
//Adding feet and inches to height
comboBox2.Items.Add(1);
comboBox2.Items.Add(2);
comboBox2.Items.Add(3);
comboBox2.Items.Add(4);
comboBox2.Items.Add(5);
comboBox2.Items.Add(6);
comboBox2.Items.Add(7);
comboBox2.Items.Add(8);
comboBox2.Items.Add(9);
comboBox2.Items.Add(10);
comboBox2.Items.Add(11);
comboBox1.Items.Add(1);
comboBox1.Items.Add(2);
comboBox1.Items.Add(3);
comboBox1.Items.Add(4);
comboBox1.Items.Add(5);
comboBox1.Items.Add(6);
textBox2.Text = DoctorView.Patient;
textBox3.Text = DoctorView.MR.ToString();
textBox12.Text = ConsultationForm.appt.ToString();
textBox13.Text = ConsultationForm.doc;
dateTimePicker1.Text = ConsultationForm.date;
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("Select PresentComplaints, Investigation, Heightf, Heighti, Weight, Temp, BP, Pulse, RespRate from Appointment, Doctors where Doctors.idDoctors = Appointment.idDoctors and Doctors.Name like '" + ConsultationForm.doc + "' and MR_No = " + DoctorView.MR.ToString() + " and Date = '" + ConsultationForm.date + "' and idAppointment = " + ConsultationForm.appt.ToString(), false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
textBox1.Text = ds.Tables[0].Rows[0]["PresentComplaints"].ToString();
textBox4.Text = ds.Tables[0].Rows[0]["Investigation"].ToString();
comboBox1.Text = ds.Tables[0].Rows[0]["Heightf"].ToString();
comboBox2.Text = ds.Tables[0].Rows[0]["Heighti"].ToString();
textBox9.Text = ds.Tables[0].Rows[0]["Weight"].ToString();
textBox8.Text = ds.Tables[0].Rows[0]["Temp"].ToString();
textBox7.Text = ds.Tables[0].Rows[0]["BP"].ToString();
textBox6.Text = ds.Tables[0].Rows[0]["Pulse"].ToString();
textBox5.Text = ds.Tables[0].Rows[0]["RespRate"].ToString();
}
}
}
public void Auto()
{
DataSet ds2 = new DataSet();
ds2 = _sqlSetup.GetData("select City.Name as CName from City", false, null);
if (ds2 != null)
{
if (ds2.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds2.Tables[0].Rows.Count; i++)
{
coll.Add(ds2.Tables[0].Rows[i]["CName"].ToString());
}
}
else
{
textBox7.Clear();
MessageBox.Show("City not found");
}
}
textBox7.AutoCompleteMode = AutoCompleteMode.Suggest;
textBox7.AutoCompleteSource = AutoCompleteSource.CustomSource;
textBox7.AutoCompleteCustomSource = coll;
}
private void Reg_Click_1(object sender, EventArgs e)
{
if (uname.Text == "" || pass.Text == "" || cpass.Text == "")
{
MessageBox.Show("Incomplete Information!");
}
else if (pass.Text.Length < 8)
{
MessageBox.Show("Password needs more characters");
}
else if (pass.Text != cpass.Text)
{
MessageBox.Show("Passwords don't match");
}
else
{
DataSet ds = new DataSet();
ds = _sqlSetup.GetData("select username from Users where username ='******'", false, null);
if (ds != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
MessageBox.Show("A user already exists with these credentials. Please enter a different username and password.");
}
else
{
string command;
if (radioButton1.Checked == true)
{
command = "Insert into dbo.Users(username,pw,isDoctor,isReceptionist,isPharmacist,isAdmin) " +
"values( '" + uname.Text + "', '" + pass.Text + "', 0,0,1,0)";
int update = _sqlSetup.SetData(command, false, null);
MessageBox.Show("User Details Added!");
this.Close();
}
else if (radioButton2.Checked == true)
{
command = "Insert into dbo.Users(username,pw,isDoctor,isReceptionist,isPharmacist,isAdmin) " +
"values( '" + uname.Text + "', '" + pass.Text + "', 0,1,0,0)";
int update = _sqlSetup.SetData(command, false, null);
MessageBox.Show("User Details Added!");
this.Close();
}
else if (radioButton3.Checked == true)
{
command = "Insert into dbo.Users(username,pw,isDoctor,isReceptionist,isPharmacist,isAdmin) " +
"values( '" + uname.Text + "', '" + pass.Text + "', 0,0,0,1)";
int update = _sqlSetup.SetData(command, false, null);
MessageBox.Show("User Details Added!");
this.Close();
}
else if (radioButton4.Checked == true)
{
command = "Insert into dbo.Users(username,pw,isDoctor,isReceptionist,isPharmacist,isAdmin) " +
"values( '" + uname.Text + "', '" + pass.Text + "', 1,0,0,0)";
int add = _sqlSetup.SetData("Insert into dbo.Doctors(Name) values('" + uname.Text + "')", false, null);
int update = _sqlSetup.SetData(command, false, null);
MessageBox.Show("User Details Added!");
this.Close();
}
else
{
MessageBox.Show("Please select your position!");
}
}
}
}
}