public async Task <List <POIModel> > GetNowOpenPOIs()
{
var allPois = await GetAllPOIs();
List <POIModel> resultList = new List <POIModel>();
DateTime nowTime = DateTime.Now;
foreach (var poi in allPois)
{
if (nowTime.DayOfWeek == DayOfWeek.Sunday)
{
if (await IsPOIOpenAtTime(poi.Id, nowTime, DayHelper.IsSundayTrading(nowTime)))
{
resultList.Add(poi);
}
}
else
{
if (await IsPOIOpenAtTime(poi.Id, nowTime))
{
resultList.Add(poi);
}
}
}
return(resultList);
}
private void PopulateWorksheetWithPurchaseOrders(ExcelWorksheet worksheet, DayOfWeek day,
IEnumerable <KeyValuePair <Guid, string> > clients,
IEnumerable <Product> existingProducts, IEnumerable <PurchaseOrder> purchaseOrders)
{
AddHeadersRow(worksheet, DayHelper.GetDayFromEnum(day), clients);
AddProductsRows(worksheet, clients, existingProducts, purchaseOrders);
}
public void View(string projectSlug, int issueId)
{
if (!string.IsNullOrEmpty(Request.UrlReferrer))
{
var referer = new Uri(Request.UrlReferrer);
var routeMatch = RoutingModuleEx.Engine.FindMatch(referer.AbsolutePath,
new RouteContext(Request, null, "/", new Hashtable()));
if (routeMatch.Name == "issues")
{
PropertyBag.Add("referer", referer.PathAndQuery);
}
}
var project = session.Query <Project>().FirstOrDefault(p => p.Slug == projectSlug);
PropertyBag.Add("project", project);
var item = session.Query <Issue>().FirstOrDefault(i => i.Number == issueId && i.Project == project);
PropertyBag.Add("item", item);
PropertyBag.Add("comments", item.Comments);
PropertyBag.Add("days", DayHelper.GetPastDaysList());
PropertyBag.Add("datetime", DateTime.Now);
item.Touch(CurrentUser);
foreach (var action in item.Actions)
{
action.Touch(CurrentUser);
}
using (var transaction = session.BeginTransaction())
{
session.SaveOrUpdate(item);
transaction.Commit();
}
}
public List <Day> GetCurrentWeekDays()
{
var startDate = DateTime.Today.ToUniversalTime().AddDays(-(((DateTime.Today.ToUniversalTime().DayOfWeek - DayOfWeek.Monday) + 7) % 7));
var endDate = startDate.AddDays(7);
var numDays = (int)((endDate - startDate).TotalDays);
List <DateTime> weekDates = Enumerable
.Range(0, numDays)
.Select(x => startDate.AddDays(x))
.ToList();
var weekDays = new List <Day>();
using (var da = new DataAccess())
{
foreach (DateTime date in weekDates)
{
int dayId = DayHelper.GetDayIdByDate(date);
Day day = da.Find <Day>(dayId);
if (day != null)
{
weekDays.Add(day);
}
else
{
weekDays.Add(new Day(date));
}
}
}
return(weekDays);
}
public bool IsDay(string line)
{
if (string.IsNullOrEmpty(line))
{
return(false);
}
var splitted = line.Trim().Split(null);
if (splitted.Length != 2)
{
return(false);
}
if (!_allowedDays.Contains(splitted[0]))
{
return(false);
}
DateTime?dateFormat = DayHelper.CheckIfCorrectDateFormat(splitted[1]);
if (dateFormat == null)
{
return(false);
}
return(true);
}
public static List <KeyValuePair <int, string> > GetOpenDaysKeyValuePairs(this IOpenDays activeSchool)
{
var activeDays = new List <KeyValuePair <int, string> >();
if (activeSchool.OpenSunday)
{
activeDays.Add(new KeyValuePair <int, string>(0, DayHelper.GetDayNameForCurrentCulture(DayOfWeek.Sunday)));
}
if (activeSchool.OpenMonday)
{
activeDays.Add(new KeyValuePair <int, string>(1, DayHelper.GetDayNameForCurrentCulture(DayOfWeek.Monday)));
}
if (activeSchool.OpenTuesday)
{
activeDays.Add(new KeyValuePair <int, string>(2, DayHelper.GetDayNameForCurrentCulture(DayOfWeek.Tuesday)));
}
if (activeSchool.OpenWednesday)
{
activeDays.Add(new KeyValuePair <int, string>(3, DayHelper.GetDayNameForCurrentCulture(DayOfWeek.Wednesday)));
}
if (activeSchool.OpenThursday)
{
activeDays.Add(new KeyValuePair <int, string>(4, DayHelper.GetDayNameForCurrentCulture(DayOfWeek.Thursday)));
}
if (activeSchool.OpenFriday)
{
activeDays.Add(new KeyValuePair <int, string>(5, DayHelper.GetDayNameForCurrentCulture(DayOfWeek.Friday)));
}
if (activeSchool.OpenSaturday)
{
activeDays.Add(new KeyValuePair <int, string>(6, DayHelper.GetDayNameForCurrentCulture(DayOfWeek.Saturday)));
}
return(activeDays);
}
private int GetTeachersSectionColumn()
{
int dayColumnWidth = PeriodHelper.GetCountOfPeriods();
int daysSummaryWidth = dayColumnWidth * DayHelper.GetCountOfSchoolDays();
int teachersSectionColumn = SubjectSectionWidth + daysSummaryWidth;
return(teachersSectionColumn);
}
public void InvalidDay_TrowsException()
{
var d = new DayHelper();
Assert.Throws <InvalidDateException>(() => {
var result = d.ToFrieldlyText(new int[] { 0, 1 });
});
}
public void ContinuouslyDay8(int[] days, string excpected)
{
var d = new DayHelper();
var result = d.ToFrieldlyText(days);
Assert.Equal(excpected, result);
}
public void DayBetweenForMondayAndMondayShallReturn0()
{
//Exercise
var differential = DayHelper.DaysBetween(DayOfWeek.Monday, DayOfWeek.Monday);
//Verify
Assert.AreEqual(0, differential);
}
public void InvalidDay_ThrowException_2()
{
var d = new DayHelper();
Assert.Throws <InvalidDayException>(() =>
{
var result = d.ToFriendlyText(new int[] { 1, 32 });
});
}
public void ContinuouslyAndSingleDays()
{
var d = new DayHelper();
var input = new int[] { 1, 2, 5 };
var result = d.ToFriendlyText(input);
Assert.Equal("1-2 and 5", result);
}
public void ContinuouslyDays()
{
var d = new DayHelper();
var input = new int[] { 1, 2, 3 };
var result = d.ToFriendlyText(input);
Assert.Equal("1-3", result);
}
//public ActionResult CheckSubjectSlotAvialability(string subject, string level, string StartHourclinet, string StartMinuteclinet)
public ActionResult CheckDaySlotAvialability(string levels)
{
//var theValue = $('#Subject').val() + ";" + $('#Class').val() + ";" + $('#StratTimeHour').val() + ";" + $('#StratTimeMinute').val() + ";" + $('#Teacher').val() + ";" + $('#Day').val();
string[] theLEvel = levels.Split(';');
string subject = theLEvel[0];
string level = theLEvel[1];
string StartHourclinet = theLEvel[2];
string StartMinuteclinet = theLEvel[3];
string day1 = theLEvel[5];
// string day1 = theLEvel[5];
Day day = DayHelper.GetDay(day1);
smContext db = new smContext();
List <TeachingDay> theTeachingDay = db.TeachingDay.Include("TeachingSubject").Where(a => a.TeachingClass.ClassName == level && a.theDay == day).ToList();
foreach (TeachingDay td in theTeachingDay)
{
TeachingClass theTeachingClass = db.TeachingClass.Where(a => a.TeachingClassID == td.TeachingClassID).First();
string theClass = theTeachingClass.ClassName;
// string theClass = td.TeachingClass.ClassName;
foreach (TeachingSubject ts in td.TeachingSubject)
{
String Day = ts.TeachingDay.theDay.ToString();
string theSubject = ts.SubjectName;
string EndHour = ts.TeachingDay.EndTimeHour;
string EndMinutes = ts.TeachingDay.EndTimeMinute;
string StartHour = ts.TeachingDay.StratTimeHour;
string StartMinutes = ts.TeachingDay.StratTimeMinute;
StringBuilder EndHourEndMinutes = new StringBuilder();
EndHourEndMinutes.Append(EndHour);
EndHourEndMinutes.Append(EndMinutes);
int time = Convert.ToInt16(EndHourEndMinutes.ToString()); //= Convert.ToInt16(EndHour) + Convert.ToInt16(EndMinutes);
StringBuilder StartHourStartMinuteclinets = new StringBuilder();
StartHourStartMinuteclinets.Append(StartHourclinet).Append(StartMinuteclinet);
int timeClient = Convert.ToInt16(StartHourStartMinuteclinets.ToString());//Convert.ToInt16(StartHourclinet) + Convert.ToInt16(StartMinuteclinet);
if (timeClient < time)
{
string theAlert = theSubject + " has been fixed for " + theClass + " which starts " + StartHour + ":" + StartMinutes + " ends at " + EndHour + ":" + EndMinutes;
return(Json(theAlert, JsonRequestBehavior.AllowGet));
}
}
}
// }
return(Json("", JsonRequestBehavior.AllowGet));
}
public static IServiceCollection AddAdventOfCodeDays(this IServiceCollection serviceCollection)
{
var types = DayHelper.GetDaysFromAssemblies();
types.ForEach(type =>
{
var serviceDescriptor = new ServiceDescriptor(typeof(IDay), type, ServiceLifetime.Singleton);
serviceCollection.TryAddEnumerable(serviceDescriptor);
});
return(serviceCollection);
}
public void EmptyArray_EmptyString()
{
//arrange => Prepare input data
var d = new DayHelper();
//act => process of method to test
var result = d.ToFriendlyText(new int[] { });
//assert => check expected result
Assert.Equal("", result);
}
public void Insert(Day day)
{
if (day.DayId == null)
{
day.DayId = DayHelper.GetDayIdByDate(day.Date);
}
using (var da = new DataAccess())
{
da.Insert <Day>(day);
}
}
public void GetLastDayOfWeekForATuesdayShouldReturnTheNextSundayForFirstDayOfWeekBeingMonday()
{
//Setup
var workingDate = new DateTime(2014, 7, 8); //A Tuesday
//Exercise
var lastDayOfWeek = DayHelper.GetLastDayOfWeek(workingDate, DayOfWeek.Monday);
//Verify
Assert.AreEqual(DayOfWeek.Tuesday, workingDate.DayOfWeek);
Assert.AreEqual(new DateTime(2014, 7, 13), lastDayOfWeek);
}
public void SingleDay(int day, string expected)
{
//arrange => Prepare input data
var d = new DayHelper();
var input = new int[] { day };
//act => process of method to test
string result = d.ToFriendlyText(input);
//assert => check expected result
Assert.Equal(expected, result);
}
public void EmptyArray_ReturnEmptyString()
{
// arrange
var d = new DayHelper();
var input = new int[] {};
// act
var result = d.ToFrieldlyText(input);
// assert
Assert.Equal("", result);
}
//[MemberData(nameof(DayInMonthTestData))]
public void SingleDay(int day, string expected)
{
// arrange
var d = new DayHelper();
var input = new int [] { day };
// act
var result = d.ToFrieldlyText(input);
// assert
Assert.Equal(expected, result);
}
/// <summary>
/// Get all the entries in the ItemPricing table, with the specified ItemId
/// </summary>
public static IEnumerable <ItemPricing> GetAll(int itemId, bool nowOnly, bool enableRequired)
{
string cmdText = "SELECT * FROM ItemPricing WHERE (ItemPricingItemId=" + itemId + ")";
if (nowOnly)
{
cmdText += " AND (ItemPricingDayOfWeek=@ItemPricingDayOfWeek)" +
" AND ((ItemPricingStartDate IS NULL) OR (ItemPricingStartDate >= @CurrentTime))" +
" AND ((ItemPricingEndDate IS NULL) OR (ItemPricingEndDate <= @CurrentTime))";
}
if (enableRequired)
{
cmdText += " AND (ItemPricingIsEnabled=@ItemPricingIsEnabled)";
}
DateTime now = DateTime.Now;
SqlConnection cn = GetConnection();
SqlCommand cmd = null;
try
{
int dayOfWeek = (int)DayHelper.ConvertToDay(now.DayOfWeek);
cmd = new SqlCommand(cmdText, cn);
if (nowOnly)
{
BuildSqlParameter(cmd, "@ItemPricingDayOfWeek", SqlDbType.TinyInt, dayOfWeek);
BuildSqlParameter(cmd, "@CurrentTime", SqlDbType.Time, now.TimeOfDay);
}
if (enableRequired)
{
BuildSqlParameter(cmd, "@ItemPricingIsEnabled", SqlDbType.Bit, enableRequired);
}
using (SqlDataReader rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
yield return(BuildItemPricing(rdr));
}
}
}
finally
{
if (cmd != null)
{
cmd.Dispose();
}
FinishedWithConnection(cn);
}
}
public void SaveToDataBase(Day day)
{
if (day.DayId != null)
{
this.dayDataService.Update(day);
}
else
{
this.dayDataService.Insert(day);
}
if (day.DayId == DayHelper.GetDayIdByDate(DateTime.Today))
{
this.IsCurrentDayDirty = true;
}
this.IsDirty = true;
}
/// <summary>
/// Return null if there are no more subjects
/// </summary>
private WeekInfo ParseWeekRow(IExcelDataReader reader, bool isEvenWeek, bool isUpperRowOfWeek)
{
if (!reader.Read())
{
return(null);
}
var weekRowInfo = new WeekInfo()
{
Days = new List <SchoolDayInfo>()
};
int subjectTitleColumn = 1;
if (isUpperRowOfWeek)
{
// Get subject info: title / from-to-time
weekRowInfo.SubjectSection = GetStringValue(reader, subjectTitleColumn);
}
for (DayOfWeek day = DayOfWeek.Monday; DayHelper.IsSchoolDay(day); day++)
{
List <PeriodInfo> periods = ParseSchoolDay(reader, day, isUpperRowOfWeek);
weekRowInfo.Days.Add(new SchoolDayInfo
{
Day = day,
Periods = periods
});
}
int teachersColumn = GetTeachersSectionColumn();
// Get teachers
if (!isEvenWeek && isUpperRowOfWeek)
{
string teachers = GetStringValue(reader, teachersColumn);
weekRowInfo.TeachersSection = teachers;
//ConsoleHelper.WriteOk("Teachers: " + teachers);
}
return(weekRowInfo);
}
public HttpResponseMessage GetTotalImports(HttpRequestMessage request, int year, int month)
{
try
{
string fromDate = DayHelper.GetFirstDayOfMonth(month, year).ToString("yyyy/MM/dd");
string toDate = DayHelper.GetLastDayOfMonth(month, year).ToString("yyyy/MM/dd");
var parameters = new SqlParameter[] {
new SqlParameter("@fromDate", fromDate),
new SqlParameter("@toDate", toDate),
new SqlParameter("@comid", CurrentUser.Instance.User.ComId.ToString())
};
var result = new StoreprocedureHelper <GetTotalImportViewModel>().ExecuteStoreprocedure("exec GetTotalImportSP @fromDate,@toDate,@comid", parameters).ToList().OrderBy(n => n.Date);
return(request.CreateResponse(HttpStatusCode.OK, result));
}
catch (Exception ex)
{
Log(ex);
return(request.CreateResponse(HttpStatusCode.BadRequest, "Lỗi hệ thống."));
}
}
public Day GetCurrentDay()
{
using (var da = new DataAccess())
{
DateTime today = DateTime.Today.ToUniversalTime();
int dayId = DayHelper.GetDayIdByDate(today);
Day current = da.Find <Day>(dayId);
if (current == null)
{
current = new Day(today);
Insert(current);
}
return(current);
}
}
public async Task <Result <ResourceExportDto> > ExportAsync(RequestUser user,
IQueryable <PurchaseOrder> purchaseOrdersQuery, CancellationToken token)
{
using (var excelPkg = new ExcelPackage())
{
var purchaseOrders = await purchaseOrdersQuery.ToListAsync(token);
var storeDeliveryDays = purchaseOrders
.Where(po => po.SenderInfo.Kind == ProfileKind.Store)
.GroupBy(po => po.ExpectedDelivery.ExpectedDeliveryDate.DayOfWeek);
var products = await _context.Products
.Where(p =>
!p.RemovedOn.HasValue &&
p.ProducerId == user.Id)
.OrderBy(p => p.Name)
.ToListAsync(token);
foreach (var storeDeliveryDay in storeDeliveryDays)
{
var worksheet =
excelPkg.Workbook.Worksheets.Add($"Commandes du {DayHelper.GetDayFromEnum(storeDeliveryDay.Key)}");
var clients = await _context.Agreements
.Where(u =>
!u.RemovedOn.HasValue &&
u.ProducerId == user.Id &&
u.DeliveryMode.Kind == DeliveryKind.ProducerToStore &&
u.DeliveryMode.DeliveryHours.Any(oh => oh.Day == storeDeliveryDay.Key))
.Select(c => new KeyValuePair <Guid, string>(c.StoreId, c.Store.Name))
.OrderBy(c => c.Value)
.ToListAsync(token);
var storesPurchaseOrders = storeDeliveryDay.Select(d => d).ToList();
PopulateWorksheetWithPurchaseOrders(worksheet, storeDeliveryDay.Key, clients, products,
storesPurchaseOrders);
}
var consumerDeliveryDays = purchaseOrders
.Where(po => po.SenderInfo.Kind == ProfileKind.Consumer)
.GroupBy(po => po.ExpectedDelivery.ExpectedDeliveryDate.DayOfWeek)
.ToList();
if (consumerDeliveryDays.Any())
{
var clients = consumerDeliveryDays
.SelectMany(cpo => cpo.Select(c => new KeyValuePair <Guid, string>(c.ClientId, $"{c.SenderInfo.Name} ({c.Reference})")))
.OrderBy(c => c.Value)
.ToList();
foreach (var consumerDeliveryDay in consumerDeliveryDays)
{
var worksheet = excelPkg.Workbook.Worksheets.Add($"Commandes conso du {DayHelper.GetDayFromEnum(consumerDeliveryDay.Key)}");
var consumersPurchaseOrders = consumerDeliveryDay.Select(d => d).ToList();
PopulateWorksheetWithPurchaseOrders(worksheet, consumerDeliveryDay.Key, clients, products,
consumersPurchaseOrders);
}
}
return(Success(new ResourceExportDto
{
Data = excelPkg.GetAsByteArray(), Extension = "xlsx", MimeType = "application/ms-excel"
}));
}
}
public Day(string title)
{
Title = title;
Date = DayHelper.ExtractDate(Title);
Tasks = new List <CustomTask>();
}
private DateTime act(string line)
{
return(DayHelper.ExtractDate(line));
}
//public ActionResult CheckSubjectSlotAvialability(string subject, string level, string StartHourclinet, string StartMinuteclinet)
public ActionResult CheckStaffSlotAvialability(string levels)
{
string[] theLEvel = levels.Split(';');
string subject = theLEvel[0];
string level = theLEvel[1];
string StartHourclinet = theLEvel[2];
string StartMinuteclinet = theLEvel[3];
string teacher = theLEvel[4];
// string[] split = teacher.Split(' ');
// int teacherID = Convert.ToInt32(split[0]);
string day1 = theLEvel[5];
Day day = DayHelper.GetDay(day1);
smContext db = new smContext();
List <Teacher> Teacher = db.Teacher.Include("TheTeachingClass").Where(a => a.TeacherName == teacher).ToList();
foreach (Teacher t in Teacher)
{
// List<TeachingSubject> theTeachingSubject = work.TeachingSubjectRepository.Get().ToList();
// List<TeachingClass> theTeachingClass = db.TeachingClass.Include("TheTeachingDay").Where(a => a.ClassName == level && a.Teacher.TeacherID == t.TeacherID).ToList(); //work.TeachingClassRepository.Get(a => a.ClassName == level).ToList();
List <TeachingClass> theTeachingClass = db.TeachingClass.Include("TheTeachingDay").Where(a => a.Teacher.TeacherID == t.TeacherID).ToList(); //work.TeachingClassRepository.Get(a => a.ClassName == level).ToList();
foreach (TeachingClass c in theTeachingClass)
{
string ClassName = c.ClassName;
// foreach (TeachingDay td in c.TheTeachingDay)
// {
List <TeachingDay> theTeachingDay = db.TeachingDay.Include("TeachingSubject").Where(a => a.TeachingClass.TeachingClassID == c.TeachingClassID && a.theDay == day).ToList();
foreach (TeachingDay td in theTeachingDay)
{
foreach (TeachingSubject ts in td.TeachingSubject)
{
String Day = ts.TeachingDay.theDay.ToString();
string theSubject = ts.SubjectName;
string EndHour = ts.TeachingDay.EndTimeHour;
string EndMinutes = ts.TeachingDay.EndTimeMinute;
string StartHour = ts.TeachingDay.StratTimeHour;
string StartMinutes = ts.TeachingDay.StratTimeMinute;
StringBuilder EndHourEndMinutes = new StringBuilder();
EndHourEndMinutes.Append(EndHour);
EndHourEndMinutes.Append(EndMinutes);
int time = Convert.ToInt16(EndHourEndMinutes.ToString()); //= Convert.ToInt16(EndHour) + Convert.ToInt16(EndMinutes);
StringBuilder StartHourStartMinuteclinets = new StringBuilder();
StartHourStartMinuteclinets.Append(StartHourclinet).Append(StartMinuteclinet);
int timeClient = Convert.ToInt16(StartHourStartMinuteclinets.ToString());//Conve
if (theSubject == subject && timeClient < time)
{
string theAlert = theSubject + " " + "has been fixed for " + teacher + " on " + Day + " for class " + ClassName + " which starts at " + StartHour + ":" + StartMinutes + " and which ends at " + EndHour + ":" + EndMinutes;
return(Json(theAlert, JsonRequestBehavior.AllowGet));
}
if (theSubject != subject && timeClient < time)
{
string theAlert = theSubject + " " + "has been fixed for " + teacher + " on " + Day + " for class " + ClassName + " which starts at " + StartHour + ":" + StartMinutes + " and which ends at " + EndHour + ":" + EndMinutes;
// string theAlert = teacher + " " + "has been fixed for this day and ends " + EndHour + ":" + EndMinutes;
return(Json(theAlert, JsonRequestBehavior.AllowGet));
}
}
// tdy.su
// theTeachingDay.
// foreach(TeachingSubj)
}
}
}
return(Json("", JsonRequestBehavior.AllowGet));
}
