protected void Page_Load(object sender, EventArgs e)
{
DBServicesAPP dbs = new DBServicesAPP();
JavaScriptSerializer serializer = new JavaScriptSerializer();
//DataTable getCities;
// DataTable getAnimalTypes;
DataTable Products;
try
{
Products = dbs.getProducts();
}
catch (Exception ex)
{
Logger.writeToLog(LoggerLevel.ERROR, "page :InjuredPet.aspx.cs, the exeption message is : " + ex.Message);
throw;
}
Products.Columns[0].ColumnName = "id";
Products.Columns[1].ColumnName = "name";
// string jsonStringProducts = "{\"Products\":" + serializer.Serialize(SerializeTable(Products)) + "}";
string jsonStringProducts = serializer.Serialize(SerializeTable(Products));
Response.Write(jsonStringProducts);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
DBServicesAPP dbs = new DBServicesAPP();
if (Request.QueryString == null)
{
Response.End();
return;
}
NameValueCollection requestQuery = Request.QueryString;
JavaScriptSerializer serializer = new JavaScriptSerializer();
DataTable ShoppingList;
try
{
string UserId = requestQuery["UserId"];
ShoppingList = dbs.ShowShoppingList_byUserId(UserId);
}
catch (Exception ex)
{
Logger.writeToLog(LoggerLevel.ERROR, "page :ShowShoppingList.aspx.cs, the exeption message is : " + ex.Message);
throw;
}
string jsonStringShoppingList = serializer.Serialize(SerializeTable(ShoppingList));
Response.Write(jsonStringShoppingList);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
DBServicesAPP dbs = new DBServicesAPP();
JavaScriptSerializer serializer = new JavaScriptSerializer();
DataTable ProductCategories;
try
{
ProductCategories = dbs.GetProductCategories(); // 1 is shabat imutz
}
catch (Exception ex)
{
Logger.writeToLog(LoggerLevel.ERROR, "page :ActivityShabatDog.aspx.cs, the exeption message is : " + ex.Message);
throw;
}
ProductCategories.Columns[0].ColumnName = "Code";
ProductCategories.Columns[1].ColumnName = "Name";
string jsonStringCategories = serializer.Serialize(SerializeTable(ProductCategories));
string jsonString = "{\"Categories\":" + jsonStringCategories + "}";
Response.Write(jsonString);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
DBServicesAPP dbs = new DBServicesAPP();
if (Request.QueryString == null)
{
Response.End();
return;
}
NameValueCollection requestQuery = Request.QueryString;
try
{
string UserId = requestQuery["UserId"];
dbs.FinishShopping(UserId);
}
catch (Exception ex)
{
Logger.writeToLog(LoggerLevel.ERROR, "page :ActivityShow.aspx.cs, the exeption message is : " + ex.Message);
}
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
DBServicesAPP dbs = new DBServicesAPP();
if (Request.QueryString == null)
{
Response.End();
return;
}
NameValueCollection requestQuery = Request.QueryString;
try
{
string Product_list_id = requestQuery["Product_list_id"];
string RemoveOrDelete = requestQuery["RemoveOrDelete"];
Product_list_id = Product_list_id.Replace("ID", "");
//remove the purchesd products id's
int index = Product_list_id.IndexOf(",P");
if (index > 0)
{
Product_list_id = Product_list_id.Substring(0, index);
}
if (RemoveOrDelete == "1") // remove product from list - update IsPurchesd=true
{
dbs.RemoveProduct(Product_list_id);
}
else if (RemoveOrDelete == "2" && Product_list_id.Contains("P") == false) // delete product from list
{
dbs.DeleteProduct(Product_list_id);
}
}
catch (Exception ex)
{
if (ex.Message.Contains("Violation of UNIQUE KEY constraint"))
{
Response.StatusCode = 999;
}
else
{
Response.StatusCode = 1; //general error
Logger.writeToLog(LoggerLevel.ERROR, "page :ActivityRequestDogTour.aspx.cs, Faild to insertRequest. the exeption message is : " + ex.Message);
//send mail to systemsupport + log
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
DBServicesAPP dbs = new DBServicesAPP();
JavaScriptSerializer serializer = new JavaScriptSerializer();
DataTable UserDetails = new DataTable();
if (Request.QueryString == null)
{
Response.End();
return;
}
NameValueCollection workerDetailQS = Request.QueryString;
string UserNameString = workerDetailQS["id"];
string passwordString = workerDetailQS["password"];
try
{
UserDetails = dbs.getUserDedails(UserNameString, passwordString);
if (passwordString != UserDetails.Rows[0].ItemArray[0].ToString())
{
Response.StatusCode = 1; // user name exists BUT password is not correct
}
}
catch (Exception ex)
{
Logger.writeToLog(LoggerLevel.ERROR, "page :loginPage.aspx.cs, the exeption message is : " + ex.Message);
Response.StatusCode = 3; // empty pass and user name
}
UserDetails.Columns[1].ColumnName = "id";
string jsonStringUserDetails = serializer.Serialize(SerializeTable(UserDetails));
//string a = "[{UserId:1}]";//[{"UserPassword":"******","id":1}]
Response.Write(jsonStringUserDetails);
Response.End();
}
protected void Page_Load(object sender, EventArgs e)
{
DBServicesAPP dbs = new DBServicesAPP();
if (Request.QueryString == null)
{
Response.End();
return;
}
NameValueCollection requestQuery = Request.QueryString;
try
{
Product product = new Product()
{
Product_amount = requestQuery["Prodect_amount"],
Product_id = requestQuery["Product_id"],
Units = requestQuery["Units"],
Comment = requestQuery["Comment"],
UserId = requestQuery["UserId"],
};
dbs.insertProductToList(product);
}
catch (Exception ex)
{
if (ex.Message.Contains("AnimelType_id_FK1"))
{
Response.StatusCode = 1; // must choose AnimelType
}
else
{
Response.StatusCode = 999; //general error
Logger.writeToLog(LoggerLevel.ERROR, "page :InjuredPet_Incident.aspx.cs, the exeption message is : " + ex.Message);
//send mail to systemsupport
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request.QueryString == null)
{
Response.End();
return;
}
NameValueCollection workerDetailQS = Request.QueryString;
List <string> UserDetailsList = new List <string>();
UserDetailsList.Add(workerDetailQS["NewUNTB"]);
UserDetailsList.Add(workerDetailQS["NewPassTB"]);
try
{
DBServicesAPP dbs = new DBServicesAPP();
NewUserID = dbs.CreateNewUser(UserDetailsList); //create new user and returns the New User ID
}
catch (Exception ex)
{
Logger.writeToLog(LoggerLevel.ERROR, "page :loginPage.aspx.cs, the exeption message is : " + ex.Message);
Response.StatusCode = 3; // empty pass and user name
}
NewUserID.Columns[0].ColumnName = "id";
string jsonStringuserID = serializer.Serialize(SerializeTable(NewUserID));
Response.Write(jsonStringuserID);
Response.End();
}
