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