private void sendtherapstdata(int uid)
{
String pw = this.password.Text;
String rpw = this.textBoxrepassword.Text;
if (pw == rpw)
{
//MessageBox.Show("two");
Tech te = new Tech();
te.Regno = textBoxtherapistgrn.Text;
te.Qualification = textBoxtherapistpq.Text;
te.Designation = textBoxtherapistdesignation.Text;
te.Workingplce = textBoxtherapistwp.Text;
usermng uMng = new usermng();
string qry = "insert into cmshdb.technecian(userid,regno,qualifications,designation,workingplace)values('" + uid + "','" + te.Regno + "','" + te.Qualification + "','" + te.Designation + "','" + te.Workingplce + "')";
uMng.insert(qry);
}
else
{
MessageBox.Show("there is a error");
}
}
private void senddrdata(int uid)
{
String pw = this.password.Text;
String rpw = this.textBoxrepassword.Text;
if (pw == rpw)
{
//MessageBox.Show("two");
Doctors doctors = new Doctors();
doctors.Regno = textBoxcadrgrn.Text;
doctors.Qualification = textBoxcadrpq.Text;
doctors.Designation = textBoxcadrdesignation.Text;
doctors.Hospital = textBoxcadrcurrenthospital.Text;
usermng uMng = new usermng();
string qry = "insert into cmshdb.doctors(userid,regno,qualifications,designation,hospital)values('" + uid + "','" + doctors.Regno + "','" + doctors.Qualification + "','" + doctors.Designation + "','" + doctors.Hospital + "')";
uMng.insert(qry);
}
else
{
MessageBox.Show("there is a error");
}
}
private void sendcdata()
{
//MessageBox.Show("One");
String pw = this.password.Text;
String rpw = this.textBoxrepassword.Text;
if (pw == rpw)
{
//MessageBox.Show("two");
User user = new User();
user.Fname = textBoxfirstname.Text;
user.Lname = textBoxlastname.Text;
user.Contact = textBoxcontactno.Text;
user.Nic = textBoxnicno.Text;
user.Username = textBoxusername.Text;
user.Password = password.Text;
user.Acctype = comboBoxacctype.SelectedItem.ToString();
ImageConverter cnvrtr = new ImageConverter();
byte[] img = (byte[])cnvrtr.ConvertTo(pictureBoxca.Image, typeof(byte[]));
user.Pic = img;
user.Imgsize = img.Length;
usermng uMng = new usermng();
string qry = "insert into cmshdb.users(fname,lname,contact,nic,username,password,acctype,img,imgsize)values('" + user.Fname + "','" + user.Lname + "','" + user.Contact + "','" + user.Nic + "','" + user.Username + "','" + user.Password + "','" + user.Acctype + "','" + user.Pic + "','" + user.Imgsize + "');";
uMng.insert(/*user*/ qry);
}
else
{
MessageBox.Show("there is a error");
}
}
private void buttoncadrcreate_Click(object sender, EventArgs e)
{
sendcdata();
User user = new User();
usermng umng = new usermng();
umng.getdata(user, textBoxusername.Text);
senddrdata(user.Userid);
}
/* private void buttonRecommendcheckups_Click(object sender, EventArgs e)
* {
*
* //senddata();
* }*/
private void buttonRecommendcheckups_Click(object sender, EventArgs e)
{
//Checkups[] chkps ;
Checkups chkps = new Checkups();
FormDoctoracc fda = new FormDoctoracc();
chkps.Pid = int.Parse(fda.textBoxdapid.Text);
usermng umng = new usermng();
Console.Write("here1");
umng.getdatafrmrecmndcheckups(chkps);
MessageBox.Show(chkps.Checkupno + " test:");
// MessageBox.Show("" + chkps[0].Pid);
}
private void sendpatdata(int uid)
{
String pw = this.password.Text;
String rpw = this.textBoxrepassword.Text;
if (pw == rpw)
{
//MessageBox.Show("two");
Patients patient = new Patients();
// patient.Bgroup = comboBoxbloodgroup.SelectedItem.ToString();
patient.Bgroup = comboBoxbloodgroup.SelectedItem.ToString();
//patient.BDay = dateTimePickerbday.Value;
var bday = dateTimePickerbday.Value.ToString("dd/MM/yyyy", CultureInfo.InvariantCulture);
patient.BDay = bday;
string gender;
bool ischecked = radioButtonmale.Checked;
if (ischecked)
{
gender = radioButtonmale.Text;
}
else
{
gender = radioButtonfemale.Text;
}
patient.Gender = gender;
patient.Address = textBoxcaaddress.Text;
usermng uMng = new usermng();
string qry = "insert into cmshdb.patients(userid,bldgrp,bday,gender,address)values('" + uid + "','" + patient.Bgroup + "','" + patient.BDay + "','" + patient.Gender + "','" + patient.Address + "')";
uMng.insert(qry);
}
else
{
MessageBox.Show("there is a error");
}
}
private void buttonHFlogin_Click(object sender, EventArgs e)
{
//this.Hide();
//View.FormDoctorAcc DA = new View.FormDoctorAcc();
//DA.Show();
string unme = textboxHFusername.Text;
string pwrd = textboxHFpassword.Text;
User user = new User();
//Doctors dctrs = new Doctors();
usermng uMng = new usermng();
uMng.getdata(user, unme);
string id = user.Userid.ToString();
//uMng.getdatafrmdctrs(dctrs,id);
uMng.login(user, pwrd);
}
public void setvaluespatnt()
{
//Patients ptnt = new Patients();
User ur = new User();
Patients ptnt = new Patients();
usermng umng = new usermng();
int uid = int.Parse(textBoxdapid.Text);
umng.getdatafrmpatnt(ur, ptnt, uid);
labeldapname.Text = ur.Fname + " " + ur.Lname;
labeldaaddress.Text = ptnt.Address;
labeldapnic.Text = ur.Nic;
DateTime bday = Convert.ToDateTime(ptnt.BDay);
DateTime now = DateTime.Today;
int age = now.Year - bday.Year;
labeldapage.Text = Convert.ToString(age);
}
