public int AddNewRequest(int factoryId, int workUnitId, int workSectionId, DateTime requestDate,
int workerId, string requestNote)
{
var newDr = TechnologyProblemsTable.NewRow();
newDr["GlobalID"] = "0200000";
newDr["FactoryID"] = factoryId;
newDr["WorkUnitID"] = workUnitId;
newDr["WorkSectionID"] = workSectionId;
newDr["RequestDate"] = requestDate;
newDr["RequestWorkerID"] = workerId;
newDr["RequestNotes"] = requestNote;
newDr["RequestClose"] = false;
newDr["Enable"] = true;
TechnologyProblemsTable.Rows.Add(newDr);
UpdateTechnologyProblems();
var techProblemId = GetTechnologyProblemId(workSectionId, workerId, requestDate);
if (techProblemId != -1)
{
newDr["TechnologyProblemID"] = techProblemId;
newDr.AcceptChanges();
newDr["GlobalID"] = "02" + techProblemId.ToString("00000");
UpdateTechnologyProblems();
}
return(techProblemId);
}
private IEnumerable <long> GetTechnologyProblemIds()
{
var ids = from technologyProblemsView in TechnologyProblemsTable.AsEnumerable()
select technologyProblemsView.Field <Int64>("TechnologyProblemID");
return(ids.ToList());
}
public void ChangeReceivedNotes(int techProblemId, string receivedNotes)
{
var rows = TechnologyProblemsTable.Select("TechnologyProblemID = " + techProblemId);
if (!rows.Any())
{
return;
}
var techProblemRow = rows.First();
techProblemRow["ReceivedNotes"] = receivedNotes;
UpdateTechnologyProblems();
}
public void DeleteTechnologyProblem(int techProblemId)
{
var rows = TechnologyProblemsTable.Select("TechnologyProblemID = " + techProblemId);
if (!rows.Any())
{
return;
}
var deletingRow = rows.First();
deletingRow["Enable"] = false;
UpdateTechnologyProblems();
}
public void FillReceivedInfo(int techProblemId, DateTime receivedDate, int receivedWorkerId, string receivedNote)
{
var rows = TechnologyProblemsTable.Select("TechnologyProblemID = " + techProblemId);
if (!rows.Any())
{
return;
}
var receivedRow = rows.First();
receivedRow["ReceivedDate"] = receivedDate;
receivedRow["ReceivedWorkerID"] = receivedWorkerId;
receivedRow["ReceivedNotes"] = receivedNote;
UpdateTechnologyProblems();
}
public void FillPlannedCompletionDate(int techProblemId, object plannedCompleteDate, DateTime editingDate,
int editingWorkerId)
{
var rows = TechnologyProblemsTable.Select("TechnologyProblemID = " + techProblemId);
if (!rows.Any())
{
return;
}
var additionalRow = rows.First();
additionalRow["PlanedCompletionDate"] = plannedCompleteDate;
additionalRow["EditingDate"] = editingDate;
additionalRow["EditingWorkerID"] = editingWorkerId;
UpdateTechnologyProblems();
}
public void FillCompletionInfo(string globalId, DateTime completionDate, int completionWorkerId)
{
var rows = TechnologyProblemsTable.Select("GlobalID = " + globalId);
if (!rows.Any())
{
CompleteRequest(globalId, completionDate, completionWorkerId);
return;
}
var completionRow = rows.First();
completionRow["CompletionDate"] = completionDate;
completionRow["CompletionWorkerID"] = completionWorkerId;
UpdateTechnologyProblems();
}
public void CompleteRequest(int techProblemId, DateTime completionDate, int completionWorkerId,
string completionNote)
{
var rows = TechnologyProblemsTable.Select("TechnologyProblemID = " + techProblemId);
if (!rows.Any())
{
return;
}
var completionRow = rows.First();
completionRow["CompletionDate"] = completionDate;
completionRow["CompletionWorkerID"] = completionWorkerId;
completionRow["CompletionNotes"] = completionNote;
completionRow["RequestClose"] = true;
UpdateTechnologyProblems();
}
