protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack == false)
{
using (TravelDBEntities context = new TravelDBEntities())
{
TravelDAL.Tour tour = new TravelDAL.Tour();
tour = (from item in context.Tour
where item.IDTour == this.id
select item).First();
rating.Text = tour.AverageMark.ToString();
views.Text = ((int)(tour.NumberOfPageVisits + 1)).ToString();
rates.Text = Application["tourvote" + id.ToString()].ToString();
visits = (int)tour.NumberOfPageVisits + 1;
Application.Lock();
tour.NumberOfPageVisits = visits;
context.SaveChanges();
Application.UnLock();
string[] i = Request.Cookies.AllKeys;
if (i.Contains("tourvote" + id.ToString()) && Request.Cookies["tourvote" + id.ToString()].Expires < DateTime.Now)
{
//UpdateButton.Visible = false;
UpdateLabel.Visible = true;
}
else
{
//UpdateButton.Visible = true;
UpdateLabel.Visible = false;
}
}
}
}
public BriefView(int id, bool w)
{
obj = new TravelDAL.Tour();
using (var context = new TravelDBEntities())
{
EntityKey key = new EntityKey("TravelDBEntities.Tour", "IDTour", id);
obj = (TravelDAL.Tour)context.GetObjectByKey(key);
if (obj != null)
{
tourname = obj.Name;
addinfo = obj.AdditionalInfo;
if (addinfo.Length > 120) addinfo = addinfo.Substring(0, 120);
addinfo += "...";
minprice = obj.MinimalPrice.ToString();
avgprice = obj.AveragePrice.ToString();
rating = obj.AverageMark.ToString();
wide = w;
foreach (TravelDAL.Country m in obj.Country)
{
countrynames += m.Name;
countrynames += " ";
}
}
}
}
protected void Application_Start(object sender, EventArgs e)
{
using (TravelDBEntities context = new TravelDBEntities())
{
IQueryable<TravelDAL.Tour> t = from item in context.Tour select item;
foreach (TravelDAL.Tour tour in t)
{
Application["tourvote" + tour.IDTour.ToString()] = 0;
}
}
}
protected void Session_Start(object sender, EventArgs e)
{
using (TravelDBEntities context = new TravelDBEntities())
{
double avg = 0;
double purchases = 0;
IQueryable<TravelDAL.Tour> t = from item in context.Tour select item;
foreach (TravelDAL.Tour tour in t)
{
purchases += (double)tour.NumberOfPurchases;
}
avg = purchases / t.Count();
Application["avg_purchases"] = avg;
}
}
static WorkWithDB()
{
MinTourPriceInBD = 100000;
MaxTourPriceInBD = 0;
using (TravelDBEntities context = new TravelDBEntities())
{
int a = 0;
int b = 0;
foreach (TravelDAL.Tour tur in context.Tour)
{
a = GetMaxOrMinTourPrice(tur.IDTour, false);
b = GetMaxOrMinTourPrice(tur.IDTour, true);
if (MinTourPriceInBD > a) MinTourPriceInBD = a;
if (MaxTourPriceInBD > b) MaxTourPriceInBD = b;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
CurrentTours = new List<int>();
Search.Refresh += new SearchParams.ListHandler(Search_Refresh);
if (!IsPostBack)
{
if(Session["srequest"] != null && this.PreviousPage != null)
{
if(Session["srequest"].ToString() == "true")
{
string s = ((this.PreviousPage.FindControl("mainsearch") as SearchMainWeb).FindControl("searchbox") as TextBox).Text;
CurrentTours = WorkWithDB.AnalyseSearchRequest(s);
}
}
else
{
using (var context = new TravelDBEntities())
{
var list = from item in context.Tour select new { ID = item.IDTour };
foreach (var a in list)
{
CurrentTours.Add(a.ID);
}
}
Search.CurrentTours = this.CurrentTours;
}
}
TravelDAL.Tour obj= new TravelDAL.Tour();
using (var context = new TravelDBEntities())
{
foreach (int id in CurrentTours)
{
EntityKey k = new EntityKey("TravelDBEntities.Tour", "IDTour", id);
obj = (TravelDAL.Tour)context.GetObjectByKey(k);
if (obj != null)
{
BriefView brt = new BriefView(id, true);
brt.BorderColor = System.Drawing.Color.Aquamarine;
Panel.Controls.Add(brt);
}
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int[] mTours;
TravelDAL.Tour obj = new TravelDAL.Tour();
mTours = ListBox1.GetSelectedIndices();
using (TravelDBEntities context = new TravelDBEntities())
{
foreach (int m in mTours)
{
EntityKey key = new EntityKey("TravelDBEntities.Tour", "IDTour",m + 1);
obj = (TravelDAL.Tour)context.GetObjectByKey(key);
if (obj != null)
{
context.DeleteObject(obj);
}
}
context.SaveChanges();
Server.Transfer(Request.FilePath);
}
}
protected void Page_Load(object sender, EventArgs e)
{
TravelDAL.Tour obj = new TravelDAL.Tour();
TravelDAL.Tour simt = new TravelDAL.Tour();
int id = Int32.Parse(Request.QueryString["id"]);
//rateobj.IDToRate = id;
int i = 0;
using (var context = new TravelDBEntities())
{
EntityKey key = new EntityKey("TravelDBEntities.Tour", "IDTour", id);
obj = (TravelDAL.Tour)context.GetObjectByKey(key);
Label1.Text = obj.Program;
Label2.Text = obj.AdditionalInfo;
Label3.Text = obj.Price;
if (obj.SimilarTours.Length < 2)
{
Label ll = new Label();
ll.Text = "К сожалению, туров, похожих на этот, нет.";
PanelForSimilar.Controls.Add(ll);
}
else
{
int[] mas = WorkWithDB.SearchNumbersInString(obj.SimilarTours);
foreach(int m in mas)
{
EntityKey k = new EntityKey("TravelDBEntities.Tour", "IDTour", m);
simt = (TravelDAL.Tour)context.GetObjectByKey(k);
if (simt != null)
{
i++;
BriefView brt = new BriefView(m, true);
PanelForSimilar.Controls.Add(brt);
}
if (i == 2) break;
}
}
//obj.SimilarTours
}
}
//ind: 0 - min, 1 - max
private static int GetMaxOrMinTourPrice(int tourID, bool ind)
{
//int[] prices = new int[20];
int min = 0, avg = 0;
TravelDAL.Tour obj = new TravelDAL.Tour();
using (TravelDBEntities context = new TravelDBEntities())
{
EntityKey key = new EntityKey("TravelDBEntities.Tour", "IDTour", tourID);
obj = (TravelDAL.Tour)context.GetObjectByKey(key);
if (obj != null)
{
//prices = SearchPrices(obj.Price);
min = (int)obj.MinimalPrice;
avg = (int)obj.AveragePrice;
}
}
return ind == false ? min : avg;
}
protected void ButtonDone_Click(object sender, EventArgs e)
{
int[] mCountries; //for lists of countries and types
int[] mTypes;
int[] mTours; //we have list of tours which are similar to current, we have to decide in which way it will be better to store it
//int lastID = 0;
TravelDAL.Tour obj = new TravelDAL.Tour();
if (TextForName.Text != "")
{
using (TravelDBEntities context = new TravelDBEntities())
{
var num = (from item in context.Tour select item).Count();
if (num != 0) lastID = (from item in context.Tour select item.IDTour).Max(); //getting last id from tours
lastID++;
if (!folderExist) CreateFolder(lastID);
}
obj.Name = TextForName.Text;
obj.Program = TextForProgram.Text;
obj.AdditionalInfo = TextForAddInfo.Text;
obj.Price = TextForPrice.Text;
obj.NumberOfPageVisits = 0;
if (TextForPurchNum.Text != "")
{
obj.NumberOfPurchases = int.Parse(TextForPurchNum.Text);
}
else obj.NumberOfPurchases = 0;
if (TextForAvgPrice.Text != "")
{
obj.AveragePrice = int.Parse(TextForAvgPrice.Text);
}
else obj.AveragePrice = 0;
if (TextForMinPrice.Text != "")
{
obj.MinimalPrice = int.Parse(TextForMinPrice.Text);
}
else obj.MinimalPrice = 0;
if (TextForSpecInfo.Text != "")
{
obj.SpecialOfferFlag = true;
obj.SpecialOfferInfo = TextForSpecInfo.Text;
}
mCountries = ListofCountries.GetSelectedIndices(); //array of indexes
mTypes = ListOfTypes.GetSelectedIndices();
mTours = ListOfToursNames.GetSelectedIndices();
using (TravelDBEntities context = new TravelDBEntities())
{
var num = (from item in context.Tour select item).Count();
if(num != 0) lastID = (from item in context.Tour select item.IDTour).Max(); //getting last id from tours
lastID++;
obj.IDTour = lastID;
obj.XmlRef = GenerateXML(obj.IDTour); // generating xml file
foreach (int m in mTypes)
{
var tip = new TravelDAL.Type{IDType = m + 1};
context.Type.Attach(tip);
obj.Type.Add(tip);
}
foreach (int m in mCountries)
{
var coun = new Country { IDCountry = m + 1 };
context.Country.Attach(coun);
obj.Country.Add(coun);
}
context.Tour.AddObject(obj);
context.SaveChanges();
}
}
else
{
lblNewError.Text = "Enter name of tour!";
lblNewError.Visible = true;
}
// else return; //i need message here, that you've forgotten to input name of tour
}
protected void ButtonUplode_Click(object sender, EventArgs e)
{
try
{
HttpFileCollection hfc = Request.Files;
using (TravelDBEntities context = new TravelDBEntities())
{
var num = (from item in context.Tour select item).Count();
if (num != 0) lastID = (from item in context.Tour select item.IDTour).Max(); //getting last id from tours
lastID++;
if (!folderExist) CreateFolder(lastID);
}
for (int i = 0; i < hfc.Count; i++)
{
HttpPostedFile hpf = hfc[i];
if (hpf.ContentLength > 0 && TextForName.Text != "")
{
hpf.SaveAs(Server.MapPath("flash\\images") + "\\" + lastID + "\\" + System.IO.Path.GetFileName(hpf.FileName));
Response.Write("<b>File: </b>" + hpf.FileName + " <b>Size:</b> " + hpf.ContentLength + " <b>Type:</b> " + hpf.ContentType + " Uploaded Successfully <br/>");
lblError.Visible = false;
}
else throw new Exception("File length = 0 or no name for tour!");
}
}
catch (Exception ex)
{
lblError.Visible = true;
lblError.Text = ex.Message;
}
}
protected void PatternMatching()
{
string StringForWhere = "AveragePrice >= MinPrice && Average <= MaxPrice";
int counter = new int();
if (TypeForSearch != 0)
{
StringForWhere += " && ";
}
LinqDataSource quer = new LinqDataSource();
quer.TableName = "Tour";
quer.ID = "LinqDataSource1";
//quer.Where;
using(var context = new TravelDBEntities())
{
if (MaxPrice == 0)
{
MinPrice = 0;
MaxPrice = 100500;
}
var list = from item in context.Tour
where item.AveragePrice >= MinPrice && item.MinimalPrice <= MaxPrice
select item.IDTour;
foreach (int a in list) //checking up results
{
counter++;
// str = TextBox1.Text;
// str += a.ToString();
// TextBox1.Text = str;
}
if (counter == 0)
{
//there are no results, too strict requirements i need message about it
return;
}
else _quantity = counter;
}
MaxPrice = 0;
Refresh();
}
