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