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