protected void grdUser_RowDeleting(object sender, GridViewDeleteEventArgs e) { GridViewRow row = (GridViewRow)grdUser.Rows[e.RowIndex]; Label lbldeleteid = (Label)row.FindControl("lblUserID"); DatabaseEntities db = new DatabaseEntities(); int id = Convert.ToInt32(lbldeleteid.Text); USERS u = (from x in db.USERS where x.userID == id && x.approvalSituation == true && x.isActive == true select x).SingleOrDefault(); u.isActive = false; db.SaveChanges(); USERS[] u1 = (from x in db.USERS where x.approvalSituation == true && x.isActive == true select x).ToArray(); grdUser.DataSource = u1; grdUser.DataBind(); }
protected void grdAppVet_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = grdAppVet.SelectedRow; int id = Convert.ToInt32(row.Cells[0].Text); DatabaseEntities db = new DatabaseEntities(); VETS[] chosenVet = (from v in db.VETS where v.vetID == id && v.isActive == true select v).ToArray(); chosenVet[0].approvalSituation = true; db.SaveChanges(); VETS[] listOfVets = (from v in db.VETS where v.approvalSituation == false && v.isActive == true select v).ToArray(); grdAppVet.DataSource = listOfVets; grdAppVet.DataBind(); }
protected void grdAppUser_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = grdAppUser.SelectedRow; int id = Convert.ToInt32(row.Cells[0].Text); DatabaseEntities db = new DatabaseEntities(); USERS[] chosenUser = (from u in db.USERS where u.userID == id && u.isActive == true select u).ToArray(); chosenUser[0].approvalSituation = true; db.SaveChanges(); USERS[] listOfUsers = (from u in db.USERS where u.approvalSituation == false && u.isActive == true select u).ToArray(); grdAppUser.DataSource = listOfUsers; grdAppUser.DataBind(); }
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(); }
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(); }
protected void Page_Load(object sender, EventArgs e) { 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(); var query = (from a in db.ANNOUNCEMENTS join u in db.USERS on a.userID equals u.userID join p in db.PETS on a.petID equals p.petID 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, userName = u.name, userSurname = u.surname, userAddress = u.address, userCity = u.city, userMail = u.emailAddress, userPhone = u.phoneNumber }).ToList(); grdAnnouncementsUser.DataSource = query; grdAnnouncementsUser.DataBind(); var query2 = (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 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, vetCity = v.city, vetMail = v.emailAddress, vetPhone = v.phoneNumber }).ToList(); grdAnnouncementsVet.DataSource = query2; grdAnnouncementsVet.DataBind(); }
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 !"; } }