public static string ConvertDayOfWeekToZh(System.DayOfWeek dw) { string DayOfWeekZh = ""; switch (dw.ToString("D")) { case "0": DayOfWeekZh = "日"; break; case "1": DayOfWeekZh = "一"; break; case "2": DayOfWeekZh = "二"; break; case "3": DayOfWeekZh = "三"; break; case "4": DayOfWeekZh = "四"; break; case "5": DayOfWeekZh = "五"; break; case "6": DayOfWeekZh = "六"; break; } return DayOfWeekZh; }
// --------------------------------------------------------------------- public void Serialize(TextWriter textWriter) { textWriter.WriteLine(topMostS + "=" + topMost.ToString()); textWriter.WriteLine(borderS + "=" + border.ToString()); textWriter.WriteLine(showWeekNumbersS + "=" + showWeekNumbers.ToString()); textWriter.WriteLine(showTodayS + "=" + showToday.ToString()); textWriter.WriteLine(showTodayCircleS + "=" + showTodayCircle.ToString()); textWriter.WriteLine(opacityS + "=" + opacity.ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(positionS + "=" + position.ToString()); textWriter.WriteLine(firstDayS + "=" + firstDay.ToString()); textWriter.WriteLine(fontS + "=" + Settings.FontToString(font)); textWriter.WriteLine(colorForeS + "=" + colorFore.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorBackS + "=" + colorBack.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorTitleForeS + "=" + colorTitleFore.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorTitleBackS + "=" + colorTitleBack.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorTrailingForeS + "=" + colorTrailingFore.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorHighlightDayForeS + "=" + colorHighlightDayFore.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorGridlinesS + "=" + colorGridlines.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorWeekdayForeS + "=" + colorWeekdayFore.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorWeekdayBackS + "=" + colorWeekdayBack.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorWeeknumberForeS + "=" + colorWeeknumberFore.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorWeeknumberBackS + "=" + colorWeeknumberBack.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(colorWeekdayBarS + "=" + colorWeekdayBar.ToArgb().ToString(CultureInfo.InvariantCulture)); textWriter.WriteLine(trayIconS + "=" + trayIcon.ToString()); textWriter.WriteLine(gridlinesS + "=" + gridlines.ToString()); textWriter.WriteLine(startMonthJanuaryS + "=" + startMonthJanuary.ToString()); textWriter.WriteLine(startMonthPreviousS + "=" + startMonthPrevious.ToString(CultureInfo.InvariantCulture)); }
private void addDayOffStripMenuItem_Click(object sender, EventArgs e) { ToolStripMenuItem item = sender as ToolStripMenuItem; int week = Convert.ToInt16(treeView1.SelectedNode.Text.ToLower().Replace("week", "")); System.DayOfWeek dayselected = (System.DayOfWeek)Enum.Parse(typeof(System.DayOfWeek), item.Text); if (!treeView1.SelectedNode.Nodes.ContainsKey(dayselected.ToString())) { treeView1.SelectedNode.Nodes.Add(new TreeNode() { Name = dayselected.ToString(), Text = dayselected.ToString() }); treeView1.SelectedNode.Expand(); } }
/// <summary> /// Determines weekday or weekend /// </summary> /// <param name="dayOfWeek"></param> /// <returns></returns> private string GetPartOfWeek(DayOfWeek dayOfWeek) { switch (dayOfWeek.ToString()) { case "Saturday": case "Sunday": return(HttpContext.Current.GetLocaleResource(ResourceTypes.Label, "Weekend").ToString()); break; default: return(HttpContext.Current.GetLocaleResource(ResourceTypes.Label, "Weekday").ToString()); break; } }
private void CreateSessionVars() { FlyingFishClassesDataContext ff = new FlyingFishClassesDataContext(); try { var qry = (from o in ff.EmployeeMemberships join emp in ff.aspnet_Users on o.userId equals emp.UserId where emp.UserName == User.Identity.Name select o.empId).Single(); Session["CurEmpId"] = qry.ToString(); //Label1.Text += "\t" + Convert.ToString(Session["CurEmpId"]); System.DateTime currentDate = System.DateTime.Now; System.DateTime actualQryDate = currentDate; System.DayOfWeek dayOfWeek = currentDate.DayOfWeek; // trying to get the sunday of the week picked by the user switch (dayOfWeek.ToString()) { case "Monday": actualQryDate = currentDate.AddDays(-1); break; case "Tuesday": actualQryDate = currentDate.AddDays(-2); break; case "Wednesday": actualQryDate = currentDate.AddDays(-3); break; case "Thursday": actualQryDate = currentDate.AddDays(-4); break; case "Friday": actualQryDate = currentDate.AddDays(-5); break; case "Saturday": actualQryDate = currentDate.AddDays(-6); break; default: break; } Session["CurrentDate"] = actualQryDate; } catch { Response.Redirect("~/Login.aspx"); } }
public Dias(System.DayOfWeek day) { switch (day.ToString()) { case "Sunday": Id = 1; Detalle = "Domingo"; break; case "Monday": Id = 2; Detalle = "Lunes"; break; case "Tuesday": Id = 3; Detalle = "Martes"; break; case "Wednesday": Id = 4; Detalle = "Miercoles"; break; case "Thursday": Id = 5; Detalle = "Jueves"; break; case "Friday": Id = 6; Detalle = "Viernes"; break; case "Saturday": Id = 7; Detalle = "Sábado"; break; } }
private void populategridview() { string empIdTemp = ""; var qry = (from o in ff.EmployeeMemberships join emp in ff.aspnet_Users on o.userId equals emp.UserId where emp.UserName == User.Identity.Name select o.empId).Single(); Session["CurEmpId"] = qry.ToString(); empIdTemp = qry.ToString(); //Label1.Text += "\t" + Convert.ToString(Session["CurEmpId"]); System.DateTime currentDate = System.DateTime.Now; System.DateTime actualQryDate = currentDate; System.DayOfWeek dayOfWeek = currentDate.DayOfWeek; // trying to get the sunday of the week picked by the user switch (dayOfWeek.ToString()) { case "Monday": actualQryDate = currentDate.AddDays(-1); break; case "Tuesday": actualQryDate = currentDate.AddDays(-2); break; case "Wednesday": actualQryDate = currentDate.AddDays(-3); break; case "Thursday": actualQryDate = currentDate.AddDays(-4); break; case "Friday": actualQryDate = currentDate.AddDays(-5); break; case "Saturday": actualQryDate = currentDate.AddDays(-6); break; default: break; } Session["CurrentDate"] = actualQryDate; var qry2 = from ts in ff.TimesheetEntries where (ts.tsDate >= actualQryDate) && (ts.empId == Convert.ToInt32(empIdTemp)) select new { ProjID = ts.projId, WpId = ts.wpId, tsdate = ts.tsDate, Sun = ts.sun, Mon = ts.mon, Tue = ts.tue, Wed = ts.wed, Thu = ts.thu, Fri = ts.fri, Sat = ts.sat, Notes = ts.notes }; if (qry2.Count() == 0) { //gvStatus.DataSource = null; //gvStatus.DataBind(); //lblResults.Visible = true; //divReportData.Visible = false; //return; } DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("ProjID", typeof(System.String))); dt.Columns.Add(new DataColumn("WpID", typeof(System.String))); dt.Columns.Add(new DataColumn("Mon", typeof(System.String))); dt.Columns.Add(new DataColumn("Tue", typeof(System.String))); dt.Columns.Add(new DataColumn("Wed", typeof(System.String))); dt.Columns.Add(new DataColumn("Thur", typeof(System.String))); dt.Columns.Add(new DataColumn("Fri", typeof(System.String))); dt.Columns.Add(new DataColumn("Sat", typeof(System.String))); dt.Columns.Add(new DataColumn("Sun", typeof(System.String))); dt.Columns.Add(new DataColumn("Notes", typeof(System.String))); dt.Columns.Add(new DataColumn("Date", typeof(System.String))); foreach (var row in qry2) { DataRow dr = dt.NewRow(); dr["ProjID"] = row.ProjID; dr["WpID"] = row.WpId; dr["Mon"] = row.Mon; dr["Tue"] = row.Tue; dr["Wed"] = row.Wed; dr["Thur"] = row.Thu; dr["Fri"] = row.Thu; dr["Sat"] = row.Sat; dr["Sun"] = row.Sun; dr["Notes"] = row.Notes; dr["Date"] = row.tsdate; dt.Rows.Add(dr); } double totMon = 0; double totTue = 0; double totWed = 0; double totThu = 0; double totFri = 0; double totSat = 0; double totSun = 0; for (int i = 0; i < dt.Rows.Count; i++) { var b = dt.Rows[i][2].ToString(); totMon += Convert.ToDouble(dt.Rows[i][2].ToString()); } for (int i = 0; i < dt.Rows.Count; i++) { var b = dt.Rows[i][3].ToString(); totTue += Convert.ToDouble(dt.Rows[i][3].ToString()); } for (int i = 0; i < dt.Rows.Count; i++) { var b = dt.Rows[i][4].ToString(); totWed += Convert.ToDouble(dt.Rows[i][4].ToString()); } for (int i = 0; i < dt.Rows.Count; i++) { var b = dt.Rows[i][5].ToString(); totThu += Convert.ToDouble(dt.Rows[i][5].ToString()); } for (int i = 0; i < dt.Rows.Count; i++) { var b = dt.Rows[i][6].ToString(); totFri += Convert.ToDouble(dt.Rows[i][6].ToString()); } for (int i = 0; i < dt.Rows.Count; i++) { var b = dt.Rows[i][7].ToString(); totSat += Convert.ToDouble(dt.Rows[i][7].ToString()); } for (int i = 0; i < dt.Rows.Count; i++) { var b = dt.Rows[i][8].ToString(); totSun += Convert.ToDouble(dt.Rows[i][8].ToString()); } // add the total row DataRow totalRow = dt.NewRow(); totalRow["ProjID"] = "Total"; totalRow["Mon"] = totMon; totalRow["Tue"] = totThu; totalRow["wed"] = totWed; totalRow["Thur"] = totThu; totalRow["Fri"] = totFri; totalRow["Sat"] = totSat; totalRow["Sun"] = totSun; dt.Rows.Add(totalRow); dvTimeSheet.DataSource = dt; dvTimeSheet.DataBind(); }
public ActionResult Fixed(FinalShift FixedShift) { if ((FixedShift.Morning == true && FixedShift.Afternoon == true) || (FixedShift.Morning == true && FixedShift.Night == true) || (FixedShift.Afternoon == true && FixedShift.Night == true) || (FixedShift.Morning == true && FixedShift.Afternoon == true && FixedShift.Night == true)) { ModelState.AddModelError("Night", "Choose one shift"); FixedShift.Employees = db.Employees.Where(x => x.Admin == false).ToList();; return(View(FixedShift)); } var employ = db.Employees.Where(x => x.Admin == false).ToList(); var totalshifts = db.ShiftsPerWeek.Select(o => o.NumOfShifts).FirstOrDefault(); DateTime NextSunday = DateTime.Now.AddDays(1); while (NextSunday.DayOfWeek != DayOfWeek.Sunday) { NextSunday = NextSunday.AddDays(1); } var listofFixed = new List <FinalShift>(); if ((db.FinalShift.Where(s => s.Dates > NextSunday.Date).Count() <= totalshifts / 2) && db.FinalShift.Count() > 0) { foreach (var shift in db.FinalShift.Where(e => e.Dates > NextSunday.Date).ToList()) { listofFixed.Add(shift); } } ViewBag.FixedList = listofFixed; var xyz = listofFixed.Where(w => w.Day == FixedShift.Day && w.Name == FixedShift.Name).Count(); if (xyz > 0) { ModelState.AddModelError("Name", "This employee has already been placed on this day"); FixedShift.Employees = employ; return(View(FixedShift)); } if (FixedShift.Morning == true) { var x = db.ScheduleParameters.Select(c => c.Morning).FirstOrDefault(); var w = db.ScheduleParameters.Where(d => d.Day == FixedShift.Day).Select(d => d.DMorning).FirstOrDefault(); if (w == null) { w = 0; } var p = db.FinalShift.Where(f => f.Day == FixedShift.Day && f.Morning == true).Count(); if (p >= (x + w)) { ModelState.AddModelError("Night", "Maximum employees per shift. Please update the settings to allow more employees"); FixedShift.Employees = employ; return(View(FixedShift)); } } else if (FixedShift.Afternoon == true) { var x = db.ScheduleParameters.Select(c => c.Afternoon).FirstOrDefault(); var w = db.ScheduleParameters.Where(d => d.Day == FixedShift.Day).Select(d => d.DAfternoon).FirstOrDefault(); if (w == null) { w = 0; } var p = db.FinalShift.Where(f => f.Day == FixedShift.Day && f.Afternoon == true).Count(); if (p >= (x + w)) { ModelState.AddModelError("Night", "Maximum employees per shift, please update the settings to allow more employees"); FixedShift.Employees = employ; return(View(FixedShift)); } } else { var x = db.ScheduleParameters.Select(c => c.Night).FirstOrDefault(); var w = db.ScheduleParameters.Where(d => d.Day == FixedShift.Day).Select(d => d.DNight).FirstOrDefault(); if (w == null) { w = 0; } var p = db.FinalShift.Where(f => f.Day == FixedShift.Day && f.Night == true).Count(); if (p >= (x + w)) { ModelState.AddModelError("Night", "Maximum employees per shift, please update the settings to allow more employees"); FixedShift.Employees = employ; return(View(FixedShift)); } } bool flag = false; int i, y; Employees Emp = db.Employees.FirstOrDefault(x => x.FirstName == FixedShift.Name); for (i = 1; FSrespo.DayOfWeek(i) != FixedShift.Day; i++) { ; } y = FixedShift.Morning == true ? 0 : FixedShift.Afternoon == true ? 2 : 3; DayOfWeek day = new System.DayOfWeek(); string dday = FSrespo.DayOfWeek(i); for (int d = 0; d < 7; d++) { if (day.ToString() != dday) { day = (DayOfWeek)((d + 1) % 7); } else { break; } } FixedShift.Dates = FSrespo.NextWeeksDates(day); if (db.FinalShift.Count() <= totalshifts) { FSrespo.OfDayHandler(true, 0, 0); } try { if (Emp != null && ModelState.IsValid) { FixedShift.EmployID = Emp.ID; flag = true; FixedShift.OfDayType = FSrespo.OrderOfDayTypeHandler(i, y); db.FinalShift.Add(FixedShift); db.SaveChanges(); return(RedirectToAction("Fixed")); } } catch { if (flag) { ModelState.AddModelError("Name", "Error Saving this shift"); FixedShift.Employees = db.Employees.ToList(); return(View(FixedShift)); } ModelState.AddModelError("Name", "Employee's ID was not found or matched"); FixedShift.Employees = db.Employees.ToList(); return(View(FixedShift)); } return(View(FixedShift)); }
/// <summary> /// Date time to string. /// </summary> /// <returns>Date time as a string.</returns> public override string ToString() { if (Skip != DateTimeSkips.None) { System.Globalization.CultureInfo culture = System.Globalization.CultureInfo.CurrentCulture; #if !WINDOWS_UWP string dateSeparator = culture.DateTimeFormat.DateSeparator, timeSeparator = culture.DateTimeFormat.TimeSeparator; List <string> shortDatePattern = new List <string>(culture.DateTimeFormat.ShortDatePattern.Split(new string[] { dateSeparator }, StringSplitOptions.RemoveEmptyEntries)); #else //In UWP Standard Date and Time Format Strings are used. string dateSeparator = Internal.GXCommon.GetDateSeparator(), timeSeparator = Internal.GXCommon.GetTimeSeparator(); List <string> shortDatePattern = new List <string>("yyyy-MM-dd".Split(new string[] { dateSeparator }, StringSplitOptions.RemoveEmptyEntries)); #endif List <string> shortTimePattern = new List <string>(culture.DateTimeFormat.LongTimePattern.Split(new string[] { timeSeparator, " ", "." }, StringSplitOptions.RemoveEmptyEntries)); if ((Skip & DateTimeSkips.Year) != 0) { shortDatePattern.Remove("yyyy"); shortDatePattern.Remove("yy"); } if ((Skip & DateTimeSkips.Month) != 0) { shortDatePattern.Remove("M"); shortDatePattern.Remove("MM"); } if ((Skip & DateTimeSkips.Day) != 0 || (Extra & DateTimeExtraInfo.LastDay) != 0 || (Extra & DateTimeExtraInfo.LastDay2) != 0) { shortDatePattern.Remove("d"); shortDatePattern.Remove("dd"); } if ((Skip & DateTimeSkips.Hour) != 0) { shortTimePattern.Remove("h"); shortTimePattern.Remove("H"); shortTimePattern.Remove("HH"); shortTimePattern.Remove("tt"); } if ((Skip & DateTimeSkips.Minute) != 0) { shortTimePattern.Remove("mm"); } if ((Skip & DateTimeSkips.Second) != 0 || (shortTimePattern.Count == 1 && Value.Second == 0)) { shortTimePattern.Remove("ss"); } string format = null; if (shortDatePattern.Count != 0) { format = string.Join(dateSeparator, shortDatePattern.ToArray()); } if (shortTimePattern.Count != 0) { if (format != null) { format += " "; } format += string.Join(timeSeparator, shortTimePattern.ToArray()); } if (format == "H") { return(Value.Hour.ToString()); } if (format == null) { return(""); } string str = Value.LocalDateTime.ToString(format, culture); if (DayOfWeek != 0 && (Skip & DateTimeSkips.DayOfWeek) == 0) { System.DayOfWeek t = (System.DayOfWeek)DayOfWeek; if (DayOfWeek == 7) { t = System.DayOfWeek.Sunday; } str = t.ToString() + " " + str; if ((Extra & DateTimeExtraInfo.LastDay) != 0) { str = "Last " + str; } } else if ((Extra & DateTimeExtraInfo.LastDay) != 0) { str = "Last Day of month " + str; } return(str); } if (DayOfWeek != 0) { #if !WINDOWS_UWP return(Value.LocalDateTime.ToLongDateString()); #else return(Value.LocalDateTime.ToString()); #endif //!WINDOWS_UWP } return(Value.LocalDateTime.ToString()); }
public string ToFormatString(CultureInfo culture) { int pos; if (Skip != DateTimeSkips.None) { #if !WINDOWS_UWP string dateSeparator = culture.DateTimeFormat.DateSeparator, timeSeparator = culture.DateTimeFormat.TimeSeparator; List <string> shortDatePattern = new List <string>(culture.DateTimeFormat.ShortDatePattern.Split(new string[] { dateSeparator, " " }, StringSplitOptions.RemoveEmptyEntries)); #else //In UWP Standard Date and Time Format Strings are used. string dateSeparator = Internal.GXCommon.GetDateSeparator(), timeSeparator = Internal.GXCommon.GetTimeSeparator(); List <string> shortDatePattern = new List <string>("yyyy-MM-dd".Split(new string[] { dateSeparator }, StringSplitOptions.RemoveEmptyEntries)); #endif List <string> shortTimePattern = new List <string>(culture.DateTimeFormat.LongTimePattern.Split(new string[] { timeSeparator, " ", "." }, StringSplitOptions.RemoveEmptyEntries)); if (this is GXTime) { shortDatePattern.Clear(); } else { if ((Skip & DateTimeSkips.Year) != 0) { pos = shortDatePattern.IndexOf("yyyy"); if (pos == -1) { pos = shortDatePattern.IndexOf("yy"); } shortDatePattern[pos] = "*"; } if ((Skip & DateTimeSkips.Month) != 0) { pos = shortDatePattern.IndexOf("M"); if (pos == -1) { pos = shortDatePattern.IndexOf("MM"); } shortDatePattern[pos] = "*"; } if ((Skip & DateTimeSkips.Day) != 0) { pos = shortDatePattern.IndexOf("d"); if (pos == -1) { pos = shortDatePattern.IndexOf("dd"); } shortDatePattern[pos] = "*"; } else { pos = shortDatePattern.IndexOf("d"); if (pos == -1) { pos = shortDatePattern.IndexOf("dd"); } if ((Extra & DateTimeExtraInfo.LastDay) != 0) { shortDatePattern[pos] = "-1"; } else if ((Extra & DateTimeExtraInfo.LastDay2) != 0) { shortDatePattern[pos] = "-2"; } } } if (this is GXDate) { shortTimePattern.Clear(); } else { if ((Skip & DateTimeSkips.Hour) != 0) { pos = shortTimePattern.IndexOf("h"); if (pos == -1) { pos = shortTimePattern.IndexOf("H"); if (pos == -1) { pos = shortTimePattern.IndexOf("HH"); } } shortTimePattern[pos] = "*"; } if ((Skip & DateTimeSkips.Minute) != 0) { pos = shortTimePattern.IndexOf("mm"); shortTimePattern[pos] = "*"; } if ((Skip & DateTimeSkips.Second) != 0 || (shortTimePattern.Count == 1 && Value.Second == 0)) { pos = shortTimePattern.IndexOf("ss"); shortTimePattern[pos] = "*"; } } string format = null; if (shortDatePattern.Count != 0) { format = string.Join(dateSeparator, shortDatePattern.ToArray()); } if (shortTimePattern.Count != 0) { if (format != null) { format += " "; } format += string.Join(timeSeparator, shortTimePattern.ToArray()); format = format.Replace(timeSeparator + "tt", " tt"); } if (format == "H") { return(Value.Hour.ToString()); } if (format == null) { return(""); } string str = Value.LocalDateTime.ToString(format, culture); if (DayOfWeek != 0 && (Skip & DateTimeSkips.DayOfWeek) == 0 && (Skip & (DateTimeSkips.Year | DateTimeSkips.Month | DateTimeSkips.Day)) != 0) { System.DayOfWeek t = (System.DayOfWeek)DayOfWeek; if (DayOfWeek == 7) { t = System.DayOfWeek.Sunday; } str = t.ToString() + " " + str; } return(str); } return(Value.LocalDateTime.ToString(culture)); }
public DateTime GetDepartDateTime(Train train, DateTime departDate) { int occurID = db.TrainsRecurring.Where(tr => tr.TrainID == train.ID).ToList()[0].OccurID; string frequency = db.Occurs.Where(o => o.ID == occurID).ToList()[0].Frequency; if (train != null) { switch (frequency) { case "Monthly": { TrainRecurring tr = trainRecrrRepo.GetByTrainId(train.ID); if (tr != null) { return(departDate.AddHours(tr.DepartureTime.Hours).AddMinutes(tr.DepartureTime.Minutes)); } break; } case "Weekly": { System.DayOfWeek dayOfWeek = (System.DayOfWeek)departDate.DayOfWeek; int dayOfWeekId = db.DaysOfWeek.Where(d => d.WeekDay == dayOfWeek.ToString()).ToList()[0].ID; TrainRecurring trRcr = trainRecrrRepo.GetByDaysOfWeekIdAndTrainId(dayOfWeekId, train.ID); if (trRcr != null) { return(departDate.AddHours(trRcr.DepartureTime.Hours).AddMinutes(trRcr.DepartureTime.Minutes)); } break; } case "Every day": { TrainRecurring trRcr = trainRecrrRepo.GetByTrainId(train.ID); if (trRcr != null) { return(departDate.AddHours(trRcr.DepartureTime.Hours).AddMinutes(trRcr.DepartureTime.Minutes)); } break; } } } return(new DateTime(1, 1, 1)); }
public override string ToString() { return(day.ToString() + " " + timeFrom.Hours.ToString().PadLeft(2, '0') + ":" + timeFrom.Minutes.ToString().PadLeft(2, '0') + " to " + timeTo.Hours.ToString().PadLeft(2, '0') + ":" + timeTo.Minutes.ToString().PadLeft(2, '0')); }