public static string UploadXMLFile(string type, FinalReport report)
{
var nameFile =
SteamFriends.GetPersonaName() + "." + SteamUser.GetSteamID() +
"_" + DateTime.Now.ToString("yy.MM.dd") +
"_" + DateTime.Now.ToString("HH.mm.ss") +
"_" + type + ".zip";
var path = Application.dataPath + "/" + nameFile;
Debug.Log(path);
//write xml file
DataContainer DataCollection = new DataContainer();
DataCollection.FinalReport = report;
DataCollection.Save(path);
//
if (SteamUser.GetSteamID().m_SteamID == 76561198245800476 ||
SteamUser.GetSteamID().m_SteamID == 76561197970401438)
{
Debug.Log("Update XML Stopped");
return(path);
}
LogUploader.UploadDirectToAWSCarlos(path);
return(path);
}
public ActionResult Generate()
{
Filter_Emp fe = new Filter_Emp(db.Employees.ToList(), db.WorkingDays.ToList());
Filter_Emp fetmp = new Filter_Emp();
List <WorkDay> myWorkSchedule = new List <WorkDay>();
List <WorkDay> final = new List <WorkDay>();
int min = 9;
fr = new FinalReport();
for (int a = 0; a < 20; a++)
{
db = new EmployeeContext();
myWorkSchedule = new List <WorkDay>();
fe = new Filter_Emp(db.Employees.ToList(), db.WorkingDays.ToList());
myWorkSchedule = fe.autoArrange();
if (min > fe.message.Count)
{
fetmp = fe;
min = fe.message.Count;
final = myWorkSchedule;
}
if (fe.signal == true)
{
final = myWorkSchedule;
break;
}
}
final.Reverse();
fr.fe = fetmp;
fr.myWorkSchedule = final;
return(View(fr));
}
public async Task ReportGenerationByMonth()
{
var MockInfo = new Mock <IStore>();
var reports = Task.Run(() => GetList());
MockInfo.Setup(fun => fun.GenerateReports("2000-1-01 00:00:00", "2000-1-31 23:59:59")).Returns(reports);
IFinalReport finalReport = new FinalReport(MockInfo.Object);
var reportsList = await finalReport.GenerateReportByMonthAndYear("january", 2000);
Assert.Equal("111", reportsList[0].EmployeeId);
}
public FinalReport Get(int id)
{
var result = new FinalReport();
try {
result = context.FinalReports.Single(x => x.Id == id);
}catch (System.Exception)
{
throw;
}
return(result);
}
public static string WriteXMLFinalReport(FinalReport report)
{
DataContainer DataCollection = new DataContainer();
DataCollection.FinalReport = report;
var root = Path.Combine(Application.dataPath, "Final.txt");
DataCollection.Save(root);
return(root);
}
public bool Save(FinalReport entity)
{
try
{
context.Add(entity);
context.SaveChanges();
}
catch (System.Exception)
{
return(false);
}
return(true);
}
public async Task ReportGenerationByStartToEnd()
{
var MockInfo = new Mock <IStore>();
var reports = Task.Run(() => GetList());
MockInfo.Setup(fun => fun.GenerateReports("2000-1-01 00:00:00", "2000-1-31 23:59:59")).Returns(reports);
IFinalReport finalReport = new FinalReport(MockInfo.Object);
var reportsList = await finalReport.GenerateReport("2000-1-01", "2000-1-31");
Assert.Equal("naveen bora", reportsList[0].FullName);
}
/// <summary>
/// This method creates worksheet and writes all date at first cell.
/// </summary>
/// <param name="filePath">Path to xlsx file.</param>
/// <param name="report">Peport DTO.</param>
public void Write(string filePath, FinalReport report)
{
var pathWithExtension = Path.ChangeExtension(filePath, Extension);
var file = new FileInfo(pathWithExtension);
using ExcelPackage excelPackage = new ExcelPackage(file);
var count = excelPackage.Workbook.Worksheets.Count + 1;
var worksheet = excelPackage.Workbook.Worksheets.Add(string.Format(WorksheetName, count));
worksheet.Cells[StudentsResults].LoadFromCollection(report.StudentResults);
worksheet.Cells[ExamResults].LoadFromCollection(report.ExamResults);
worksheet.Cells[Average].Value = report.Average;
excelPackage.Save();
}
/// <summary>
/// Writes collections to json file.
/// </summary>
/// <param name="filePath">Path to file.</param>
/// <param name="report">Peport DTO.</param>
public void Write(string filePath, FinalReport report)
{
var options = new JsonSerializerOptions
{
Encoder = JavaScriptEncoder.UnsafeRelaxedJsonEscaping,
};
var result = JsonSerializer.Serialize(report, options);
var pathWithExtension = Path.ChangeExtension(filePath, Extension);
using var writer = new StreamWriter(pathWithExtension, false, Encoding.UTF8);
writer.WriteLine(result);
}
public bool Delete(int id)
{
try
{
var result = new FinalReport();
result = context.FinalReports.Single(x => x.Id == id);
context.Remove(result);
context.SaveChanges();
return(true);
}
catch (System.Exception)
{
throw;
}
}
public bool Update(FinalReport entity)
{
try{
var newFinalReport = context.FinalReports.Single(x => x.Id == entity.Id);
newFinalReport.Id = entity.Id;
newFinalReport.Description = entity.Description;
newFinalReport.ReportDate = entity.ReportDate;
context.Update(newFinalReport);
context.SaveChanges();
}
catch (System.Exception)
{
return(true);
}
return(false);
}
private void SaveFile(bool Combined = false)
{
Stream stream;
SaveFileDialog SaveFile = new SaveFileDialog
{
Title = "Сохранить отчет",
InitialDirectory = @"C:\",
Filter = "Таблица Excel (*.xlsx)|*.xlsx",
FilterIndex = 0,
RestoreDirectory = true
};
if (SaveFile.ShowDialog() == DialogResult.OK)
{
try
{
if ((stream = SaveFile.OpenFile()) != null)
{
{
if (Combined)
{
TimerSettings.Competition = TimerSettings.Container.Competition;
LoadReports();
}
byte[] b = FinalReport.Generate(Reports);
stream.Write(b);
stream.Close();
}
}
}
catch (Exception ED)
{
MessageBox.Show("Невозможно получть доступ к файлу, возможно он занят другим приложением. Ошибка: " + ED.Message + " Стек вызовов: " + ED.StackTrace);
}
}
Close();
}
public static void Start()
{
_finalReport = new FinalReport();
}
public void Process(string[] args)
{
var logger = Log4Net.Log;
Log4Net.InitLogger();
string inputPath = string.Empty, outputPath = string.Empty;
FileMode mode = FileMode.Json;
Parser.Default.ParseArguments <Options>(args)
.WithParsed(o =>
{
inputPath = o.InputFile;
outputPath = o.OutputFile;
mode = o.Mode;
});
var students = new List <Student>();
try
{
students = (List <Student>)Services.CsvReader.Read(inputPath);
}
catch (FormatException e)
{
logger.Error(e.Message);
return;
}
catch (ArgumentException e)
{
logger.Error(e.Message);
return;
}
catch (ReaderException e)
{
logger.Error(e.Message);
return;
}
catch (TypeConverterException e)
{
logger.Error(e.Message);
return;
}
catch (System.IO.FileNotFoundException e)
{
logger.Error(e.Message);
return;
}
var finalReport = new FinalReport
{
StudentResults = students.GetStudentsResult(),
ExamResults = students.GetExamResults(),
Average = students.GetGroupAverage(),
};
switch (mode)
{
case FileMode.Json:
var jsonWriter = new JsonWriter();
jsonWriter.Write(outputPath, finalReport);
break;
case FileMode.Excel:
var excelWriter = new ExcelWriter();
excelWriter.Write(outputPath, finalReport);
break;
default:
break;
}
}
public ActionResult Put([FromBody] FinalReport finalReport)
{
return(Ok(
finalReportService.Update(finalReport)
));
}
public ActionResult Post([FromBody] FinalReport finalReport)
{
return(Ok(
finalReportService.Save(finalReport)
));
}
// GET: Reports
public ActionResult ReportView(FinalReport model)
{
var reports = Session["Reports"] as FinalReport;
return(View(reports));
}
public bool Update(FinalReport entity)
{
return(this.finalReportRepository.Update(entity));
}
public bool Save(FinalReport entity)
{
return(this.finalReportRepository.Save(entity));
}
public bool Update(FinalReport entity)
{
throw new System.NotImplementedException();
}
private void ReportForm_Load(object sender, EventArgs e)
{
{
using (SqlConnection con = new SqlConnection(cs))
{
if (label4.Text == "bazar")
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from vw_BazarDetails where BazarDate between @fromdate and @todate", con);
cmd.Parameters.AddWithValue("@fromdate", label1.Text);
cmd.Parameters.AddWithValue("@todate", label2.Text);
//cmd.Parameters.AddWithValue("@name", label3.Text);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("There is no data to show !");
this.Close();
}
else
{
BazarReport Bazar = new BazarReport();
Bazar.SetDataSource(dt);
MainReportViwer.ReportSource = Bazar;
}
}
else if (label4.Text == "meal")
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from vw_MealDetails where MealDate between @fromdate and @todate ", con);
//cmd.Parameters.AddWithValue("@name", label3.Text);
cmd.Parameters.AddWithValue("@fromdate", label1.Text);
cmd.Parameters.AddWithValue("@todate", label2.Text);
//cmd.Parameters.AddWithValue("@name", label3.Text);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("There is no data to show !");
this.Close();
}
else
{
MealReport meal = new MealReport();
meal.SetDataSource(dt);
MainReportViwer.ReportSource = meal;
}
}
else
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from vw_FinalDetails where BazarDate between @fromdate and @todate and FullName=@name", con);
cmd.Parameters.AddWithValue("@name", label3.Text);
cmd.Parameters.AddWithValue("@fromdate", label1.Text);
cmd.Parameters.AddWithValue("@todate", label2.Text);
//cmd.Parameters.AddWithValue("@name", label3.Text);
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
if (dt.Rows.Count == 0)
{
MessageBox.Show("There is no data to show !");
this.Close();
}
else
{
FinalReport final = new FinalReport();
final.SetDataSource(dt);
MainReportViwer.ReportSource = final;
}
}
}
}
//
}
