protected void btnSaveStars_OnClick(object sender, EventArgs e)
{
// ddl
var x = Convert.ToInt32(ddlStars.SelectedItem.Value);
DefinedValueService definedValueService = new DefinedValueService(rockContext);
var definedValue = definedValueService.Queryable().FirstOrDefault(a => a.Id == x);
definedValue.LoadAttributes();
var attributeValue = definedValue.GetAttributeValue("StarValue");
var starsValue = Convert.ToDecimal(attributeValue);
var pa = Person.PrimaryAliasId;
//var pa = ppPerson.PersonAliasId;
//var value = Decimal.Parse(tbValue.Text);
StarsService starsService = new StarsService(starsProjectContext);
org.newpointe.Stars.Model.Stars stars = new org.newpointe.Stars.Model.Stars();
stars.PersonAliasId = pa.GetValueOrDefault();
stars.CampusId = 1;
stars.TransactionDateTime = DateTime.Now;
stars.Value = starsValue;
stars.Note = ddlStars.SelectedItem.Text + ". Manually added by " + CurrentPerson.FullName;
starsService.Add(stars);
starsProjectContext.SaveChanges();
//Refresh Page to update grids
Response.Redirect(Request.RawUrl);
}
protected void Page_Load(object sender, EventArgs e)
{
SelectedPerson = Person;
StarsService starsService = new StarsService(starsProjectContext);
var starsList = starsService.Queryable().Where(a => a.PersonAliasId == SelectedPerson.PrimaryAliasId.Value).OrderByDescending(a => a.TransactionDateTime).ToList();
gStars.DataSource = starsList;
gStars.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
SelectedPerson = Person;
StarsService starsService = new StarsService(starsProjectContext);
var starsList = starsService.Queryable().Where(a => a.PersonAliasId == SelectedPerson.PrimaryAliasId.Value).OrderByDescending(a => a.TransactionDateTime).ToList();
gStars.DataSource = starsList;
gStars.DataBind();
}
protected void BindGrid()
{
StarsService starsService = new StarsService(_starsProjectContext);
DateTime selectedDate = mypMonth.SelectedDate ?? DateTime.Now;
var selectedDateBefore = selectedDate.SundayDate().AddDays(-6);
var selectedDateAfter = selectedDate.AddMonths(1).SundayDate().AddDays(-6);
var starsList = starsService.Queryable()
.Where(x => x.TransactionDateTime > selectedDateBefore && x.TransactionDateTime < selectedDateAfter)
.GroupBy(x => x.PersonAlias.Person, (x, y) => new { Person = x, Sum = y.Sum(z => z.Value) })
.ToList()
.Select(x => new { x.Person, x.Sum, Campus = x.Person.GetCampus() });
//Filter Campuses
var selectedCampuses = cpCampus.SelectedValues;
if (selectedCampuses.Count > 0)
{
starsList = starsList.Where(x => x.Campus == null || selectedCampuses.Contains(x.Campus.Name)).ToList();
}
//Get Sum of stars
var startsList = starsList.Select(g =>
{
var personLoc = g.Person.GetHomeLocation();
return(new
{
Month = selectedDate.Month,
g.Person.Id,
g.Person,
g.Sum,
g.Campus,
PersonZip = personLoc != null ? personLoc.PostalCode : ""
});
});
//Filter Star Levels
int starsValueFilter = 0;
if (!string.IsNullOrWhiteSpace(ddlStars.SelectedValue))
{
starsValueFilter = ddlStars.SelectedValue.AsInteger();
startsList = startsList.Where(a => a.Sum >= starsValueFilter && a.Sum < starsValueFilter + 10);
}
//Order the list
startsList = startsList.OrderBy(g => g.Campus != null ? g.Campus.Name : "").ThenBy(g => g.PersonZip).ThenBy(g => g.Person.LastName).ThenBy(g => g.Person.FirstName);
//Bind list to grid
gStars.DataSource = startsList.ToList();
gStars.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
PersonAliasService personAliasService = new PersonAliasService(rockContext);
StarsService starsService = new StarsService(starsProjectContext);
var starsList = starsService.Queryable().GroupBy(a => a.PersonAlias.Person).Select(g => new { Person = g.Key, Sum = g.Sum(a => a.Value) }).ToList();
gStars.DataSource = starsList;
gStars.DataBind();
}
protected void BindGrid()
{
StarsService starsService = new StarsService(_starsProjectContext);
//Get Sum of stars
var startsList = from x in starsService.Queryable().ToList()
where x.TransactionDateTime.Month == FilterMonth && x.TransactionDateTime.Year == FilterYear
group x by x.PersonAlias.Person into g
select new {
Person = g.Key,
PersonId = g.Key.Id,
Sum = g.Sum(x => x.Value),
Month = g.Select(x => x.TransactionDateTime.Month),
PersonZip = g.Key.GetFamilies(_rockContext).FirstOrDefault().GroupLocations.FirstOrDefault().Location.PostalCode,
PersonCampus = g.Key.GetFamilies(_rockContext).FirstOrDefault().Campus.Name
};
//Filter Star Levels
int starsValueFilter = 0;
if (!ddlStars.SelectedValue.IsNullOrWhiteSpace())
{
starsValueFilter = Convert.ToInt32(ddlStars.SelectedValue);
startsList = startsList.AsQueryable().Where(a => a.Sum >= starsValueFilter && a.Sum < starsValueFilter + 10);
}
//Filter Campuses
var selectedCampuses = cpCampus.SelectedValues;
if (selectedCampuses.Count > 0)
{
var starsListWithCampus = (from x in startsList.ToList()
let firstOrDefault = x.Person.GetFamilies(_rockContext).FirstOrDefault()
where firstOrDefault != null && selectedCampuses.Contains(firstOrDefault.Campus.Name) select x);
startsList = starsListWithCampus;
}
//Order the list
startsList = startsList.OrderBy(g => g.PersonCampus).ThenBy(g => g.PersonZip).ThenBy(g => g.Person.LastName).ThenBy(g => g.Person.FirstName);
//Bind list to grid
gStars.DataSource = startsList.ToList();
gStars.DataBind();
}
protected void btnSaveStars_OnClick(object sender, EventArgs e)
{
var pa = ppPerson.PersonAliasId;
var value = Decimal.Parse(tbValue.Text);
StarsService starsService = new StarsService(starsProjectContext);
org.newpointe.Stars.Model.Stars stars = new org.newpointe.Stars.Model.Stars();
stars.PersonAliasId = pa.GetValueOrDefault();
stars.CampusId = 1;
stars.TransactionDateTime = DateTime.Now;
stars.Value = value;
starsService.Add(stars);
starsProjectContext.SaveChanges();
}
protected void btnSaveStars_OnClick(object sender, EventArgs e)
{
var pa = ppPerson.PersonAliasId;
var value = Decimal.Parse(tbValue.Text);
StarsService starsService = new StarsService(starsProjectContext);
org.newpointe.Stars.Model.Stars stars = new org.newpointe.Stars.Model.Stars();
stars.PersonAliasId = pa.GetValueOrDefault();
stars.CampusId = 1;
stars.TransactionDateTime = DateTime.Now;
stars.Value = value;
starsService.Add(stars);
starsProjectContext.SaveChanges();
}
public async Task TestGetAllStars()
{
var options = new DbContextOptionsBuilder <ApplicationDbContext>()
.UseInMemoryDatabase("Stars");
var starRepository = new EfDeletableEntityRepository <Stars>(new ApplicationDbContext(options.Options));
await starRepository.AddAsync(new Stars { Name = "One" });
await starRepository.AddAsync(new Stars { Name = "Two" });
await starRepository.SaveChangesAsync();
var starsService = new StarsService(starRepository);
AutoMapperConfig.RegisterMappings(typeof(MyTestStars).Assembly);
var stars = starsService.GetAll <MyTestStars>();
Assert.Equal(2, stars.Count());
}
public void SaveStars(DateTime dt, int paId, decimal starsValue, string note)
{
StarsProjectContext starsProjectContext = new StarsProjectContext();
StarsService starsService = new StarsService(starsProjectContext);
org.newpointe.Stars.Model.Stars stars = new org.newpointe.Stars.Model.Stars();
PersonAliasService personAliasService = new PersonAliasService(new RockContext());
int campusId = personAliasService.GetByAliasId(paId).Person.GetCampus().Id;
stars.PersonAliasId = paId;
stars.CampusId = campusId;
stars.TransactionDateTime = DateTime.Now;
stars.Value = starsValue;
stars.Note = note;
starsService.Add(stars);
starsProjectContext.SaveChanges();
}
protected void btnSaveStars_OnClick(object sender, EventArgs e)
{
// ddl
var x = Convert.ToInt32(ddlStars.SelectedItem.Value);
DefinedValueService definedValueService = new DefinedValueService(rockContext);
var definedValue = definedValueService.Queryable().FirstOrDefault(a => a.Id == x);
definedValue.LoadAttributes();
var attributeValue = definedValue.GetAttributeValue("StarValue");
var starsValue = Convert.ToDecimal(attributeValue);
var pa = Person.PrimaryAliasId;
//var pa = ppPerson.PersonAliasId;
//var value = Decimal.Parse(tbValue.Text);
StarsService starsService = new StarsService(starsProjectContext);
org.newpointe.Stars.Model.Stars stars = new org.newpointe.Stars.Model.Stars();
stars.PersonAliasId = pa.GetValueOrDefault();
stars.CampusId = 1;
stars.TransactionDateTime = DateTime.Now;
stars.Value = starsValue;
stars.Note = ddlStars.SelectedItem.Text + ". Manually added by " + CurrentPerson.FullName;
starsService.Add(stars);
starsProjectContext.SaveChanges();
//Refresh Page to update grids
Response.Redirect(Request.RawUrl);
}
protected void Page_Load(object sender, EventArgs e)
{
SelectedPerson = Person;
StarsService starsService = new StarsService(starsProjectContext);
var starsList = starsService.Queryable().GroupBy(a => a.PersonAlias.Id)
.Select(g => new
{
Person = g.Key,
Sum = g.Sum(a => a.Value)
}
).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList();
var starsListThisMonth = starsService.Queryable()
.Where(a => a.TransactionDateTime.Month == DateTime.Now.Month && a.TransactionDateTime.Year == DateTime.Now.Year)
.GroupBy(a => a.PersonAlias.Id)
.Select(g => new
{
Person = g.Key,
Sum = g.Sum(a => a.Value)
}
).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList();
var starsListLastMonth = starsService.Queryable()
.Where(a => a.TransactionDateTime.Month == DateTime.Now.Month - 1 && a.TransactionDateTime.Year == DateTime.Now.Year)
.GroupBy(a => a.PersonAlias.Id)
.Select(g => new
{
Person = g.Key,
Sum = g.Sum(a => a.Value)
}
).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList();
if (starsList.Any())
{
hlStarsTotal.Text = starsList.FirstOrDefault().Sum.ToString() + " Stars All Time";
}
else
{
hlStarsTotal.Text = "0 Stars All Time";
hlStarsTotal.LabelType = LabelType.Default;
}
if (starsListThisMonth.Any())
{
hlStarsThisMonth.Text = starsListThisMonth.FirstOrDefault().Sum.ToString() + " Stars This Month";
}
else
{
hlStarsThisMonth.Text = "0 Stars This Month";
hlStarsThisMonth.LabelType = LabelType.Default;
}
if (starsListLastMonth.Any())
{
hlStarsLastMonth.Text = starsListLastMonth.FirstOrDefault().Sum.ToString() + " Stars Last Month";
}
else
{
hlStarsLastMonth.Text = "0 Stars Last Month";
hlStarsLastMonth.LabelType = LabelType.Default;
}
}
public void SaveStars(DateTime dt, int paId, decimal starsValue, string note)
{
StarsProjectContext starsProjectContext = new StarsProjectContext();
StarsService starsService = new StarsService(starsProjectContext);
org.newpointe.Stars.Model.Stars stars = new org.newpointe.Stars.Model.Stars();
PersonAliasService personAliasService = new PersonAliasService(new RockContext());
int campusId = personAliasService.GetByAliasId(paId).Person.GetCampus().Id;
stars.PersonAliasId = paId;
stars.CampusId = campusId;
stars.TransactionDateTime = DateTime.Now;
stars.Value = starsValue;
stars.Note = note;
starsService.Add(stars);
starsProjectContext.SaveChanges();
}
protected void Page_Load(object sender, EventArgs e)
{
SelectedPerson = Person;
StarsService starsService = new StarsService(starsProjectContext);
var starsList = starsService.Queryable().GroupBy(a => a.PersonAlias.Id)
.Select(g => new
{
Person = g.Key,
Sum = g.Sum(a => a.Value)
}
).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList();
var starsListThisMonth = starsService.Queryable()
.Where(a => a.TransactionDateTime.Month == DateTime.Now.Month && a.TransactionDateTime.Year == DateTime.Now.Year)
.GroupBy(a => a.PersonAlias.Id)
.Select(g => new
{
Person = g.Key,
Sum = g.Sum(a => a.Value)
}
).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList();
var starsListLastMonth = starsService.Queryable()
.Where(a => a.TransactionDateTime.Month == DateTime.Now.Month - 1 && a.TransactionDateTime.Year == DateTime.Now.Year)
.GroupBy(a => a.PersonAlias.Id)
.Select(g => new
{
Person = g.Key,
Sum = g.Sum(a => a.Value)
}
).Where(ab => ab.Person == SelectedPerson.PrimaryAliasId.Value).ToList();
if (starsList.Any())
{
hlStarsTotal.Text = starsList.FirstOrDefault().Sum.ToString() + " Stars All Time";
}
else
{
hlStarsTotal.Text = "0 Stars All Time";
hlStarsTotal.LabelType = LabelType.Default;
}
if (starsListThisMonth.Any())
{
hlStarsThisMonth.Text = starsListThisMonth.FirstOrDefault().Sum.ToString() + " Stars This Month";
}
else
{
hlStarsThisMonth.Text = "0 Stars This Month";
hlStarsThisMonth.LabelType = LabelType.Default;
}
if (starsListLastMonth.Any())
{
hlStarsLastMonth.Text = starsListLastMonth.FirstOrDefault().Sum.ToString() + " Stars Last Month";
}
else
{
hlStarsLastMonth.Text = "0 Stars Last Month";
hlStarsLastMonth.LabelType = LabelType.Default;
}
}
public StarsController(StarsService service)
{
_service = service;
}
protected void Page_Load(object sender, EventArgs e)
{
PersonAliasService personAliasService = new PersonAliasService(rockContext);
StarsService starsService = new StarsService(starsProjectContext);
var starsList = starsService.Queryable().GroupBy(a => a.PersonAlias.Person).Select(g => new { Person = g.Key, Sum = g.Sum(a => a.Value)}).ToList();
gStars.DataSource = starsList;
gStars.DataBind();
}
