Exemple #1
0
        protected void btnMyPets_Click(object sender, EventArgs e)
        {
            DatabaseEntities db = new DatabaseEntities();

            VETS loginVet = (VETS)Session["Vet"];

            var query = (from p in db.PETS
                         join v in db.VETS on p.vetID equals v.vetID
                         where v.vetID == loginVet.vetID && p.approvalSituation == true && p.isActive == true
                         select new DataBindingProjection
            {
                ID = p.petID,
                photo = p.photoURL,
                name = p.name,
                type = p.type,
                petClass = p.petClass,
                age = p.age,
                gender = p.gender,
                address = p.address,
                city = p.city,
                vetName = v.name,
                vetSurname = v.surname
            }).ToList();

            grdPets.DataSource = query;
            grdPets.DataBind();

            grdPets.Visible                = true;
            grdAnnouncements.Visible       = false;
            lblPetsHeader.Visible          = true;
            lblAnnouncementsHeader.Visible = false;
        }
Exemple #2
0
        protected void grdVet_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            GridViewRow      row         = (GridViewRow)grdVet.Rows[e.RowIndex];
            Label            lbldeleteid = (Label)row.FindControl("lblVetID");
            DatabaseEntities db          = new DatabaseEntities();
            int id = Convert.ToInt32(lbldeleteid.Text);

            VETS v = (from x in db.VETS where x.approvalSituation == true && x.vetID == id && x.isActive == true select x).SingleOrDefault();

            v.isActive = false;
            db.SaveChanges();

            VETS[] v1 = (from x in db.VETS where x.approvalSituation == true && x.isActive == true select x).ToArray();
            grdVet.DataSource = v1;
            grdVet.DataBind();
        }
Exemple #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            VETS loginVet = (VETS)Session["Vet"];

            lblHeaderName.Text = loginVet.name + " " + loginVet.surname;
            imgVet.ImageUrl    = loginVet.photoURL;
            DateTime todayDate = DateTime.Today;

            DatabaseEntities db = new DatabaseEntities();

            ANNOUNCEMENTS[] listOfPastAnnouncements = (from x in db.ANNOUNCEMENTS where x.date < todayDate && x.isActive == true select x).ToArray();

            for (int i = 0; i < listOfPastAnnouncements.Length; i++)
            {
                listOfPastAnnouncements[i].isActive = false;
            }

            db.SaveChanges();
        }
Exemple #4
0
        protected void btnMyAnnouncements_Click(object sender, EventArgs e)
        {
            DatabaseEntities db = new DatabaseEntities();

            VETS loginVet = (VETS)Session["Vet"];

            var query = (from a in db.ANNOUNCEMENTS
                         join v in db.VETS on a.vetID equals v.vetID
                         join p in db.PETS on a.petID equals p.petID
                         where v.vetID == loginVet.vetID && a.approvalSituation == true && a.isActive == true
                         select new DataBindingProjection
            {
                ID = a.announcementID,
                date = a.date,
                photo = p.photoURL,
                name = p.name,
                type = p.type,
                petClass = p.petClass,
                age = p.age,
                gender = p.gender,
                situation = a.situation,
                fee = a.fee,
                text = a.text,
                vetName = v.name,
                vetSurname = v.surname,
                vetAddress = v.address,
                vetMail = v.emailAddress,
                vetPhone = v.phoneNumber
            }).ToList();

            grdAnnouncements.DataSource = query;
            grdAnnouncements.DataBind();

            grdAnnouncements.Visible       = true;
            grdPets.Visible                = false;
            lblAnnouncementsHeader.Visible = true;
            lblPetsHeader.Visible          = false;
        }
