protected void Page_Load(object sender, EventArgs e)
{
oDB = new DB.Data();
//Submit.Click += new EventHandler(this.Submit_Click);
// btnLogin.ServerClick += new EventHandler(this.btnLogin_ServerClick);
error.Text = "";
}
protected void Page_Load(object sender, EventArgs e)
{
PetStore.DB.Data oDB;
oDB = new PetStore.DB.Data();
string mainCategory = "";
string categoryName = "";
mainCategory = Request.QueryString["pettype"];
if (mainCategory == null)
{
mainCategory = "DOG";
}
if (mainCategory == "DOG")
{
imgCategory.ImageUrl = "../Images/dogbanner.jpg";
}
else if (mainCategory == "CAT")
{
imgCategory.ImageUrl = "../Images/catbanner.jpg";
}
else if (mainCategory == "FISH")
{
imgCategory.ImageUrl = "../Images/fishbanner.jpg";
}
else if (mainCategory == "BIRD")
{
imgCategory.ImageUrl = "../Images/birdbanner.jpg";
}
}
protected void Page_Load(object sender, EventArgs e)
{
PetStore.DB.Data oDB = new PetStore.DB.Data();
mainCategory = "";
categoryName = "";
mainCategory = Request.QueryString["MainCat"];
categoryName = Request.QueryString["Cat"];
if (mainCategory == null)
{
mainCategory = "DOG";
}
if (categoryName == null)
{
categoryName = oDB.GetFirstCategoryForMainCategory(mainCategory);
}
DataTable dtCategories = new DataTable();
dtCategories = oDB.GetCategories(mainCategory); //, categoryName);
rptLeftNav.DataSource = dtCategories;
rptLeftNav.DataBind();
//string url = HttpContext.Current.Request.Url.AbsoluteUri; // http://localhost:1302/TESTERS/Default6.aspx
////home product calendar checjlist vet login, faq
//if (url.Contains("dog")) { LeftStyleType = "DOG"; }
//else if (url.Contains("cat")) { LeftStyleType = "CAT"; }
//else if (url.Contains("fish")) { LeftStyleType = "FISH"; }
//else if (url.Contains("bird")) { LeftStyleType = "BIRD"; }
}
protected void rptShoppingCart_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
oShoppingCartCollection = (ShoppingCartCollection)Session["ShoppingCart"];
PetStore.DB.Data oDB = new PetStore.DB.Data();
HiddenField RemoveItem = (HiddenField)e.Item.FindControl("hidItem");
switch (e.CommandName.ToUpper())
{
case "REMOVE":
foreach (ShoppingCart eachItem in oShoppingCartCollection)
{
if (eachItem.Item == RemoveItem.Value)
{
oShoppingCartCollection.Delete(eachItem);
break;
}
}
Session["ShoppingCart"] = oShoppingCartCollection;
Response.Redirect("checkout.aspx");
break;
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
PetName = "";
PetName = Request.QueryString["Name"];
if (Session["User"] != null)
{
oUser = (PetStore.Class.User)Session["User"];
oDB = new PetStore.DB.Data();
if (PetName == null)
{
PetName = oDB.GetFirstPetName(oUser.ID);
}
if (PetName == "")
{
noPet.Style.Add("display", "");
noPet.Text = "There is no pet registered.";
}
else
{
DataTable dtPets = new DataTable();
dtPets = oDB.GetPet(oUser.ID, ""); //, categoryName);
rptLeftNav.DataSource = dtPets;
rptLeftNav.DataBind();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
PetStore.DB.Data oDB = new PetStore.DB.Data();
rptVet.DataSource = oDB.GetUsers();;
rptVet.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
string pettype = "";
pettype = Request.QueryString["PetType"];
if (pettype == null || pettype == "")
{
pettype = "DOG";
}
PetStore.DB.Data oDB = new PetStore.DB.Data();
rptVet.DataSource = oDB.GetCheckList(pettype);;
rptVet.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
oDB = new DB.Data();
error.Style.Add("display", "none");
string needlogout = "";
needlogout = Request.QueryString["logout"];
if (needlogout == "Y")
{
Session["User"] = null;
Session["ShoppingCart"] = null;
Response.Redirect("home.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
txtError.Text = "";
oProduct = new Product();
oDB = new PetStore.DB.Data();
string pid = "";
string CAT = "";
pid = Request.QueryString["pid"];
CAT = Request.QueryString["CAT"];
oProduct = oDB.GetProduct(Convert.ToInt32(pid));
itemTitle.Text = oProduct.Item;
itemDescription.Text = oProduct.Description;
itemPrice.Text = oProduct.Price.ToString();
itemImage.ImageUrl = oProduct.Image;
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
oDB = new DB.Data();
DateTime temp;
if (DateTime.TryParse(sAge, out temp))
{
Debug.WriteLine(sAge);
oDB.UpdatePet(sFirstName, sOldName, oUser.ID, sAge, sWeight, sType);
Response.Redirect("pet.aspx");
}
else
{
Age.Text = "Invalid Date Input";
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
oDB = new DB.Data();
DateTime temp;
if (DateTime.TryParse(Age.Text, out temp))
{
oDB.UpdatePet(txtFirstname.Text, "", oUser.ID, Age.Text, Weight.Text, ddlType.SelectedValue);
result.Style.Add("display", "");
result.Text = "The profile has been updated. Please add your pet(s).";
Response.Redirect("pet.aspx?Name=" + txtFirstname.Text);
}
else
{
Age.Text = "Invalid Date Input";
}
}
protected void Page_Load(object sender, EventArgs e)
{
notRegisteredError.Style.Add("display", "none");
if (Session["User"] == null)
{
notRegisteredError.Style.Add("display", "");
notRegisteredError.Text = "Only registered users can use this feature";
}
else
{
PetStore.Class.User oUser = (PetStore.Class.User)Session["User"];
DataTable dtCity = new DataTable();
PetStore.DB.Data oDB = new PetStore.DB.Data();
rptOrder.DataSource = oDB.GetOrders(oUser.ID);;
rptOrder.DataBind();
}
}
protected void rptVet_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
PetStore.DB.Data oDB = new PetStore.DB.Data();
HiddenField userID = (HiddenField)e.Item.FindControl("userID");
HiddenField IsBlocked = (HiddenField)e.Item.FindControl("IsBlocked");
if (IsBlocked.Value == "")
{
Button unblockButton = (Button)e.Item.FindControl("btnUnblockUser");
unblockButton.Style.Add("display", "none");
}
else
{
Button blockButton = (Button)e.Item.FindControl("btnBlockUser");
blockButton.Style.Add("display", "none");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
PetStore.DB.Data oDB;
oDB = new PetStore.DB.Data();
string mainCategory = "";
string categoryName = "";
mainCategory = Request.QueryString["MainCat"];
categoryName = Request.QueryString["Cat"];
if (mainCategory == null)
{
mainCategory = "DOG";
}
if (categoryName == null)
{
categoryName = oDB.GetFirstCategoryForMainCategory(mainCategory);
}
////if (mainCategory == "DOG") { ldog.Attributes.Add("class", "headerNavSelected"); imgCategory.ImageUrl = "../Images/dogbanner.jpg"; }
////else if (mainCategory == "CAT") { lcat.Attributes.Add("class", "headerNavSelected"); imgCategory.ImageUrl = "../Images/catbanner.jpg"; }
////else if (mainCategory == "FISH") { lfish.Attributes.Add("class", "headerNavSelected"); imgCategory.ImageUrl = "../Images/fishbanner.jpg"; }
////else if (mainCategory == "BIRD") { lbird.Attributes.Add("class", "headerNavSelected"); imgCategory.ImageUrl = "../Images/birdbanner.jpg"; }
if (mainCategory == "DOG")
{
imgCategory.ImageUrl = "../Images/newdog.jpg";
}
else if (mainCategory == "CAT")
{
imgCategory.ImageUrl = "../Images/newcat.png";
}
else if (mainCategory == "FISH")
{
imgCategory.ImageUrl = "../Images/newfish.jpg";
}
else if (mainCategory == "BIRD")
{
imgCategory.ImageUrl = "../Images/newbird.jpg";
}
}
protected void Page_Load(object sender, EventArgs e)
{
oDB = new PetStore.DB.Data();
if (!IsPostBack)
{
txtError.Text = "";
if (Session["ShoppingCart"] != null)
{
oShoppingCartCollection = (ShoppingCartCollection)Session["ShoppingCart"];
}
else
{
oShoppingCartCollection = new ShoppingCartCollection();
}
string mainCategory = "";
string categoryName = "";
mainCategory = Request.QueryString["MainCat"];
categoryName = Request.QueryString["Cat"];
if (mainCategory == null)
{
mainCategory = "DOG";
}
if (categoryName == null)
{
categoryName = oDB.GetFirstCategoryForMainCategory(mainCategory);
}
//if (mainCategory == "DOG") { ldog.Attributes.Add("class", "headerNavSelected"); imgCategory.ImageUrl = "../Images/dogbanner.jpg"; }
//else if (mainCategory == "CAT") { lcat.Attributes.Add("class", "headerNavSelected"); imgCategory.ImageUrl = "../Images/catbanner.jpg"; }
//else if (mainCategory == "FISH") { lfish.Attributes.Add("class", "headerNavSelected"); imgCategory.ImageUrl = "../Images/fishbanner.jpg"; }
//else if (mainCategory == "BIRD") { lbird.Attributes.Add("class", "headerNavSelected"); imgCategory.ImageUrl = "../Images/birdbanner.jpg"; }
categoryTitle.Text = oDB.GetCategoryTitle(mainCategory, categoryName);
DataTable dtProduct = new DataTable();
dtProduct = oDB.GetProductByCategory(mainCategory, categoryName);
rptProduct.DataSource = dtProduct;
rptProduct.DataBind();
}
}
protected void rptVet_ItemsCommand(Object Sender, RepeaterCommandEventArgs e)
{
try
{
PetStore.DB.Data oDB = new PetStore.DB.Data();
HiddenField userID = (HiddenField)e.Item.FindControl("userID");
switch (e.CommandName.ToUpper())
{
case "BLOCK":
oDB.BlockUser(userID.Value);
Response.Redirect("admin.aspx");
break;
case "UNBLOCK":
oDB.UnblockUser(userID.Value);
Response.Redirect("admin.aspx");
break;
}
}
catch
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
oDB = new DB.Data();
error.Style.Add("display", "none");
result.Style.Add("display", "none");
if (!IsPostBack)
{
//if (Session["User"] != null)
//{
// PageTitle.Text = "Update my account";
// oUser = (PetStore.Class.User)Session["User"];
// txtFirstname.Text = oUser.Address;
// oUser.City = txtLastName.Text = oUser.City;
// txtEmail.Text = oUser.Email;
// txtFirstname.Text = oUser.FirstName;
// txtLastName.Text = oUser.LastName;
// txtPassword.Text = oUser.Password;
// txtAddress.Text = oUser.Address;
// txtCity.Text = oUser.City;
// //oUser.PetType = ddlPettype.SelectedItem.Value;
// txtPhone.Text = oUser.Phone;
// txtPostal.Text = oUser.PostalCode;
// txtProv.Text = oUser.Province;
//}
//else
//{
// //result.Style.Add("display", "");
// //result.Text = "The profile has been created.";
//}
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
oDB = new DB.Data();
oDB.DeletePet(txtFirstname.Text, oUser.ID);
Response.Redirect("pet.aspx");
}
protected void Page_Load(object sender, EventArgs e)
{
oDB = new DB.Data();
oUser = (PetStore.Class.User)Session["User"];
btnUpdate.Text = "ADD";
}
protected void Page_Load(object sender, EventArgs e)
{
oDB = new DB.Data();
error.Style.Add("display", "none");
result.Style.Add("display", "none");
string CreateMsg = "";
CreateMsg = Request.QueryString["Created"];
if (CreateMsg == "Y")
{
result.Style.Add("display", "");
result.Text = "The profile has been created.";
PropertyInfo isreadonly =
typeof(System.Collections.Specialized.NameValueCollection).GetProperty(
"IsReadOnly", BindingFlags.Instance | BindingFlags.NonPublic);
// make collection editable
isreadonly.SetValue(this.Request.QueryString, false, null);
// remove
this.Request.QueryString.Remove("Created");
}
if (!IsPostBack)
{
btnSubmit.Style.Add("display", "none");
btnUpdate.Style.Add("display", "none");
if (Session["User"] != null)
{
PageTitle.Text = "Update my account";
btnUpdate.Style.Add("display", "");
oUser = (PetStore.Class.User)Session["User"];
update = true;
txtFirstname.Text = oUser.Address;
oUser.City = txtLastName.Text = oUser.City;
txtEmail.Text = oUser.Email;
txtEmail.Enabled = false;
txtFirstname.Text = oUser.FirstName;
txtLastName.Text = oUser.LastName;
txtPassword.Text = oUser.Password;
txtAddress.Text = oUser.Address;
txtCity.Text = oUser.City;
//oUser.PetType = ddlPettype.SelectedItem.Value;
txtPhone.Text = oUser.Phone;
txtPostal.Text = oUser.PostalCode;
txtProv.Text = oUser.Province;
}
else
{
PageTitle.Text = "Register";
btnSubmit.Style.Add("display", "");
DataTable dtPetType = new DataTable();
dtPetType = oDB.GetPetType();
//ddlPettype.DataSource = dtPetType;
//ddlPettype.DataValueField = "PetType";
//ddlPettype.DataTextField = "Description";
//ddlPettype.DataBind();
//ddlPettype.Items.Insert(0, new ListItem("--Select your pet type--", ""));
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (String.IsNullOrEmpty(txtEmail.Text))
{
error.Style.Add("display", "");
result.Style.Add("display", "none");
}
else
{
oUser = new Class.User();
oDB = new PetStore.DB.Data();
oUser.Email = txtEmail.Text;
if (oDB.IsUserExist(oUser))
{
oUser = oDB.Login(txtEmail.Text, "tempassword12345");
//Guid oGuid = Guid.NewGuid();
Random oRandom = new Random();
int tempPassword = oRandom.Next(100000);
oUser.Password = oUser.LastName + tempPassword.ToString();
oDB.UpdateUser(oUser); //update the password with new password
//send an email witht the Guid password
SmtpClient smtpClient = new SmtpClient();
MailMessage oMessage1 = new MailMessage();
oMessage1.Subject = "New password for One stop pet shop";
oMessage1.Body = "Hi, here is the new password, '" + oUser.Password + "'. <br/> Once you log in the site, please update your password again.";
oMessage1.IsBodyHtml = true;
oMessage1.To.Add(new MailAddress(txtEmail.Text));
oMessage1.From = new MailAddress("*****@*****.**"); // https://www.google.com/settings/security/lesssecureapps
smtpClient.Send(oMessage1);
//// SmtpClient client1 = new SmtpClient();
//// client1.Host = "smtp.gmail.com";
//// client1.Port = 587;
//// client1.UseDefaultCredentials = false;
//// client1.DeliveryMethod = SmtpDeliveryMethod.Network;
//// client1.EnableSsl = true;
//// client1.Credentials = new NetworkCredential("*****@*****.**", "sendingemail");
////MailMessage oMessage = new MailMessage();
//// oMessage.Subject = "hello";
//// oMessage.Body = "body";
//// oMessage.To.Add(new MailAddress(txtEmail.Text));
//// oMessage.From = new MailAddress("*****@*****.**");
//// client1.Send(oMessage);
//// MailMessage objeto_mail = new MailMessage();
//// SmtpClient client3 = new SmtpClient();
//// client3.Port = 587;
//// client3.Host = "smtp.gmail.com";
//// client3.Timeout = 10000;
//// client3.DeliveryMethod = SmtpDeliveryMethod.Network;
//// client3.UseDefaultCredentials = false;
//// client3.EnableSsl = true;
//// client3.Credentials = new System.Net.NetworkCredential("*****@*****.**", "sendingemail");
//// objeto_mail.From = new MailAddress("*****@*****.**");
//// objeto_mail.To.Add(new MailAddress(txtEmail.Text));
//// objeto_mail.Subject = "Password Recover";
//// objeto_mail.Body = "Message";
//// client3.Send(objeto_mail);
result.Style.Add("display", "");
}
else
{
error.Style.Add("display", "");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
oDB = new DB.Data();
PetName = "";
notRegisteredError.Style.Add("display", "none");
DataTable dtDates = new DataTable();
DataTable dtPet = new DataTable();
oUser = (PetStore.Class.User)Session["User"];
if (btnBookApnt.Text == "1")
{
btnBookApnt.Text = "BOOK APPOINTMENT";
}
ApntBooked.Style.Add("display", "none");
ShowDateInput.Style.Add("display", "none");
notRegisteredError.Style.Add("display", "none");
if (Session["User"] == null)
{
notRegisteredError.Style.Add("display", "");
notRegisteredError.Text = "Only registered users can use this feature";
vetpagecontent.Style.Add("display", "none");
}
else
{
PetName = oDB.GetFirstPetName(oUser.ID);
oUser = (PetStore.Class.User)Session["User"];
dtVet = oDB.GetVets();
int i = 0;
q = 0;
string myTable = "";
foreach (DataRow row in dtVet.Rows)
{
if (dtVet.Rows[i]["City"].ToString() == oUser.City)
{
description[q] = dtVet.Rows[i]["description"].ToString();
VetTitle[q] = dtVet.Rows[i]["Title"].ToString();
Address[q] = dtVet.Rows[i]["Address"].ToString();
City[q] = dtVet.Rows[i]["City"].ToString();
province[q] = dtVet.Rows[i]["province"].ToString();
postalcode[q] = dtVet.Rows[i]["Postal"].ToString();
url[q] = dtVet.Rows[i]["url"].ToString();
logo[q] = dtVet.Rows[i]["logo"].ToString();
vetaddress[q] = dtVet.Rows[i]["Address"].ToString() + ", " + dtVet.Rows[i]["City"].ToString() + ", " + dtVet.Rows[i]["province"].ToString() + ", " + dtVet.Rows[i]["Postal"].ToString();
myTable += "<table>";
myTable += "<tr>";
myTable += "<td> <a href=" + url[q] + "> <img style='max-height: 180px; max-width: 180px' src=" + logo[q] + " /></a></td>";
myTable += "</tr>";
myTable += "<tr>";
myTable += "<td><b> <a href=" + url[q] + ">" + VetTitle[q] + "</a></b></td>";
myTable += "</tr>";
myTable += "<tr>";
myTable += "<td>" + vetaddress[q] + " </td>";
myTable += "</tr>";
myTable += "<br>";
if (!this.IsPostBack)
{
ddlVet.Items.Add(new ListItem(VetTitle[q], VetTitle[q]));
}
q++;
}
i++;
}
myTable += "</table>";
tablePrint.InnerHtml = myTable;
if (!this.IsPostBack)
{
ddlPet.Items.Insert(0, new ListItem("", ""));
int n = 0;
DataTable dtPets = new DataTable();
dtPets = oDB.GetPets(oUser.ID);
foreach (DataRow row in dtPets.Rows)
{
ddlPet.Items.Add(new ListItem(dtPets.Rows[n]["Name"].ToString(), dtPets.Rows[n]["Name"].ToString()));
n++;
}
}
// rptVet.DataSource = oDB.GetVets(); ;
// rptVet.DataBind();
if (PetName == "")
{
btnBookApnt.Style.Add("display", "none");
}
} // end else
} // end page load
protected void Page_Load(object sender, EventArgs e)
{
oDB = new DB.Data();
PetName = "";
PetName = Request.QueryString["Name"];
notRegisteredError.Style.Add("display", "none");
if (Session["User"] == null)
{
notRegisteredError.Style.Add("display", "");
notRegisteredError.Text = "Only registered users can use this feature";
pageContent.Style.Add("display", "none");
btnUpdate.Text = "ADD";
btnDelete.Style.Add("style", "none");
}
else if (PetName == null)
{
oUser = (PetStore.Class.User)Session["User"];
PetName = oDB.GetFirstPetName(oUser.ID);
if (PetName == "")
{
oUser = (PetStore.Class.User)Session["User"];
Div1.Style.Add("display", "none");
}
else
{
btnUpdate.Text = "UPDATE";
NewButton.Style.Add("display", "none");
DataTable dtPets = new DataTable();
dtPets = oDB.GetPet(oUser.ID, PetName); //, categoryName);
sFirstName = txtFirstname.Text;
sOldName = dtPets.Rows[0]["Name"].ToString();
txtFirstname.Text = sOldName;
sWeight = Weight.Text;
sOldWeight = dtPets.Rows[0]["Weight"].ToString();
Weight.Text = sOldWeight;
sAge = Age.Text;
sOldAge = dtPets.Rows[0]["DOB"].ToString();
Age.Text = sOldAge;
sType = ddlType.SelectedValue;
sOldType = dtPets.Rows[0]["Type"].ToString();
ddlType.ClearSelection();
ddlType.Items.FindByValue(sOldType).Selected = true;
}
}
else
{
oUser = (PetStore.Class.User)Session["User"];
btnUpdate.Text = "UPDATE";
NewButton.Style.Add("display", "none");
DataTable dtPets = new DataTable();
dtPets = oDB.GetPet(oUser.ID, PetName);
sFirstName = txtFirstname.Text;
sOldName = dtPets.Rows[0]["Name"].ToString();
txtFirstname.Text = sOldName;
sWeight = Weight.Text;
sOldWeight = dtPets.Rows[0]["Weight"].ToString();
Weight.Text = sOldWeight;
sAge = Age.Text;
sOldAge = dtPets.Rows[0]["DOB"].ToString();
Age.Text = sOldAge;
sType = ddlType.SelectedValue;
sOldType = dtPets.Rows[0]["Type"].ToString();;
ddlType.ClearSelection();
ddlType.Items.FindByValue(sOldType).Selected = true;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["Calendar"] = oCalendar;
oCalendar = new Class.Calendar();
oDB = new DB.Data();
PetName = "";
PetName = Request.QueryString["Name"];
notRegisteredError.Style.Add("display", "none");
DataTable dtDates = new DataTable();
DataTable dtPet = new DataTable();
DeleteSelection.Style.Add("display", "none");
DeleteCompleted.Style.Add("display", "none");
ShowDateInput.Style.Add("display", "none");
DateMade.Style.Add("display", "none");
notRegisteredError.Style.Add("display", "none");
Error.Style.Add("display", "none");
if (btnAddDate.Text == "1")
{
btnAddDate.Text = "ADD DATE";
}
if (btnDateDelete.Text == "1")
{
btnDateDelete.Text = "DELETE DATE";
}
if (Session["User"] == null)
{
notRegisteredError.Style.Add("display", "");
notRegisteredError.Text = "Only registered users can use this feature";
pagecontent.Style.Add("display", "none");
}
// OpenNewWindow("test.aspx");
else if (PetName == null)
{
oUser = (PetStore.Class.User)Session["User"];
PetName = oDB.GetFirstPetName(oUser.ID);
if (PetName == "")
{
oUser = (PetStore.Class.User)Session["User"];
btnDateDelete.Style.Add("display", "none");
btnAddDate.Style.Add("display", "none");
}
else
{
oUser = (PetStore.Class.User)Session["User"];
dtDates = oDB.GetDates(oUser.ID);
dtPets = oDB.GetPets(oUser.ID);
System.DateTime Today = DateTime.Now;
System.DateTime DateLastDogFoodWasPurchase = Today.AddDays(-7);
System.DateTime DateLastCatFoodWasPurchase = Today.AddDays(-7);
int NumberofDogFoodCans = 20;
int NumberofCatFoodCans = 20;
double DogFoodCaloriesPerOrder = 424 * NumberofDogFoodCans;
double CatFoodCaloriesPerOrder = 424 * NumberofCatFoodCans;
int i = 0;
foreach (DataRow row in dtPets.Rows)
{
if ((Convert.ToString(dtPets.Rows[i]["Type"]) == "Dog"))
{
Date = oCalendar.DogFoodNeeded(Convert.ToDouble(dtPets.Rows[i]["Weight"]), DateLastDogFoodWasPurchase, DogFoodCaloriesPerOrder);
info = dtPets.Rows[i]["Name"].ToString() + " Needs Food on: " + oCalendar.DogFoodNeeded(Convert.ToDouble(dtPets.Rows[i]["Weight"]), DateLastDogFoodWasPurchase, DogFoodCaloriesPerOrder).ToString("MMMM dd, yyyy") + " ";
}
if ((Convert.ToString(dtPets.Rows[i]["Type"]) == "Cat"))
{
Date = oCalendar.CatFoodNeeded(Convert.ToDouble(dtPets.Rows[i]["Weight"]), DateLastCatFoodWasPurchase, CatFoodCaloriesPerOrder);
info = dtPets.Rows[i]["Name"].ToString() + " Needs Food on: " + oCalendar.CatFoodNeeded(Convert.ToDouble(dtPets.Rows[i]["Weight"]), DateLastCatFoodWasPurchase, CatFoodCaloriesPerOrder).ToString("MMMM dd, yyyy") + " ";
}
if ((Convert.ToString(dtPets.Rows[i]["Type"]) == "Fish"))
{
Date = DateTime.Now.AddDays(7);
info = dtPets.Rows[i]["Name"].ToString() + " Needs Their Bowl Cleaned On: " + Date.ToString("MMMM dd, yyyy") + " ";
}
if ((Convert.ToString(dtPets.Rows[i]["Type"]) == "Bird"))
{
Date = DateTime.Now.AddDays(9);
info = dtPets.Rows[i]["Name"].ToString() + " Needs Their Cage Cleaned On: " + Date.ToString("MMMM dd, yyyy") + " ";
}
oDB.DeleteDate(oUser.ID, info);
oDB.AddDate(oUser.ID, dtPets.Rows[i]["Name"].ToString(), Date, info, "");
i++;
}
dtPet = oDB.GetPet(oUser.ID, PetName);
Pet = dtPet.Rows[0]["Name"].ToString();
/*
* int n = 0;
* int z = 0;
* foreach (DataRow row in dtDates.Rows)
* {
* if (dtDates.Rows[z]["Pet"].ToString() == dtPet.Rows[0]["Name"].ToString())
* {
*
* switch (n)
* {
* case 0: Day0.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 1: Day1.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 2: Day2.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 3: Day3.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 4: Day4.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 5: Day5.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 6: Day6.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 7: Day7.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 8: Day8.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 9: Day9.Text = dtDates.Rows[z]["Info"].ToString(); break;
* case 10: Day10.Text = dtDates.Rows[z]["Info"].ToString(); break;
* }
* n++;
* }
* z++;
* }
*/
}//end else
}
else
{
oUser = (PetStore.Class.User)Session["User"];
dtDates = oDB.GetDates(oUser.ID);
dtPets = oDB.GetPets(oUser.ID);
System.DateTime Today = DateTime.Now;
System.DateTime DateLastDogFoodWasPurchase = Today.AddDays(-7);
System.DateTime DateLastCatFoodWasPurchase = Today.AddDays(-7);
int NumberofDogFoodCans = 20;
int NumberofCatFoodCans = 20;
double DogFoodCaloriesPerOrder = 424 * NumberofDogFoodCans;
double CatFoodCaloriesPerOrder = 424 * NumberofCatFoodCans;
int i = 0;
foreach (DataRow row in dtPets.Rows)
{
if ((Convert.ToString(dtPets.Rows[i]["Type"]) == "Dog"))
{
Date = oCalendar.DogFoodNeeded(Convert.ToDouble(dtPets.Rows[i]["Weight"]), DateLastDogFoodWasPurchase, DogFoodCaloriesPerOrder);
info = dtPets.Rows[i]["Name"].ToString() + " Needs Food on: " + oCalendar.DogFoodNeeded(Convert.ToDouble(dtPets.Rows[i]["Weight"]), DateLastDogFoodWasPurchase, DogFoodCaloriesPerOrder).ToString("MMMM dd, yyyy") + " ";
}
if ((Convert.ToString(dtPets.Rows[i]["Type"]) == "Cat"))
{
Date = oCalendar.CatFoodNeeded(Convert.ToDouble(dtPets.Rows[i]["Weight"]), DateLastCatFoodWasPurchase, CatFoodCaloriesPerOrder);
info = dtPets.Rows[i]["Name"].ToString() + " Needs Food on: " + oCalendar.CatFoodNeeded(Convert.ToDouble(dtPets.Rows[i]["Weight"]), DateLastCatFoodWasPurchase, CatFoodCaloriesPerOrder).ToString("MMMM dd, yyyy") + " ";
}
if ((Convert.ToString(dtPets.Rows[i]["Type"]) == "Fish"))
{
Date = DateTime.Now.AddDays(7);
info = dtPets.Rows[i]["Name"].ToString() + " Needs Their Bowl Cleaned On: " + Date.ToString("MMMM dd, yyyy") + " ";
}
if ((Convert.ToString(dtPets.Rows[i]["Type"]) == "Bird"))
{
Date = DateTime.Now.AddDays(9);
info = dtPets.Rows[i]["Name"].ToString() + " Needs Their Cage Cleaned On: " + Date.ToString("MMMM dd, yyyy") + " ";
}
oDB.DeleteDate(oUser.ID, info);
oDB.AddDate(oUser.ID, dtPets.Rows[i]["Name"].ToString(), Date, info, "");
i++;
}
dtPet = oDB.GetPet(oUser.ID, PetName);
Pet = dtPet.Rows[0]["Name"].ToString();
}//end else
if (!this.IsPostBack)
{
ddlDateSelection.Items.Insert(0, new ListItem("", ""));
int q = 0;
foreach (DataRow row in dtDates.Rows)
{
if (dtDates.Rows[q]["Pet"].ToString() == dtPet.Rows[0]["Name"].ToString())
{
ddlDateSelection.Items.Add(new ListItem(dtDates.Rows[q]["Info"].ToString(), dtDates.Rows[q]["Info"].ToString()));
}
q++;
}
}
}// End page load
/// <summary>
/// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void DayRender(object sender, DayRenderEventArgs e)
{
Session["Calendar"] = oCalendar;
oCalendar = new Class.Calendar();
oDB = new DB.Data();
PetName = "";
PetName = Request.QueryString["Name"];
DataTable dtDates = new DataTable();
DataTable dtPet = new DataTable();
Debug.WriteLine(PetName);
if (Session["User"] == null)
{
}
//else if (PetName == null)
//{
// oUser = (PetStore.Class.User)Session["User"];
// PetName = oDB.GetFirstPetName(oUser.ID);
// if (PetName == "")
// {
// oUser = (PetStore.Class.User)Session["User"];
// }
else
{
oUser = (PetStore.Class.User)Session["User"];
dtDates = oDB.GetDates(oUser.ID);
dtPets = oDB.GetPets(oUser.ID);
int i = 0;
DateTime day;
e.Day.IsSelectable = false;
dtPet = oDB.GetPet(oUser.ID, PetName);
foreach (DataRow row in dtDates.Rows)
{
if (dtDates.Rows[i]["Pet"].ToString() == Pet)
{
day = Convert.ToDateTime(dtDates.Rows[i]["Date"]);
day = day.Date;
if (e.Day.Date == day)
{
e.Cell.BackColor = Color.LightBlue;
e.Day.IsSelectable = true;
}
}
i++;
}
if (e.Day.IsToday)
{
e.Cell.BackColor = Color.Tomato;
}
else if (e.Day.IsSelected)
{
e.Cell.BackColor = Color.Orange;
}
// } // end else
//}//end if PetName==Null
}
SqlConnection.ClearAllPools();
}//end dayrender void
