protected void lbGetAllUsersInfo_Click(object sender, EventArgs e)
{
var dm = new DataManager();
var month = DateTime.Now.Month.ToString();
if (month.Length == 1)
{
month = String.Format("0{0}", month);
}
var date1 = Convert.ToDateTime(String.Format("01-{0}-{1}", month, DateTime.Now.Year)).ToString("yyyy-MM-dd");
var date2 = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
var infoSet = dm.QueryWithReturnDataSet("SELECT " +
"U.`ID` as `UID`, " +
"U.`Family` as `Фамилия`, " +
"U.`Name` as `Имя`, " +
"U.`Phone` as `Телефон`, " +
"U.`Email` as `Емейл`, " +
"U.`Login` as `Логин`, " +
"U.`Status` as `Статус`, " +
"U.`CreateDate` as `Дата регистрации`, " +
"U.`Discount` as `Скидка`, " +
"U.`SpecialClient` as `Особый клиент`, " +
"U.`IsCourse` as `Может выставлять курсы`, " +
"U.`Note` as `Заметка`, " +
"CONCAT(UU.`Family`,\" \", UU.`Name`) as `Ответственный менеджер`, " +
"CONCAT(UUU.`Family`,\" \", UUU.`Name`) as `Ответств. мен. по прод.`, " +
"(SELECT COUNT(*) FROM `tickets` T WHERE T.`UserID` = U.ID AND (T.`CreateDate` BETWEEN '" + date1 + "' AND '" + date2 + "' )) as `Кол-во зявок за календ. месяц` " +
"FROM `users` U " +
"LEFT JOIN `users` UU ON U.`ManagerID` = UU.`ID` " +
"LEFT JOIN `users` UUU ON U.`SalesManagerID` = UUU.`ID` " +
"WHERE U.`Role` = 'User' AND U.`ID` <> 1 AND U.`Status` = 2;");
const string fileName = "полная_информация_клиентов_с_которыми_работаем";
ExportMethods.CreateXlsFile(Response, infoSet, fileName, "users");
}
IGenerateAction ICodeGenerator.InitalizeSelection(CodeGenerationOptions options, TreeView treeView)
{
var exportMethods = new ExportMethods(this, options);
exportMethods.Initialize(treeView);
return(exportMethods);
}
protected void lbGetAllUsersProfilesInfo_Click(object sender, EventArgs e)
{
var dm = new DataManager();
var infoSet = dm.QueryWithReturnDataSet("SELECT " +
"P.`ID` as `PID`, " +
"P.`UserID` as `UID`, " +
"CONCAT(U.`Family`, \" \", U.`Name`) as `Клиент`, " +
"P.`FirstName` as `Фамилия`, " +
"P.`LastName` as `Имя`, " +
"P.`ThirdName` as `Отчество`, " +
"P.`ContactPhoneNumbers` as `Контактный телефон`, " +
"P.`ContactPersonFIO` as `Контактное лицо`, " +
"P.`TypeID` as `Тип профиля` , " +
"P.`StatusID` as `Статус`, " +
"P.`RejectBlockedMessage` as `Расшифровка статуса` , " +
"CONCAT(P.`PassportSeria`,\" \", P.`PassportNumber`) as `Серия и номер паспорта`, " +
"P.`PassportData` as `Выда кем`," +
"P.`PassportDate` as `Выдан когда`, " +
"P.`Address` as `Адрес проживания`, " +
"P.`CompanyName` as `Имя компании`, " +
"P.`CompanyAddress` as `Юр. адрес компании`, " +
"P.`PostAddress` as `Контактный адрес компании`," +
"P.`RasShet` as `Расчетный счет`, " +
"P.`UNP` as `УНП`, " +
"P.`BankName` as `Имя банка`, " +
"P.`BankCode` as `Код банка`, " +
"P.`BankAddress` as `Адрес банка`, " +
"P.`CreateDate` as `Дата создания`, " +
"P.`IsDefault` as `Профиль по умолч.` " +
"FROM `usersprofiles` P " +
"LEFT JOIN `users` U ON P.`UserID` = U.`ID` U.`Status` = 2;");
const string fileName = "полная_информация_профилей_клиентов";
ExportMethods.CreateXlsFile(Response, infoSet, fileName, "profiles");
}
protected void btnExport_Click(object sender, EventArgs e)
{
var dm = new DataManager();
GetSearchString();
var infoSet = dm.QueryWithReturnDataSet(SelectToExcelFile);
const string fileName = "касса-рассчет";
ExportMethods.CreateXlsFile(Response, infoSet, fileName, "calculation");
}
public void FixSpacingTest()
{
List <Subject> subjects = new List <Subject>
{
new Subject("MAT4", "Mathematics", "A*", "C"),
new Subject("PHY4", "Physics", "B", "A*"),
new Subject("GEO4", "Geography", "C", "B")
};
Assert.AreEqual("", ExportMethods.FixSpacing(subjects, subjects[0], "name"));
Assert.AreEqual(" ", ExportMethods.FixSpacing(subjects, subjects[1], "actualGrade"));
Assert.AreEqual(" ", ExportMethods.FixSpacing(subjects, subjects[2], "expectedGrade"));
}
/**
* <summary>This method effectively stores student data from the model classes into individual reports.</summary>
*
* <param name="sl">The School object where the data will be retrieved from.</param>
*/
public void StoreReportData(School sl)
{
// IF statement checks the School object supplied as a parameter is not null.
if (sl != null)
{
// Iterates through each AcademicYear object within the School object.
sl.GetYears.ForEach(year =>
{
//Invokes the 'GenerateOutput' method from the ExportMethods utility class.
ExportMethods.GenerateOutput(sl, year);
});
}
}
public static DataTable GetReportTable <T>(this List <T> items, ExportMethods Method) where T : class
{
var result = new DataTable();
result.Columns.Add(RGlobal.TableIndex, typeof(string));
foreach (var p in typeof(T).GetProperties().OrderBy(p => p.GetOrder()))
{
if ((Method == ExportMethods.PDF && p.GetIsExportedToPDF()) ||
(Method == ExportMethods.Excel && p.GetIsExportedToExcel()))
{
result.Columns.Add(p.ToDisplayName(), typeof(string));
}
}
var index = -1;
foreach (var item in items)
{
index++;
var values = new List <string>
{
(index + 1).ToString()
};
foreach (var p in typeof(T).GetProperties().OrderBy(p => p.GetOrder()))
{
if ((Method == ExportMethods.PDF && p.GetIsExportedToPDF()) ||
(Method == ExportMethods.Excel && p.GetIsExportedToExcel()))
{
var v = p.GetValue(item, null);
if (v == null)
{
v = "";
}
values.Add(v.ToString());
}
}
result.Rows.Add(values.ToArray());
}
return(result);
}
static async Task RunSimulationAsync(string csvOutputFile, AppSettings appSettings)
{
SimulatorConfiguration simConfig;
SimulatorEngine simEngine;
IList <SimulatorEmployeeContact> allEmployeeContacts;
SimulatorResult simulatorResult;
try
{
simConfig = await CreateConfiguration(appSettings);
simEngine = new SimulatorEngine(simConfig);
allEmployeeContacts = new List <SimulatorEmployeeContact>();
simulatorResult = new SimulatorResult();
simEngine.InitializeSimulation();
}
catch (Exception exc)
{
LogMessage("ERROR", "Unable to configure and initialize the simulation: " + exc.ToString());
throw exc;
}
try
{
LogMessage("INFO", "Starting simulation.");
do
{
simulatorResult = simEngine.RunNext();
allEmployeeContacts.AddRange(simulatorResult.EmployeeContacts);
}while (!simulatorResult.IsSimulatorComplete && !simulatorResult.HasError);
LogMessage("DEBUG", "Simulation complete. Creating output CSV file.");
await ExportMethods.CreateSimulatorCsvLogAsync(allEmployeeContacts, simConfig.Employees, simConfig.WorkplaceRooms, simConfig.VirusStages, csvOutputFile);
}
catch (Exception exc)
{
LogMessage("ERROR", "Unable to complete simulation: " + exc.ToString());
throw exc;
}
}
public ExportDataFacade()
{
exportMeth = new ExportMethods();
}
IGenerateAction ICodeGenerator.InitalizeSelection (CodeGenerationOptions options, TreeView treeView)
{
var exportMethods = new ExportMethods (this, options);
exportMethods.Initialize (treeView);
return exportMethods;
}
public ExportMethod(Export Cdo, ExportMethods Method, Export_Parameters Parameters)
{
this.Cdo = Cdo;
this.ServiceMethod = Method;
this.Parameters = Parameters;
}
public void GetCurrentTimeTest()
{
Assert.AreEqual("18:22:00", ExportMethods.GetCurrentTime());
}
public void GetCurrentDateTest()
{
Assert.AreEqual("06/01/2020", ExportMethods.GetCurrentDate());
}
public void AddSpacesTest()
{
Assert.AreEqual(" ".Length, ExportMethods.AddSpaces(5).Length);
}
public void OutputFeedbackTest()
{
Assert.AreEqual("Julia Walters is outstanding, as they are exceeding their target grades for all of their subjects!", ExportMethods.OutputFeedback("Julia Walters", 4, 0, 0));
Assert.AreEqual("Julia Walters is performing excellently, as they are exceeding their target grades for the majority of their subjects!", ExportMethods.OutputFeedback("Julia Walters", 3, 1, 0));
Assert.AreEqual("Julia Walters is performing well, as they are exceeding their target grades for some of their subjects!", ExportMethods.OutputFeedback("Julia Walters", 2, 1, 1));
Assert.AreEqual("Gareth Keenan is performing really well, as they are meeting their target grades for all of their subjects!", ExportMethods.OutputFeedback("Gareth Keenan", 0, 9, 0));
Assert.AreEqual("Gareth Keenan is performing well, as they are meeting their target grades for most of their subjects!", ExportMethods.OutputFeedback("Gareth Keenan", 2, 6, 1));
Assert.AreEqual("Gareth Keenan is performing okay, as they are meeting their target grades for some of their subjects!", ExportMethods.OutputFeedback("Gareth Keenan", 2, 4, 3));
Assert.AreEqual("Brent Pritchard is performing adequately, however they could do more to achieve or exceed their target grades for more subjects!", ExportMethods.OutputFeedback("Brent Pritchard", 1, 1, 1));
Assert.AreEqual("Mike Riley is performing horribly, as they are below their target grades for all of their subjects!", ExportMethods.OutputFeedback("Mike Riley", 0, 0, 14));
Assert.AreEqual("Mike Riley is performing very poorly, as they are below their target grades for most of their subjects!", ExportMethods.OutputFeedback("Mike Riley", 2, 4, 8));
Assert.AreEqual("Mike Riley is performing rather poorly, as they are below their target grades for some of their subjects!", ExportMethods.OutputFeedback("Mike Riley", 4, 3, 7));
Assert.AreEqual("Mike Riley is performing a bit poorly, as they are below their target grades for a few of their subjects!", ExportMethods.OutputFeedback("Mike Riley", 5, 3, 6));
}