Exemple #5
0
        protected void grdVet_RowUpdating(object sender, GridViewUpdateEventArgs e)
        {
            Label    id           = (Label)grdVet.Rows[e.RowIndex].FindControl("lblVetID");
            TextBox  name         = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtVetName");
            TextBox  surname      = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtVetSurname");
            TextBox  eMailAddress = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtEmail");
            TextBox  password     = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtPassword");
            TextBox  phoneNumber  = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtPhone");
            TextBox  age          = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtAge");
            TextBox  gender       = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtGender");
            TextBox  photo        = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtPhoto");
            TextBox  address      = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtAddress");
            TextBox  city         = (TextBox)grdVet.Rows[e.RowIndex].FindControl("txtCity");
            CheckBox approval     = (CheckBox)grdVet.Rows[e.RowIndex].FindControl("checkApproval");

            DatabaseEntities db = new DatabaseEntities();
            int id1             = Convert.ToInt32(id.Text);

            VETS v = (from x in db.VETS where x.approvalSituation == true && x.vetID == id1 && x.isActive == true select x).SingleOrDefault();

            v.name              = name.Text;
            v.surname           = surname.Text;
            v.emailAddress      = eMailAddress.Text;
            v.password          = password.Text;
            v.phoneNumber       = phoneNumber.Text;
            v.age               = Convert.ToInt32(age.Text);
            v.gender            = gender.Text;
            v.photoURL          = photo.Text;
            v.address           = address.Text;
            v.city              = city.Text;
            v.approvalSituation = approval.Checked;
            db.SaveChanges();

            VETS[] v1 = (from x in db.VETS where x.approvalSituation == true && x.isActive == true select x).ToArray();
            grdVet.DataSource = v1;
            grdVet.DataBind();
        }
Exemple #6
0
        protected void btnLogin_Click(object sender, EventArgs e)
        {
            string email    = txtEmail.Text;
            string password = txtPassword.Text;

            DatabaseEntities db = new DatabaseEntities();

            USERS u = (from x in db.USERS
                       where x.emailAddress == email && x.password == password && x.approvalSituation == true && x.isActive == true
                       select x).SingleOrDefault();

            if (u == null)
            {
                ADMINISTRATORS a = (from x in db.ADMINISTRATORS
                                    where x.companyEmail == email && x.password == password && x.isActive == true
                                    select x).SingleOrDefault();

                if (a == null)
                {
                    VETS v = (from x in db.VETS
                              where x.emailAddress == email && x.password == password && x.isActive == true
                              select x).SingleOrDefault();

                    if (v == null)
                    {
                        lblMessage.Visible = true;
                        lblMessage.Text    = "Please check your information !";
                    }

                    else
                    {
                        if (cbRememberMe.Checked)
                        {
                            Response.Cookies["Email"].Value   = txtEmail.Text;
                            Response.Cookies["Email"].Expires = DateTime.Now.AddHours(8);

                            Response.Cookies["Password"].Value   = txtPassword.Text;
                            Response.Cookies["Password"].Expires = DateTime.Now.AddHours(8);
                        }

                        else
                        {
                            if (Request.Cookies["Email"] != null && Request.Cookies["Password"] != null)
                            {
                                Response.Cookies["Email"].Expires    = DateTime.Now.AddHours(-1);
                                Response.Cookies["Password"].Expires = DateTime.Now.AddHours(-1);
                            }
                        }

                        Session["Vet"] = v;

                        Application.Lock();
                        Application["Counter"] = Convert.ToInt32(Application["Counter"]) + 1;
                        Application.UnLock();

                        Response.Redirect("VetHomePage.aspx");
                    }
                }

                else
                {
                    if (cbRememberMe.Checked)
                    {
                        Response.Cookies["Email"].Value   = txtEmail.Text;
                        Response.Cookies["Email"].Expires = DateTime.Now.AddHours(8);

                        Response.Cookies["Password"].Value   = txtPassword.Text;
                        Response.Cookies["Password"].Expires = DateTime.Now.AddHours(8);
                    }

                    else
                    {
                        if (Request.Cookies["Email"] != null && Request.Cookies["Password"] != null)
                        {
                            Response.Cookies["Email"].Expires    = DateTime.Now.AddHours(-1);
                            Response.Cookies["Password"].Expires = DateTime.Now.AddHours(-1);
                        }
                    }

                    Session["Admin"] = a;

                    Application.Lock();
                    Application["Counter"] = Convert.ToInt32(Application["Counter"]) + 1;
                    Application.UnLock();

                    Response.Redirect("AdminHomePage.aspx");
                }
            }

            else
            {
                if (cbRememberMe.Checked)
                {
                    Response.Cookies["Email"].Value   = txtEmail.Text;
                    Response.Cookies["Email"].Expires = DateTime.Now.AddHours(8);

                    Response.Cookies["Password"].Value   = txtPassword.Text;
                    Response.Cookies["Password"].Expires = DateTime.Now.AddHours(8);
                }

                else
                {
                    if (Request.Cookies["Email"] != null && Request.Cookies["Password"] != null)
                    {
                        Response.Cookies["Email"].Expires    = DateTime.Now.AddHours(-1);
                        Response.Cookies["Password"].Expires = DateTime.Now.AddHours(-1);
                    }
                }

                Session["User"] = u;

                Application.Lock();
                Application["Counter"] = Convert.ToInt32(Application["Counter"]) + 1;
                Application.UnLock();

                Response.Redirect("UserHomePage.aspx");
            }
        }
