private void WorkChange()
{
Action action = () =>
{
try
{
Table_Class workTest = new Table_Class(String.Format("SELECT [ID_Work] from [dbo].[Work] where [ID_Work] = {0}", dgWork.Rows[dgWork.SelectedCells[0].RowIndex].Cells[0].Value.ToString()));
}
catch
{
IDWork = "";
}
finally
{
IDWork = dgWork.Rows[dgWork.SelectedCells[0].RowIndex].Cells[0].Value.ToString();
}
if (IDWork != "")
{
Table_Class workFill = new Table_Class(String.Format("SELECT [WorkDay],[Work_Time],[Work_Length] FROM [dbo].[Work] WHERE [LogicDelete] = 0 and [ID_Work] = {0}", IDWork));
nudStartHour.Value = Convert.ToInt32(workFill.table.Rows[0][1].ToString().Substring(0, 2));
nudStartMinute.Value = Convert.ToInt32(workFill.table.Rows[0][1].ToString().Substring(3, 2));
nudEndHour.Value = Convert.ToInt32(workFill.table.Rows[0][2].ToString().Substring(0, 2));
nudEndMinute.Value = Convert.ToInt32(workFill.table.Rows[0][2].ToString().Substring(3, 2));
switch (workFill.table.Rows[0][0].ToString())
{
case ("ПН"):
cbWorkDay.SelectedIndex = 0;
break;
case ("ВТ"):
cbWorkDay.SelectedIndex = 1;
break;
case ("СР"):
cbWorkDay.SelectedIndex = 2;
break;
case ("ЧТ"):
cbWorkDay.SelectedIndex = 3;
break;
case ("ПТ"):
cbWorkDay.SelectedIndex = 4;
break;
case ("СБ"):
cbWorkDay.SelectedIndex = 5;
break;
case ("ВС"):
cbWorkDay.SelectedIndex = 6;
break;
}
}
btWorkInsert.Enabled = false;
};
Invoke(action);
}
private void TrainerLoad()
{
Action action = () =>
{
Table_Class tableTrainer = new Table_Class("SELECT [ID_Trainer] as \'Табельный номер\',[TrainerFirstName] as \'Имя\',[TrainerSecondName] as \'Фамилия\',[TrainerLastName] as \'Отчество\',[TrainerCategory] as \'Категория\',[TrainerLogin] as \'Логин\' FROM [dbo].[Trainers] WHERE [LogicDelete] = 0 AND [ID_Trainer]>0");
dgTrainers.DataSource = tableTrainer.table;
};
Invoke(action);
}
private void NCFill(string ClientID)
{
Action action = () =>
{
Table_Class table_NC = new Table_Class(String.Format(CurNCQuerry + "AND (dbo.Abonement.ID_Client = {0})", ClientID));
table_NC.Dependency.OnChange += NCDependency_OnChange;
dgNewcoming.DataSource = table_NC.table;
};
Invoke(action);
}
private void GroupFill()
{
Action action = () =>
{
Table_Class tableGroup = new Table_Class(CurGroupQuerry + String.Format("and dbo.[Group].Trainer_ID = {0}", Program.intID));
tableGroup.Dependency.OnChange += GroupDependency_OnChange;
dgGroup.DataSource = tableGroup.table;
};
Invoke(action);
}
public void ActionFill()
{
Action action = () =>
{
Table_Class table_Action = new Table_Class(CurActionQuerry);
table_Action.Dependency.OnChange += ActionDependency_OnChange;
dgAction.DataSource = table_Action.table;
};
Invoke(action);
}
private void ThemeFill()
{
Action action = () =>
{
Table_Class themeTable = new Table_Class(CurThemeQuerry);
themeTable.Dependency.OnChange += ThemeDependency_OnChange;
dgTheme.DataSource = themeTable.table;
};
Invoke(action);
}
public void FilialFill()
{
Action action = () =>
{
Table_Class table_Filial = new Table_Class("SELECT [ID_Filial] as \'Код\',[FilialName] as \'Название\',[FilialAdress] as \'Адрес\' FROM [dbo].[Filials] WHERE [LogicDelete] = 0 and [ID_Filial]>0");
table_Filial.Dependency.OnChange += FilialDependency_OnChange;
dgFilial.DataSource = table_Filial.table;
};
Invoke(action);
}
public void WorkPlaceFill()
{
Action action = () =>
{
Table_Class table_WorkPlace = new Table_Class(String.Format("SELECT [ID_WorkPlace] as \'Номер\' ,[WorkPlaceLocation] as \'Расположение\' FROM [dbo].[WorkPlaces] WHERE [LogicDelete] = 0 and [ID_WorkPlace]>0 and [ID_Filial] = {0}", FID));
table_WorkPlace.Dependency.OnChange += WorkPlaceDependency_OnChange;;
dgWorkPlaces.DataSource = table_WorkPlace.table;
};
Invoke(action);
}
private void TimetableFill()
{
Action action = () =>
{
Table_Class table_TT = new Table_Class("SELECT [ID_Work] as \'Номер тренировки\',[WorkDay] as \'День недели\',[Work_Time] as \'Начало\',[Work_Length] as \'Окончание\',[ThemeName] as \'Темактика\',([TrainerFirstName] + ' ' + SUBSTRING([TrainerSecondName],1,1) + '. ' + SUBSTRING([TrainerLastName],1,1) +'.') as \'Тренер\',[FilialName] as \'Филиал\',[WorkPlaceLocation] as \'Зал\' FROM [dbo].[Timetable] where [LogicDelete] = 0 and [ID_Work] > 0");
table_TT.Dependency.OnChange += TTDependency_OnChange;
dgTimetable.DataSource = table_TT.table;
};
Invoke(action);
}
private void TimetableSave()
{
Action action = () =>
{
Table_Class table_TT = new Table_Class("SELECT [ID_Work] as \'Номер тренировки\',[WorkDay] as \'День недели\',[Work_Time] as \'Начало\',[Work_Length] as \'Окончание\',[ThemeName] as \'Темактика\',([TrainerFirstName] + ' ' + SUBSTRING([TrainerSecondName],1,1) + '. ' + SUBSTRING([TrainerLastName],1,1) +'.') as \'Тренер\',[FilialName] as \'Филиал\',[WorkPlaceLocation] as \'Зал\' FROM [dbo].[Timetable] where [LogicDelete] = 0 and [ID_Work] > 1");
Document_class ttDoc = new Document_class();
ttDoc.Document_Create(Document_class.Document_Type.Timetable, Document_class.Document_Format.Excel, TTSaveDialog.FileName, table_TT.table);
};
Invoke(action);
}
private void AbonFill(string ClientID)
{
Action action = () =>
{
Table_Class table_Abonement = new Table_Class(String.Format(CurAbonQuerry + "and dbo.Abonement.ID_Client = {0}", ClientID));
table_Abonement.Dependency.OnChange += AbonDependency_OnChange;
dgAbonement.DataSource = table_Abonement.table;
};
Invoke(action);
}
///<summary>
///Перегрузка для процедур с параметрами.
///</summary>
///<param name = "Function_Name">Название процедуры</param>
///<param name = "Type_function">Тип функции</param>
///<param name = "Parameters">Параметры</param>
public Function_class(string Function_Name, Function_Result Type_function, ArrayList Parameters)
{
string querry = "";
try
{
switch (Type_function)
{
case Function_Result.scalar:
//Вывод данныхиз скалаярной функции
querry = string.Format(@"select [dbo].[{0}](", Function_Name);
break;
case Function_Result.table:
querry = string.Format(@"select * from [dbo].[{0}](", Function_Name);
break;
}
//Переменная списка параметров
string list_parameters = "";
//switch (Parameters.Count)
//{
// case 1:
// //Вывод данныхиз скалаярной функции
// list_parameters += Parameters[0].ToString() + ")";
// break;
// default:
// foreach (object parameter in Parameters)
// {
// list_parameters += parameter + ",";
// }
// list_parameters = list_parameters.Remove(list_parameters.Length-1, 1);
// list_parameters += ")";
// break;
//}
//Заполнение списка из листа параметров
foreach (object parameter in Parameters)
{
list_parameters += parameter.ToString() + ",";
}
list_parameters = list_parameters.Remove(list_parameters.Length - 1, 1);
list_parameters += ")";
//Оформление запроса
querry += list_parameters;
//Заполнение таблицы
Table_Class table = new Table_Class(querry);
Regtable = table.table;
}
catch
{
}
}
private void GroupPagesFill()
{
Action action = () =>
{
string CurWP = "";
string CurTM = "";
string CurAC = "";
Table_Class groupPageWP = new Table_Class("SELECT dbo.WorkPlaces.ID_WorkPlace, dbo.Filials.FilialName + ' ' +dbo.WorkPlaces.WorkPlaceLocation as \'Descriptor\' FROM dbo.Filials INNER JOIN dbo.WorkPlaces ON dbo.Filials.ID_Filial = dbo.WorkPlaces.ID_Filial WHERE dbo.WorkPlaces.[ID_WorkPlace]>0 and dbo.WorkPlaces.[LogicDelete] = 0");
groupPageWP.Dependency.OnChange += GroupPageDependency_OnChange;
cbWorkPlace.DataSource = groupPageWP.table;
cbWorkPlace.DisplayMember = "Descriptor";
cbWorkPlace.ValueMember = "ID_WorkPlace";
Table_Class groupPageTM = new Table_Class("SELECT [ID_Theme],[ThemeName] FROM [dbo].[Themes] WHERE [LogicDelete] = 0 and [ID_Theme]>0");
groupPageTM.Dependency.OnChange += GroupPageDependency_OnChange;
cbTheme.DataSource = groupPageTM.table;
cbTheme.DisplayMember = "ThemeName";
cbTheme.ValueMember = "ID_Theme";
if (GroupID != "")
{
Table_Class groupPages = new Table_Class(String.Format("SELECT [WorkPlace_ID],[Theme_ID],[Abon_Cost] FROM [dbo].[Group] WHERE [ID_Group] = {0}", GroupID));
CurWP = groupPages.table.Rows[0][0].ToString();
CurTM = groupPages.table.Rows[0][1].ToString();
CurAC = groupPages.table.Rows[0][2].ToString();
}
try
{
cbWorkPlace.SelectedValue = CurWP;
}
catch
{
cbWorkPlace.SelectedIndex = 0;
}
try
{
cbTheme.SelectedValue = CurTM;
}
catch
{
cbTheme.SelectedIndex = 0;
}
try
{
nudCost.Value = Convert.ToInt32(CurAC);
}
catch
{
nudCost.Value = 1;
}
};
Invoke(action);
}
private void ClientFill()
{
Action action = () =>
{
if (ClientID != "")
{
Table_Class clientMain = new Table_Class(String.Format("SELECT [CLFirstName],[CLName],[CLMiddleName] FROM [dbo].[Client] WHERE [ID_Client] = {0}", ClientID));
lblCurClient.Text = clientMain.table.Rows[0][0].ToString() + ' ' + clientMain.table.Rows[0][1].ToString() + ' ' + clientMain.table.Rows[0][0].ToString();
}
};
Invoke(action);
}
private void WorkFill()
{
Action action = () =>
{
if (GroupID != "")
{
Table_Class tableWork = new Table_Class(String.Format("SELECT [ID_Work] as \'Код\',[WorkDay] as \'День недели\',[Work_Time] as \'Начало\',[Work_Length] as \'Окончание\' FROM [dbo].[Work] WHERE [LogicDelete] = 0 and [ID_Work]>0 and [ID_Group] = {0}", GroupID));
tableWork.Dependency.OnChange += WorkDependency_OnChange;
dgWork.DataSource = tableWork.table;
}
};
Invoke(action);
}
private void AbonFill()
{
Action action = () =>
{
if (ClientID != "")
{
Table_Class tableAbonement = new Table_Class(String.Format("SELECT ID_Abonement ,(\'Группа №\' +Convert(varchar,ID_Group) +\' (С \' + Abonement_Start_Date + \' По \' + Abonement_End_Date +\')\') as \'Descriptor\' FROM [dbo].[Abonement] where LogicDelete = 0 and ID_Abonement > 0 and ID_Client = {0}", ClientID));
cbAbonement.DataSource = tableAbonement.table;
cbAbonement.ValueMember = "ID_Abonement";
cbAbonement.DisplayMember = "Descriptor";
}
};
Invoke(action);
}
private void Manager_Fill()
{
Action action = () =>
{
Table_Class table_Manager = new Table_Class(String.Format("SELECT [ManagerFirstName],[ManagerSecondName],[ManagerLastName],[ManagerLogin],[ManagerPassword] FROM [dbo].[Managers] where [ID_Manager] = {0}", Program.intID));
table_Manager.Dependency.OnChange += DependencyManager_OnChange;
tbManagerFirstname.Text = table_Manager.table.Rows[0][0].ToString();
tbManagerName.Text = table_Manager.table.Rows[0][1].ToString();
tbManagerPatronymic.Text = table_Manager.table.Rows[0][2].ToString();
tbManagerLogin.Text = table_Manager.table.Rows[0][3].ToString();
Password = table_Manager.table.Rows[0][4].ToString();
this.Text = "Интерфейс менеджера: " + table_Manager.table.Rows[0][0].ToString() + " " + table_Manager.table.Rows[0][1].ToString().Substring(0, 1) + ". " + table_Manager.table.Rows[0][2].ToString().Substring(0, 1) + ".";
};
Invoke(action);
}
private void ActionFill()
{
if (ImCLose)
{
this.Close();
}
else
{
Action action = () =>
{
Table_Class acttable = new Table_Class("SELECT [ID_Action],(Convert(varchar,[ActionProperties]) +' (' + Convert(varchar,[ActionProc]) + ')') as 'Descriptor' FROM [dbo].[Action] WHERE [LogicDelete] = 0");
cbAction.DataSource = acttable.table;
cbAction.DisplayMember = "Descriptor";
cbAction.ValueMember = "ID_Action";
};
Invoke(action);
}
}
private void TrainerFill()
{
Action action = () =>
{
Table_Class tableTrainer = new Table_Class(String.Format("SELECT [TrainerFirstName],[TrainerSecondName],[TrainerLastName],[TrainerCategory],[TrainerLogin],[TrainerPassword] FROM [dbo].[Trainers] WHERE [ID_Trainer] = {0}", Program.intID));
tbTrainerFirstname.Text = tableTrainer.table.Rows[0][0].ToString();
tbTrainerName.Text = tableTrainer.table.Rows[0][1].ToString();
tbTrainerPatronymic.Text = tableTrainer.table.Rows[0][2].ToString();
tbCat.Text = tableTrainer.table.Rows[0][3].ToString();
tbTrainerLogin.Text = tableTrainer.table.Rows[0][4].ToString();
this.Text = "Интерфейс тренера: " + tableTrainer.table.Rows[0][0].ToString() + " " + tableTrainer.table.Rows[0][1].ToString().Substring(0, 1) + ". " + tableTrainer.table.Rows[0][2].ToString().Substring(0, 1) + ".";
Password = tableTrainer.table.Rows[0][5].ToString();
tbTrainerPassword.Clear();
tbTrainerConfirm.Clear();
};
Invoke(action);
}
private void DgWorkPlace_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Action action = () =>
{
try
{
Table_Class WPTest = new Table_Class(String.Format("SELECT [ID_WorkPlace] FROM [dbo].[WorkPlaces] WHERE [ID_WorkPlace]={0}", dgWorkPlaces.Rows[dgWorkPlaces.SelectedCells[0].RowIndex].Cells[0].Value.ToString()));
}
catch
{
WPID = "";
}
finally
{
WPID = dgWorkPlaces.Rows[dgWorkPlaces.SelectedCells[0].RowIndex].Cells[0].Value.ToString();
}
};
Invoke(action);
}
private void ThemeChange()
{
Action action = () =>
{
try
{
Table_Class themeTest = new Table_Class(String.Format("SELECT [ThemeName],[ThemeAbout] FROM [dbo].[Themes] WHERE [LogicDelete]=0 and [ID_Theme] = {0}", dgTheme.Rows[dgTheme.SelectedCells[0].RowIndex].Cells[0].Value.ToString()));
}
catch
{
IDTheme = "";
}
finally
{
IDTheme = dgTheme.Rows[dgTheme.SelectedCells[0].RowIndex].Cells[0].Value.ToString();
}
};
Invoke(action);
}
private void Client_Fill()
{
Action action = () =>
{
Table_Class table_Client = new Table_Class(CurClientQuerry);
table_Client.Dependency.OnChange += DependencyClient_OnChange;
//При переустановке базы необходимо заменить 3 на 0 (особенности сервера и автонумерации)
dgClient.DataSource = table_Client.table;
cbGender.SelectedIndex = 0;
dtpBirthdate.Value = DateTime.Now.AddDays(-1);
dtpWorkStart.Value = DateTime.Now;
Table_Class table_Manager = new Table_Class(String.Format("SELECT [ManagerFirstName],[ManagerSecondName],[ManagerLastName],[ManagerLogin],[ManagerPassword] FROM [dbo].[Managers] where [ID_Manager] = {0}", Program.intID));
tbManagerFirstname.Text = table_Manager.table.Rows[0][0].ToString();
tbManagerName.Text = table_Manager.table.Rows[0][1].ToString();
tbManagerPatronymic.Text = table_Manager.table.Rows[0][2].ToString();
tbManagerLogin.Text = table_Manager.table.Rows[0][3].ToString();
};
Invoke(action);
}
private void DgFilial_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
Action action = () =>
{
try
{
Table_Class FTest = new Table_Class(String.Format("SELECT [ID_Filial] FROM [dbo].[Filials] WHERE [ID_Filial] = {0}", dgFilial.Rows[dgFilial.SelectedCells[0].RowIndex].Cells[0].Value.ToString()));
}
catch
{
FID = "";
}
finally
{
FID = dgFilial.Rows[dgFilial.SelectedCells[0].RowIndex].Cells[0].Value.ToString();
WorkPlaceFill();
}
};
Invoke(action);
}
private void TrainerFill()
{
Action action = () =>
{
if (TrainerID != "")
{
Table_Class tableTrainer = new Table_Class(String.Format("SELECT [TrainerFirstName],[TrainerSecondName],[TrainerLastName],[TrainerCategory],[TrainerLogin], [TrainerPassword] FROM [dbo].[Trainers] WHERE [LogicDelete] = 0 AND [ID_Trainer]={0}", TrainerID));
tbTrainerFirstname.Text = tableTrainer.table.Rows[0][0].ToString();
tbTrainerName.Text = tableTrainer.table.Rows[0][1].ToString();
tbTrainerPatronymic.Text = tableTrainer.table.Rows[0][2].ToString();
switch (tableTrainer.table.Rows[0][3].ToString())
{
case ("старший"):
cbCategory.SelectedIndex = 0;
break;
case ("1"):
cbCategory.SelectedIndex = 1;
break;
case ("2"):
cbCategory.SelectedIndex = 2;
break;
case ("3"):
cbCategory.SelectedIndex = 3;
break;
case ("помощник"):
cbCategory.SelectedIndex = 4;
break;
}
tbTrainerLogin.Text = tableTrainer.table.Rows[0][4].ToString();
Password = tableTrainer.table.Rows[0][5].ToString();
}
};
Invoke(action);
}
private void GroupChange()
{
Action action = () =>
{
try
{
Table_Class groupTest = new Table_Class(String.Format("SELECT [ID_Group] from [dbo].[Group] where [ID_Group] = {0}", dgGroup.Rows[dgGroup.SelectedCells[0].RowIndex].Cells[0].Value.ToString()));
}
catch
{
GroupID = "";
}
finally
{
GroupID = dgGroup.Rows[dgGroup.SelectedCells[0].RowIndex].Cells[0].Value.ToString();
}
TabChange();
btWorkInsert.Enabled = false;
};
Invoke(action);
}
private void ThemeLoad()
{
Action action = () =>
{
if (Mode)
{
this.Text = "Изменение тематики";
lblTheme.Text = "Изменение тематики";
btInsertUpdate.Text = "Изменить";
Table_Class theme = new Table_Class(String.Format("SELECT [ThemeName],[ThemeAbout] FROM [dbo].[Themes] WHERE [LogicDelete]=0 and [ID_Theme] = {0}", (Owner as TrainerInterface).IDTheme));
tbThemeName.Text = theme.table.Rows[0][0].ToString();
tbThemeAbout.Text = theme.table.Rows[0][1].ToString();
}
else
{
this.Text = "Добавление тематики";
lblTheme.Text = "Добавление тематики";
btInsertUpdate.Text = "Добавить";
}
};
Invoke(action);
}
private void GroupFill()
{
if (ImCLose)
{
this.Close();
}
else
{
Action action = () =>
{
Table_Class group = new Table_Class("SELECT [ID_Group],((select (select [FilialName] from [dbo].[Filials] where [dbo].[WorkPlaces].[ID_Filial] = [dbo].[Filials].[ID_Filial]) from [dbo].[WorkPlaces] where [dbo].[Group].[WorkPlace_ID] = [dbo].[WorkPlaces].[ID_WorkPlace]) + ' ' + Substring((select [WorkPlaceLocation] from [dbo].[WorkPlaces] where [dbo].[Group].[WorkPlace_ID] = [dbo].[WorkPlaces].[ID_WorkPlace]),1,3) +'.; ' + (select [ThemeName] from [dbo].[Themes] where [dbo].[Group].[Theme_ID] = [dbo].[Themes].[ID_Theme]) +'; ' + (select [TrainerFirstname] from [dbo].[Trainers] where [dbo].[Group].[Trainer_ID] = [dbo].[Trainers].[ID_Trainer]) + ' (' + Convert(varchar,[ID_Group]) + ')') as 'Descriptor' FROM [dbo].[Group] where [LogicDelete] = 0 and [ID_Group] > 0");
cbGroup.DataSource = group.table;
if (group.table.Rows.Count == 0)
{
MessageBox.Show("Должна быть добавлена хоть одна группа!", "PaladinApp", MessageBoxButtons.OK, MessageBoxIcon.Error);
ImCLose = true;
}
cbGroup.DisplayMember = "Descriptor";
cbGroup.ValueMember = "ID_Group";
};
Invoke(action);
}
}
