protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
image1.ImageUrl = Random_Image(); //set image filepath to a random image
dateTime.Value = System.DateTime.Today.ToString();
if(!Page.IsPostBack)
{
MonkData db = new MonkData();
var languages = from l in db.jkp_Languages
select l;
dlLanguages.DataSource = languages;
dlLanguages.DataTextField = "Lang_DisplayName";
dlLanguages.DataValueField = "Lang_BrowserCode";
dlLanguages.DataBind();
// culture codes http://msdn.microsoft.com/en-us/library/system.globalization.cultureinfo.aspx
if(Session["Culture"] != null)
{
dlLanguages.Items.FindByValue(Session["Culture"].ToString()).Selected = true;
}
var retreats = from r in db.jkp_Retreats
//where r.Ret_EndDate > DateTime.Now
orderby r.Ret_StartDate ascending
select r;
rpRetreats.DataSource = retreats.Take(10);
rpRetreats.DataBind();
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
if (!Page.IsPostBack)
{
Monks.jkp_ArticlePage artPage = db.jkp_ArticlePages.First(p => p.ArtP_ID == ArticlePageId);
litContent.Text = artPage.ArtP_DefaultBodyText;
litPageTitle.Text = GetResource(artPage.ArtP_ResxHeaderName);
this.Page.Title = GetResource(artPage.ArtP_ResxTitle);
litCategoryName.Text = artPage.jkp_ArticleCategory.ArtCat_Name;
rpArticles.DataSource = artPage.jkp_ArticleCategory.jkp_Articles;
rpArticles.DataBind();
}
if(ArticleId != null)
{
Monks.jkp_Article article = db.jkp_Articles.First(p=>p.Art_ID == ArticleId);
litPageTitle.Text = article.Art_Title;
this.Page.Title = article.Art_Title;
litContent.Text = article.Art_Content;
litAuthor.Text = article.jkp_Person.Per_FirstName + " " + article.jkp_Person.Per_LastName;
spanAuthorName.Visible = true;
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
if (MediaType == Monks.Enums.MediaTypes.Audio)
{
Monks.jkp_Audio audio = db.jkp_Audios.First(p => p.Aud_ID == ItemId);
litPageTitle.Text = "Audio: " + audio.Aud_Title;
hlEditDetails.NavigateUrl = "AddEdit.aspx?typename=jkp_Audio&itemid=" + ItemId.ToString();
hlEditRoles.NavigateUrl = "Media-RoleManager.aspx?mediatype=Audio&itemid=" + ItemId.ToString();
}
else if(MediaType == Monks.Enums.MediaTypes.Book)
{
Monks.jkp_Book book = db.jkp_Books.First(p=>p.Bk_ID == ItemId);
litPageTitle.Text = "Book: " + book.Bk_Title;
hlEditDetails.NavigateUrl = "AddEdit.aspx?typename=jkp_Book&itemid=" + ItemId.ToString();
hlEditRoles.NavigateUrl = "Media-RoleManager.aspx?mediatype=Book&itemid=" + ItemId.ToString();
}
else if(MediaType == Monks.Enums.MediaTypes.Image)
{
Monks.jkp_Image image = db.jkp_Images.First(p=>p.Img_ID == ItemId);
litPageTitle.Text = "Image: " + image.Img_Title;
hlEditDetails.NavigateUrl = "AddEdit.aspx?typename=jkp_Image&itemid=" + ItemId.ToString();
hlEditRoles.NavigateUrl = "Media-RoleManager.aspx?mediatype=Image&itemid=" + ItemId.ToString();
}
else if(MediaType == Monks.Enums.MediaTypes.Video)
{
Monks.jkp_Video video = db.jkp_Videos.First(p=>p.Vid_ID == ItemId);
litPageTitle.Text = "Image: " + video.Vid_Title;
hlEditDetails.NavigateUrl = "AddEdit.aspx?typename=jkp_Video&itemid=" + ItemId.ToString();
hlEditRoles.NavigateUrl = "Media-RoleManager.aspx?mediatype=Video&itemid=" + ItemId.ToString();
}
}
public void btnAddMediaRole_Clicked(object sender, EventArgs e)
{
if(dlRolesToAssign.Items.Count == 0)
throw new Exception("Roles must be created first before trying to assign roles.");
MonkData db = new MonkData();
Monks.jkp_MediaRole mediaRole = new Monks.jkp_MediaRole();
if(MediaType == Monks.Enums.MediaTypes.Audio)
mediaRole.AudioId = ItemId;
else if(MediaType == Monks.Enums.MediaTypes.Book)
mediaRole.BookId = ItemId;
else if(MediaType == Monks.Enums.MediaTypes.Image)
mediaRole.ImageId = ItemId;
else if(MediaType == Monks.Enums.MediaTypes.Video)
mediaRole.VideoId = ItemId;
mediaRole.RoleId = new Guid(dlRolesToAssign.SelectedValue);
mediaRole.MediaRoleId = Guid.NewGuid();
var existingSameRole = from d in db.jkp_MediaRoles
where object.Equals( d.AudioId, mediaRole.AudioId) && object.Equals( d.BookId, mediaRole.BookId) && object.Equals( d.ImageId, mediaRole.ImageId) && object.Equals(d.VideoId , mediaRole.VideoId)
&& d.RoleId == mediaRole.RoleId
select d;
if(existingSameRole.Count() > 0)
{
modalAddRole.Hide();
return;
}
db.jkp_MediaRoles.InsertOnSubmit(mediaRole);
db.SubmitChanges();
LoadPageData();
modalAddRole.Hide();
}
public void btnSearchMedia_Clicked(object sender, EventArgs e)
{
MonkData db = new MonkData();
if(rbtnAudio.Checked)
{
var audioBooks = from a in db.jkp_Audios
where SqlMethods.Like( a.Aud_Title , "%" + txtMediaSearch.Text + "%")
select a;
gridSearchResults.DataSource = audioBooks;
gridSearchResults.DataBind();
}
else if(rbtnBooks.Checked)
{
var books = from b in db.jkp_Books
where SqlMethods.Like(b.Bk_Title, "%" + txtMediaSearch.Text + "%")
select b;
gridSearchResults.DataSource = books;
gridSearchResults.DataBind();
}
else if(rbtnVideo.Checked)
{
var videos = from v in db.jkp_Videos
where SqlMethods.Like(v.Vid_Title, "%" + txtMediaSearch.Text + "%")
select v;
gridSearchResults.DataSource = videos;
gridSearchResults.DataBind();
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
Monks.jkp_Video videoItem = db.jkp_Videos.First(p=>p.Vid_ID == VideoId);
//litContents.Text = videoItem.Vid_Contents;
//litCredits.Text = videoItem.Vid_Credits;
// videoItem.Vid_DateAdded;
//litDuration.Text = videoItem.Vid_Description;
//if(videoItem.Vid_Disc_Number != null)
// litDiscNumber.Text = ((int)videoItem.Vid_Disc_Number).ToString();
//if(videoItem.Vid_Duration != null)
// litDuration.Text = ((decimal)videoItem.Vid_Duration).ToString();
//litGenre.Text = videoItem.Vid_Genre;
//litLanguage.Text = videoItem.Vid_Language;
hlVideoDownload.NavigateUrl = videoItem.Vid_Pathname;
//videoItem.Vid_Size;
//litSubject.Text = videoItem.Vid_Subject;
//litVideoSummary.Text = videoItem.Vid_Summary;
litVideoTitle.Text = videoItem.Vid_Title;
//if(videoItem.Vid_Year != null)
// litYear.Text = videoItem.Vid_Year;
}
public bool CanUserAccessPage(string pagePath, bool redirectOnNoAccess, ref MonkData db )
{
var rolesForPage = from r in db.aspnet_PageUnderRoles
where r.FilePath == pagePath
select r;
// We know there is a role applied to this page if there are more than 0 roles and we only want to check if roles are enabled.
if (rolesForPage.Count() > 0 && bool.Parse(ConfigurationManager.AppSettings["EnableRoles"]))
{
var userInRoles = from p in db.aspnet_UsersInRoles
where p.UserId == UserId && p.aspnet_Role.aspnet_PageUnderRoles.Where(j => j.FilePath == pagePath).Count() > 0
select p;
// If it's equal to zero the user doesn't have permission to access this page but we want to possibly
// redirect them to a page telling them why they can't access it.
if (userInRoles.Count() == 0)
{
string rolesNeedToAccessPage = string.Empty;
foreach (Monks.aspnet_PageUnderRole pageUnderRole in rolesForPage)
{
if (!String.IsNullOrEmpty(rolesNeedToAccessPage))
rolesNeedToAccessPage += ", ";
rolesNeedToAccessPage += pageUnderRole.aspnet_Role.RoleName;
}
if(redirectOnNoAccess)
Response.Redirect("Access-Denied.aspx?reason=" + Uri.EscapeDataString(rolesNeedToAccessPage), true);
return false;
}
}
return true;
}
public bool CanUserAccessTable(string tableName, bool redirectUserOnFailure, ref MonkData db)
{
var rolesForPage = from r in db.aspnet_TableUnderRoles
where r.TableName.Contains(tableName)
select r;
if (rolesForPage.Count() > 0 && bool.Parse(ConfigurationManager.AppSettings["EnableRoles"]))
{
// Check if the current user is in the role that has access to this page.
var userInRoles = from p in db.aspnet_UsersInRoles
where p.UserId == UserId && p.aspnet_Role.aspnet_TableUnderRoles.Where(j => j.TableName.Contains( tableName)).Count() > 0
select p;
if (userInRoles.Count() == 0)
{
string rolesNeedToAccessPage = string.Empty;
foreach (Monks.aspnet_TableUnderRole pageUnderRole in rolesForPage)
{
if (!String.IsNullOrEmpty(rolesNeedToAccessPage))
rolesNeedToAccessPage += ", ";
rolesNeedToAccessPage += pageUnderRole.aspnet_Role.RoleName;
}
if(redirectUserOnFailure)
Response.Redirect("Access-Denied.aspx?reason=" + Uri.EscapeDataString(rolesNeedToAccessPage), true);
return false;
}
return true;
}
return false;
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
Monks.jkp_Retreat retreat = db.jkp_Retreats.First(p => p.Ret_ID == RetreatId);
litRetreatName.Text = retreat.Ret_Name;
litDescription.Text = retreat.Ret_Description;
if (retreat.Ret_StartDate != null)
litStartDate.Text = ((DateTime)retreat.Ret_StartDate).ToShortDateString();
if (retreat.Ret_EndDate != null)
litEndDate.Text = ((DateTime)retreat.Ret_EndDate).ToShortDateString();
if (retreat.jkp_Site != null)
{
if (!String.IsNullOrEmpty(retreat.jkp_Site.Site_LocalName))
litSite.Text = retreat.jkp_Site.Site_LocalName;
else if (!String.IsNullOrEmpty(retreat.jkp_Site.Site_EnglishName))
litSite.Text = retreat.jkp_Site.Site_EnglishName;
if (retreat.jkp_Site.jkp_Address != null)
litAddress.Text = retreat.jkp_Site.jkp_Address.Add_Street + "<br />" + retreat.jkp_Site.jkp_Address.Add_City + ", " + retreat.jkp_Site.jkp_Address.Add_State + " " + retreat.jkp_Site.jkp_Address.Add_PostalCode;
}
litRemainingSpots.Text = (retreat.Ret_TotalCapacity - retreat.jkp_PersonAttendingRetreats.Count()).ToString();
//var roomsForRetreat = from r in db.jkp_Rooms
// where r.Rm_ContructedDate <= retreat.Ret_StartDate && r.Rm_DestroyedDate >= retreat.Ret_EndDate
// select r;
//if (roomsForRetreat.Count() > 0)
//{
// //litRemainingSpots.Text = (capacity - retreat.jkp_PersonAttendingRetreats.Count()).ToString();
//}
//else
//{
// litRemainingSpots.Text = "No more spots left";
//}
litLanguage.Text = retreat.jkp_Language.Lang_DisplayName;
if( retreat.Ret_EndDate <= DateTime.Now)
{
hlRegisterForReteat.Visible = false;
}
else if(retreat.Ret_StartDate <= DateTime.Now && retreat.Ret_AllowRegistrationDuringRetreat)
{
hlRegisterForReteat.Visible = true;
}
else if(retreat.Ret_StartDate <= DateTime.Now && !retreat.Ret_AllowRegistrationDuringRetreat)
{
hlRegisterForReteat.Visible = false;
}
else if(retreat.Ret_StartDate > DateTime.Now)
{
hlRegisterForReteat.Visible = true;
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
foreach(PropertyInfo tablePInfo in db.GetType().GetProperties())
{
Type[] genericTypes = tablePInfo.PropertyType.GetGenericArguments();
if(genericTypes.Count() < 1)
continue;
if(!CanUserAccessTable(genericTypes[0].Name, false, ref db))
{
continue;
}
HyperLink hlTypeEdit = new HyperLink();
hlTypeEdit.NavigateUrl = "AddEdit.aspx?typename=" + genericTypes[0].Name;
hlTypeEdit.Text = "Add " + GetFieldNameFromString( tablePInfo.Name);
plcAddItemsList.Controls.Add(hlTypeEdit);
Literal litLineBreak = new Literal();
litLineBreak.Text = "<br />";
plcAddItemsList.Controls.Add(litLineBreak);
HyperLink hlTypeGridView = new HyperLink();
hlTypeGridView.NavigateUrl = "GridView.aspx?typename=" + genericTypes[0].Name;
hlTypeGridView.Text = GetFieldNameFromString( tablePInfo.Name);
plcViewItems.Controls.Add(hlTypeGridView);
Literal litLineBreakGridView = new Literal();
litLineBreakGridView.Text = "<br />";
plcViewItems.Controls.Add(litLineBreakGridView);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//this code block dynamically generates the top navigation from the database
MonkData db = new MonkData();
//separate 'Home' link from the list of menu items
var homeLink = from u1 in db.aspnet_MenuItems
where u1.LinkText == "Home"
select u1;
//get the rest of the menu items
var menuItemList = from u2 in db.aspnet_MenuItems
where u2.LinkText != "Home"
orderby u2.LinkText
select u2;
topNavul.Controls.Clear();
//want 'Home' link first
topNavul.InnerHtml += "<li><a href=\"" + homeLink.First().LinkLocation + "\">"
+ GetResource(homeLink.First().LinkText) + "</a></li>";
//then append the rest of the menu items
foreach (Monks.aspnet_MenuItem menuItemElement in menuItemList)
{
string textForLink = GetResource(menuItemElement.LinkText);
topNavul.InnerHtml += "<li><a href=\"" + menuItemElement.LinkLocation + "\">"
+ textForLink + "</a></li>";
}
}
topNavul.Controls.Add(lgv);
}
public void btnSavePageAccessRole_Clicked(object sender, EventArgs e)
{
MonkData db = new MonkData();
Guid roleId = new Guid(hidRoleId.Value);
var pagesUnderRole = db.aspnet_PageUnderRoles.Where(p=>p.RoleId == roleId && p.FilePath == dlPages.SelectedValue);
if(pagesUnderRole.Count() > 0)
{
// Role was already found that was defined for this page.
return;
}
Monks.aspnet_PageUnderRole pageUnderRole = new Monks.aspnet_PageUnderRole();
pageUnderRole.FilePath = dlPages.SelectedValue.Trim();
pageUnderRole.PageId = Guid.NewGuid();
pageUnderRole.RoleId = roleId;
db.aspnet_PageUnderRoles.InsertOnSubmit(pageUnderRole);
db.SubmitChanges();
var pagePermissions = db.aspnet_PageUnderRoles.Where(p=>p.RoleId == roleId);
rpPagePermissions.DataSource = pagePermissions;
rpPagePermissions.DataBind();
var tablePermissions = db.aspnet_TableUnderRoles.Where(p=>p.RoleId == roleId);
rpTablePermissions.DataSource = tablePermissions;
rpTablePermissions.DataBind();
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
Monks.jkp_Book book = db.jkp_Books.First(p=>p.Bk_ID == BookId);
litTitle.Text = book.Bk_Title;
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
if (!Page.IsPostBack)
{
LoadDate(db);
}
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
var articlePages = from a in db.jkp_ArticlePages
select a;
rpArticlePages.DataSource = articlePages;
rpArticlePages.DataBind();
}
private void LoadDate(MonkData db)
{
if (SiteId != null)
{
Monks.jkp_Site site = db.jkp_Sites.First(p => p.Site_ID == SiteId);
txtEnglishName.Text = site.Site_EnglishName;
txtDescription.Text = site.Site_Description;
}
}
public void btnDelete_Clicked(object sender, EventArgs e)
{
LinkButton lbtnDelete = (LinkButton)sender;
Guid itemIdToDelete = new Guid(lbtnDelete.Attributes["itemid"]);
MonkData db = new MonkData();
string tableName = ((System.Data.Linq.Mapping.TableAttribute)DataType.GetCustomAttributes(typeof(System.Data.Linq.Mapping.TableAttribute), false).First()).Name;
primaryKeyProp = GetPrimaryKeyProperty(DataType);
db.ExecuteCommand("DELETE FROM " + tableName + " WHERE " + primaryKeyProp.Name + " = '" + itemIdToDelete.ToString() + "'");
db.SubmitChanges();
}
public void lbtnRemoveMediaRole_Clicked(object sender, EventArgs e)
{
LinkButton lbtnRemoveMediaRole = (LinkButton)sender;
Guid mediaRoleId = new Guid(lbtnRemoveMediaRole.Attributes["mediaroleid"]);
MonkData db = new MonkData();
Monks.jkp_MediaRole mediaRole = db.jkp_MediaRoles.First(p => p.MediaRoleId == mediaRoleId);
db.jkp_MediaRoles.DeleteOnSubmit(mediaRole);
db.SubmitChanges();
LoadPageData();
}
public void lbtnRemoveRole_Clicked(object sender, EventArgs e)
{
MonkData db = new MonkData();
LinkButton lbtnRemoveRole = (LinkButton)sender;
Guid roleId = new Guid( lbtnRemoveRole.Attributes["roleid"]);
Monks.aspnet_UsersInRole userInRole = db.aspnet_UsersInRoles.First(p=>p.RoleId == roleId && p.UserId == PageUserId);
db.aspnet_UsersInRoles.DeleteOnSubmit(userInRole);
db.SubmitChanges();
LoadPageData();
}
protected void Page_Load(object sender, EventArgs e)
{
hlEditMembership.NavigateUrl = "AddEdit.aspx?typename=aspnet_Membership&itemid=" + UserId.ToString();
hlEditUserDetails.NavigateUrl = "AddEdit.aspx?typename=aspnet_User&itemid=" + UserId.ToString();
hlEditRoles.NavigateUrl = "Admin-GivePersonRoles.aspx?userid=" + UserId.ToString();
MonkData db = new MonkData();
Monks.jkp_Person person = db.aspnet_Memberships.First(p=>p.UserId == UserId).jkp_Person;
litUserName.Text = person.Per_FirstName + " " + person.Per_LastName;
hlLoginAsUser.NavigateUrl = "Admin-LoginAsUser.aspx?username=" + person.aspnet_Memberships.First().aspnet_User.UserName;
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
rpAudioRecordings.DataSource = (from a in db.jkp_Audios orderby a.Aud_DateAdded descending select a).Take(10);
rpAudioRecordings.DataBind();
rpBooks.DataSource = (from b in db.jkp_Books orderby b.Bk_DateAdded descending select b).Take(10);
rpBooks.DataBind();
rpVideos.DataSource = (from b in db.jkp_Videos orderby b.Vid_DateAdded descending select b).Take(10);
rpVideos.DataBind();
}
public void detailsAddress_OnItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
DropDownList dlSanghas = (DropDownList)detailsAddress.FindControl("dlSanghas");
string idStringOfSangha = dlSanghas.SelectedValue;
MonkData db = new MonkData();
Monks.jkp_Person jPerson = db.aspnet_Memberships.First(p => p.UserId == UserId).jkp_Person;
jPerson.jkp_Address.Add_San_ID = new Guid(idStringOfSangha);
db.SubmitChanges();
detailsAddress.DataBind();
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
System.Linq.IQueryable<System.Linq.IGrouping<string, Monks.jkp_Site>> sites = from s in db.jkp_Sites
orderby s.Site_EnglishName
group s by s.jkp_Address.Add_Country into g
select g;
rpCountriesOfSites.DataSource = sites;
rpCountriesOfSites.DataBind();
}
private void LoadDate(MonkData db)
{
if (AddressId != null)
{
Monks.jkp_Address address = db.jkp_Addresses.First(p => p.Add_ID == AddressId);
txtAddress.Text = address.Add_Street;
txtCity.Text = address.Add_City;
txtCountry.Text = address.Add_Country;
txtState.Text = address.Add_State;
txtZip.Text = address.Add_PostalCode;
}
}
public void DetailsView2_OnItemUpdated(object sender, DetailsViewUpdatedEventArgs e)
{
DropDownList dlGender = (DropDownList)DetailsView2.FindControl("genderSelection");
string valueOfGender = dlGender.SelectedItem.Text;
MonkData db = new MonkData();
Monks.jkp_Person jPerson = db.aspnet_Memberships.First(p => p.UserId == UserId).jkp_Person;
jPerson.Per_Gender = valueOfGender[0];
db.SubmitChanges();
DetailsView2.DataBind();
}
protected override void OnPreRender(EventArgs e)
{
base.OnPreRender(e);
MonkData db = new MonkData();
Monks.jkp_Audio audio = db.jkp_Audios.First(p=>p.Aud_ID == AudioId);
litAudioItem.Text = audio.Aud_Title;
if(!String.IsNullOrEmpty(audio.Aud_Pathname))
{
hlDownload.NavigateUrl = audio.Aud_Pathname;
}
else
hlDownload.NavigateUrl = "#";
}
public void btnMarkAsPaidSave_Clicked(object sender, EventArgs e)
{
Guid contribId = new Guid(btnMarkAsPaidSave.Attributes["contid"]);
MonkData db = new MonkData();
Monks.jkp_Contribution contrib = db.jkp_Contributions.First(p => p.Cont_ID == contribId);
if (!contrib.Cont_AmountPaid.HasValue || contrib.Cont_AmountPaid.Value == 0)
contrib.Cont_AmountPaid = decimal.Parse(txtAmountPaid.Text);
else
contrib.Cont_AmountPaid += decimal.Parse(txtAmountPaid.Text);
db.SubmitChanges();
modalMarkAsPaid.Hide();
LoadContributions();
}
public void LoadPageData()
{
MonkData db = new MonkData();
Monks.jkp_Person person = db.aspnet_Memberships.First(p=>p.UserId == PageUserId).jkp_Person;
litPersonName.Text = person.Per_FirstName + " " + person.Per_LastName;
rpPersonRoles.DataSource = db.aspnet_UsersInRoles.Where(p=>p.UserId == PageUserId);
rpPersonRoles.DataBind();
dlRolesToAssign.DataSource = db.aspnet_Roles;
dlRolesToAssign.DataTextField = "RoleName";
dlRolesToAssign.DataValueField = "RoleId";
dlRolesToAssign.DataBind();
}
/// <summary>
/// Event clicked when the user signs up.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSignup_Clicked(object sender, EventArgs e)
{
if (CheckUsername() || CheckEmail())
return;
btnSignup.Enabled = false;
MonkData db = new MonkData();
// Get the application from the ASP.NET Membership object. When we create the user, we'll need to know what aspnet_Application object they will use.
// This is the only spot in the entire site where we'll care about the asp.net application.
var app = (from u in db.aspnet_Applications
where u.ApplicationName == "DeerPark"
select u).Single();
string salt = GenerateSalt(); // Gets the salt that will be used for encoding the password if encoding the password is turned on.
// Load up all of the LINQ objects for a new user
bool personExists = false; // use a bool to see if the corresponding person entry exists. if so, do not perform insert to db
Monks.jkp_Person jPerson = Create_jkp_Person(ref personExists, ref db);
if (personExists)
{
jPerson.Per_Email = txtEmailAddress1.Text;
}
Monks.jkp_Address jAddress = Create_jkp_Address();
Monks.aspnet_Membership curMembership = Create_aspnet_Membership(app, salt);
Monks.aspnet_User curUser = Create_aspnet_User(curMembership);
// Attach the Person ID to the aspnet_Membership object
curMembership.PersonId = jPerson.Per_ID;
jPerson.Per_Add_ID = jAddress.Add_ID;
// Setup the inserts.
db.jkp_Addresses.InsertOnSubmit(jAddress);
// do not perform insert to the person table if an entry was already found for them
if (!personExists)
{
db.jkp_Persons.InsertOnSubmit(jPerson);
}
db.aspnet_Users.InsertOnSubmit(curUser);
db.aspnet_Memberships.InsertOnSubmit(curMembership);
// Submit the inserts. This is a transactional insert. If one fails, they all fail.
db.SubmitChanges();
// Show the success view.
mvSignup.ActiveViewIndex = 1;
FormsAuthentication.SetAuthCookie(txtUsername.Text, false);
}
protected void Page_Load(object sender, EventArgs e)
{
hlActAddEditRooms.NavigateUrl = "Retreat-AddEditRooms.aspx?retreatid=" + RetreatId.ToString();
hlActAssignPeople.NavigateUrl = "Retreat-AssignRooms.aspx?retreatid=" + RetreatId.ToString();
hlActViewRetreatants.NavigateUrl = "Retreat-ViewRetreatants.aspx?retreatid=" + RetreatId.ToString();
hlActEditRetreatDetals.NavigateUrl = "AddEdit.aspx?typename=jkp_Retreat&itemid=" + RetreatId.ToString();
hlActAssignments.NavigateUrl = "Retreat-Assignments.aspx?retreatid=" + RetreatId.ToString();
hlActActivites.NavigateUrl = "Retreat-Activities.aspx?retreatid=" + RetreatId.ToString();
hlActBuilder.NavigateUrl = "Retreat-Builder.aspx?retreatid=" + RetreatId.ToString();
hlActDiscussionGroups.NavigateUrl = "Retreat-DiscussionGroups.aspx?retreatid=" + RetreatId.ToString();
hlContributions.NavigateUrl = "Retreat-Contributions.aspx?retreatid=" + RetreatId.ToString();
MonkData db = new MonkData();
Monks.jkp_Retreat retreat = db.jkp_Retreats.First(p=>p.Ret_ID == RetreatId);
litRetreatName.Text = retreat.Ret_Name;
}
public void LoadGame()
{
Debug.Log(Application.persistentDataPath);
if (File.Exists(Application.persistentDataPath + "/gamesave.save"))
{
BinaryFormatter bf = new BinaryFormatter();
FileStream file = File.Open(Application.persistentDataPath + "/gamesave.save", FileMode.Open);
Save save = (Save)bf.Deserialize(file);
file.Close();
lastLevelWon = save.s_lastLevelWon;
//Aqui se hace lo contrario que en el CreateSaveGameObject. Se toman las variables del save y se aplican esos valores a las variables que se usan en código
currentExp = save.s_currentXp;
characterDataForCurrentLevel.Clear();
for (int i = 0; i < allCharacters.Length; i++)
{
if (save.s_charactersUnlocked.Contains(allCharacters[i].idCharacter))
{
characterDataForCurrentLevel.Add(allCharacters[i]);
allCharacters[i].isCharacterUnlocked = true;
allCharacters[i].HideShowMeshCharacterData(true);
}
}
allLevelNodes = FindObjectsOfType <LevelNode>();
//List<LevelNode> allLevelNodesList = new List<LevelNode>(allLevelNodes);
//allLevelNodesList.Sort(delegate (LevelNode a, LevelNode b)
//{
// return (a.GetComponent<LevelNode>().idLevel).CompareTo(b.GetComponent<LevelNode>().idLevel);
//});
//allLevelNodes = allLevelNodesList.ToArray();
levelIDsUnlocked.Clear();
levelIDsUnlocked = new List <int>(save.s_levelIDsUnlocked);
for (int i = 0; i < allLevelNodes.Length; i++)
{
for (int j = 0; j < levelIDsUnlocked.Count; j++)
{
if (allLevelNodes[i].idLevel == levelIDsUnlocked[j])
{
if (lastLevelWon <= allLevelNodes[i].idLevel)
{
lastLevelWon = allLevelNodes[i].idLevel;
}
allLevelNodes[i].WinLevel();
allLevelNodes[i].UnlockThisLevel();
allLevelNodes[i].UnlockConnectedLevels();
break;
}
}
}
//for (int i = 0; i < save.s_levelIDsUnlocked.Count; i++)
//{
// levelIDsUnlocked.Add(save.s_levelIDsUnlocked[i]);
// if (allLevelNodes[save.s_levelIDsUnlocked[i-1]].idLevel < lastLevelWon)
// {
// allLevelNodes[save.s_levelIDsUnlocked[i-1]].WinLevel();
// }
// else if (allLevelNodes[save.s_levelIDsUnlocked[i-1]].idLevel == lastLevelWon-1)
// {
// allLevelNodes[save.s_levelIDsUnlocked[i-1]].UnlockConnectedLevels();
// }
// //allLevelNodes[save.s_levelIDsUnlocked[i]].UnlockThisLevel();
//}
//if (allLevelNodes[2].isUnlocked)
//{
// allLevelNodes[1].UnlockThisLevel();
//}
#region Characters
UITableManager UITM = FindObjectOfType <UITableManager>();
KnightData _knight = FindObjectOfType <KnightData>();
_knight.unitPowerLevel = save.s_KnightPowerLevel;
if (_knight.isCharacterUnlocked)
{
for (int i = 0; i < save.s_KnightSkillsIds.Count; i++)
{
_knight.idSkillsBought.Add(save.s_KnightSkillsIds[i]);
}
UITM.SetCharacterUpgradeBookInfo(_knight);
}
RogueData _rogue = FindObjectOfType <RogueData>();
_rogue.unitPowerLevel = save.s_RoguePowerLevel;
if (_rogue.isCharacterUnlocked)
{
for (int i = 0; i < save.s_RogueSkillsIds.Count; i++)
{
_rogue.idSkillsBought.Add(save.s_RogueSkillsIds[i]);
}
UITM.SetCharacterUpgradeBookInfo(_rogue);
}
MageData _mage = FindObjectOfType <MageData>();
_mage.unitPowerLevel = save.s_MagePowerLevel;
if (_mage.isCharacterUnlocked)
{
for (int i = 0; i < save.s_MageSkillsIds.Count; i++)
{
_mage.idSkillsBought.Add(save.s_MageSkillsIds[i]);
}
UITM.SetCharacterUpgradeBookInfo(_mage);
}
BerserkerData _berserker = FindObjectOfType <BerserkerData>();
_berserker.unitPowerLevel = save.s_BerserkerPowerLevel;
if (_berserker.isCharacterUnlocked)
{
for (int i = 0; i < save.s_BerserkerSkillsIds.Count; i++)
{
_berserker.idSkillsBought.Add(save.s_BerserkerSkillsIds[i]);
}
UITM.SetCharacterUpgradeBookInfo(_berserker);
}
ValkyrieData _valkyrie = FindObjectOfType <ValkyrieData>();
_valkyrie.unitPowerLevel = save.s_ValkyriePowerLevel;
if (_valkyrie.isCharacterUnlocked)
{
for (int i = 0; i < save.s_ValkyrieSkillsIds.Count; i++)
{
_valkyrie.idSkillsBought.Add(save.s_ValkyrieSkillsIds[i]);
}
UITM.SetCharacterUpgradeBookInfo(_valkyrie);
}
DruidData _druid = FindObjectOfType <DruidData>();
_druid.unitPowerLevel = save.s_DruidPowerLevel;
if (_druid.isCharacterUnlocked)
{
for (int i = 0; i < save.s_DruidSkillsIds.Count; i++)
{
_druid.idSkillsBought.Add(save.s_DruidSkillsIds[i]);
}
UITM.SetCharacterUpgradeBookInfo(_druid);
}
MonkData _monk = FindObjectOfType <MonkData>();
_monk.unitPowerLevel = save.s_MonkPowerLevel;
if (_monk.isCharacterUnlocked)
{
for (int i = 0; i < save.s_MonkSkillsIds.Count; i++)
{
_monk.idSkillsBought.Add(save.s_MonkSkillsIds[i]);
}
UITM.SetCharacterUpgradeBookInfo(_monk);
}
SamuraiData _samurai = FindObjectOfType <SamuraiData>();
_samurai.unitPowerLevel = save.s_SamuraiPowerLevel;
if (_samurai.isCharacterUnlocked)
{
for (int i = 0; i < save.s_SamuraiSkillsIds.Count; i++)
{
_samurai.idSkillsBought.Add(save.s_SamuraiSkillsIds[i]);
}
UITM.SetCharacterUpgradeBookInfo(_samurai);
}
#endregion
enemiesKilled = save.s_enemiesKilled;
randomLevelsCompleted = save.s_randomLevelsCompleted;
Debug.Log("File Load");
Debug.Log("-----");
}
else
{
Debug.Log("Se ha intentado cargar y no existe archivo de guardado");
SaveGame();
}
}
//Esta función se usa únicamente en el SaveGame. La he separado para que quede más claro la información que se guarda en cada archivo
private Save CreateSaveGameObject()
{
//Construyo archivo de guardado e inicializo todas las variables en el save
Save save = new Save();
save.s_lastLevelWon = lastLevelWon;
save.s_currentXp = currentExp;
for (int i = 0; i < characterDataForCurrentLevel.Count; i++)
{
save.s_charactersUnlocked.Add(characterDataForCurrentLevel[i].idCharacter);
}
for (int i = 0; i < levelIDsUnlocked.Count; i++)
{
save.s_levelIDsUnlocked.Add(levelIDsUnlocked[i]);
}
#region Characters
KnightData _knight = FindObjectOfType <KnightData>();
save.s_KnightPowerLevel = _knight.unitPowerLevel;
if (_knight.isCharacterUnlocked)
{
for (int i = 0; i < _knight.idSkillsBought.Count; i++)
{
save.s_KnightSkillsIds.Add(_knight.idSkillsBought[i]);
}
}
RogueData _rogue = FindObjectOfType <RogueData>();
save.s_RoguePowerLevel = _rogue.unitPowerLevel;
if (_rogue.isCharacterUnlocked)
{
for (int i = 0; i < _rogue.idSkillsBought.Count; i++)
{
save.s_RogueSkillsIds.Add(_rogue.idSkillsBought[i]);
}
}
MageData _mage = FindObjectOfType <MageData>();
save.s_MagePowerLevel = _mage.unitPowerLevel;
if (_mage.isCharacterUnlocked)
{
for (int i = 0; i < _mage.idSkillsBought.Count; i++)
{
save.s_MageSkillsIds.Add(_mage.idSkillsBought[i]);
}
}
BerserkerData _berserker = FindObjectOfType <BerserkerData>();
save.s_BerserkerPowerLevel = _berserker.unitPowerLevel;
if (_berserker.isCharacterUnlocked)
{
for (int i = 0; i < _berserker.idSkillsBought.Count; i++)
{
save.s_BerserkerSkillsIds.Add(_berserker.idSkillsBought[i]);
}
}
ValkyrieData _valkyrie = FindObjectOfType <ValkyrieData>();
save.s_ValkyriePowerLevel = _valkyrie.unitPowerLevel;
if (_valkyrie.isCharacterUnlocked)
{
for (int i = 0; i < _valkyrie.idSkillsBought.Count; i++)
{
save.s_ValkyrieSkillsIds.Add(_valkyrie.idSkillsBought[i]);
}
}
DruidData _druid = FindObjectOfType <DruidData>();
save.s_DruidPowerLevel = _druid.unitPowerLevel;
if (_druid.isCharacterUnlocked)
{
for (int i = 0; i < _druid.idSkillsBought.Count; i++)
{
save.s_DruidSkillsIds.Add(_druid.idSkillsBought[i]);
}
}
MonkData _monk = FindObjectOfType <MonkData>();
save.s_MonkPowerLevel = _monk.unitPowerLevel;
if (_monk.isCharacterUnlocked)
{
for (int i = 0; i < _monk.idSkillsBought.Count; i++)
{
save.s_MonkSkillsIds.Add(_monk.idSkillsBought[i]);
}
}
SamuraiData _samurai = FindObjectOfType <SamuraiData>();
save.s_SamuraiPowerLevel = _samurai.unitPowerLevel;
if (_samurai.isCharacterUnlocked)
{
for (int i = 0; i < _samurai.idSkillsBought.Count; i++)
{
save.s_SamuraiSkillsIds.Add(_samurai.idSkillsBought[i]);
}
}
#endregion
save.s_enemiesKilled = enemiesKilled;
save.s_randomLevelsCompleted = randomLevelsCompleted;
return(save);
}
public void ReseteSaveFile()
{
if (File.Exists(Application.persistentDataPath + "/gamesave.save"))
{
BinaryFormatter bf = new BinaryFormatter();
FileStream file = File.Open(Application.persistentDataPath + "/gamesave.save", FileMode.Open);
Save save = (Save)bf.Deserialize(file);
file.Close();
//Aqui se hace lo contrario que en el CreateSaveGameObject. Se toman las variables del save y se aplican esos valores a las variables que se usan en código
currentExp = 0;
lastLevelWon = 0;
characterDataForCurrentLevel.Clear();
allLevelNodes = FindObjectsOfType <LevelNode>();
for (int i = 0; i < allLevelNodes.Length; i++)
{
allLevelNodes[i].HideThisLevel();
}
levelIDsUnlocked.Clear();
for (int i = 0; i < allLevelNodes.Length; i++)
{
if (allLevelNodes[i].idLevel == 1)
{
levelIDsUnlocked.Add(allLevelNodes[i].idLevel);
allLevelNodes[i].UnlockThisLevel();
}
}
#region Characters
KnightData _knight = FindObjectOfType <KnightData>();
_knight.unitPowerLevel = _knight.initialPowerLevelOnlyUsedForResetSaveFile;
_knight.HideShowMeshCharacterData(true);
_knight.isCharacterUnlocked = true;
_knight.idSkillsBought.Clear();
MageData _mage = FindObjectOfType <MageData>();
_mage.unitPowerLevel = _mage.initialPowerLevelOnlyUsedForResetSaveFile;
_mage.HideShowMeshCharacterData(true);
_mage.isCharacterUnlocked = true;
_mage.idSkillsBought.Clear();
//Añado al mago y al caballero para que salgan en la caja de selección al principio
characterDataForCurrentLevel.Add(_knight);
characterDataForCurrentLevel.Add(_mage);
RogueData _rogue = FindObjectOfType <RogueData>();
_rogue.unitPowerLevel = _rogue.initialPowerLevelOnlyUsedForResetSaveFile;
_rogue.HideShowMeshCharacterData(false);
_rogue.isCharacterUnlocked = false;
_rogue.idSkillsBought.Clear();
BerserkerData _berserker = FindObjectOfType <BerserkerData>();
_berserker.unitPowerLevel = _berserker.initialPowerLevelOnlyUsedForResetSaveFile;
_berserker.HideShowMeshCharacterData(false);
_berserker.isCharacterUnlocked = false;
_berserker.idSkillsBought.Clear();
ValkyrieData _valkyrie = FindObjectOfType <ValkyrieData>();
_valkyrie.unitPowerLevel = _valkyrie.initialPowerLevelOnlyUsedForResetSaveFile;
_valkyrie.HideShowMeshCharacterData(false);
_valkyrie.isCharacterUnlocked = false;
_valkyrie.idSkillsBought.Clear();
DruidData _druid = FindObjectOfType <DruidData>();
_druid.unitPowerLevel = _druid.initialPowerLevelOnlyUsedForResetSaveFile;
_druid.HideShowMeshCharacterData(false);
_druid.isCharacterUnlocked = false;
_druid.idSkillsBought.Clear();
MonkData _monk = FindObjectOfType <MonkData>();
_monk.unitPowerLevel = _monk.initialPowerLevelOnlyUsedForResetSaveFile;
_monk.HideShowMeshCharacterData(false);
_monk.isCharacterUnlocked = false;
_monk.idSkillsBought.Clear();
SamuraiData _samurai = FindObjectOfType <SamuraiData>();
_samurai.unitPowerLevel = _samurai.initialPowerLevelOnlyUsedForResetSaveFile;
_samurai.HideShowMeshCharacterData(false);
_samurai.isCharacterUnlocked = false;
_samurai.idSkillsBought.Clear();
#endregion
enemiesKilled = 0;
randomLevelsCompleted = 0;
Debug.Log("File Reseted");
Debug.Log("-----");
}
else
{
Debug.Log("Se ha intentado cargar y no existe archivo de guardado");
}
print(Application.persistentDataPath);
}