Exemple #7
0
        protected void btnRegister_Click(object sender, EventArgs e)
        {
            DatabaseEntities db = new DatabaseEntities();

            USERS u = (from x in db.USERS
                       where x.emailAddress == txtEmail.Text
                       select x).SingleOrDefault();

            if (u == null)
            {
                VETS v = (from x in db.VETS
                          where x.emailAddress == txtEmail.Text
                          select x).SingleOrDefault();

                if (v == null)
                {
                    if (ddlUserTypes.SelectedValue == "User")
                    {
                        USERS newUser = new USERS();
                        newUser.name         = txtName.Text;
                        newUser.surname      = txtSurname.Text;
                        newUser.emailAddress = txtEmail.Text;
                        newUser.password     = txtPassword.Text;
                        newUser.phoneNumber  = txtPhoneNumber.Text;
                        newUser.age          = Convert.ToInt32(txtAge.Text);
                        newUser.gender       = ddlGender.SelectedValue;
                        newUser.address      = txtAddress.Text;
                        newUser.city         = txtCity.Text;
                        fuImage.SaveAs(Server.MapPath("~/Photos/" + fuImage.FileName));
                        newUser.photoURL          = "~/Photos/" + fuImage.FileName;
                        newUser.isActive          = true;
                        newUser.approvalSituation = false;
                        db.USERS.Add(newUser);
                        db.SaveChanges();
                    }

                    else if (ddlUserTypes.SelectedValue == "Veterinary")
                    {
                        VETS newVet = new VETS();
                        newVet.name         = txtName.Text;
                        newVet.surname      = txtSurname.Text;
                        newVet.emailAddress = txtEmail.Text;
                        newVet.password     = txtPassword.Text;
                        newVet.phoneNumber  = txtPhoneNumber.Text;
                        newVet.age          = Convert.ToInt32(txtAge.Text);
                        newVet.gender       = ddlGender.SelectedValue;
                        newVet.address      = txtAddress.Text;
                        newVet.city         = txtCity.Text;
                        fuImage.SaveAs(Server.MapPath("~/Photos/" + fuImage.FileName));
                        newVet.photoURL          = "~/Photos/" + fuImage.FileName;
                        newVet.isActive          = true;
                        newVet.approvalSituation = false;
                        db.VETS.Add(newVet);
                        db.SaveChanges();
                    }

                    lblMessage.Visible = true;
                    lblMessage.Text    = "Your information has been successfully saved.";

                    clear();
                }

                else
                {
                    lblMessage.Visible = true;
                    lblMessage.Text    = "Your e-mail registered already !";
                }
            }

            else
            {
                lblMessage.Visible = true;
                lblMessage.Text    = "Your e-mail registered already !";
            }
        }