protected void btnLogin_Click(object sender, EventArgs e)
{
try
{
SqlCommand cmd = new SqlCommand("select * from tblLogin where UsrName=@UsrName and Password=@Password", conn);
cmd.Parameters.AddWithValue("@UsrName", txtUsername.Text);
cmd.Parameters.AddWithValue("@Password", txtPassword.Text);
SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dtbl = new DataTable();
adp.Fill(dtbl);
conn.Open();
int x = cmd.ExecuteNonQuery();
conn.Close();
if (dtbl.Rows.Count > 0)
{
SqlDataReader drdr;
SiteLibrary mylib = new SiteLibrary();
string getEmployee = @"select EmpId,FirstName,LastName,DOB,Address,Email,TelephoneNumber,Position from tblEmployees inner join tblLogin on tblLogin.UsrName=tblEmployees.EmpId and tblLogin.UserType=tblEmployees.Position";
drdr = mylib.ExecuteSearch(getEmployee);
if (drdr.Read() == true)
{
if (selectList.SelectedValue == "1")
{
Response.Redirect("LoginForm.aspx");
}
else if (selectList.SelectedValue == "2")
{
Response.Redirect("MedicalForm.aspx");
}
else if (selectList.SelectedValue == "3")
{
Response.Redirect("PersonalCareForm.aspx");
}
else if (selectList.SelectedValue == "4")
{
Response.Redirect("AppointmentSelectionForm.aspx");
}
}
}
else
{
ErrorMessage.Text = "Incorrect Username or Password";
ErrorMessage.ForeColor = System.Drawing.Color.Red;
ErrorMessage.Visible = true;
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void registerbutton_Click(object sender, EventArgs e)
{
ErrorMessage.Visible = false;
string[] customerArray = new string[10];
try
{
customerArray[0] = txtPetID_NC.Text;
customerArray[1] = txtOwner_NC.Text;
customerArray[2] = txtGender_NC.Text;
customerArray[3] = txtNumber_NC.Text;
customerArray[4] = txtAddress_NC.Text;
customerArray[5] = txtBreed_NC.Text;
customerArray[6] = txtEmail_NC.Text;
customerArray[7] = Convert.ToDateTime(txtApptDate_NC.Text).ToString();
customerArray[8] = txtApptTime_NC.Text;
customerArray[9] = txtEmpId_NC.Text;
SiteLibrary mylib = new SiteLibrary();
bool check;
check = mylib.spAddPet(customerArray, "spAddPet");
if (check == false)
{
ErrorMessage.Visible = true;
ErrorMessage.Text = "No addition made to Pet Database";
ErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
ErrorMessage.Visible = true;
ErrorMessage.Text = "Database Updated! Pet has been added";
ErrorMessage.ForeColor = System.Drawing.Color.Green;
txtPetID_NC.Text = "";
txtOwner_NC.Text = "";
txtGender_NC.Text = "";
txtNumber_NC.Text = "";
txtAddress_NC.Text = "";
txtBreed_NC.Text = "";
txtEmail_NC.Text = "";
txtApptDate_NC.Text = "";
txtApptTime_NC.Text = "";
txtEmpId_NC.Text = "";
Response.AddHeader("REFRESH", "7;URL=AppointmentSelectionForm.aspx");
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void medformSubmit_Click(object sender, EventArgs e)
{
ErrorMessage.Visible = false;
string[] medicalArray = new string[9];
try
{
medicalArray[0] = txtPetID_MF.Text;
medicalArray[1] = txtEmpId_MF.Text;
medicalArray[2] = txtComplaint.Text;
medicalArray[3] = treatmentList.Text;
medicalArray[4] = txtDrug.Text;
medicalArray[5] = txtDosage.Text;
medicalArray[6] = txtSugeryDate.Text;
medicalArray[7] = txtSurgeryTime.Text;
medicalArray[8] = txtCost.Text;
SiteLibrary mylib = new SiteLibrary();
bool check;
check = mylib.spAddMedical(medicalArray, "spAddMedical");
if (check == false)
{
ErrorMessage.Visible = true;
ErrorMessage.Text = "Medical Database Has Not Been Updated";
ErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
ErrorMessage.Visible = true;
ErrorMessage.Text = "Database Updated!";
ErrorMessage.ForeColor = System.Drawing.Color.Green;
txtPetID_MF.Text = "";
txtEmpId_MF.Text = "";
txtComplaint.Text = "";
treatmentList.Text = "";
txtDrug.Text = "";
txtDosage.Text = "";
txtSugeryDate.Text = "";
txtSurgeryTime.Text = "";
txtCost.Text = "";
Response.AddHeader("REFRESH", "5;URL=MedicalForm.aspx");
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void updatebutton_Click(object sender, EventArgs e)
{
string[] pet;
SiteLibrary mylib = new SiteLibrary();
try
{
if (txtPetID.Text == "")
{
ErrorMessage.Visible = true;
ErrorMessage.Text = "Please Enter a valid PetID";
}
else
{
pet = new string[10];
pet[0] = txtPetID.Text;
pet[1] = txtOwner.Text;
pet[2] = txtGender.Text;
pet[3] = txtNumber.Text;
pet[4] = txtAddress.Text;
pet[5] = txtBreed.Text;
pet[6] = txtemail.Text;
pet[7] = Convert.ToDateTime(txtApptDate.Text).ToString();
pet[8] = txtApptTime.Text;
pet[9] = txtEmpId.Text;
bool check;
check = mylib.spUpdatePet(pet, "spUpdatePet");
if (check == false)
{
ErrorMessage.Text = "Update Unsuccessful";
ErrorMessage.ForeColor = System.Drawing.Color.Red;
ErrorMessage.Visible = true;
}
else
{
ErrorMessage.Text = "Update Successful";
ErrorMessage.ForeColor = System.Drawing.Color.Green;
ErrorMessage.Visible = true;
}
}
}
catch(Exception ex)
{
throw ex;
}
}
protected void PCFSubmit_Click(object sender, EventArgs e)
{
ErrorMessage.Visible = false;
string[] pcArray = new string[6];
try
{
pcArray[0] = txtPetID_PCF.Text;
pcArray[1] = txtEmpId_PCF.Text;
pcArray[2] = servicesList.Text;
pcArray[3] = txtCost_PCF.Text;
pcArray[4] = txtNextApptDate.Text;
pcArray[5] = txtTimeofAppt.Text;
SiteLibrary mylib = new SiteLibrary();
bool check;
check = mylib.spAddPersonalCare(pcArray, "spAddPersonalCare");
if (check == false)
{
ErrorMessage.Visible = true;
ErrorMessage.Text = "Database Has Not Been Updated";
ErrorMessage.ForeColor = System.Drawing.Color.Red;
}
else
{
ErrorMessage.Visible = true;
ErrorMessage.Text = "Personal Care Database Updated!";
ErrorMessage.ForeColor = System.Drawing.Color.Green;
txtPetID_PCF.Text = "";
txtEmpId_PCF.Text = "";
servicesList.ClearSelection();
txtCost_PCF.Text = "";
txtNextApptDate.Text = "";
txtTimeofAppt.Text = "";
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void generatebutton_Click(object sender, EventArgs e)
{
try
{
SqlCommand cmd = new SqlCommand("select * from tblPet where PetId=@PetId", conn);
cmd.Parameters.AddWithValue("@PetId", txtPetID.Text);
conn.Open();
SqlDataReader drx = cmd.ExecuteReader();
if (drx.Read())
{
SiteLibrary mylib1 = new SiteLibrary();
txtOwner.Text = drx["OwnersName"].ToString();
txtGender.Text= drx["Gender"].ToString();
txtNumber.Text = drx["TelephoneNumber"].ToString();
txtAddress.Text = drx["Address"].ToString();
txtBreed.Text = drx["Breed"].ToString();
txtemail.Text = drx["Email"].ToString();
txtApptDate.Text = drx["DateofAppt"].ToString();
txtApptTime.Text = drx["TimeofAppt"].ToString();
txtEmpId.Text = drx["EmpId"].ToString();
ErrorMessage.Text = "Success";
ErrorMessage.ForeColor = System.Drawing.Color.Green;
}
else
{
ErrorMessage.Visible = true;
ErrorMessage.Text = "Try Again";
ErrorMessage.ForeColor = System.Drawing.Color.Red;
}
}
catch (Exception ex)
{
throw ex;
}
}
