protected void GV_List_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
object[] obj = (object[])e.Row.DataItem;
((Label)(e.Row.FindControl("lblSupplier"))).Text = ((Supplier)obj[0]).Code;
((Label)(e.Row.FindControl("lblItem"))).Text = ((Item)obj[1]).Code;
DetachedCriteria selectCriteria = DetachedCriteria.For(typeof(RollingForecast));
selectCriteria.Add(Expression.Eq("Supplier.Code", ((Supplier)obj[0]).Code));
selectCriteria.Add(Expression.Eq("Item.Code", ((Item)obj[1]).Code));
selectCriteria.Add(Expression.Ge("Date", StartDate));
selectCriteria.Add(Expression.Lt("Date", StartDate.AddDays(140)));
IList <RollingForecast> rollingForecastList = TheCriteriaMgr.FindAll <RollingForecast>(selectCriteria);
for (int i = 0; i < DateArr.Count(); i++)
{
var q = rollingForecastList.Where(f => f.Date.ToShortDateString() == DateArr[i].ToShortDateString()).OrderByDescending(p => p.CreateDate);
if (q.Count() > 0)
{
RollingForecast c = q.First();
((Label)(e.Row.FindControl("lblQty" + i))).Text = c.Qty.ToString("0.########");
}
}
}
}
private void SetUserMilestones(BreatheEasyEntities db)
{
if (this.UserMilestones == null)
{
UserMilestones = new List <UserMilestone>();
}
UserMilestones.Clear();
if (Plan.Duration > 0)
{
for (int days = 0; days <= Plan.Duration; days++)
{
var milestoneDate = StartDate.AddDays(days);
int target = CigsPerDay * (Plan.Duration - days) / Plan.Duration;
var milestone = new UserMilestone()
{
Date = milestoneDate,
Target = target,
};
UserMilestones.Add(milestone);
}
}
else
{
UserMilestones.Add(new UserMilestone {
Date = DateTime.Today, Target = 0
});
}
}
public async Task OnGetAsync(DateTime?dtStartDate /*, DateTime EndDate*/)
{
//Course = await _context.Course.ToListAsync();
//一个时间区间的courses（周）：如果dtStartDate空，这当前周
//var courses = from c in db.Courses
// select c;
if (!dtStartDate.HasValue) //null
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
}
else
{
StartDate = new DateTime(dtStartDate.Value.Year, dtStartDate.Value.Month, dtStartDate.Value.Day);
}
EndDate = StartDate.AddDays(7).AddMilliseconds(-1);
//Courses = Courses.Where(c => c.StartTime >= StartDate && c.StartTime < EndDate).OrderBy(c => c.StartTime);
//public async Task<List<Course>> GetByDateAsync(DateTime StartDate)
Course = await _CourseMgr.GetByDateAsync(StartDate);
}
private Border CreateContentBorder(int i, DayNight dayNight, Service service)
{
var border1 = new Border();
border1.BorderBrush = Brushes.Gray;
border1.BorderThickness = new Thickness(0, 0.5, 1, 0.5);
var planning = service.PlanningUnits?.FirstOrDefault(p => p.Date == StartDate.AddDays(i) && p.DayNight == dayNight);
var listEditorControl = new ListEditorControl {
ResourceItems = ResourceItems, DayNight = dayNight, Date = StartDate.AddDays(i), ObservableResources = planning?.Employees.Select(e => new Resource(e)).ToObservableCollection() ?? new ObservableCollection <Resource>()
};
Binding myBinding = new Binding();
myBinding.Source = this;
myBinding.Path = new PropertyPath("IsEdited");
myBinding.Mode = BindingMode.TwoWay;
myBinding.UpdateSourceTrigger = UpdateSourceTrigger.PropertyChanged;
BindingOperations.SetBinding(listEditorControl, ListEditorControl.IsEditedProperty, myBinding);
border1.Child = listEditorControl;
Grid.SetColumn(border1, i);
return(border1);
}
public HoursViewModel(bool forUser)
{
_allGID = Guid.NewGuid();
ShowFilter = true;
Users = new ObservableCollection <User>();
ForUser = forUser;
StartDate = DateTime.Now;
EndDate = DateTime.Now;
var usr = LoginHelper.GetLoggedInUser();
if (ForUser)
{
while ((int)StartDate.DayOfWeek > usr.User.Company.WeekStartValue)
{
StartDate = StartDate.AddDays(-1);
}
EndDate = StartDate.AddDays(6);
}
DeleteCommand = new Command(async(parameter) => await ExecuteDeleteCommand(parameter as DisplayItem));
ApproveCommand = new Command(async(parameter) => await approveDenyHours(parameter as UserClock, true));
DenyCommand = new Command(async(parameter) => await approveDenyHours(parameter as UserClock, false));
this.sortQueue.Add(new Tuple <string, bool>("clockInDate", true));
this.sortFields.Add("Date", "clockInDate");
if (!forUser)
{
this.sortFields.Add("Employee", "user");
}
}
public void ShouldFailWhenFirstCareChargeStartLessThanPackageStartDate(ReclaimSubType subtype, int daysDelta)
{
var request = CreateUpsertRequest(
(subtype, _coreCost.StartDate.AddDays(daysDelta), null));
VerifyFailedRequest(request, "First care charge start date must be greater or equal to package start date");
}
internal Expression WasMemberAsOf()
{
var tf = CodeIds == "1";
var now = Util.Now;
EndDate = EndDate?.AddDays(1) ?? StartDate?.AddDays(1);
Expression <Func <Person, bool> > pred = p => (
from et in p.EnrollmentTransactions
where et.TransactionTypeId <= 3 // things that start a change
where et.TransactionStatus == false
where et.TransactionDate <= EndDate // transaction starts <= looked for end
where et.MemberTypeId != MemberTypeCode.Prospect
where (et.Pending ?? false) == false
where (et.NextTranChangeDate ?? now) >= StartDate // transaction ends >= looked for start
where (OrgTypeInt ?? 0) == 0 || et.Organization.OrganizationTypeId == OrgTypeInt
where OrganizationInt == 0 || et.OrganizationId == OrganizationInt
where DivisionInt == 0 || et.Organization.DivOrgs.Any(dg => dg.DivId == DivisionInt)
where ProgramInt == 0 || et.Organization.DivOrgs.Any(dg => dg.Division.ProgDivs.Any(pg => pg.ProgId == ProgramInt))
select et
).Any();
Expression expr = Expression.Convert(Expression.Invoke(pred, parm), typeof(bool));
if (!(op == CompareType.Equal && tf))
{
expr = Expression.Not(expr);
}
return(expr);
}
public void SetWeekDays()
{
StartDate = DateTime.Now.AddDays(-(((int)DateTime.Now.DayOfWeek)) - (int)DayOfWeek.Sunday).Date;
StartDate = StartDate.Add(new TimeSpan(6, 0, 0));
EndDate = StartDate.AddDays(7).Date;
EndDate = EndDate.Add(new TimeSpan(5, 59, 59));
}
public TimeCardViewModel()
{
EmployeeList = RFRepo.GetEmployees();
//JobsList = RFRepo.GetJobs();
if (DateTime.Now.DayOfWeek == DayOfWeek.Monday)
{
StartDate = DateTime.Now;
}
else if (DateTime.Now.DayOfWeek == DayOfWeek.Tuesday)
{
StartDate = DateTime.Now.AddDays(-1);
}
else if (DateTime.Now.DayOfWeek == DayOfWeek.Wednesday)
{
StartDate = DateTime.Now.AddDays(-2);
}
else if (DateTime.Now.DayOfWeek == DayOfWeek.Thursday)
{
StartDate = DateTime.Now.AddDays(-3);
}
else if (DateTime.Now.DayOfWeek == DayOfWeek.Friday)
{
StartDate = DateTime.Now.AddDays(-4);
}
else if (DateTime.Now.DayOfWeek == DayOfWeek.Saturday)
{
StartDate = DateTime.Now.AddDays(-5);
}
else if (DateTime.Now.DayOfWeek == DayOfWeek.Sunday)
{
StartDate = DateTime.Now.AddDays(-6);
}
EndDate = StartDate.AddDays(5);
}
public ACOHandler(SchedulingPeriod inputData)
{
InputData = inputData;
StartDate = DateTime.Parse(InputData.StartDate);
EndDate = DateTime.Parse(InputData.EndDate);
NurseNumber = inputData.Employees.Employee.Count;
GenerationManager = new GenerationManager(InputData);
Evaluator = new Evalutador(InputData);
WParam = new double[inputData.Skills.Skill.Count];
for (int i = 0; i < inputData.Skills.Skill.Count; i++)
{
GradeIndex.Add(inputData.Skills.Skill.ElementAt(i), i);
WParam[i] = i + 1;
}
var orderedShifts = inputData.ShiftTypes.Shift.ToList();
orderedShifts.ForEach(x => ShiftPatternIndex.Add(x.ID, orderedShifts.IndexOf(x)));
for (int i = 0; i < EndDate.Subtract(StartDate).Days + 1; i++)
{
DayIndex[StartDate.AddDays(i).DayOfWeek.ToString()].Add(i);
}
InitiazeCoverRequirements();
}
protected override void OnCommand(CommandArgs e)
{
switch (e.Command)
{
case "navigate":
StartDate = (DateTime)e.Data["start"];
Update(CallBackUpdateType.Full);
break;
case "refresh":
Update();
break;
case "previous":
StartDate = StartDate.AddDays(-7);
Update(CallBackUpdateType.Full);
break;
case "next":
StartDate = StartDate.AddDays(7);
Update(CallBackUpdateType.Full);
break;
case "today":
StartDate = DateTime.Today;
Update(CallBackUpdateType.Full);
break;
}
}
public void AddCalculatedQuotation()
{
StartDate = DateTime.Today;
if (Quotaion.IsRush == false || Quotaion.IsRush == null)
{
NumberOfDays = (Quotaion.WordCount / Category.WorkRate);
NumberOfDays = Math.Round(NumberOfDays, 0, MidpointRounding.AwayFromZero);
//EndDate = StartDate.AddDays((double)NumberOfDays - 1);
CalcPrice(Quotaion.WordCount, Quotaion.ToLangID);
}
else if (Quotaion.IsRush == true || Quotaion.RushDate != null)
{
NumberOfDays = Quotaion.WordCount / Category.WorkRate;
EndDate = StartDate.AddDays((double)NumberOfDays - 1);
TimeSpan difference = EndDate.Subtract(Quotaion.RushDate);
NumberOfRushDays = (decimal)difference.TotalDays;
// NumberOfRushDays = EndDate.Day - Quotaion.RushDate.Day;
NumberOfDays = NumberOfDays - NumberOfRushDays;
NumberOfDays = Math.Round(NumberOfDays, 0, MidpointRounding.AwayFromZero);
//EndDate = StartDate.AddDays((double)NumberOfDays - 1);
CalcPriceRush(Quotaion.WordCount, Quotaion.ToLangID, NumberOfRushDays);
}
}
internal Expression MemberTypeAsOf()
{
var end = EndDate?.AddDays(1) ?? StartDate?.AddDays(1);
Expression <Func <Person, bool> > pred = p => (
from et in p.EnrollmentTransactions
where et.TransactionTypeId <= 3 // things that start a change
where et.TransactionStatus == false
where StartDate <= (et.NextTranChangeDate ?? Util.Now) // where it ends
where et.TransactionDate <= end // where it begins
where (et.Pending ?? false) == false
where CodeIntIds.Contains(et.MemberTypeId) // what it's type was during that time
where (OrgTypeInt ?? 0) == 0 || et.Organization.OrganizationTypeId == OrgTypeInt
where OrganizationInt == 0 || et.OrganizationId == OrganizationInt
where DivisionInt == 0 || et.Organization.DivOrgs.Any(dg => dg.DivId == DivisionInt)
where ProgramInt == 0 || et.Organization.DivOrgs.Any(dg => dg.Division.ProgDivs.Any(pg => pg.ProgId == ProgramInt))
select et
).Any();
Expression expr = Expression.Invoke(pred, parm);
if (op == CompareType.NotEqual || op == CompareType.NotOneOf)
{
expr = Expression.Not(expr);
}
return(expr);
}
public async Task FormDataToList()
{
DateTime dateForCycle = StartDate.AddDays(DaysInterval);
while (dateForCycle <= EndDate)
{
FilterDate filterDate = new FilterDate(StartDate, dateForCycle);
var jsonStringCreator = new JsonStringCreator(filter: new FilterType(filterDate), dimension: new string[] { "date" }, metrics: TypeOfMetrics);
string output = jsonStringCreator.CreateJsonString(jsonStringCreator);
HttpContent contentPost = new StringContent(output, Encoding.UTF8, "application/json");
var respons = await Client.PostAsync("https://api.adform.com/v1/reportingstats/publisher/reportdata", contentPost);
if (respons.ReasonPhrase != "OK")
{
throw new HttpRequestException(message: "Issue with request HTTP cleint post. Reason: " + respons.ReasonPhrase);
}
var responseString = await respons.Content.ReadAsStringAsync();
DataFromResponse dataFromResponse = JsonConvert.DeserializeObject <DataFromResponse>(responseString);
Console.WriteLine("Deserializing JSON and parsing");
foreach (var item in dataFromResponse.reportData.rows)
{
DataSetFormat tempElement = new DataSetFormat();
tempElement.FormDataFromString(item);
DataSet.Add(tempElement);
}
dateForCycle = dateForCycle.AddDays(1);
StartDate = dateForCycle;
dateForCycle = dateForCycle.AddDays(DaysInterval);
Console.WriteLine("Data is being configured");
}
}
protected override void Next()
{
if (!Check())
{
return;
}
OrderDto.FullCost = GetCost(cost, costChild, Old, Child, DaysCount);
OrderDto.PeopleCount = Child + Old;
OrderDto.ChildCount = Child;
OrderDto.StartDate = new DateTimeOffset(StartDate);
OrderDto.EndDate = new DateTimeOffset(StartDate.AddDays(DaysCount));
orderService.SetupFilledOrder(OrderDto);
if (userService.IsAutorized)
{
orderService.SetupClient(userService.CurrentUser.Id);
pageservice.ChangePage <Pages.OrderResultPage>(PoolIndex, DisappearAnimation.Default);
}
else
{
pageservice.ChangePage <Pages.ClientRegisterPage>(PoolIndex, DisappearAnimation.Default);
}
}
private void ShiftButton_Click(object sender, RoutedEventArgs e)
{
var tag = ((sender as Button)?.Tag ?? null)?.ToString()?.Trim();
if (string.IsNullOrWhiteSpace(tag))
{
return;
}
if (!byte.TryParse(tag, out var value) || value < 0 || value > 1)
{
return;
}
if (value == 0)
{
if (Shift == 0)
{
return;
}
--Shift;
}
else
{
if (Shift == ulong.MaxValue)
{
return;
}
++Shift;
}
_vm.Shift = Shift;
LastDate = StartDate.AddDays(Shift);
_vm.LastDate = LastDate.ToString(@"yyyy/MM/dd HH:mm:ss");
SetDate(LastDate);
}
public GetTimeSheetRequest()
{
// TODO: [TESTS] (GetTimeSheetRequest.GetTimeSheetRequest) Add tests
StartDate = DateTime.Now;
EndDate = StartDate.AddDays(7);
ClientId = 0;
}
private void randomDates(object sender, EventArgs e)
{
Random rnd = new Random();
DateTime StartDate, EndDate;
double days, months;
double pv = 10000;
double intr = 0.12;
double InterestAmount;
string path = @"\\nas4\ark2\_ab HealthcareFinanceDirect\TValue\AmortizationSchedule\random.csv";
string ln;
int n = 100;
if (Directory.Exists(Path.GetDirectoryName(path)))
{
using (System.IO.StreamWriter wr = new System.IO.StreamWriter(path))
{
for (int i = 0; i < n; i++)
{
StartDate = DateTime.Now.Date.AddDays(rnd.Next(100));
EndDate = StartDate.AddDays(rnd.Next(365 * 2));
Calculate(StartDate, EndDate, out days, out months);
InterestAmount = GetInterestAmount(intr, pv, months, days);
ln = string.Format("{0}, {1:M/d/yyyy}, {2:M/d/yyyy}, {3}, {4}, {5:0.00}, {6:0.00}, {7:0.00}", i + 1, StartDate, EndDate, (int)months, (int)days, pv, intr, InterestAmount);
wr.WriteLine(ln);
}
}
tResult.Text = string.Format("Completed {0} random dates to CSV text file.", n);
}
else
{
tResult.Text = "The NAS directory does not exist.";
}
}
public DateTime this[int index]
{
get
{
return(StartDate.AddDays(IntervalTimeSpan.TotalDays * index));
}
}
/// <summary>
/// Gets the occurence of this entry for the given day.
/// </summary>
/// <param name="day"></param>
/// <returns>The found occurence, or null when this entry does not occur on that day</returns>
private ScheduleDateTimeRange GetRangeForDay(DateTime day)
{
switch (Frequency)
{
default:
throw new NotImplementedException();
case RecurringFrequency.Daily:
break;
case RecurringFrequency.Weekdays:
if (day.DayOfWeek < DayOfWeek.Monday || day.DayOfWeek > DayOfWeek.Friday)
{
return(null);
}
break;
case RecurringFrequency.Weekends:
if (day.DayOfWeek != DayOfWeek.Saturday && day.DayOfWeek != DayOfWeek.Sunday)
{
return(null);
}
break;
case RecurringFrequency.Weekly:
DateTime firstInstance = StartDate.AddDays((DayOfWeek - StartDate.DayOfWeek + 7) % 7);
if (day.DayOfWeek != DayOfWeek || day.Subtract(firstInstance).Days % (7 * WeeksPeriod) != 0)
{
return(null);
}
break;
case RecurringFrequency.Monthly:
if (day.Day != DayOfMonth)
{
if (day.Day <= 3 && DayOfMonth >= 29)
{
if (!IsOverflowDate(day))
{
return(null);
}
}
else if (day.Day >= 28 && DayOfMonth >= 29)
{
if (!IsOverflowDate(day))
{
return(null);
}
}
else
{
return(null);
}
}
break;
}
return(new ScheduleDateTimeRange(day.Add(TimeSpan.FromSeconds(StartTimeInSeconds)),
day.Add(TimeSpan.FromSeconds(EndTimeInSeconds))));
}
public static DateTimeSpan CompareDates(DateTime StartDate, DateTime EndDate)
{
DateTimeSpan R = new DateTimeSpan();
if (StartDate.Equals(EndDate))
{
return(new DateTimeSpan());
}
bool Later;
if (Later = StartDate > EndDate)
{
DateTime D = StartDate;
StartDate = EndDate;
EndDate = D;
}
// Calculate Date Stuff
for (DateTime D = StartDate.AddYears(1); D < EndDate; D = D.AddYears(1), R.Years++)
{
;
}
if (R.Years > 0)
{
StartDate = StartDate.AddYears(R.Years);
}
for (DateTime D = StartDate.AddMonths(1); D < EndDate; D = D.AddMonths(1), R.Months++)
{
;
}
if (R.Months > 0)
{
StartDate = StartDate.AddMonths(R.Months);
}
for (DateTime D = StartDate.AddDays(1); D < EndDate; D = D.AddDays(1), R.Days++)
{
;
}
if (R.Days > 0)
{
StartDate = StartDate.AddDays(R.Days);
}
// Calculate Time Stuff
TimeSpan T1 = EndDate - StartDate;
R.Hours = T1.Hours;
R.Minutes = T1.Minutes;
R.Seconds = T1.Seconds;
R.Milliseconds = T1.Milliseconds;
// Return answer. Negate values if the Start Date was later than the End Date
if (Later)
{
return(new DateTimeSpan(-R.Years, -R.Months, -R.Days, -R.Hours, -R.Minutes, -R.Seconds, -R.Milliseconds));
}
return(R);
}
private InvoiceDataVM()
{
EndDate = DateTime.Today;
StartDate = DateTime.Today;
StartDate.AddDays(-7);
GetInvoice();
Refresh = new OwnCommand(GetInvoice);
NewInvoice = new OwnCommand(OpenWindowCreateNewInvoice);
}
private void setWeekStart()
{
var usr = LoginHelper.GetLoggedInUser().User;
while (StartDate.DayOfWeek != (DayOfWeek)usr.Company.WeekStart.GetValueOrDefault())
{
StartDate = StartDate.AddDays(-1);
}
}
public Course()
{
this.StartDate = DateTime.Now;
this.EndDate = StartDate.AddDays(60);
this.Resources = new List <Resource>();
this.StudentsEnrolled = new List <StudentCourse>();
this.HomeworkSubmissions = new List <Homework>();
}
protected override void OnFinish()
{
Events = new EventManager().FilteredData(StartDate, StartDate.AddDays(31)).AsEnumerable();
DataIdField = "id";
DataStartField = "eventstart";
DataEndField = "eventend";
DataRecurrenceField = "recurrence"; // Nie działa!
}
protected override void OnBeforeEventRecurrence(DayPilot.Web.Mvc.Events.Navigator.BeforeEventRecurrenceArgs e)
{
Events = new EventManager().FilteredData(StartDate, StartDate.AddDays(31)).AsEnumerable();
DataIdField = "id";
DataStartField = "eventstart";
DataEndField = "eventend";
DataRecurrenceField = "recurrence"; // Nie działa!
}
public MarketingReport GenerateReport(int days = 90)
{
var totalMarketingDays = Enumerable.Range(0, days)
.Select(x => StartDate.AddDays(x))
.Select(day => new MarketingDay(day, Customers.Where(customer => customer.MarketingChoice.SendMarketing(day))))
.ToList();
return(new MarketingReport(totalMarketingDays));
}
private DocumentDataVM()
{
EndDate = DateTime.Today;
StartDate = DateTime.Today;
StartDate = StartDate.AddDays(-7);
GetDocuments();
ShowButton = new OwnCommand(GetDocuments);
CreateExpenseForNutrition = new OwnCommand(CreateExpenseForNutritionWindow);
}
public override void ViewWillAppear(bool animated)
{
base.ViewWillAppear(animated);
StartDate = DateTime.Now.Date;
EndDate = StartDate.AddDays(5);
SelectedDay = StartDate;
DayText.Text = $"{SelectedDay: MMM dd}";
StartLoad();
}
public static IEnumerable <Category> GetCategories()
{
return(Enumerable.Range(1, 5).Select(i => new Category
{
Name = $"Category {i}",
CreatedDate = StartDate.AddDays(RandomGenerator.Next(DateRange)),
UpdatedDate = StartDate.AddDays(RandomGenerator.Next(DateRange))
}));
}