private void UserDialog_Closing(object sender, MaterialDesignThemes.Wpf.DialogClosingEventArgs eventArgs) { string command = (string)eventArgs.Parameter; switch (command) { case "reset": Date1.Date = ""; Date2.Date = ""; Date1.Clear(); Date2.Clear(); LoadBarChartData(); break; case "confirm": LoadBarChartData(); break; case "cancel": Dynamics.LastEscapeTime = DateTime.Now; break; default: break; } }
private void Window_Loaded(object sender, RoutedEventArgs e) { Date1.SetToday(); Date2.SetToday(); Time1.SelectedTime = DateTime.Today; Time2.SelectedTime = DateTime.Today.AddDays(1).AddSeconds(-1); RefreshGrid(); }
protected bool Equals(CultureSample other) { if (Numbers.Where((t, i) => !t.Equals(other.Numbers[i])).Any()) { return(false); } return(Number1.Equals(other.Number1) && Number2.Equals(other.Number2) && Number3.Equals(other.Number3) && Dec1 == other.Dec1 && Dec2 == other.Dec2 && Date1.Equals(other.Date1) && Date2.Equals(other.Date2)); }
public bool IsMatch(Post post) { switch (Operator) { case DateOperator.Before: return(Date1.CompareTo(post.Date) > 0); case DateOperator.Equal: return(Date1.CompareTo(post.Date) == 0); case DateOperator.After: return(Date1.CompareTo(post.Date) < 0); case DateOperator.Range: return(Date1.CompareTo(post.Date) < 0 && Date2.CompareTo(post.Date) > 0); } return(false); }
private void Window_Loaded(object sender, RoutedEventArgs e) { Date1.SetToday(); Date2.SetToday(); RefreshGrid(); var list = new List <Data.Good>(); list.Add(new Data.Good { Id = 0, Name = "همه" }); list.AddRange(db.Goods.ToList()); cmbItems.DataContext = list; }
/// <inheritdoc/> public override int GetHashCode() { // Overflow is fine, just wrap. unchecked { int hash = 17; hash *= 23 + DateTime1.GetHashCode(); hash *= 23 + DateTime2.GetHashCode(); hash *= 23 + Date1.GetHashCode(); hash *= 23 + Date2.GetHashCode(); return(hash); } }
public override int GetHashCode() { unchecked { var hashCode = Number1.GetHashCode(); hashCode = (hashCode * 397) ^ Number2.GetHashCode(); hashCode = (hashCode * 397) ^ Number3.GetHashCode(); hashCode = (hashCode * 397) ^ (Numbers?.GetHashCode() ?? 0); hashCode = (hashCode * 397) ^ Dec1.GetHashCode(); hashCode = (hashCode * 397) ^ Dec2.GetHashCode(); hashCode = (hashCode * 397) ^ Date1.GetHashCode(); hashCode = (hashCode * 397) ^ Date2.GetHashCode(); return(hashCode); } }
public void ToDateTime() { // Arrange const string Date1 = "28/09/2011"; const string Date2 = "28/09/2011 15:35"; // Act var result1 = Date1.ToDateTime(103); var result2 = Date2.ToDateTime(-1); // Assert Assert.IsNotNull(result1); Assert.AreEqual(Date1, result1.ToString("dd/MM/yyyy")); Assert.IsNotNull(result2); Assert.AreEqual(Date2, result2.ToString("dd/MM/yyyy HH:mm")); }
public double Calculate() { var a = Date1.Split().ToList(); int aYear = int.Parse(a[0]); int aMonth = int.Parse(a[1]); int aDay = int.Parse(a[2]); var b = Date2.Split().ToList(); int bYear = int.Parse(b[0]); int bMonth = int.Parse(b[1]); int bDay = int.Parse(b[2]); DateTime d1 = new DateTime(aYear, aMonth, aDay); DateTime d2 = new DateTime(bYear, bMonth, bDay); TimeSpan time = d1 - d2; return(Math.Abs(time.TotalDays)); }
public fillDates() { QueryViewModel qvm=new QueryViewModel() int i=0; foreach(var item in Date1.Reverse()) { qvm.displayDate = theDate; qvm.Count1 = theCount; DateList.Add(qvm); } int i=0; foreach(var item in Date2.Reverse()) { DateList[i].Count2 = theCount; i++; } return DateList }
public String DateString() { String dateString = null; if (Date1 != null) { if ((Date2 != null) && !Date2.Julian) { dateString = String.Format("BET {0} AND {1}", Date1.ToString(), Date2.ToString()); } else { dateString = Date1.ToString(); } } return(dateString); }
public async void SaveChanges() { if (Date1 < Date2) { bool confirmed = await JsRunTime.InvokeAsync <bool>("confirm", "Are you sure you want to make these changes?"); if (confirmed) { string tasks = ""; foreach (var item in results.Where(i => i.IsJobSelected == true)) { tasks += "'" + item.TASK_ID + "'" + ","; item.ScheduledDownTime = Date1.ToString() + " - " + Date2.ToString(); } tasks = tasks.TrimEnd(','); string insertSql = "update " + OracleTableNames.JobService + " set service_suspend_start = to_date('" + Date1.ToString() + "','MM/DD/YYYY HH:MI:SS AM')," + " service_suspend_stop = to_date('" + Date2.ToString() + "','MM/DD/YYYY HH:MI:SS AM') where task_id in (" + tasks + ")"; var sqlString = new StringContent(insertSql, Encoding.UTF8, "text/plain"); await HttpClient.PostAsync(ServiceEndpoints.EXECUTE_SQL_POST, sqlString); await GetData(); GetStatus(); ClearSelected(); Date1 = DateTime.Now; Date2 = DateTime.Now; } else { GetStatus(); Date1 = DateTime.Now; Date2 = DateTime.Now; } } else { FontColor = "red"; Message = "Start Time must be less than End Time"; GetStatus(); } await GetData(); GetStatus(); StateHasChanged(); }
public string Output(string jparameters, List <CategoryViewModel> jCategory, int GroupID, int ItemID, dynamic variable, string DataType) { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); CalculationCSharp.Areas.Configuration.Models.ConfigFunctions Config = new CalculationCSharp.Areas.Configuration.Models.ConfigFunctions(); ArrayBuildingFunctions ArrayBuilder = new ArrayBuildingFunctions(); string[] Parts = null; //Returns Array Parts = ArrayBuilder.InputArrayBuilder(variable, jCategory, GroupID, ItemID); string Output = null; //Loop through the array to calculate each value in array foreach (string part in Parts) { dynamic InputA = Config.VariableReplace(jCategory, part, GroupID, ItemID); if (DataType == "Date") { DateTime Date1; DateTime.TryParse(InputA, out Date1); Output = Output + Convert.ToString(Date1.ToShortDateString()) + "~"; } else if (DataType == "Decimal") { Int16 Int1; Int16.TryParse(InputA, out Int1); Output = Output + Convert.ToString(Int1) + "~"; } else { Output = Output + Convert.ToString(InputA) + "~"; } } Output = Output.Remove(Output.Length - 1); return(Convert.ToString(Output)); }
public void VerifyDate1() { Date1String = Date1.ToString("g"); }
public void ChangeYear(DateTime dt) { Date1 = Date1.AddYears(dt.Year - Date1.Year); Date2 = Date2.AddYears(dt.Year - Date2.Year); }
public bool Find(string toFind) { return(DateType.ToString() == toFind || Date1.ToString() == toFind); }
private void button2_Click(object sender, EventArgs e) { Excel.Application ex = new Microsoft.Office.Interop.Excel.Application(); ex.Visible = true; ex.SheetsInNewWorkbook = 12; Excel.Workbook workBook = ex.Workbooks.Add(Type.Missing); ex.DisplayAlerts = false; var currentYear1 = DateTime.Now.Year; for (int i = 0; i < 12; i++) { Excel.Worksheet sheet = (Excel.Worksheet)ex.Worksheets.get_Item(i + 1); sheet.StandardWidth = 3; sheet.Name = months[i]; sheet.Cells[1, 1] = String.Format("Номер отеля | День"); if (months[i] == "01" || months[i] == "03" || months[i] == "05" || months[i] == "07" || months[i] == "08" || months[i] == "10" || months[i] == "12") { for (int j = 2; j < 33; j++) { sheet.Cells[j] = String.Format("{0}", j - 1); } for (int j = 2; j < 17; j++) { sheet.Cells[j, 1] = String.Format("{0}", j - 1); } } if (months[i] == "02") { for (int j = 2; j < 31; j++) { sheet.Cells[j] = String.Format("{0}", j - 1); } for (int j = 2; j < 17; j++) { sheet.Cells[j, 1] = String.Format("{0}", j - 1); } } if (months[i] == "04" || months[i] == "06" || months[i] == "09" || months[i] == "11") { for (int j = 2; j < 32; j++) { sheet.Cells[j] = String.Format("{0}", j - 1); } for (int j = 2; j < 17; j++) { sheet.Cells[j, 1] = String.Format("{0}", j - 1); } } } SQLiteConnection sql = new SQLiteConnection(@"Data Source=D:\VS\Diplom\Guest.sqlite"); sql.Open(); int count = 0; SQLiteCommand sc4 = new SQLiteCommand("select count (*) as '" + count + "'from Гости", sql); //кол-во строк в таблице count = Convert.ToInt32(sc4.ExecuteScalar()); int[] b = new int[count]; //получение id int o = 0; SQLiteCommand sc3 = new SQLiteCommand("select id from Гости", sql); var mas1 = sc3.ExecuteReader(); while (mas1.Read()) { b[o] = Convert.ToInt32(mas1["id"]); o++; } string Date1, Date2, Number = ""; for (int j = 0; j < count; j++) { SQLiteCommand sc = new SQLiteCommand("select Дата_Заезда from Гости where id='" + b[j] + "'", sql); SQLiteCommand sc1 = new SQLiteCommand("select Дата_Выезда from Гости where id='" + b[j] + "'", sql); SQLiteCommand sc2 = new SQLiteCommand("select Номер_Комнаты from Гости where id= '" + b[j] + "'", sql); Date1 = sc.ExecuteScalar().ToString(); Date2 = sc1.ExecuteScalar().ToString(); Number = sc2.ExecuteScalar().ToString(); var currentYear = DateTime.Now.Date; string[] words = Date1.Split(new char[] { '.' }, StringSplitOptions.RemoveEmptyEntries); //разделение даты string Day = words[0]; string Month = words[1]; string Year = words[2]; words = Date2.Split(new char[] { '.' }, StringSplitOptions.RemoveEmptyEntries); string Day1 = words[0]; string Month1 = words[1]; string Year1 = words[2]; Excel.Worksheet sheet = (Excel.Worksheet)ex.Worksheets.get_Item(Month); if (listBox2.SelectedItem.ToString() == currentYear1.ToString()) { if (Month == Month1) { ((Excel.Worksheet)ex.Application.ActiveWorkbook.Sheets[Month]).Select(); Excel.Range range2 = ex.get_Range(ex.Cells[Convert.ToInt32(Number) + 1, Convert.ToInt32(Day) + 1], ex.Cells[Convert.ToInt32(Number) + 1, Convert.ToInt32(Day1) + 1]); range2.Interior.Color = ColorTranslator.ToOle(Color.Blue); } else { string h = Day1; for (int a = Convert.ToInt32(Month); a <= Convert.ToInt32(Month1); a++) { if (a != Convert.ToInt32(Month1)) { if (a == 01 || a == 03 || a == 05 || a == 07 || a == 08 || a == 10 || a == 12) { Day1 = "31"; } else if (a == 02) { Day1 = "29"; } else if (a == 04 || a == 06 || a == 09 || a == 11) { Day1 = "30"; } } ((Excel.Worksheet)ex.Application.ActiveWorkbook.Sheets[a]).Select(); Excel.Range range2 = ex.get_Range(ex.Cells[Convert.ToInt32(Number) + 1, Convert.ToInt32(Day) + 1], ex.Cells[Convert.ToInt32(Number) + 1, Convert.ToInt32(Day1) + 1]); range2.Interior.Color = ColorTranslator.ToOle(Color.Blue); Day1 = h; } } } } sql.Close(); }