void FillListStatuses()
{
listBox1.DataSource =
RequestStatusDB.GetInstance().
GetRequestStatuses();
listBox1.DisplayMember = "Name";
}
public static RequestStatusDB GetInstance()
{
if (instance == null)
{
instance = new RequestStatusDB();
}
return(instance);
}
private static void Application_ApplicationExit(
object sender, EventArgs e)
{
ClientDB.GetInstance().Save();
WorkerDB.GetInstance().Save();
RequestDB.GetInstance().Save();
RequestStatusDB.GetInstance().Save();
}
void FillFilters()
{
comboBox2.DataSource = RequestStatusDB.GetInstance().GetRequestStatuses();
comboBox2.DisplayMember = "Name";
comboBox1.DataSource = typeof(RequestPriority).GetEnumValues();
comboBox3.DataSource = WorkerDB.GetInstance().GetWorkers();
comboBox3.DisplayMember = "LastName";
comboBox4.DataSource = ClientDB.GetInstance().GetClients();
comboBox4.DisplayMember = "LastName";
}
public FormRequestEdit(Request request)
{
InitializeComponent();
FillFilters();
this.request = request;
textBox1.Text = request.Name;
comboBox1.SelectedItem = request.Priority;
comboBox2.SelectedItem = RequestStatusDB.GetInstance().GetRequestStatusByID(request.StatusID);
comboBox3.SelectedItem = WorkerDB.GetInstance().GetWorkerByID(request.WorkerID);
dateTimePicker1.Value = request.DateCreate;
comboBox4.SelectedItem = ClientDB.GetInstance().GetClientByID(request.ClientID);
}
public void Log(Request request)
{
var db = RequestStatusDB.GetInstance();
string statusName = null;
if (request.StatusID == 0)
{
statusName = "без статуса";
}
else
{
statusName = db.GetRequestStatusByID(
request.StatusID).Name;
}
File.AppendAllText(
Properties.Settings.Default.FilePath,
$"{DateTime.Now}: id {request.ID} " +
$"name {request.Name} create: {request.DateCreate}" +
$"close: {request.DateClose != DateTime.MinValue}, status: {statusName}" +
$"priority: {request.Priority}, worker id: {request.WorkerID}");
}
private void ShowRequests(List <Request> requests)
{
listView1.Items.Clear();
RequestStatusDB statusDB = RequestStatusDB.GetInstance();
WorkerDB workerDB = WorkerDB.GetInstance();
ClientDB clientDB = ClientDB.GetInstance();
foreach (var request in requests)
{
ListViewItem row = new ListViewItem(request.Name);
row.SubItems.Add(request.DateCreate.ToString());
if (request.Closed)
{
row.SubItems.Add(" ");
}
row.SubItems.Add(statusDB.GetRequestStatusByID(request.StatusID).Name);
row.SubItems.Add(request.Priority.ToString());
row.SubItems.Add(workerDB.GetWorkerByID(request.WorkerID).LastName);
row.SubItems.Add(clientDB.GetClientByID(request.ClientID).LastName);
row.Tag = request;
listView1.Items.Add(row);
}
}
private void удалитьToolStripMenuItem_Click(object sender, EventArgs e)
{
if (listBox1.SelectedIndex == -1)
{
return;
}
RequestStatus requestStatus =
(RequestStatus)listBox1.SelectedItem;
var requests = RequestDB.GetInstance().
GetRequests()
.GetRequestsByStatus(requestStatus);
if (requests.requests.Count == 0)
{
RequestStatusDB.GetInstance().
RemoveRequestStatus(requestStatus);
FillListStatuses();
}
else
{
MessageBox.Show("Невозможно удалить статус, " +
"Существуют заявки с таким статусом");
}
}
private void button1_Click(object sender, EventArgs e)
{
RequestStatusDB.GetInstance().
CreateRequestStatus(textBox1.Text);
Close();
}