private void AddPersonel_Load(object sender, EventArgs e)
{
cmbDepartment.DataSource = GetDbItems.GetDepartments();
cmbDep.DataSource = GetDbItems.GetDepartments();
cmbUpPers.DataSource = GetDbItems.GetPersonel();
cmbDelPers.DataSource = GetDbItems.GetPersonel();
}
private void btnDel_Click(object sender, EventArgs e)
{
try
{
var person = (from a in _ip.PersonalInformations where a.Name + " " + a.Surname == cmbDelPers.SelectedItem select a).FirstOrDefault();
person.IsDeleted = true;
person.DeletedTime = DateTime.Now;
_ip.SubmitChanges();
lblDurum.Text = "Personel silindi";
cmbDelPers.DataSource = GetDbItems.GetPersonel();
MainForm main = (MainForm)Application.OpenForms["MainForm"];
main.flowLayoutPanel1.Controls.Clear();
int index = 0;
var personals = from a in _ip.PersonalInformations where a.IsDeleted == false select a;
// index = personals.Count();
// this.Location = new Point(Screen.FromPoint(this.Location).WorkingArea.Right - this.Width);
foreach (var item in personals)
{
Personal pers = new Personal();
pers.Tag = index;
pers.lblPersName.Text = item.Name + " " + item.Surname;
try
{
pers.picPers.Image = Image.FromFile(item.P_Image);
}
catch (Exception)
{
}
try
{
pers.picPers.Image = HelpMe.ScaleImage(Image.FromFile(item.P_Image), 80, 74);
}
catch (Exception)
{
}
pers.picStat.Image = Properties.Resources.green;
pers.picStat.Image = HelpMe.ScaleImage(Properties.Resources.green, 20, 18);
main.flowLayoutPanel1.Controls.Add(pers);
//f.Controls.Add(pers);
index++;
}
}
catch (Exception)
{
lblDurum.Text = "Persoonel silme başarısız";
}
}
private void cmbDep_SelectedIndexChanged(object sender, EventArgs e)
{
var id = (from a in ip.Departments where a.AuthName == cmbDep.SelectedItem select a.AuthID).FirstOrDefault();
var pers = from b in ip.PersonalInformations where b.Departman == id select b;
if (pers.Count() != 0)
{
cmbPers.DataSource = null;
cmbPers.Items.Clear();
foreach (var item in pers)
{
cmbPers.Items.Add(item.Name + " " + item.Surname);
}
cmbPers.SelectedIndex = 0;
}
else
{
cmbPers.DataSource = GetDbItems.GetPersonel();
}
}
private void btnOK_Click(object sender, EventArgs e)
{
try
{
bool result = PersonelProcess.AddPersonal(Guid.NewGuid(),
txtAdi.Text,
txtSoyadi.Text,
txtTelefon.Text,
txtTCNo.Text,
txtAdress.Text,
txtMailAdress.Text,
fileName,
(from a in _ip.Departments where a.AuthName == cmbDepartment.SelectedItem select a.AuthID).FirstOrDefault(),
txtUser.Text,
txtPassw.Text,
DateTime.Now,
false,
Convert.ToDateTime("1900-10-01 00:00:00.000")
);
if (result)
{
lblDurum.Text = "Kayıt başarılı";
cmbDepartment.DataSource = GetDbItems.GetDepartments();
cmbDep.DataSource = GetDbItems.GetDepartments();
cmbUpPers.DataSource = GetDbItems.GetPersonel();
cmbDelPers.DataSource = GetDbItems.GetPersonel();
MainForm main = (MainForm)Application.OpenForms["MainForm"];
main.flowLayoutPanel1.Controls.Clear();
int index = 0;
var personals = from a in _ip.PersonalInformations where a.IsDeleted == false select a;
// index = personals.Count();
// this.Location = new Point(Screen.FromPoint(this.Location).WorkingArea.Right - this.Width);
foreach (var item in personals)
{
Personal pers = new Personal();
pers.Tag = index;
pers.lblPersName.Text = item.Name + " " + item.Surname;
try
{
pers.picPers.Image = Image.FromFile(item.P_Image);
}
catch (Exception)
{
}
try
{
pers.picPers.Image = HelpMe.ScaleImage(Image.FromFile(item.P_Image), 80, 74);
}
catch (Exception)
{
}
pers.picStat.Image = Properties.Resources.green;
pers.picStat.Image = HelpMe.ScaleImage(Properties.Resources.green, 20, 18);
main.flowLayoutPanel1.Controls.Add(pers);
//f.Controls.Add(pers);
index++;
}
}
}
catch (Exception)
{
lblDurum.Text = "Kayıt başarısız";
}
}
private void Status_Load(object sender, EventArgs e)
{
cmbDep.DataSource = GetDbItems.GetDepartments();
cmbServices.DataSource = GetDbItems.GetMissions();
cmbPers.DataSource = GetDbItems.GetPersonel();
}
