private void SetPost(String id)
{
adminPost = db.LoadRecordByIdAdminPost <AdminPost>("AdminPosts", id);
post = db.LoadRecordById <Post>("Posts", adminPost.PostId);
adminPost.IsCheck = true;
db.UpsertRecord <AdminPost>("Posts", adminPost.Id, adminPost);
db.DeleteRecord <Post>("Posts", post.Id);
}
private void SetPost(String id)
{
adminPost = db.LoadRecordByIdAdminPost <AdminPost>("AdminPosts", id);
post = db.LoadRecordById <Post>("Posts", adminPost.PostId);
adminPost.IsCheck = true;
post.IsCheck = true;
userTwo.PostId = post.Id;
db.UpsertRecord <User>("Users", userTwo.Id, userTwo);
db.UpsertRecord <Post>("Posts", post.Id, post);
db.UpsertRecord <AdminPost>("Posts", adminPost.Id, adminPost);
}
public string FilterSalesCommissionTable(AdminPost data)
{
DateTime?low = null;
DateTime?high = null;
if (data.SalesPersonCommissionDateRangeLow != null)
{
low = Convert.ToDateTime(data.SalesPersonCommissionDateRangeLow);
}
if (data.SalesPersonCommissionDateRangeHigh != null)
{
high = Convert.ToDateTime(data.SalesPersonCommissionDateRangeHigh);
}
List <Transaction> transactions;
SalesPerson salesPerson;
// filter transactions down by sales person first
transactions = db.Transactions.Include(t => t.Items).Where(p => p.SalesPerson.Id == data.SalesPersonIdToGet).ToList();
// filter transactions by date if supplied
if (low != null)
{
transactions = transactions.Where(p => p.Date >= low).ToList();
}
if (high != null)
{
transactions = transactions.Where(p => p.Date <= high).ToList();
}
salesPerson = db.SalesPersons.Single(p => p.Id == data.SalesPersonIdToGet);
var totalCommission = 0m;
foreach (var transaction in transactions)
{
totalCommission += (transaction.TotalCharges * (salesPerson.Commission * 0.01m));
}
var returnData = @"<tr><td>" + salesPerson.Name + "</td><td>" + string.Format("{0:C}", totalCommission) + "</td></tr>";
return(returnData);
}
public async Task <AdminPost> SetPost([FromBody] AdminPost post)
{
var updated = await this.catiDatalayer.SetPost(post.ToPost(), this.GetUserAccessDetails());
return(new AdminPost(updated.MetaData, updated.PostContent.First().Content));
}
