private void UpdatingInformationDeposit()
{
string deposit = LvDeposits.SelectedItem.ToString();
int k = deposit.IndexOf('.');
int depositId = Int32.Parse(deposit.Substring(0, k));
var depositSel = bd.Deposits.Find(depositId);
TblName.Text = depositSel.Name;
TblNumber.Text = depositSel.Term.ToString();
TblPassport.Text = depositSel.Percent.ToString();
TblAdress.Text = depositSel.Currency.Name.ToString();
TblStaff.Text = null;
InitializeInformationDeposit();
var table = (from p in bd.DepositClients
join d in bd.Deposits on p.Deposit_Id equals d.Id
join c in bd.Clients on p.Client_Id equals c.Id
where EntityFunctions.AddMonths(p.DateOfEnrollment, d.Term) > DateTime.Today &&
d.Id == depositId
select new
{
id = d.Id,
surname = c.Surname,
name = c.Name,
dateOfEnrollment = p.DateOfEnrollment,
enrollment = p.Enrollment,
endDate = EntityFunctions.AddMonths(p.DateOfEnrollment, d.Term),
summ = (double)p.Enrollment * Math.Pow((double)(1 + (d.Percent) / (100 * 12)), (12 * (double)(EntityFunctions.DiffMonths(p.DateOfEnrollment, DateTime.Today)) / 12))
}).ToList();
depositsGrid.ItemsSource = table; //.Where(p => p.id == depositId);
}
private static IQueryable <Associate> AssociateAvailability(AssociateSearchModel search, IQueryable <Associate> associates)
{
if (search.AvailableFrom.HasValue && search.AvailableTo.HasValue)
{
associates = from a in associates
where !a.Individual.Any(i => i.StartDate < search.AvailableTo.Value && (
i.EndDate.Value > search.AvailableFrom.Value ||
(EntityFunctions.AddDays(i.EndDate.Value, (i.NoticeAmount * -1)) > search.AvailableFrom.Value && i.NoticeIntervalId == (int)NoticeIntervalEnum.Days) ||
(EntityFunctions.AddDays(i.EndDate.Value, (i.NoticeAmount * -7)) > search.AvailableFrom.Value && i.NoticeIntervalId == (int)NoticeIntervalEnum.Weeks) ||
(EntityFunctions.AddMonths(i.EndDate.Value, (i.NoticeAmount * -1)) > search.AvailableFrom.Value && i.NoticeIntervalId == (int)NoticeIntervalEnum.Months)
)
)
select a;
}
if (search.NoticePeriod.HasValue && search.NoticeIntervalId.HasValue)
{
associates = from a in associates
where a.Individual.Any(i => (i.Role.NoticeIntervalId == search.NoticeIntervalId.Value || i.NoticeIntervalId == search.NoticeIntervalId.Value) &&
((i.Role.NoticeAmount == null && i.NoticeAmount == null) || i.Role.NoticeAmount <= search.NoticePeriod.Value || i.NoticeAmount <= search.NoticePeriod.Value))
select a;
}
return(associates);
}
public void UpdatingInformationClient()
{
InitializeInformationClient();
string client = LvClients.SelectedItem.ToString();
int k = client.IndexOf('.');
int clientId = Int32.Parse(client.Substring(0, k));
var clientsSel2 = bd.Clients.FirstOrDefault(p => p.Id == clientId);
TblName.Text = clientsSel2.Surname + " " + clientsSel2.Name;
TblNumber.Text = clientsSel2.PhoneNumber;
TblPassport.Text = clientsSel2.Passport;
TblAdress.Text = clientsSel2.City + ", " + clientsSel2.Adress;
TblStaff.Text = clientsSel2.Staff.Surname + " " + clientsSel2.Staff.Name;
var table = (from p in bd.DepositClients
join d in bd.Deposits on p.Deposit_Id equals d.Id
join c in bd.Clients on p.Client_Id equals c.Id
where EntityFunctions.AddMonths(p.DateOfEnrollment, d.Term) > DateTime.Today
select new
{
id = c.Id,
name = d.Name,
currency = d.Currency.Name,
dateOfEnrollment = p.DateOfEnrollment,
enrollment = p.Enrollment,
endDate = EntityFunctions.AddMonths(p.DateOfEnrollment, d.Term),
summ = (double)p.Enrollment * Math.Pow((double)(1 + (d.Percent) / (100 * 12)), (12 * (double)(EntityFunctions.DiffMonths(p.DateOfEnrollment, DateTime.Today)) / 12))
}).ToList();
clientsGrid.ItemsSource = table.Where(p => p.id == clientId);
}
public Dictionary <string, int> CalculateMonthlyExpense()
{
List <Operation> lstEmployee = new List <Operation>();
Dictionary <string, int> dictMonthlySum = new Dictionary <string, int>();
int foodSum = db.Operations.Where
(cat => cat.type == "Food" && (cat.creationDate > EntityFunctions.AddMonths(DateTime.Now, -1)))
.Sum(cat => (int?)cat.amount) ?? 0;
int shoppingSum = db.Operations.Where
(cat => cat.type == "Shopping" && (cat.creationDate > EntityFunctions.AddMonths(DateTime.Now, -1)))
.Sum(cat => (int?)cat.amount) ?? 0;
int travelSum = db.Operations.Where
(cat => cat.type == "Travel" && (cat.creationDate > EntityFunctions.AddMonths(DateTime.Now, -1)))
.Sum(cat => (int?)cat.amount) ?? 0;
int healthSum = db.Operations.Where
(cat => cat.type == "Health" && (cat.creationDate > EntityFunctions.AddMonths(DateTime.Now, -1)))
.Sum(cat => (int?)cat.amount) ?? 0;
dictMonthlySum.Add("Food", foodSum);
dictMonthlySum.Add("Shopping", shoppingSum);
dictMonthlySum.Add("Travel", travelSum);
dictMonthlySum.Add("Health", healthSum);
return(dictMonthlySum);
}
public int GetAllPositiveTestsByStainOrganTissueForALastMonth(string stain, string organ, string tissue)
{
var _context = new ApplicationDbContext();
var reports = GetAllPositiveReports();
return(_context.Reports.Where(r => r.StainName == stain && r.OrganName == organ &&
r.TissueName == tissue && r.Creation < EntityFunctions.AddMonths(DateTime.Now, -1)).ToList().Count);
}
public void DateTimeAddMonths()
{
DateTime date = stored.AddMonths(-1);
#if !EFOLD
var q = this.Entities
.Where(x =>
DbFunctions.AddMonths(x.DateTime, -1) == date);
#else
var q = this.Entities
.Where(x =>
EntityFunctions.AddMonths(x.DateTime, -1) == date);
#endif
q.Should().NotBeEmpty();
}
public void DateTimeOffsetAddMonths()
{
DateTimeOffset offset = stored.AddMonths(-1);
#if !EFOLD
var q = this.Entities
.Where(x =>
DbFunctions.AddMonths(x.Offset, -1) == offset);
#else
var q = this.Entities
.Where(x =>
EntityFunctions.AddMonths(x.Offset, -1) == offset);
#endif
q.Should().NotBeEmpty();
}
public ActionResult MarkItemsAsRead(string timeFrame)
{
IQueryable <SubscriptionPost> subscriptionPostsUnread = _dbContext.SubscriptionPosts
.Where(x => x.Subscription.UserSubscriptions
.Any(y => y.User.Email == WebSecurity.CurrentUserName) &&
!x.PostsRead.Any(y => y.UserSubscription.User.Email == WebSecurity.CurrentUserName &&
y.SubscriptionPost.Id == x.Id));
switch (timeFrame)
{
case "DAY":
subscriptionPostsUnread =
subscriptionPostsUnread
.Where(x => x.PublishDateUTC <= EntityFunctions.AddDays(DateTime.UtcNow, -1));
break;
case "WEEK":
subscriptionPostsUnread =
subscriptionPostsUnread
.Where(x => x.PublishDateUTC <= EntityFunctions.AddDays(DateTime.UtcNow, -7));
break;
case "MONTH":
subscriptionPostsUnread =
subscriptionPostsUnread
.Where(x => x.PublishDateUTC <= EntityFunctions.AddMonths(DateTime.UtcNow, -1));
break;
}
foreach (var subscriptionPost in subscriptionPostsUnread)
{
var userSubscription = subscriptionPost.Subscription.UserSubscriptions
.Single(x => x.User.Email == WebSecurity.CurrentUserName);
userSubscription.UnreadItems--;
var postRead = new PostRead
{
ReadOnUTC = DateTime.UtcNow,
SubscriptionPost = subscriptionPost,
UserSubscription = userSubscription
};
_dbContext.PostsRead.Add(postRead);
}
_dbContext.SaveChanges();
return(Content("MARKED"));
}
public IEnumerable <Report> GetAllReportsLastMonth()
{
var _context = new ApplicationDbContext();
return(_context.Reports.Where(r => r.Creation > EntityFunctions.AddMonths(DateTime.Now, -1)).ToList());
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (checkBox1.Checked)
{
textBox1.Text = "";
checkBox2.Checked = false;
checkBox3.Checked = false;
_PhamaPOSEntities = _dbConnector.getConn();
List <item> _itemList = new List <item>();
tblItems.Rows.Clear();
grdItem.DataSource = tblItems;
_itemList = _PhamaPOSEntities.items
.Where(a => a.stocks.Count > 0 && a.stocks.OrderByDescending(b => b.stockExpDate).FirstOrDefault().stockExpDate < EntityFunctions.AddMonths(DateTime.Now, 6) && a.itemStatus == true)
.OrderBy(a => a.stocks.OrderBy(b => b.stockId).FirstOrDefault().stockExpDate)
.ToList();
foreach (item i in _itemList)
{
DataRow dr = tblItems.NewRow();
dr["Item Code"] = i.itemCode.ToString().PadLeft(4, '0');
dr["Item Name"] = i.itemDescription;
dr["Item Description"] = i.itemCallingName;
dr["Item Unit"] = i.unit.unitCode;
dr["Item Status"] = i.itemStatus == true ? "Available" : "Not Available";
dr["Stock Available"] = i.stocks.Sum(a => a.runningQuantity);
// dr["Stock Value"] = i.stocks.Count != 0 ? ((int)(i.stocks.Average(a => a.itemUnitPriceSelling) * i.stocks.Sum(a => a.runningQuantity))) : 0.00;
dr["Stock Value"] = i.stocks.Count != 0 ? (
i.stocks.Select(a => new
{
value = a.itemUnitPriceSelling * a.runningQuantity
}).Sum(a => a.value)
) : (decimal)0.00;
dr["Stock Cost"] = i.stocks.Count != 0 ? ((int)(i.stocks.Average(a => a.itemUnitPriceBuying) * i.stocks.Sum(a => a.runningQuantity))) : 0.00;
dr["Expiry Date"] = i.stocks.Count != 0 ? i.stocks.OrderByDescending(a => a.stockExpDate).FirstOrDefault().stockExpDate : DateTime.MinValue;
tblItems.Rows.Add(dr);
}
grdItem.Sort(this.grdItem.Columns["Expiry Date"], ListSortDirection.Ascending);
grdItem.Refresh();
}
else
{
getAllItems();
}
}
public ActionResult OldPost()
{
DemoContext _context = new DemoContext();
var objAvd = _context.Advertisements.Include(x => x.City.Province.Country).Include(x => x.Images).Include(x => x.Status).Include(x => x.SubCatagory.Catagory).Include(x => x.Type).Include(x => x.User).Where(x => EntityFunctions.AddMonths(x.PostedOn, 2) > DateTime.Now).ToList();
return(View(objAvd));
}