public string InsertSQL()
{
String sql = "insert into workorder (productorder,type,scheduledate,lenth,width," +
"thickness,gross,done,undone,completedate,machinecode,worker,worth,remark,status,receivedate,grosswidth) " +
"values ('{0}','{1}','{2}',{3},{4},{5},{6},{7},{8},'{9}','{10}','{11}',{12},'{13}',{14},'{15}',{16})";
return(String.Format(sql, ProductOrder, Type, ScheduleDate.ToString("yyyy-MM-dd"), Length.ToString(), Width.ToString(),
Thickness.ToString(), Gross.ToString(), Done.ToString(), Undo.ToString(), CompleteDate.ToString("yyyy-MM-dd"),
MachineCode, Worker, Worth.ToString(), Remark, Status.ToString(), ReceiveDate.ToString("yyyy-MM-dd HH:mm:ss"), GrossWidth.ToString()));
}
public string UndateSQL()
{
String sql = "update workorder set productorder = '{0}',type = '{1}',scheduledate='{2}',lenth={3},width = {4}," +
"thickness={5},gross={6},done={7},undone={8},completedate='{9}',machinecode='{10}',worker='{11}'," +
"worth={12},remark='{13}',status={14} ,receivedate = '{15}',grosswidth = {16} where id = {17} ";
return(String.Format(sql, ProductOrder, Type, ScheduleDate.ToString("yyyy-MM-dd"), Length.ToString(), Width.ToString(),
Thickness.ToString(), Gross.ToString(), Done.ToString(), Undo.ToString(), CompleteDate.ToString("yyyy-MM-dd"),
MachineCode, Worker, Worth.ToString(), Remark, Status.ToString(), ReceiveDate.ToString("yyyy-MM-dd HH:mm:ss"),
GrossWidth.ToString(), id.ToString()));
}
} // Fill
public override string ToString()
{
return(string.Format(
"LoanID: {0}, Schedule: {1} at {2}, Transaction: {3} at {4}, Delay: {5}",
LoanID,
ScheduleID,
ScheduleDate.ToString("d/MMM/yyyy H:mm:ss", CultureInfo.InvariantCulture),
TransactionID,
TransactionTime.ToString("d/MMM/yyyy H:mm:ss", CultureInfo.InvariantCulture),
Delay
));
} // ToString
protected async void SelectCallback(PatientUI p)
{
Scheduler.patient = p;
Scheduler.MRN = p.MRN;
Scheduler.ScheduleTime = ScheduleDate.ToString();
Console.WriteLine(Scheduler.patient.Firstname);
Console.WriteLine(Scheduler.MRN);
Console.WriteLine(Scheduler.ScheduleTime);
//We need to save the schedule here to the database
await ScheduleService.Update(Scheduler);
StateHasChanged();
}
public override async System.Threading.Tasks.Task ExecuteLoadSchedulesCommand()
{
if (IsBusy)
{
return;
}
if (!IsRefreshing)
{
IsBusy = true;
}
try
{
if (!Users.Any())
{
var lookups = await DataService.GetLookups(1000);
lookups.Users.ForEach(u => Users.Add(u));
}
ScheduleDateFormatted = ScheduleDate.ToShortDateString();
OnPropertyChanged("ScheduleDateFormatted");
Schedules.Clear();
var items = await DataService.GetItemsAsync <Schedule>($"schedules?start={ScheduleDate.ToString("MM-dd-yyyy")}&end={ScheduleDate.ToString("MM-dd-yyyy")}{(CanManageSchedule ? "" : "&assigned=true")}");
NoSchedules = !items.Data.Any();
OnPropertyChanged("NoSchedules");
this.WeekUnpublished = false;
foreach (var item in items.Data.OrderBy(d => d.User == null ? "zzzzzz" : d.User.FirstName))
{
if (item.UserId != null && !item.PublishedValue)
{
this.WeekUnpublished = true;
}
var displayItem = new DisplayItem();
scheduleToDisplayItem(displayItem, item);
Schedules.Add(displayItem);
}
}
catch (Exception ex)
{
IsBusy = false;
IsRefreshing = false;
ExceptionHelper.ShowException(ex);
}
finally
{
IsBusy = false;
IsRefreshing = false;
}
}
public override async System.Threading.Tasks.Task ExecuteLoadSchedulesCommand()
{
await runTask(async() =>
{
if (!Users.Any())
{
Users.Add(new User()
{
FirstName = "(All)", UserId = _allGuid
});
Users.Add(new User()
{
FirstName = "(Unassigned)", UserId = _unassignedGuid
});
Users.Add(new User()
{
FirstName = "(Assigned)", UserId = _assignedGuid
});
var lookups = await DataService.GetLookups(4);
lookups.Users.ForEach(u => Users.Add(u));
Shifts.Add(new Shift()
{
ShiftName = "(All)", ShiftId = _allGuid
});
lookups.Shifts.ForEach(s => Shifts.Add(s));
Tasks.Add(new Task()
{
TaskName = "(All)", TaskId = _allGuid
});
lookups.Tasks.ForEach(t => Tasks.Add(t));
}
Schedules.Clear();
var items = await DataService.GetItemsAsync <Schedule>($"schedules?start={ScheduleDate.ToString("MM-dd-yyyy")}&end={ScheduleDate.AddDays(6).ToString("MM-dd-yyyy")}");
NoSchedules = !items.Data.Any();
this.WeekUnpublished = false;
foreach (var item in items.Data.OrderBy(d => d.ScheduleDateValue).ThenBy(d => d.StartTimeValue).ThenBy(d => d.User == null ? "aaaaaaa" : d.User.FirstName))
{
if (item.UserId != null && !item.PublishedValue)
{
this.WeekUnpublished = true;
}
_weekSchedules = items.Data;
if (SelectedUser != null && SelectedUser.UserIdValue != _allGuid)
{
if (SelectedUser.UserIdValue == _unassignedGuid && item.User != null)
{
continue;
}
if (SelectedUser.UserIdValue == _assignedGuid && item.User == null)
{
continue;
}
if (SelectedUser.UserIdValue != _assignedGuid && SelectedUser.UserIdValue != _unassignedGuid && SelectedUser.UserIdValue != item.UserIdValue)
{
continue;
}
}
if (SelectedShift != null && SelectedShift.ShiftIdValue != _allGuid && SelectedShift.ShiftIdValue != item.ShiftIdValue)
{
continue;
}
if (SelectedTask != null && SelectedTask.TaskIdValue != _allGuid && SelectedTask.TaskIdValue != item.TaskIdValue)
{
continue;
}
var displayItem = new DisplayItem();
scheduleToDisplayItem(displayItem, item);
Schedules.Add(displayItem);
}
OnPropertyChanged("WeekUnpublished");
return(items);
});
OnPropertyChanged("NoSchedules");
}