//Заполнение ComboBox'ов
private void RefreshControls()
{
if (TablesClass.SelectedTable == Tables.ORDERS.Name())
{
TablesClass.FillComboBoxAssistance(ORD_OrderCB);
}
else if (TablesClass.SelectedTable == Tables.ASSISTANCE.Name())
{
TablesClass.FillComboBoxFindAssistance(ASCE_HelpCB);
}
else if (TablesClass.SelectedTable == Tables.ASSISTANTS.Name())
{
TablesClass.FillComboBox(ASS_FullnameCB, Tables.ASSISTANTS.Name(), AssistantsFileds.ASS_Fullname.Name(),
AssistantsFileds.ASS_Code.Name());
}
else if (TablesClass.SelectedTable == Tables.PHOTOGRAPHERS.Name())
{
TablesClass.FillComboBox(PHO_FullnameCB, Tables.PHOTOGRAPHERS.Name(),
PhotographersFileds.PHO_Fullname.Name(), PhotographersFileds.PHO_Code.Name());
}
else if (TablesClass.SelectedTable == Tables.CUSTOMERS.Name())
{
TablesClass.FillComboBox(CUS_FullnameCB, Tables.CUSTOMERS.Name(), CustomerFields.CUS_Fullname.Name(),
CustomerFields.CUS_Code.Name());
}
else if (TablesClass.SelectedTable == Tables.SERVICES.Name())
{
TablesClass.FillComboBox(SER_DescriptionCB, Tables.SERVICES.Name(),
ServicesFileds.SER_Description.Name(), ServicesFileds.SER_Code.Name());
}
}
//Поиск записи таблицы CUSTOMERS
private void CUS_FindRecordBTN_Click(object sender, EventArgs e)
{
MessageBox.Show(
TablesClass.FindRecord(TablesClass.SelectedTable,
CUS_FullnameCB.ValueMember + " = " + CUS_FullnameCB.SelectedValue),
TablesClass.TableDisplay[TablesClass.SelectedTable]);
RefreshControls();
}
//Поиск записи таблицы SERVICES
private void SER_FindRecordBTN_Click(object sender, EventArgs e)
{
MessageBox.Show(
TablesClass.FindRecord(TablesClass.SelectedTable,
SER_DescriptionCB.ValueMember + " = " + SER_DescriptionCB.SelectedValue),
TablesClass.TableDisplay[TablesClass.SelectedTable]);
RefreshControls();
}
//Добавление записи в таблицу ASSISTANCE
private void ASCE_AddRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.AddRecord(Tables.ASSISTANCE.Name(), new Dictionary <string, string>
{
{ AssistanceFileds.ASCE_AssCode.Name(), ASCE_AssistantCB.SelectedValue.ToString() },
{ AssistanceFileds.ASCE_OrdCode.Name(), ASCE_OrderCB.SelectedValue.ToString() }
});
//TablesClass.RefreshGrid(dataGrid);
}
private void ChangeTextAssistance()
{
TablesClass.ChangeText(Controls, TablesClass.SelectedTable.Name(), AssistanceFileds.ASCE_Code.Name() + '=' + ASCE_HelpCB.SelectedValue,
new Dictionary <Control, string>
{
{ ASCE_AssistantCB, AssistanceFileds.ASCE_AssCode.Name() },
{ ASCE_OrderCB, AssistanceFileds.ASCE_OrdCode.Name() }
});
}
private void ChangeTextServices()
{
TablesClass.ChangeText(Controls, TablesClass.SelectedTable.Name(), ServicesFileds.SER_Code.Name() + '=' + SER_DescriptionCB.SelectedValue,
new Dictionary <Control, string>
{
{ SER_DescriptionTB, ServicesFileds.SER_Description.Name() },
{ SER_PriceTB, ServicesFileds.SER_Price.Name() }
});
}
//Добавление записи в таблицу SERVICES
private void SER_AddRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.AddRecord(Tables.SERVICES.Name(), new Dictionary <string, string>
{
{ ServicesFileds.SER_Description.Name(), SER_DescriptionTB.Text },
{ ServicesFileds.SER_Price.Name(), SER_PriceTB.Text }
});
//TablesClass.RefreshGrid(dataGrid);
}
//Добавление записи в таблицу CUSTOMERS
private void CUS_AddRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.AddRecord(Tables.CUSTOMERS.Name(), new Dictionary <string, string>
{
{ CustomerFields.CUS_Fullname.Name(), CUS_FullnameTB.Text },
{ CustomerFields.CUS_Adress.Name(), CUS_AdressTB.Text },
{ CustomerFields.CUS_Phone.Name(), CUS_PhoneMTB.Text }
});
//TablesClass.RefreshGrid(dataGrid);
}
//Добавление записи в таблицу ASSISTANTS
private void ASS_AddRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.AddRecord(Tables.ASSISTANTS.Name(), new Dictionary <string, string>
{
{ AssistantsFileds.ASS_Fullname.Name(), ASS_FullnameTB.Text },
{ AssistantsFileds.ASS_Phone.Name(), ASS_PhoneMTB.Text },
{ AssistantsFileds.ASS_Salary.Name(), ASS_SalaryTB.Text }
});
//TablesClass.RefreshGrid(dataGrid);
}
private void ChangeTextCustomers()
{
TablesClass.ChangeText(Controls, TablesClass.SelectedTable.Name(), CustomerFields.CUS_Code.Name() + '=' + CUS_FullnameCB.SelectedValue,
new Dictionary <Control, string>
{
{ CUS_FullnameTB, CustomerFields.CUS_Fullname.Name() },
{ CUS_AdressTB, CustomerFields.CUS_Adress.Name() },
{ CUS_PhoneMTB, CustomerFields.CUS_Phone.Name() }
});
}
private void ChangeTextAssistants()
{
TablesClass.ChangeText(Controls, TablesClass.SelectedTable.Name(), AssistantsFileds.ASS_Code.Name() + '=' + ASS_FullnameCB.SelectedValue,
new Dictionary <Control, string>
{
{ ASS_FullnameTB, AssistantsFileds.ASS_Fullname.Name() },
{ ASS_PhoneMTB, AssistantsFileds.ASS_Phone.Name() },
{ ASS_SalaryTB, AssistantsFileds.ASS_Salary.Name() }
});
}
//Добавление записи в таблицу ORDERS
private void ORD_AddRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.AddRecord(Tables.ORDERS.Name(), new Dictionary <string, string>
{
{ OrdersFileds.ORD_CusCode.Name(), ORD_CustomersCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_PhoCode.Name(), ORD_PhotographersCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_SerCode.Name(), ORD_ServicesCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_Date.Name(), ORD_DateMTB.Text },
{ OrdersFileds.ORD_Exec.Name(), Convert.ToInt32(ORD_ExecCB.Checked).ToString() }
});
//TablesClass.RefreshGrid(dataGrid);
}
//Редактирование записи таблицы ASSISTANCE
private void ASCE_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ AssistanceFileds.ASCE_Code.Name(), ASCE_HelpCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ AssistanceFileds.ASCE_AssCode.Name(), ASCE_AssistantCB.SelectedValue.ToString() },
{ AssistanceFileds.ASCE_OrdCode.Name(), ASCE_OrderCB.SelectedValue.ToString() }
});
RefreshControls();
}
//Редактирование записи таблицы SERVICES
private void SER_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ ServicesFileds.SER_Code.Name(), SER_DescriptionCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ ServicesFileds.SER_Description.Name(), SER_DescriptionTB.Text },
{ ServicesFileds.SER_Price.Name(), SER_PriceTB.Text }
});
RefreshControls();
}
private void ChangeTexOrders()
{
TablesClass.ChangeText(Controls, TablesClass.SelectedTable.Name(), OrdersFileds.ORD_Code.Name() + '=' + ORD_OrderCB.SelectedValue,
new Dictionary <Control, string>
{
{ ORD_DateMTB, OrdersFileds.ORD_Date.Name() },
{ ORD_ExecCB, OrdersFileds.ORD_Exec.Name() },
{ ORD_CustomersCB, OrdersFileds.ORD_CusCode.Name() },
{ ORD_PhotographersCB, OrdersFileds.ORD_PhoCode.Name() },
{ ORD_ServicesCB, OrdersFileds.ORD_SerCode.Name() }
});
}
//Добавление записи в таблицу PHOTOGRAPHERS
private void PHO_AddRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.AddRecord(Tables.PHOTOGRAPHERS.Name(), new Dictionary <string, string>
{
{ PhotographersFileds.PHO_Fullname.Name(), PHO_FullnameTB.Text },
{ PhotographersFileds.PHO_Experience.Name(), PHO_ExperienceTB.Text },
{ PhotographersFileds.PHO_Date.Name(), PHO_DateMTB.Text },
{ PhotographersFileds.PHO_Phone.Name(), PHO_PhoneMTB.Text },
{ PhotographersFileds.PHO_Adress.Name(), PHO_AdressTB.Text },
{ PhotographersFileds.PHO_Salary.Name(), PHO_SalaryTB.Text }
});
//TablesClass.RefreshGrid(dataGrid);
}
//Редактирование записи таблицы ASSISTANTS
private void ASS_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ AssistantsFileds.ASS_Code.Name(), ASS_FullnameCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ AssistantsFileds.ASS_Fullname.Name(), ASS_FullnameTB.Text },
{ AssistantsFileds.ASS_Phone.Name(), ASS_PhoneMTB.Text },
{ AssistantsFileds.ASS_Salary.Name(), ASS_SalaryTB.Text }
});
RefreshControls();
}
//Редактирование записи таблицы CUSTOMERS
private void CUS_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ CustomerFields.CUS_Code.Name(), CUS_FullnameCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ CustomerFields.CUS_Fullname.Name(), CUS_FullnameTB.Text },
{ CustomerFields.CUS_Adress.Name(), CUS_AdressTB.Text },
{ CustomerFields.CUS_Phone.Name(), CUS_PhoneMTB.Text },
});
RefreshControls();
}
//Заполнение элементов согласно выбранному элементу ComboBox
private void ChangeTextPhotographers()
{
TablesClass.ChangeText(Controls, TablesClass.SelectedTable.Name(), PhotographersFileds.PHO_Code.Name() + '=' + PHO_FullnameCB.SelectedValue,
new Dictionary <Control, string>
{
{ PHO_FullnameTB, PhotographersFileds.PHO_Fullname.Name() },
{ PHO_ExperienceTB, PhotographersFileds.PHO_Experience.Name() },
{ PHO_DateMTB, PhotographersFileds.PHO_Date.Name() },
{ PHO_PhoneMTB, PhotographersFileds.PHO_Phone.Name() },
{ PHO_AdressTB, PhotographersFileds.PHO_Adress.Name() },
{ PHO_SalaryTB, PhotographersFileds.PHO_Salary.Name() }
});
}
//Редактирование записи таблицы ORDERS
private void ORD_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ OrdersFileds.ORD_Code.Name(), ORD_OrderCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ OrdersFileds.ORD_CusCode.Name(), ORD_CustomersCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_PhoCode.Name(), ORD_PhotographersCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_SerCode.Name(), ORD_ServicesCB.SelectedValue.ToString() },
{ OrdersFileds.ORD_Date.Name(), ORD_DateMTB.Text },
{ OrdersFileds.ORD_Exec.Name(), Convert.ToInt32(ORD_ExecCB.Checked).ToString() }
});
RefreshControls();
}
//Редактирование записи таблицы PHOTOGRAPHERS
private void PHO_EditRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.EditRecord(TablesClass.SelectedTable.Name(), new Dictionary <string, string>
{
{ PhotographersFileds.PHO_Code.Name(), PHO_FullnameCB.SelectedValue.ToString() }
}, new Dictionary <string, string>
{
{ PhotographersFileds.PHO_Fullname.Name(), PHO_FullnameTB.Text },
{ PhotographersFileds.PHO_Experience.Name(), PHO_ExperienceTB.Text },
{ PhotographersFileds.PHO_Date.Name(), PHO_DateMTB.Text },
{ PhotographersFileds.PHO_Phone.Name(), PHO_PhoneMTB.Text },
{ PhotographersFileds.PHO_Adress.Name(), PHO_AdressTB.Text },
{ PhotographersFileds.PHO_Salary.Name(), PHO_SalaryTB.Text }
});
RefreshControls();
}
//Поиск записи таблицы ASSISTANCE
private void ASCE_FindRecordBTN_Click(object sender, EventArgs e)
{
MessageBox.Show(
TablesClass.FindRecord(TablesClass.SelectedTable,
ASCE_HelpCB.ValueMember + " = " + ASCE_HelpCB.SelectedValue, new Dictionary <string, Dictionary <string, string> >
{
{ Tables.ASSISTANTS.Name(), new Dictionary <string, string> {
{ AssistantsFileds.ASS_Fullname.Name(), AssistantsFileds.ASS_Code.Name() }
} },
{ Tables.ORDERS.Name(), new Dictionary <string, string> {
{ OrdersFileds.ORD_Date.Name(), OrdersFileds.ORD_Code.Name() }
} },
}),
TablesClass.TableDisplay[TablesClass.SelectedTable]);
RefreshControls();
}
//Поиск записи таблицы ORDERS
private void ORD_FindRecordBTN_Click(object sender, EventArgs e)
{
MessageBox.Show(
TablesClass.FindRecord(TablesClass.SelectedTable,
ORD_OrderCB.ValueMember + " = " + ORD_OrderCB.SelectedValue, new Dictionary <string, Dictionary <string, string> >
{
{ Tables.CUSTOMERS.Name(), new Dictionary <string, string> {
{ CustomerFields.CUS_Fullname.Name(), CustomerFields.CUS_Code.Name() }
} },
{ Tables.PHOTOGRAPHERS.Name(), new Dictionary <string, string> {
{ PhotographersFileds.PHO_Fullname.Name(), PhotographersFileds.PHO_Code.Name() }
} },
{ Tables.SERVICES.Name(), new Dictionary <string, string> {
{ ServicesFileds.SER_Description.Name(), ServicesFileds.SER_Code.Name() }
} }
}),
TablesClass.TableDisplay[TablesClass.SelectedTable]);
RefreshControls();
}
public AddRecForm()
{
InitializeComponent();
TablesClass.ShowGroupBox(Controls);
//Заполнение ComboBox в зависимости от выбранной таблицы
if (TablesClass.SelectedTable == Tables.ORDERS.Name())
{
TablesClass.FillComboBox(ORD_CustomersCB, Tables.CUSTOMERS.Name(), CustomerFields.CUS_Fullname.Name(),
CustomerFields.CUS_Code.Name());
TablesClass.FillComboBox(ORD_PhotographersCB, Tables.PHOTOGRAPHERS.Name(),
PhotographersFileds.PHO_Fullname.Name(), PhotographersFileds.PHO_Code.Name());
TablesClass.FillComboBox(ORD_ServicesCB, Tables.SERVICES.Name(), ServicesFileds.SER_Description.Name(),
ServicesFileds.SER_Code.Name());
}
else if (TablesClass.SelectedTable == Tables.ASSISTANCE.Name())
{
TablesClass.FillComboBox(ASCE_AssistantCB, Tables.ASSISTANTS.Name(),
AssistantsFileds.ASS_Fullname.Name(), AssistantsFileds.ASS_Code.Name());
TablesClass.FillComboBoxAssistance(ASCE_OrderCB);
}
}
private void TableReport()
{
var dbTable = TablesClass.TableDisplay[TablesClass.SelectedTable];
var dialogResult = MessageBox.Show(@"Вы действительно хотите составить отчет по таблице " + dbTable,
@"Отчет", MessageBoxButtons.YesNo);
if (dialogResult != DialogResult.Yes)
{
return;
}
Word._Application application = new Word.Application();
Word._Document document = application.Documents.Add();
Word.Paragraph paragraph = document.Content.Paragraphs.Add();
application.Visible = true;
paragraph.Range.Text = TablesClass.TableDisplay[TablesClass.SelectedTable];
paragraph.Range.Font.Bold = 16;
paragraph.Range.Font.Size = 14;
paragraph.Range.Font.Name = "Times New Roman";
paragraph.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
paragraph.Range.InsertParagraphAfter();
paragraph.Range.Font.Bold = 0;
paragraph.Range.Font.Size = 12;
paragraph.Range.Font.Name = "Times New Roman";
paragraph.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
List <List <string> > list;
if (TablesClass.SelectedTable == Tables.ORDERS.Name())
{
list = TablesClass.GetList(TablesClass.SelectedTable,
new Dictionary <string, Dictionary <string, string> >
{
{
Tables.CUSTOMERS.Name(),
new Dictionary <string, string>
{
{ CustomerFields.CUS_Fullname.Name(), CustomerFields.CUS_Code.Name() }
}
},
{
Tables.PHOTOGRAPHERS.Name(),
new Dictionary <string, string>
{
{ PhotographersFileds.PHO_Fullname.Name(), PhotographersFileds.PHO_Code.Name() }
}
},
{
Tables.SERVICES.Name(),
new Dictionary <string, string>
{
{ ServicesFileds.SER_Description.Name(), ServicesFileds.SER_Code.Name() }
}
}
});
}
else if (TablesClass.SelectedTable == Tables.ASSISTANCE.Name())
{
list = TablesClass.GetList(TablesClass.SelectedTable,
new Dictionary <string, Dictionary <string, string> >
{
{
Tables.ASSISTANTS.Name(),
new Dictionary <string, string>
{
{ AssistantsFileds.ASS_Fullname.Name(), AssistantsFileds.ASS_Code.Name() }
}
},
{
Tables.ORDERS.Name(),
new Dictionary <string, string>
{
{ OrdersFileds.ORD_Date.Name(), OrdersFileds.ORD_Code.Name() }
}
},
});
}
else
{
list = TablesClass.GetList(TablesClass.SelectedTable);
}
var numCols = TablesClass.FieldsDisplay.Count(r =>
r.Key.Substring(0, 3) == TablesClass.SelectedTable.Substring(0, 3).ToUpper());
Word.Table table = document.Tables.Add(paragraph.Range, list.Count, numCols);
table.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
table.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
for (int i = 0; i < list.Count; i++)
{
for (int j = 0; j < numCols; j++)
{
table.Cell(i + 1, j + 1).Range.Text = list[i][j];
}
}
}
private void ASCE_HelpCB_Format(object sender, ListControlConvertEventArgs e)
{
TablesClass.Format(ref e, "Ассистент: {0} Заказчик: {1} Фотограф: {2}");
}
private void ORD_OrderCB_Format(object sender, ListControlConvertEventArgs e)
{
TablesClass.Format(ref e, "Заказчик: {0} Фотограф: {1}");
}
private void MonthSum()
{
var dialogResult = MessageBox.Show(@"Вы действительно хотите получить сводку за " +
$@"{DateTime.Now.AddMonths(-1).ToString("MMMM").ToLower()} {DateTime.Now.AddMonths(-1).Year} года",
@"Получение сводки", MessageBoxButtons.YesNo);
if (dialogResult != DialogResult.Yes)
{
return;
}
Word._Application application = new Word.Application();
Word._Document document = application.Documents.Add();
Word.Paragraph paragraph = document.Content.Paragraphs.Add();
application.Visible = true;
paragraph.Range.Font.Bold = 0;
paragraph.Range.Font.Size = 14;
paragraph.Range.Font.Name = "Times New Roman";
paragraph.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
paragraph.Range.Text = "Сводка за " + DateTime.Now.AddMonths(-1).ToString("MMMM") + " " + DateTime.Now.AddMonths(-1).Year + "\n" + TablesClass.GetSummary();
}
public EditRecForm()
{
InitializeComponent();
TablesClass.ShowGroupBox(Controls);
RefreshControls();
}
//Удаление записи из таблицы ASSISTANTS
private void ASS_DeleteRecordBTN_Click(object sender, EventArgs e)
{
TablesClass.DeleteRecord(TablesClass.SelectedTable, AssistantsFileds.ASS_Code.Name() + "=" + ASS_FullnameCB.SelectedValue);
RefreshControls();
}
