// Load other news
public List<News_details_entity> Load_othernews(string _sNews_Seo_Url)
{
try
{
List<News_details_entity> l = new List<News_details_entity>();
if (_sNews_Seo_Url != "")
{
var s = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
where a.NEWS_SEO_URL == _sNews_Seo_Url
select new { b.CAT_ID}).ToList();
var _tinTucKhac = (from c in db.ESHOP_NEWS_CATs
join a in db.ESHOP_NEWs on c.NEWS_ID equals a.NEWS_ID
join b in db.ESHOP_CATEGORies on c.CAT_ID equals b.CAT_ID
where a.NEWS_SEO_URL != _sNews_Seo_Url && b.CAT_ID == s[0].CAT_ID
select new { a.NEWS_ID, a.NEWS_TITLE, a.NEWS_IMAGE3, a.NEWS_PRICE1, a.NEWS_DESC, a.NEWS_SEO_URL, a.NEWS_URL, a.NEWS_ORDER, a.NEWS_ORDER_PERIOD, a.NEWS_PUBLISHDATE, c.ESHOP_CATEGORy.CAT_SEO_URL }).OrderByDescending(n => n.NEWS_PUBLISHDATE).Take(99).Distinct();
if (_tinTucKhac.ToList().Count > 0)
{
foreach (var i in _tinTucKhac)
{
News_details_entity pro = new News_details_entity();
pro.NEWS_ID = i.NEWS_ID;
pro.NEWS_TITLE = i.NEWS_TITLE;
pro.NEWS_IMAGE3 = i.NEWS_IMAGE3;
pro.NEWS_DESC = i.NEWS_DESC;
pro.NEWS_SEO_URL = i.NEWS_SEO_URL;
pro.NEWS_URL = i.NEWS_URL;
pro.NEWS_ORDER = Utils.CIntDef(i.NEWS_ORDER);
pro.NEWS_ORDER_PERIOD = Utils.CIntDef(i.NEWS_ORDER_PERIOD);
pro.NEWS_PUBLISHDATE = Utils.CDateDef(i.NEWS_PUBLISHDATE, DateTime.Now);
pro.CAT_SEO_URL = i.CAT_SEO_URL;
l.Add(pro);
}
}
}
return l.OrderByDescending(n => n.NEWS_PUBLISHDATE).ToList();
}
catch (Exception ex)
{
clsVproErrorHandler.HandlerError(ex);
return null;
}
}
/// <summary>
/// Lists the activities that matches selected criteria (type/period).
/// </summary>
private async void ListActivities()
{
DateTime? ldtStart = null;
DateTime? ldtEnd = null;
MSHealthActivityType loActivityType = MSHealthActivityType.Unknown;
MSHealthSplitDistanceType loDistance = MSHealthSplitDistanceType.None;
try
{
IsRunningRequest = true;
Activities = null;
// Check if at least one Activity Type was selected
bool lbFilterActivityType = FilterActivityExercise | FilterActivityRun | FilterActivityBike |
FilterActivityGolf | FilterActivitySleep | FilterActivityGuided |
FilterActivityHike;
if (!lbFilterActivityType)
{
#if WINDOWS_UWP
await moDialogService.ShowMessage(Resources.Strings.MessageContentSelectActivityType,
Resources.Strings.MessageTitleFilterActivities);
#endif
return;
}
// Determine Activity Types to filter
if (FilterActivityExercise)
loActivityType |= MSHealthActivityType.FreePlay;
if (FilterActivityRun)
loActivityType |= MSHealthActivityType.Run;
if (FilterActivityBike)
loActivityType |= MSHealthActivityType.Bike;
if (FilterActivityGolf)
loActivityType |= MSHealthActivityType.Golf;
if (FilterActivitySleep)
loActivityType |= MSHealthActivityType.Sleep;
if (FilterActivityGuided)
loActivityType |= MSHealthActivityType.GuidedWorkout;
if (FilterActivityHike)
loActivityType |= MSHealthActivityType.Hike;
// Determine Period to filter
switch (Settings.MSHealthFilterPeriod)
{
case Settings.PERIOD_DAY:
ldtEnd = DateTime.Today.AddDays(1).AddMilliseconds(-1);
ldtStart = DateTime.Today.AddDays(-1);
break;
case Settings.PERIOD_WEEK:
ldtEnd = DateTime.Today.AddDays(1).AddMilliseconds(-1);
ldtStart = DateTime.Today.AddDays(-7);
break;
case Settings.PERIOD_MONTH:
ldtEnd = DateTime.Today.AddDays(1).AddMilliseconds(-1);
ldtStart = DateTime.Today.AddMonths(-1);
break;
case Settings.PERIOD_YEAR:
ldtEnd = DateTime.Today.AddDays(1).AddMilliseconds(-1);
ldtStart = DateTime.Today.AddYears(-1);
break;
}
// Determine Distance Unit to retrieve
switch (Settings.MSHealthFilterDistance)
{
case DistanceUnit.DISTANCE_MILE:
loDistance = MSHealthSplitDistanceType.Mile;
break;
case DistanceUnit.DISTANCE_KILOMETER:
loDistance = MSHealthSplitDistanceType.Kilometer;
break;
}
// Find activities with selected criteria, and update MSHealth Token
MSHealthActivities loActivities = await moMSHealthClient.ListActivities(startTime: ldtStart,
endTime: ldtEnd,
type: loActivityType,
splitDistanceType: loDistance);
Settings.MSHealthToken = moMSHealthClient.Token;
// Parse each separated activity list into one single activity list
List<MSHealthActivity> loActivitiesList = new List<MSHealthActivity>();
if (loActivities.BikeActivities != null &&
loActivities.BikeActivities.Any())
loActivitiesList.AddRange(loActivities.BikeActivities);
if (loActivities.RunActivities != null &&
loActivities.RunActivities.Any())
loActivitiesList.AddRange(loActivities.RunActivities);
if (loActivities.SleepActivities != null &&
loActivities.SleepActivities.Any())
loActivitiesList.AddRange(loActivities.SleepActivities);
if (loActivities.FreePlayActivities != null &&
loActivities.FreePlayActivities.Any())
loActivitiesList.AddRange(loActivities.FreePlayActivities);
if (loActivities.GolfActivities != null &&
loActivities.GolfActivities.Any())
loActivitiesList.AddRange(loActivities.GolfActivities);
if (loActivities.GuidedWorkoutActivities != null &&
loActivities.GuidedWorkoutActivities.Any())
loActivitiesList.AddRange(loActivities.GuidedWorkoutActivities);
if (loActivities.HikeActivities != null &&
loActivities.HikeActivities.Any())
loActivitiesList.AddRange(loActivities.HikeActivities);
// Sort descending by Start Time and append to Bindable property
loActivitiesList = loActivitiesList.OrderByDescending(loAct => loAct.StartTime).ToList();
Activities = new ObservableCollection<MSHealthActivity>(loActivitiesList);
}
catch (Exception loException)
{
// Handle exceptions (just for debugging purposes). TODO: Delete this code
if (System.Diagnostics.Debugger.IsAttached)
{
System.Diagnostics.Debug.WriteLine(loException.StackTrace);
System.Diagnostics.Debugger.Break();
} // Handle exceptions (just for debugging purposes)
// Show error message
#if WINDOWS_UWP
await moDialogService.ShowError(Resources.Strings.MessageContentErrorOperation,
Resources.Strings.MessageTitleError,
Resources.Strings.MessageButtonOK,
null);
#endif
}
finally
{
IsRunningRequest = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (this.Session[Settings.Default.FlashSessionKey] != null)
{
this.FlashLiteralWrapper.Visible = true;
this.FlashLiteral.Text = this.Session[Settings.Default.FlashSessionKey].ToString();
this.Session[Settings.Default.FlashSessionKey] = null;
}
else
{
this.FlashLiteralWrapper.Visible = false;
}
this._petIdString = this.Request.QueryString["petid"];
if (String.IsNullOrEmpty(this._petIdString))
{
this.StatsLiteral.Text = "Add a New Pet";
this.SaveStatsButton.Text = "Save New Pet";
}
else
{
this.PhotoPanel.Visible = true;
}
this._userBucketName = String.Format(Settings.Default.BucketNameFormat, this.Context.User.Identity.Name, this._petIdString);
this._itemName = this._petIdString ?? Guid.NewGuid().ToString();
this._domainName = String.Format(Settings.Default.SimpleDbDomainNameFormat, this.Context.User.Identity.Name);
if (!this.Page.IsPostBack)
{
List<int> years = new List<int>(100);
for (int i = 0; i < 100; i++)
{
years.Add(DateTime.Now.AddYears(i * -1).Year);
}
this.YearDropDownList.DataSource = years.OrderByDescending(y => y);
this.YearDropDownList.DataBind();
this.SelectMonth();
this.SelectDay();
Pet pet = default(Pet);
List<string> files = new List<string>();
if (!String.IsNullOrEmpty(this._petIdString))
{
//
// Try to get the requested pet from the user's private domain
//
DomainHelper.CheckForDomain(this._domainName, _simpleDBClient);
GetAttributesRequest getAttributeRequest = new GetAttributesRequest()
.WithDomainName(this._domainName)
.WithItemName(this._itemName);
GetAttributesResponse getAttributeResponse = _simpleDBClient.GetAttributes(getAttributeRequest);
List<Attribute> attrs = null;
bool showPublic = false;
if (getAttributeResponse.IsSetGetAttributesResult())
{
attrs = getAttributeResponse.GetAttributesResult.Attribute;
showPublic = false;
//
// If we can't find it try the public domain
//
if (attrs.Count == 0)
{
showPublic = true;
}
}
if (showPublic)
{
Response.Redirect(String.Concat("PetProfile.aspx?petid", _petIdString));
return;
}
pet = new Pet
{
Name = attrs.First(a => a.Name == "Name").Value,
Birthdate = attrs.First(a => a.Name == "Birthdate").Value,
Sex = attrs.First(a => a.Name == "Sex").Value,
Type = attrs.First(a => a.Name == "Type").Value,
Breed = attrs.First(a => a.Name == "Breed").Value,
Likes = attrs.First(a => a.Name == "Likes").Value,
Dislikes = attrs.First(a => a.Name == "Dislikes").Value
};
this.Public.Checked = bool.Parse(attrs.First(a => a.Name == "Public").Value);
using (AmazonS3Client s3Client = new AmazonS3Client(Settings.Default.AWSAccessKey.Trim(), Settings.Default.AWSSecretAccessKey.Trim()))
{
BucketHelper.CheckForBucket(this._petIdString, s3Client);
ListObjectsRequest listObjectsRequest = new ListObjectsRequest()
.WithBucketName(this._userBucketName);
using (ListObjectsResponse listObjectsResponse = s3Client.ListObjects(listObjectsRequest))
{
files = listObjectsResponse.S3Objects.Select(o => String.Format(Settings.Default.S3BucketUrlFormat, this._userBucketName, o.Key)).ToList();
string firstPhoto = files.FirstOrDefault();
this.PhotoThumbUrl.Value = firstPhoto ?? String.Empty;
}
}
}
if (pet != default(Pet))
{
this.PetNameHeader.Text = pet.Name;
this.NameTextBox.Text = pet.Name;
this.AnimalDropDownList.SelectedValue = pet.Type;
this.BreedTextBox.Text = pet.Breed;
this.SexDropDownList.SelectedValue = pet.Sex;
if (pet.Birthdate != null)
{
DateTime birthdate = DateTime.Parse(pet.Birthdate);
this.YearDropDownList.SelectedValue = birthdate.Year.ToString();
this.MonthDropDownList.SelectedValue = birthdate.Month.ToString();
this.DayDropDownList.SelectedValue = birthdate.Day.ToString();
}
this.LikesTextBox.Text = pet.Likes;
this.DislikesTextBox.Text = pet.Dislikes;
this.PhotoRepeater.DataSource = files;
this.PhotoRepeater.DataBind();
}
}
}