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 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
}
}
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);
}
}
//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;
}
