public bool userExists(string username, string password) { try { var dataContext = new WebshopDataContext(); int usersCount = dataContext .User .Where(i => i.Benutzername == username && i.Passwort == Webshop.Common.Helper.StringHelper.MD5(password)) .Count(); if (usersCount == 1) { return(true); } else { return(false); } } catch (Exception) { return(false); } }
protected void Page_Load(object sender, EventArgs e) { WebshopDataContext dc = new WebshopDataContext(); IEnumerable<Event> eventX = (from ev in dc.Events select ev).Take(10).DefaultIfEmpty(); if (eventX == null) { return; } IEnumerable<Int64> topEvents = (from ev in eventX select ev.EventID); TopEvents.DataSource = topEvents; TopEvents.DataBind(); //EventSummary1.FillEvent(7); //EventSummary2.FillEvent(8); //EventSummary3.FillEvent(9); //EventSummary4.FillEvent(10); //EventSummary5.FillEvent(11); //EventSummary6.FillEvent(12); //EventSummary7.FillEvent(13);tem. //EventSummary8.FillEvent(14); //EventSummary9.FillEvent(15); //EventSummary10.FillEvent(16); }
public static Event getEventById(String eventId) { if (eventId == null) { return null; } Int64 i = new Int64(); i = Int64.Parse(eventId); WebshopDataContext dc = new WebshopDataContext(); return (from ev in dc.Events where ev.EventID == i select ev).FirstOrDefault(); }
protected void Page_Load(object sender, EventArgs e) { WebshopDataContext dc = new WebshopDataContext(); String event_category = Request.QueryString["Category"]; String event_text = Request.QueryString["Text"]; if (event_category == "Any") { if (event_text != "") { IEnumerable<Int64> topEvents = (from ev in dc.Events where ev.Name.Contains(event_text) select ev.EventID); TopEvents.DataSource = topEvents; } else { IEnumerable<Int64> topEvents = (from ev in dc.Events select ev.EventID); TopEvents.DataSource = topEvents; } } else { Category category = (from ca in dc.Categories where ca.CategoryName.Equals(event_category) select ca).FirstOrDefault(); IEnumerable<Int64> event_categories = ( from ev in dc.EventCategories where ev.CategoryID == category.CategoryID select ev.EventID); if (event_text != "") { IEnumerable<Int64> events = (from ev in dc.Events where event_categories.Contains(ev.EventID) && ev.Name.Contains(event_text) select ev.EventID); TopEvents.DataSource = events; } else { TopEvents.DataSource = event_categories; } } TopEvents.DataBind(); }
public static List<string> GetCategories() { WebshopDataContext dc = new WebshopDataContext(); IEnumerable<Category> ct = (from ev in dc.Categories select ev).DefaultIfEmpty(); List<string> categories = new List<string>(); foreach (Category ev in ct) { categories.Add(ev.CategoryName.Trim()); } return categories; }
public bool FillEvent(Int64 eventID) { eventID1 = eventID; if (eventID == -1) { return false; } //ImageButton1.ImageUrl = "..\\img\\no_img.jpg"; //ImageButton1.Width = 100; //ImageButton1.Height = 100; WebshopDataContext dc = new WebshopDataContext(); Event eventX = (from ev in dc.Events where ev.EventID == eventID select ev).FirstOrDefault(); if (eventX == null) { return false; } List<Int64> eveimg = (from tc in dc.EventImages where tc.EventID == eventX.EventID select tc.ImageID).ToList(); List<Image> images = (from im in dc.Images where eveimg.Contains(im.ImageID) select im).ToList(); if (images.Count != 0) { img.ImageUrl = images.First().URL; } lblName.Text = Utilities.ContinuousString(eventX.Name, 0, 10); lblStartTime.Text = eventX.StsrtDateTime.ToShortDateString() + " " + eventX.StsrtDateTime.ToShortTimeString(); lblEndTime.Text = eventX.EndDateTime.ToShortDateString() + " " + eventX.EndDateTime.ToShortTimeString(); lblLocation.Text = Utilities.ContinuousString(eventX.Location, 0, 26); lblPrice.Text = eventX.Price.ToString(); return true; }
protected void btnInterested_Click(object sender, EventArgs e) { if (!Page.User.Identity.IsAuthenticated) { Response.Redirect("./login.aspx"); } WebshopDataContext dc = new WebshopDataContext(); aspnet_User user = (from ev in dc.aspnet_Users where ev.UserName.Equals(Page.User.Identity.Name) select ev).FirstOrDefault(); ListsOfParticipant lists = (from ev in dc.ListsOfParticipants where ev.EventID == m_eventID && ev.UserID == user.UserId select ev).FirstOrDefault(); if (lists == null) { ListsOfParticipant newLists = new ListsOfParticipant { UserID = user.UserId, EventID = m_eventID, Interested = true }; dc.ListsOfParticipants.InsertOnSubmit(newLists); dc.SubmitChanges(); dc.Dispose(); } else if (lists.Interested == false) { //ListsOfParticipant newLists = new ListsOfParticipant //{ // lists.Interested = true //}; lists.Interested = true; dc.ListsOfParticipants.Attach(lists, true); dc.SubmitChanges(); dc.Dispose(); } }
protected void events_list_SelectedIndexChanged(object sender, EventArgs e) { if (events_list.SelectedItem.Text == "New Event") { txtName.Text = ""; txtStartDateTime.Text = ""; txtEndDateTime.Text = ""; txtNoOfMin.Text = ""; txtNoOfMax.Text = ""; txtConditions.Text = ""; txtLocation.Text = ""; txtPrice.Text = ""; txtDescription.Text = ""; Add.Visible = true; Update.Visible = false; Delete.Visible = false; lblProgram.Visible = false; events_program.DataSource = null; events_program.DataBind(); } else { WebshopDataContext dc = new WebshopDataContext(); Event eventX = (from ev in dc.Events where ev.Name.Equals(events_list.SelectedItem.Text) select ev).FirstOrDefault(); txtName.Text = eventX.Name.ToString(); txtStartDateTime.Text = eventX.StsrtDateTime.ToString(); txtEndDateTime.Text = eventX.EndDateTime.ToString(); txtNoOfMin.Text = eventX.NOfMinimum.ToString(); txtNoOfMax.Text = eventX.NOfMaximum.ToString(); txtConditions.Text = eventX.Conditions.ToString(); txtLocation.Text = eventX.Location.ToString(); txtPrice.Text = eventX.Price.ToString(); txtDescription.Text = eventX.Description.ToString(); Event main_event = (from ev in dc.Events where ev.EventID == eventX.ParentEventID select ev).FirstOrDefault(); if (main_event != null) { ddltIsMainEvent.SelectedItem.Selected = false; ddltIsMainEvent.Items.FindByText(main_event.Name).Selected = true; } else { ddltIsMainEvent.SelectedIndex = 0; } Update.Visible = true; Delete.Visible = true; lblProgram.Visible = true; Add.Visible = false; var events_programs = (from ev in dc.Events where ev.ParentEventID == eventX.EventID select new { ev.Name, ev.StsrtDateTime, ev.EndDateTime, ev.Price }); events_program.DataSource = events_programs; events_program.DataBind(); } }
// will be replaced by getPPPaymentDataString(ShoppingCart shCart) private string getPPPaymentDataString(long _productID) { decimal evNetPrice; string evName; long evID = -1; decimal tax = 0; WebshopDataContext dc = new WebshopDataContext(); Event prod = (from ev in dc.Events where ev.isMainEvent == true && ev.EventID == _productID select ev).SingleOrDefault(); StringBuilder paymentData = new StringBuilder(); paymentData.Append("cmd=_s-xclick"); paymentData.Append("\nupload=1"); paymentData.Append("\nbusiness=" + ConfigurationManager.AppSettings["PP_MerchantUsername"]); paymentData.Append("\nreturn=" + PP_myHostingPrefix + "/" + PP_cancelReturnURL); paymentData.Append("\ncancel_return=" + PP_myHostingPrefix + "/" + PP_cancelReturnURL); paymentData.Append("\ncert_id=" + ConfigurationManager.AppSettings["PP_CertID"]); //Shopping cart Data //paymentData.Append("\ninvoice=invoice_1"); //optional - Passthrough variable you can use to identify your invoice number for this purchase. paymentData.Append("\ncurrency_code=" + ConfigurationManager.AppSettings["PP_Currency"]); paymentData.Append("\npaymentaction=sale"); //default is sale (allowed: authorization, order) ////Shipping --> Added as an item!!!! //paymentData.Append("\nitem_name_1=Shipping Costs"); //paymentData.Append("\nitem_number_1=nr_1"); //paymentData.Append("\nquantity_1=1"); //paymentData.Append("\namount_1=1.00"); if (prod == null) { //No product was found --> handle error throw new Exception("No Product was found!"); } else if (prod.Name == null || prod.EventID == null || prod.Price == null) { //No sufficient info about the product --> handle Error throw new Exception("Ambivalent product data was found!"); } else { decimal taxRate = (decimal)0.19; evNetPrice = prod.Price * 1 - taxRate; evName = prod.Name; evID = prod.EventID; tax = evNetPrice * (decimal)0.19; } //Adding Items paymentData.Append("\nitem_name=" + evName); paymentData.Append("\nitem_number=" + evID.ToString()); paymentData.Append("\nquantity=1"); paymentData.Append("\namount=1.00"); paymentData.Append("\ntax=0.11"); //paymentData.Append("\namount_1=" + evNetPrice.ToString()); //paymentData.Append("\ntax_1=" + tax.ToString()); return paymentData.ToString(); }
public ProductRepository(WebshopDataContext context) { _context = context; }
protected void Page_Load(object sender, EventArgs e) { if (!Page.User.Identity.IsAuthenticated || !Page.User.IsInRole("User")) { btnInterested.Visible = false; } String eventID = Request.QueryString["EventID"]; if (eventID == null) { return; } Int64 i = new Int64(); i = Int64.Parse(eventID); m_eventID = i; if (!IsPostBack) { WebshopDataContext dc = new WebshopDataContext(); Event eventX = (from ev in dc.Events where ev.EventID == i select ev).FirstOrDefault(); if (eventX == null) { return; } List<Int64> eveimg = (from tc in dc.EventImages where tc.EventID == eventX.EventID select tc.ImageID).ToList(); List<Image> images = (from im in dc.Images where eveimg.Contains(im.ImageID) select im).ToList(); //List<Image> imgList = eventX.EventImages.ToList(); if (images.Count != 0) { rptImages.DataSource = images; rptImages.DataBind(); } else { rptImages.Visible = false; defaultimage.Visible = true; } lblEventStart.Text = eventX.Name; lblStartTime.Text = eventX.StsrtDateTime.ToString(); lblEndTime.Text = eventX.EndDateTime.ToString(); ; lblLocation.Text = eventX.Location; lblPrice.Text = eventX.Price.ToString(); IEnumerable<EventOrganization> organizations = (from o in dc.EventOrganizations join ev in dc.Events on o.EventID equals ev.EventID where ev.EventID == i orderby ev.EventID select o); IEnumerable<EventOrganizer> organizers = (from o in dc.EventOrganizers join ev in dc.Events on o.EventID equals ev.EventID join user in dc.aspnet_Users on o.UserID equals user.UserId where o.EventID == i orderby o.EventID select o); foreach (EventOrganizer organizer in organizers) { lblOrganizer.Text += organizer.aspnet_User.UserName + "<br />"; } foreach (EventOrganization organization in organizations) { lblOrganization.Text += organization.Organization.Name + "\n"; } lblDescription.Text = eventX.Description; lblConditions.Text = eventX.Conditions; IEnumerable<Int64> events_programs = (from ev in dc.Events where ev.ParentEventID == eventX.EventID select ev.EventID); EventsProgram.DataSource = events_programs; EventsProgram.DataBind(); //Payment pp_payment = new Payment(); //string pp_encString = pp_payment.getPPEncryptedString(m_eventID); //encrypted.Value = pp_encString; //ltlEncrypted.Text = "<input ID='encrypted' type='hidden' name='encrypted' value='" + pp_encString + "'/>"; } }
public DeliveryRepository(WebshopDataContext context) { _context = context; }
public OrderRepository(WebshopDataContext context) { _context = context; }
protected void Add_Click(object sender, EventArgs e) { WebshopDataContext dc = new WebshopDataContext(); aspnet_User user = (from ev in dc.aspnet_Users where ev.UserName.Equals(Page.User.Identity.Name) select ev).FirstOrDefault(); OrganizationManagement orgman = (from ev in dc.OrganizationManagements where ev.UserID == user.UserId select ev).FirstOrDefault(); Event event_x = new Event { Name = txtName.Text, StsrtDateTime = DateTime.Parse(txtEndDateTime.Text), EndDateTime = DateTime.Parse(txtEndDateTime.Text), NOfMinimum = int.Parse(txtNoOfMin.Text), NOfMaximum = int.Parse(txtNoOfMax.Text), Conditions = txtConditions.Text, Location = txtLocation.Text, Price = decimal.Parse(txtPrice.Text), Description = txtDescription.Text, //isMainEvent = btnIsMainEvent.Checked }; if (ddltIsMainEvent.SelectedIndex == 0) { event_x.isMainEvent = true; } else { event_x.isMainEvent = false; event_x.ParentEventID = (from ev in dc.Events where ev.Name.Equals(ddltIsMainEvent.SelectedItem.Text) select ev.EventID).FirstOrDefault(); } Image img = new Image { URL = txtPicture.Text }; dc.Events.InsertOnSubmit(event_x); dc.Images.InsertOnSubmit(img); dc.SubmitChanges(); EventImage eveimg = new EventImage { EventID = event_x.EventID, ImageID = img.ImageID }; EventOrganization event_orgainzation = new EventOrganization { EventID = event_x.EventID, OrgainzationID = orgman.OrganizationID }; dc.EventImages.InsertOnSubmit(eveimg); dc.EventOrganizations.InsertOnSubmit(event_orgainzation); dc.SubmitChanges(); Response.Redirect(Request.RawUrl); }
protected void Page_Load(object sender, EventArgs e) { if (!Page.User.Identity.IsAuthenticated || !Page.User.IsInRole("Institute Administrator")) { return; } if (!Page.IsPostBack) { Add.Visible = false; Update.Visible = false; Delete.Visible = false; lblProgram.Visible = false; //Participants.Visible = false; WebshopDataContext dc = new WebshopDataContext(); aspnet_User user = (from ev in dc.aspnet_Users where ev.UserName.Equals(Page.User.Identity.Name) select ev).FirstOrDefault(); // Event eventX = (from ev in dc.Events where ev.EventID == i select ev).FirstOrDefault(); OrganizationManagement orgman = (from ev in dc.OrganizationManagements where ev.UserID == user.UserId select ev).FirstOrDefault(); IEnumerable<EventOrganization> orgeve = (from ev in dc.EventOrganizations where ev.OrgainzationID == orgman.OrganizationID select ev).DefaultIfEmpty(); List<long> eventIDs = new List<long>(); foreach (EventOrganization iv in orgeve) { eventIDs.Add(iv.EventID); } IEnumerable<Event> events = (from ev in dc.Events where eventIDs.Contains(ev.EventID) == true orderby ev.StsrtDateTime select ev).DefaultIfEmpty(); var basicEvents = (from ev in events orderby ev.StsrtDateTime select new { ev.Name, ev.StsrtDateTime, ev.EndDateTime, ev.Location, ev.Price }); events_list.Items.Add(new ListItem("New Event", "0")); ddltIsMainEvent.Items.Add(new ListItem("<Main Event>", "0")); int i = 1; foreach (var li in basicEvents) { events_list.Items.Add(new ListItem(li.Name, i.ToString())); ddltIsMainEvent.Items.Add(new ListItem(li.Name, i.ToString())); ++i; } events_list.DataBind(); } }
protected void Update_Click(object sender, EventArgs e) { WebshopDataContext dc = new WebshopDataContext(); Event event_x = ( from ev in dc.Events where ev.Name.Equals(ddltIsMainEvent.SelectedItem.Text) select ev).FirstOrDefault(); event_x.Name = txtName.Text; event_x.StsrtDateTime = DateTime.Parse(txtEndDateTime.Text); event_x.EndDateTime = DateTime.Parse(txtEndDateTime.Text); event_x.NOfMinimum = int.Parse(txtNoOfMin.Text); event_x.NOfMaximum = int.Parse(txtNoOfMax.Text); event_x.Conditions = txtConditions.Text; event_x.Location = txtLocation.Text; event_x.Price = decimal.Parse(txtPrice.Text); event_x.Description = txtDescription.Text; if (ddltIsMainEvent.SelectedIndex == 0) { event_x.isMainEvent = true; } else { event_x.isMainEvent = false; event_x.ParentEventID = (from ev in dc.Events where ev.Name.Equals(events_list.SelectedItem.Text) select ev.EventID).FirstOrDefault(); } Image img = new Image { URL = txtPicture.Text }; dc.Images.InsertOnSubmit(img); dc.SubmitChanges(); EventImage eveimg = new EventImage { EventID = event_x.EventID, ImageID = img.ImageID }; dc.EventImages.InsertOnSubmit(eveimg); dc.SubmitChanges(); }
public static Event getEventById(Int64 eventId) { WebshopDataContext dc = new WebshopDataContext(); return (from ev in dc.Events where ev.EventID == eventId select ev).FirstOrDefault(); }
protected void Delete_Click(object sender, EventArgs e) { WebshopDataContext dc = new WebshopDataContext(); Event event_x = ( from ev in dc.Events where ev.Name.Equals(events_list.SelectedItem.Text) select ev).FirstOrDefault(); IEnumerable<EventOrganization> event_organizations = ( from ev in dc.EventOrganizations where ev.EventID == event_x.EventID select ev); IEnumerable<EventPlacesToMeet> event_places_to_meet = (from ev in dc.EventPlacesToMeets where ev.EventID == event_x.EventID select ev); dc.Events.DeleteOnSubmit(event_x); dc.EventOrganizations.DeleteAllOnSubmit(event_organizations); dc.EventPlacesToMeets.DeleteAllOnSubmit(event_places_to_meet); dc.SubmitChanges(); Response.Redirect(Request.RawUrl); }