public ManageExpensesListViewModel()
{
this.DateBegin = new DateTime(DateTime.Now.Year, 1, 1, 0, 0, 0, 0);
this.DateEnd = new DateTime(DateTime.Now.Year, 12, 31, 23, 59, 59, 999);
this.Dat1 = DateBegin.ToString("MM/dd/yyyy");
this.Dat2 = DateEnd.ToString("MM/dd/yyyy");
}
public string exportAsICS()
{
//create a new stringbuilder instance
StringBuilder sb = new StringBuilder();
//start the calendar item
sb.AppendLine("BEGIN:VCALENDAR");
sb.AppendLine("VERSION:2.0");
sb.AppendLine("PRODID:BilleterieEPITA");
//add the event
sb.AppendLine("BEGIN:VEVENT");
//DTSTART: Date de début de l'événement
sb.AppendLine("DTSTART;TZID=Europe/Paris:" + DateStart.ToString("yyyyMMddTHHmm00"));
//sb.AppendLine("DTSTART:" + DateStart.ToString("yyyyMMddTHHmm00"));
//DTEND: Date de fin de l'événement
sb.AppendLine("DTEND;TZID=Europe/Paris:" + DateEnd.ToString("yyyyMMddTHHmm00"));
//sb.AppendLine("DTEND:" + DateEnd.ToString("yyyyMMddTHHmm00"));
sb.AppendLine("ORGANIZER:CN=" + Organizer + ":MAILTO:" + OrganizerEmail);
//SUMMARY: Titre de l'événement
sb.AppendLine("SUMMARY:" + Summary + "");
//LOCATION: Lieu de l'événement
sb.AppendLine("LOCATION:" + Location + "");
//DESCRIPTION: Description de l'événement
sb.AppendLine("DESCRIPTION:" + Description + "");
//CATEGORIES: Catégorie de l'événement (ex: Conférence, Fête...)
//STATUS: Statut de l'événement (TENTATIVE, CONFIRMED, CANCELLED)
//TRANSP: Définit si la ressource affectée à l'événement est rendu indisponible (OPAQUE, TRANSPARENT)
//SEQUENCE: Nombre de mises à jour, la première mise à jour est à 1
sb.AppendLine("PRIORITY:" + Priority.ToString());
sb.AppendLine("END:VEVENT");
//end calendar item
sb.AppendLine("END:VCALENDAR");
//create a string from the stringbuilder
string CalendarItem = sb.ToString();
return(CalendarItem);
//send the calendar item to the browser
/*
* Response.ClearHeaders();
* Response.Clear();
* Response.Buffer = true;
* Response.ContentType = "text/calendar";
* Response.AddHeader("content-length", CalendarItem.Length.ToString());
* Response.AddHeader("content-disposition", "attachment; filename=\"" + FileName + ".ics\"");
* Response.Write(CalendarItem);
* Response.Flush();
* HttpContext.Current.ApplicationInstance.CompleteRequest();
*/
}
} // DueCurrencyCode
public override string ToString()
{
return(string.Format("{0} - {1}: {2} {3}, {4} {5}",
DateStart.ToString("MMM d yyyy", CultureInfo.InvariantCulture),
DateEnd.ToString("MMM d yyyy", CultureInfo.InvariantCulture),
PaidAmount, PaidCurrencyCode,
DueAmount, DueCurrencyCode
));
} // ToString
public ManageExpensesListViewModel(User user, string dat1, string dat2) : base()
{
First_Name = user.First_Name;
Last_Name = user.Last_Name;
Email = user.Email;
this.DateBegin = Convert.ToDateTime(dat1);
this.DateEnd = Convert.ToDateTime(dat2);
this.Dat1 = DateBegin.ToString("MM/dd/yyyy");
this.Dat2 = DateEnd.ToString("MM/dd/yyyy");
UserId = user.UserId;
}
private void BtnAddCalculatedMetrics_Click(object sender, EventArgs e)
{
string DeviceID, MetricValue;
//int MetricID;
DateTime DateStart, DateEnd;
DeviceID = MetricValue = default;
// MetricID = default;
DateStart = DateEnd = default;
if (String.IsNullOrEmpty(textBox3.Text))
{
MessageBox.Show("Gngn vraies valeurs svp");
return; //Arrete tout si jamais c'est le cas
}
else
{
MetricValue = textBox3.Text; //On est dans le cas ou c'est good
}
//if (MetricID == default)
//{
// MetricID = "";
//}
if (DeviceID == default)
{
//DeviceID = GetRandomMacAddress();
var random = new Random();
DeviceID = (1 + random.Next(100)).ToString();
}
else if (MetricValue == default)
{
var random = new Random();
MetricValue = (1 + random.Next()).ToString();
}
else if (DateStart == default)
{
DateStart = DateTime.Now;
string formatForMySql = DateStart.ToString("yyyy-MM-dd HH:mm:ss");
}
else if (DateEnd == default)
{
DateEnd = DateTime.Now;
string formatForMySql = DateEnd.ToString("yyyy-MM-dd HH:mm:ss");
}
if (DeviceID == default && MetricValue == default)
{
}
DAL.PostCalculatedMetrics(DeviceID, MetricValue, DateStart, DateEnd, 0);
}
public string exportAsICS(Models.Event ev)
{
DateStart = ev.Begin;
DateEnd = ev.End;
Organizer = ev.Assoc;
Summary = ev.Name;
Description = ev.Description;
Location = "FIXME";
try
{
object email = Database.Database.database.RequestObject("f_email", ev.Owner);
OrganizerEmail = (string)email;
}
catch (Exception) { }
//create a new stringbuilder instance
StringBuilder sb = new StringBuilder();
//start the calendar item
sb.AppendLine("BEGIN:VCALENDAR");
sb.AppendLine("VERSION:2.0");
sb.AppendLine("PRODID:BilleterieEPITA");
sb.AppendLine("BEGIN:VEVENT");
sb.AppendLine("DTSTART;TZID=Europe/Paris:" + DateStart.ToString("yyyyMMddTHHmm00"));
sb.AppendLine("DTEND;TZID=Europe/Paris:" + DateEnd.ToString("yyyyMMddTHHmm00"));
sb.AppendLine("ORGANIZER:CN=" + Organizer + ":MAILTO:" + OrganizerEmail);
sb.AppendLine("SUMMARY:" + Summary);
sb.AppendLine("LOCATION:" + Location);
sb.AppendLine("DESCRIPTION:" + Description);
//CATEGORIES: Catégorie de l'événement (ex: Conférence, Fête...)
//STATUS: Statut de l'événement (TENTATIVE, CONFIRMED, CANCELLED)
//TRANSP: Définit si la ressource affectée à l'événement est rendu indisponible (OPAQUE, TRANSPARENT)
//SEQUENCE: Nombre de mises à jour, la première mise à jour est à 1
sb.AppendLine("PRIORITY:" + Priority.ToString());
sb.AppendLine("END:VEVENT");
sb.AppendLine("END:VCALENDAR");
//create a string from the stringbuilder
string CalendarItem = sb.ToString();
return(CalendarItem);
}
public override string ToString()
{
string drome = "";
foreach (var item in SelectedAutodromes)
{
drome += item.CodeName + "\n";
}
if (SelectedAutodromes.Count < 1)
{
drome = "Все";
}
return($"Дата начала {DateStart.ToString("dd.MM")}\nДата конца {DateEnd.ToString("dd.MM")}\n" +
$"Время старта занятия больше чем {string.Format("{0:00}:{1:00}:{2:00}",TimeStart.Hours,TimeStart.Minutes,TimeStart.Seconds)}\nВыбранные площадки \"{drome}\"\n" +
$"Искомая фамилия учителя \"{TeacherLast}\"");
}
public void ReadData()
{
Logger.info(String.Format("Чтение данных за {0} по объекту ", DateStart.ToString("dd.MM.yyyy")));
foreach (KeyValuePair <string, string> de in Names)
{
try {
SqlConnection con = getConnection();
con.Open();
string comSTR = "";
comSTR = String.Format("SELECT DATA_DATE,VALUE0, SEASON FROM DATA WHERE OBJECT={0} AND OBJTYPE={1} AND ITEM={2} AND PARNUMBER=12 AND DATA_DATE>'{3}' AND DATA_DATE<='{4}'",
Data[de.Key].Source.Obj, Data[de.Key].Source.ObjType, Data[de.Key].Source.Item, DateStart.ToString(DateFormat), DateEnd.ToString(DateFormat));
SqlCommand command = new SqlCommand(comSTR, con);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
//Object dt=
DateTime date = reader.GetDateTime(0);
double val = reader.GetDouble(1);
int season = reader.GetInt32(2);
if (season >= CurrentSeason)
{
CurrentSeason = season;
}
try {
Data[de.Key].Values[date] = String.Format("{0:0.##}", val).Replace(",", ".");
} catch { }
}
reader.Close();
con.Close();
} catch (Exception e) {
Logger.info("Ошибка при данных" + e.ToString());
}
}
}
GetHashCode()
{
return((DateStart.ToString() + DateEnd.ToString() + Salary.ToString()).GetHashCode());
}
public override string ToString()
{
return($"{DateStart.ToString("dd MMM yyyy")} - {DateEnd.ToString("dd MMM yyyy")}. {Comment}");
}
