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 !"; } }