private void btnSubmit_Click(object sender, EventArgs e)
{
try
{
conn = new SqlConnection {
ConnectionString = constr
};
conn.Open();
// string insrtlg = "INSERT INTO LoginTB(Username,Password,Access_Level) VALUES(@usr,@pass,@role)";
string insrtInPat = "INSERT INTO InPatientReg(Fname,Lname,Birth,Gender,Phone,Address,Occupation,MaritalStatus,Age,Status,AdmissionDate,Symptoms,Departement,AssignedDoc,WardNo,BedNo) VALUES(@FirstName,@LastName,@DOB,@Gender,@PhoneNumber,@Address,@Occupation,@Mstatus,@Age,@Status,@AdminDate,@Sympt,@Dept,@Doc,@WNo,@BNo)";
SqlCommand cmd1 = new SqlCommand(insrtInPat, conn);
//Adding Registration Infos
cmd1.Parameters.AddWithValue("@FirstName", txtFirstName.Text);
cmd1.Parameters.AddWithValue("@LastName", txtLastName.Text);
cmd1.Parameters.AddWithValue("@DOB", txtDateOfBirth.Text);
cmd1.Parameters.AddWithValue("@Gender", txtGender.SelectedItem);
cmd1.Parameters.AddWithValue("@PhoneNumber", txtPhoneNumber.Text);
cmd1.Parameters.AddWithValue("@Address", txtAddress.Text);
cmd1.Parameters.AddWithValue("@Occupation", txtOccupation.Text);
cmd1.Parameters.AddWithValue("@Mstatus", txtMaritalStatus.SelectedItem);
cmd1.Parameters.AddWithValue("@Age", txtAge.Text);
cmd1.Parameters.AddWithValue("@Status", txtStatus.SelectedItem);
cmd1.Parameters.AddWithValue("@AdminDate", lblCurrentDateTime.Text);
cmd1.Parameters.AddWithValue("@Sympt", txtSymptoms.Text);
cmd1.Parameters.AddWithValue("@Dept", txtDepartment.SelectedItem);
cmd1.Parameters.AddWithValue("@Doc", txtAssignDoctor.Text);
cmd1.Parameters.AddWithValue("@WNo", txtWardNo.SelectedItem);
cmd1.Parameters.AddWithValue("@BNo", txtBedNumber.Value);
cmd1.ExecuteNonQuery();
conn.Close();
MessageBox.Show(this, "User successfully inserted into database. ", "Report", MessageBoxButtons.OK, MessageBoxIcon.Information);
var am = new AdminPage();
am.ClearAllTextBoxes(this);
}
catch (Exception ex)
{
lblErrorMess.Text = ex.Message;
}
}
private void ReadLogData(SqlDataReader dr)
{
if ((string)dr["Access_Level"] == "Admin")
{
var adm = new AdminPage();
txtUsername.Text = String.Empty;
txtPassword.Text = String.Empty;
txtUsername.Focus();
//GlobalUname.GlobalVar = (string) dr["Access_Level"];
adm.Show();
this.Hide();
}
else if ((string)dr["Access_Level"] == "Doctor")
{
var dp = new DoctorPage();
txtUsername.Text = string.Empty;
txtPassword.Text = string.Empty;
txtUsername.Focus();
dp.Show();
this.Hide();
}
else if ((string)dr["Access_Level"] == "Manager")
{
}
else if ((string)dr["Access_Level"] == "Nurse")
{
}
else if ((string)dr["Access_Level"] == "Assistant")
{
var hm = new Home();
txtUsername.Text = string.Empty;
txtPassword.Text = string.Empty;
txtUsername.Focus();
hm.Show();
this.Hide();
}
}