public void LoadGridFio(object sender, DoWorkEventArgs e)
{
var commandServer = new CommandServer();
try
{
radGridView5.Invoke(new MethodInvoker(delegate()
{
radGridView5.EnablePaging = true;
_bindingSource_personel = new BindingSource {
DataSource = commandServer.DataGridSet(@"select *
from spezialistView(0,0)
order by [ФИО]").Tables[0]
};
radGridView5.DataSource = _bindingSource_personel;
radGridView5.Columns[0].IsVisible = false;
GridViewCommandColumn command = new GridViewCommandColumn();
command.Name = "commandDelYes";
command.UseDefaultText = true;
command.DefaultText = "Удалить";
command.FieldName = "delete";
command.HeaderText = "Операция";
radGridView5.MasterTemplate.Columns.Add(command);
radGridView5.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView5.CommandCellClick += new CommandCellClickEventHandler(radGridViewButton_Click);
}));
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void radGridView1_Click(object sender, EventArgs e)
{
var commandServer = new CommandServer();
try
{
if (radGridViewSoc.CurrentRow.Cells[0].Value != null)
{
_bindingSource_join = new BindingSource {
DataSource = commandServer.DataGridSet(@"select keys, fio as [ФИО], joi
from InspectorJoinSocView(" + radGridView1.CurrentRow.Cells[0].Value + ")").Tables[0]
};
radGridView2.DataSource = _bindingSource_join;
GridViewCheckBoxColumn date_join = new GridViewCheckBoxColumn("Привязка");
radGridView2.Columns[2] = date_join;
date_join.Name = "date_j";
date_join.FieldName = "joi";
radGridView2.Columns[0].IsVisible = false;
radGridView2.Columns[1].ReadOnly = true;
radGridView2.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView2.Columns[1].BestFit();
radGridView2.Columns[2].BestFit();
}
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void loadGridSoc()
{
var commandServer = new CommandServer();
try
{
radGridViewSoc.Invoke(new MethodInvoker(delegate()
{
radGridViewSoc.EnablePaging = true;
_bindingSource_soc = new BindingSource {
DataSource = commandServer.DataGridSet(@"select *
from socPersonelViewColor() order by [ФИО]").Tables[0]
};
radGridViewSoc.DataSource = _bindingSource_soc;
if (radGridViewSoc.Columns.Count > 0)
{
radGridViewSoc.Columns[0].IsVisible = false;
radGridViewSoc.Columns[2].IsVisible = false;
radGridViewSoc.Columns[3].IsVisible = false;
radGridViewSoc.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
}));
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void LoadGridOff(object sender, DoWorkEventArgs e)
{
try
{
radGridView3.Invoke(new MethodInvoker(delegate()
{
radGridView3.EnablePaging = true;
_bindingSource_soc_off = new BindingSource {
DataSource = new CommandServer().DataGridSet(@"select *
from spezialistView(2,1)
order by [ФИО]").Tables[0]
};
radGridView3.DataSource = _bindingSource_soc_off;
radGridView3.Columns[0].IsVisible = false;
GridViewCommandColumn command = new GridViewCommandColumn();
command.Name = "commandDelNo";
command.UseDefaultText = true;
command.DefaultText = "Восстановить";
command.FieldName = "restore";
command.HeaderText = "Операция";
radGridView3.MasterTemplate.Columns.Add(command);
radGridView3.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView3.CommandCellClick += new CommandCellClickEventHandler(radGridViewButton_Click);
}));
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
public void LoadGridFioOff()
{
try
{
radGridView2.Invoke(new MethodInvoker(delegate()
{
radGridView2.EnablePaging = true;
_bindingSource_off = new BindingSource {
DataSource = new CommandServer().DataGridSet(@"select *
from spezialistViewColor('1')
where date_end is not null
order by [ФИО]").Tables[0]
};
radGridView2.DataSource = _bindingSource_off;
if (radGridView2.Columns.Count > 0)
{
radGridView2.Columns[0].IsVisible = false;
radGridView2.Columns[2].IsVisible = false;
radGridView2.Columns[3].IsVisible = false;
radGridView2.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
}
}));
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void ClickSOCTime(object sender, EventArgs e)
{
var commandServer = new CommandServer();
try
{
if (radGridViewSoc.CurrentRow.Cells[0].Value != null)
{
_bindingSource_soc = new BindingSource {
DataSource = commandServer.DataGridSet(@"select key_job_soc_rabotnik, date_start, date_end
from job_soc_rabotnik left join socRabotnik on job_soc_rabotnik.fk_soc_rabotnik = socRabotnik.key_socRabotnik
where fk_soc_rabotnik = " + radGridViewSoc.CurrentRow.Cells[0].Value).Tables[0]
};
radGridViewSocTime.DataSource = _bindingSource_soc;
GridViewDateTimeColumn dateS = new GridViewDateTimeColumn("Дата начала");
radGridViewSocTime.Columns[1] = dateS;
dateS.Name = "date_s";
dateS.FieldName = "date_start";
dateS.FormatString = "{0:dd/MM/yyyy}";
dateS.Format = DateTimePickerFormat.Custom;
dateS.CustomFormat = "dd.MM.yyyy";
GridViewDateTimeColumn dateE = new GridViewDateTimeColumn("Дата конца");
radGridViewSocTime.Columns[2] = dateE;
dateE.Name = "date_e";
dateE.FieldName = "date_end";
dateE.FormatString = "{0:dd/MM/yyyy}";
dateE.Format = DateTimePickerFormat.Custom;
dateE.CustomFormat = "dd.MM.yyyy";
radGridViewSocTime.Columns[0].IsVisible = false;
radGridViewSocTime.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridViewSocTime.Columns[1].BestFit();
radGridViewSocTime.Columns[2].BestFit();
if (radGridViewSocTime.Columns.Count > 0)
{
UpdateLoadJobTime();
}
else
{
richTextBox1.Text = "";
}
}
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
public Update(string server, LoadProgram load)
{
try
{
_server = server;
_load = load;
ScanFile();
}
catch (Exception ex)
{
var commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void radGridView5_Click(object sender, EventArgs e)
{
try
{
if (radGridView5.CurrentRow.Cells[0].Value != null)
{
_bindingSource_personel_time = new BindingSource {
DataSource = new CommandServer().DataGridSet(@"select key_job_spezialist, date_start, date_end
from job_spezialist left join speziolist on job_spezialist.fk_spezialist = speziolist.key_speziolist
where fk_spezialist = " + radGridView5.CurrentRow.Cells[0].Value).Tables[0]
};
radGridView6.DataSource = _bindingSource_personel_time;
GridViewDateTimeColumn dateS = new GridViewDateTimeColumn("Дата начала");
radGridView6.Columns[1] = dateS;
dateS.Name = "date_s";
dateS.FieldName = "date_start";
dateS.FormatString = "{0:dd/MM/yyyy}";
dateS.Format = DateTimePickerFormat.Custom;
dateS.CustomFormat = "dd.MM.yyyy";
GridViewDateTimeColumn dateE = new GridViewDateTimeColumn("Дата конца");
radGridView6.Columns[2] = dateE;
dateE.Name = "date_e";
dateE.FieldName = "date_end";
dateE.FormatString = "{0:dd/MM/yyyy}";
dateE.Format = DateTimePickerFormat.Custom;
dateE.CustomFormat = "d.M.y";
radGridView6.Columns[0].IsVisible = false;
radGridView6.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView6.Columns[1].BestFit();
radGridView6.Columns[2].BestFit();
if (radGridView6.RowCount > 0)
{
UpdateLoadJobTime();
}
else
{
richTextBox1.Text = "";
}
}
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void AlertOperation(string operation, string[] resultOperation)
{
var commandClient = new CommandClient();
if (resultOperation[1] == "1")
{
radDesktopAlert1.ContentText = resultOperation[0];
radDesktopAlert1.Show();
}
else
{
commandClient.WriteFileError(null, operation);
radDesktopAlert1.ContentText = resultOperation[0];
radDesktopAlert1.Show();
}
}
private void ScanFile()
{
if (!Directory.Exists("Temp"))
{
Directory.CreateDirectory("Temp");
}
else
{
DirectoryInfo dirInfo = new DirectoryInfo("Temp");
foreach (FileInfo file in dirInfo.GetFiles())
{
file.Delete();
}
}
var network = new NetworkShareAccesser();
_load.SetLabel("Проверка доступности локального сервера");
network.SaveACopy(@"\\S1\Alldoc\Install\Программы\Обновления\Одиноко проживающие\", Path.Combine(Application.StartupPath, "Temp"), 1500);
Thread.Sleep(2500);
DirectoryInfo di = new DirectoryInfo(Path.Combine(Application.StartupPath, "Temp"));
FileInfo[] files = di.GetFiles();
if (files.Length != 0)
{
UpdateProgram();
}
else
{
try
{
FTPConnect();
UpdateProgram();
}
catch (Exception ex) {
MessageBox.Show(
@"Произошла ошибка при обновлении. Обратитесь к разработчику.",
@"Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
new Configuration().ShowDialog();
var commandClient = new CommandClient();
commandClient.WriteFileError(ex, "Обновление");
}
}
}
private void fillTheDataGrid()
{
var commandServer = new CommandServer();
try
{
radGridView1.Invoke(new MethodInvoker(delegate()
{
loadGridSoc();
LoadGridInspector();
}));
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void Add(object sender, EventArgs e)
{
var commandClient = new CommandClient();
try
{
Hide();
new Alone(true, 0, null, null).ShowDialog();
}
catch (Exception ex)
{
commandClient.WriteFileError(ex, null);
}
finally
{
Show();
GC.Collect();
GC.WaitForPendingFinalizers();
}
}
private void radGridView2_Click(object sender, EventArgs e)
{
try
{
if (radGridView2.CurrentRow.Cells[0].Value != null)
{
_bindingSource_off_time = new BindingSource {
DataSource = new CommandServer().DataGridSet(@"select key_job_spezialist, date_start, date_end
from job_spezialist left join speziolist on job_spezialist.fk_spezialist = speziolist.key_speziolist
where fk_spezialist = " + radGridView2.CurrentRow.Cells[0].Value).Tables[0]
};
radGridView4.DataSource = _bindingSource_off_time;
GridViewDateTimeColumn dateS_off = new GridViewDateTimeColumn("Дата начала");
radGridView4.Columns[1] = dateS_off;
dateS_off.Name = "date_s_off";
dateS_off.FieldName = "date_start";
dateS_off.FormatString = "{0:dd/MM/yyyy}";
dateS_off.Format = DateTimePickerFormat.Custom;
dateS_off.CustomFormat = "dd.MM.yyyy";
GridViewDateTimeColumn dateE_off = new GridViewDateTimeColumn("Дата конца");
radGridView4.Columns[2] = dateE_off;
dateE_off.Name = "date_e_off";
dateE_off.FieldName = "date_end";
dateE_off.FormatString = "{0:dd/MM/yyyy}";
dateE_off.Format = DateTimePickerFormat.Custom;
dateE_off.CustomFormat = "dd.MM.yyyy";
radGridView4.Columns[0].IsVisible = false;
radGridView4.AutoSizeColumnsMode = GridViewAutoSizeColumnsMode.Fill;
radGridView4.Columns[1].BestFit();
radGridView4.Columns[2].BestFit();
}
}
catch (Exception ex)
{
CommandClient commandClient = new CommandClient();
commandClient.WriteFileError(ex, null);
}
}
private void UpdateProgram()
{
Process update = new Process();
try
{
update.StartInfo.UseShellExecute = true;
update.StartInfo.FileName = _programName;
update.Start();
}
catch (Exception ex)
{
var commandClient = new CommandClient();
commandClient.WriteFileError(ex, "Обновление");
MessageBox.Show(
@"Произошла ошибка при обновлении. Обратитесь к разработчику.",
@"Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Process.GetCurrentProcess().Kill();
}
}
