/// <summary>
/// Отчет за выбранный период
/// </summary>
private async void GetLanding()
{
_setLoading(true);
_showReport = "none;";
_buttonState = false;
await Task.Delay(100);
DateTime shiftTime;
string template = "{0}-{1}-{2} {3}:{4}:{5}.{6}";
if (_shiftNumber == "1")
{
string begTmp = String.Format(template, _timeBegin.Day, _timeBegin.Month, _timeBegin.Year, "08", "00", "00", "000");
shiftTime = DateTime.Parse(begTmp);
}
else
{
string begTmp = String.Format(template, _timeBegin.Day, _timeBegin.Month, _timeBegin.Year, "20", "00", "00", "000");
shiftTime = DateTime.Parse(begTmp);
}
_shiftData = _shift.GetShiftByDate(shiftTime);
_landed = _reports.GetLandingOrder(_shiftData.StartTime, _shiftData.FinishTime);
_showReport = "block";
_buttonState = true;
_setLoading(false);
StateHasChanged();
}
/// <summary>
/// Get a DTO with distinct Tasks, Dates, Starttimes, Endtimes and number of participantsrequired, based on a projectId
/// </summary>
/// <param name="projectId"></param>
/// <returns>DTO with distinct attributes</returns>
public async Task <ShiftData> GetUniqueDataAsync(Guid projectId)
{
if (projectId == Guid.Empty)
{
throw new ArgumentNullException(nameof(projectId));
}
ShiftData data = new ShiftData();
var q = EntitySet
.AsNoTracking()
.Include(s => s.Task)
.Where(s => s.ProjectId == projectId);
data.Tasks = await q.Select(s => s.Task).Distinct().ToListAsync();
data.Dates = await q.Select(s => s.Date).Distinct().ToListAsync();
data.StartTimes = await q.Select(s => s.StartTime.ToString("hh\\:mm")).Distinct().ToListAsync();
data.EndTimes = await q.Select(s => s.EndTime.ToString("hh\\:mm")).Distinct().ToListAsync();
data.ParticipantsRequired = await q.Select(s => s.ParticipantsRequired).Distinct().ToListAsync();
return(data);
}
/// <summary>
/// Отчет за выбранный период
/// </summary>
private async void GetMelts()
{
_setLoading(true);
_showReport = "none;";
_buttonState = false;
_downloadable = "none;";
await Task.Delay(100);
DateTime shiftTime;
string template = "{0}-{1}-{2} {3}:{4}:{5}.{6}";
if (_shiftNumber == "1")
{
string begTmp = String.Format(template, _timeBegin.Day, _timeBegin.Month, _timeBegin.Year, "08", "00", "00", "000");
shiftTime = DateTime.Parse(begTmp);
}
else
{
string begTmp = String.Format(template, _timeBegin.Day, _timeBegin.Month, _timeBegin.Year, "20", "00", "00", "000");
shiftTime = DateTime.Parse(begTmp);
}
_shiftData = _shift.GetShiftByDate(shiftTime);
_shiftReportData = _reports.GetShiftReports(_shiftData);
string fileName = _excel.GetShiftDetailReport(_shiftReportData, _webRootPath);
_url = fileName;
_downloadable = "inline;";
_showReport = "block";
_buttonState = true;
_setLoading(false);
StateHasChanged();
}
public ShiftData(ShiftData data)
{
Name = data.Name;
StartTime = data.StartTime;
EndTime = data.EndTime;
ModifiedDate = data.ModifiedDate;
Uid = data.Uid;
}
protected override void LazySet()
{
base.LazySet();
if (PersistenceState == PersistenceState.NewAndChanged || PersistenceState == PersistenceState.LoadedAndChanged)
{
if ((object)InnerData == (object)OriginalData)
{
OriginalData = new ShiftData(InnerData);
}
}
}
public async Task GetUniqueDataAsync_Should_Include_Related_Data_And_Filter_References()
{
//Arrange
Guid projectId = Guid.Parse("e86bb765-27ab-404f-b140-211505d869fe");
//Act
ShiftData data = await shiftRepositoryTestMock.Object.GetUniqueDataAsync(projectId);
//Assert
Assert.NotNull(data);
Assert.NotEmpty(data.Tasks);
}
/// <summary>
/// Сформировать отчет по текущей смене
/// </summary>
private async void GetReportCurrentShift()
{
_setLoading(true);
_meltsList = new List <MeltsForPeriod>();
await Task.Delay(100);
// Получить данные по текущей смене
Shift shift = new Shift();
ShiftData currentShift = shift.GetCurrentShift();
_meltsList = _reports.GetMeltsByShift(currentShift.StartTime, currentShift.FinishTime);
_showReport = "block";
_setLoading(false);
StateHasChanged();
}
/// <summary>
/// Сформировать список простоев за текущую смену
/// </summary>
private async void GetCurrentShift()
{
_setLoading(true);
_downTimes = new List <DownTime>();
await Task.Delay(100);
Shift shift = new Shift();
ShiftData current = shift.GetCurrentShift();
_downTimes = _reports.GetDowntimesByShift(current.StartTime, current.FinishTime);
_showReport = "block";
_setLoading(false);
StateHasChanged();
}
/// <summary>
/// Сформировать список простоев за предыдущую смену
/// </summary>
private async void GetPrevShift()
{
_setLoading(true);
_downTimes = new List <DownTime>();
await Task.Delay(100);
Shift shift = new Shift();
ShiftData previous = shift.GetPreviousShift();
_downTimes = _reports.GetDowntimesByShift(previous.StartTime, previous.FinishTime);
_showReport = "block";
_setLoading(false);
StateHasChanged();
}
public async Task GetUniqueDataAsync_Should_Throw_Exception_When_Id_EMPTYGUIDS()
{
//Arrange
Guid projectId = Guid.NewGuid();
//Act
ShiftData data = await shiftRepositoryTestMock.Object.GetUniqueDataAsync(projectId);
//Assert
Assert.NotNull(data);
Assert.Empty(data.Tasks);
Assert.Empty(data.Dates);
Assert.Empty(data.StartTimes);
Assert.Empty(data.EndTimes);
Assert.Empty(data.ParticipantsRequired);
}
/// <summary>
/// Формирование отчета за предыдущую смену
/// </summary>
private async void GetReportByPreviousShift()
{
_setLoading(true);
_reportList = new List <ShiftReport>();
await Task.Delay(100);
ShiftData previous = _shift.GetPreviousShift();
_meltInfo.StartDate = previous.StartTime;
_meltInfo.FinishDate = previous.FinishTime;
_reportList = _reports.GetShiftsReport(previous.StartTime, previous.FinishTime);
_showReport = "block";
_setLoading(false);
StateHasChanged();
}
/// <summary>
/// Формирование отчета за текущую смены
/// </summary>
private async void GetReportByCurrentShift()
{
_setLoading(true);
_reportList = new List <ShiftReport>();
await Task.Delay(100);
ShiftData current = _shift.GetCurrentShift();
_meltInfo.StartDate = current.StartTime;
_meltInfo.FinishDate = current.FinishTime;
_reportList = _reports.GetShiftsReport(current.StartTime, current.FinishTime);
_showReport = "block";
_setLoading(false);
StateHasChanged();
}
/// <summary>
/// Отчет за предыдущую смену
/// </summary>
private async void GetPrevShift()
{
_setLoading(true);
_landed = new List <LandingData>();
await Task.Delay(100);
// Получить данные по предыдущей смене
Shift shift = new Shift();
ShiftData previousShift = shift.GetPreviousShift();
_landed = _reports.GetShiftProductionReportByPeriod(previousShift.StartTime, previousShift.FinishTime);
_showReport = "block";
_setLoading(false);
StateHasChanged();
}
/// <summary>
/// Отчет за предыдущую смену
/// </summary>
private async void GetPrevShift()
{
_setLoading(true);
_showReport = "none;";
_buttonState = false;
await Task.Delay(100);
// Получить данные по предыдущей смене
_shiftData = _shift.GetPreviousShift();
_landed = _reports.GetLandingOrder(_shiftData.StartTime, _shiftData.FinishTime);
_showReport = "block";
_buttonState = true;
_setLoading(false);
StateHasChanged();
}
public void TestBlock()
{
BlockData b = BlockData.MakeBlockData(10, 7);
Debug.Log(b.index);
Debug.Log(b.light);
b.index = 12;
Debug.Log(b.index);
b.light = 4;
Debug.Log(b.light);
ShiftData s = 10;
Debug.Log(s.maxHeight);
s.maxHeight = 13;
Debug.Log(s.maxHeight);
}
public async Task GetUniqueDataAsync_Should_Return_Correct_Entities()
{
//Arrange
Guid projectId = Guid.Parse("e86bb765-27ab-404f-b140-211505d869fe");
//Act
ShiftData data = await shiftRepositoryTestMock.Object.GetUniqueDataAsync(projectId);
//Assert
Assert.NotNull(data);
Assert.NotEmpty(data.Tasks);
Assert.NotEmpty(data.Dates);
Assert.NotEmpty(data.StartTimes);
Assert.NotEmpty(data.EndTimes);
Assert.NotEmpty(data.ParticipantsRequired);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Dictionary <string, object> param = new Dictionary <string, object>();
if (Request.Params["id"] == null)
{
Response.Redirect("~/");
}
int id = Int32.Parse(Request.Params["id"]);
param.Add("Employees.ID_employee", id);
HiddenField1.Value = id.ToString();
empl = EmployeeData.getEmployees(param);
Label1.Text = empl[0].First_name + " " + empl[0].Last_name;
DatabaseTable <Shifts> shif = ShiftData.getShifts(null);
RadioButtonList1.DataValueField = "ID_shift";
RadioButtonList1.DataTextField = "Name_of_shift";
RadioButtonList1.DataSource = shif;
RadioButtonList1.DataBind();
}
}
/// <summary>
/// Сформировать отчет за период
/// </summary>
private async void GetReportByPeriod()
{
_setLoading(true);
_meltsList = new List <MeltsForPeriod>();
await Task.Delay(100);
DateTime rangeStart = _meltsPeriod.PeriodStart.AddDays(-1);
DateTime rangeFinish = _meltsPeriod.PeriodFinish;
string timeStart = $"{rangeStart.Day}-{rangeStart.Month}-{rangeStart.Year} 20:00:00.000";
string timeFinish = $"{rangeFinish.Day}-{rangeFinish.Month}-{rangeFinish.Year} 20:00:00.000";
DateTime periodStart = DateTime.Parse(timeStart);
DateTime periodFinish = DateTime.Parse(timeFinish);
// Получение данных по смене
Shift shift = new Shift();
ShiftData shiftData = shift.GetShiftByDate(periodStart);
_meltsList = new List <MeltsForPeriod>();
while (shiftData.FinishTime <= periodFinish)
{
List <MeltsForPeriod> melts = _reports.GetMeltsByShift(shiftData.StartTime, shiftData.FinishTime);
foreach (MeltsForPeriod melt in melts)
{
_meltsList.Add(melt);
}
if (shiftData.FinishTime != periodFinish && melts.Count > 0)
{
_meltsList.Add(new MeltsForPeriod());
}
shiftData = shift.GetShiftByDate(shiftData.StartTime.AddHours(12));
}
_showReport = "block";
_setLoading(false);
StateHasChanged();
}
/// <summary>
/// Отчет за предыдущую смену
/// </summary>
private async void GetPrevShift()
{
_setLoading(true);
_showReport = "none;";
_buttonState = false;
_downloadable = "none;";
await Task.Delay(100);
// Получить данные по предыдущей смене
_shiftData = _shift.GetPreviousShift();
_shiftReportData = _reports.GetShiftReports(_shiftData);
ExcelReportGenerator excel = new ExcelReportGenerator();
string fileName = excel.GetShiftDetailReport(_shiftReportData, _webRootPath);
_url = fileName;
_downloadable = "inline;";
_showReport = "block";
_buttonState = true;
_setLoading(false);
StateHasChanged();
}
public Shift From(ShiftData data) => Shift.From(data);
public Shift(ShiftData data)
{
this.data = data;
}
public void SetShiftData(int x, int z, ShiftData data)
{
shiftData[GetShiftIndex(x, z)] = data;
}
internal static Shift From(ShiftData data) => data == null ? null : new Shift(data);
