private void btnSubmit_Click(object sender, EventArgs e)
{
if (ValidateOfNull())
{
using (MyJobEntities myJob = new MyJobEntities())
{
try
{
int[] idArray = (int[])cbRecommand.Tag;
var query = (from table in myJob.Reference
where table.ReferenceId == id
select table).SingleOrDefault();
if (DetectAddOrUpdate(id))
{
query.FirstName = txtFistName.Text;
query.LastName = txtLastName.Text;
query.Alias = txtAlias.Text;
query.Position = txtPosition.Text;
query.Email = txtEmail.Text;
query.EmployeeId = idArray[cbRecommand.SelectedIndex];
myJob.SaveChanges();
MessageBox.Show("updated Successfuly");
}
else
{
myJob.Reference.Add(new Reference {
FirstName = txtFistName.Text, LastName = txtLastName.Text, Alias = txtAlias.Text, Position = txtPosition.Text, Email = txtEmail.Text, EmployeeId = idArray[cbRecommand.SelectedIndex]
});
myJob.SaveChanges();
MessageBox.Show("added Successfuly");
}
ucReferenceTable.RefreshTable(1);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
{
MessageBox.Show("please fill all fileds");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (ValidateOfNull())
{
using (MyJobEntities myJob = new MyJobEntities())
{
try
{
int[] idArray = (int[])cbSkillOf.Tag;
var query = (from table in myJob.Skills
where table.SkillId == id
select table).SingleOrDefault();
if (DetectAddOrUpdate(id))
{
query.SkillName = txtSkillName.Text;
query.BriefDescription = rtbDescription.Text;
query.EmployeeId = idArray[cbSkillOf.SelectedIndex];
myJob.SaveChanges();
MessageBox.Show("updated Successfuly");
}
else
{
myJob.Skills.Add(new Skills {
SkillName = txtSkillName.Text, BriefDescription = rtbDescription.Text, EmployeeId = idArray[cbSkillOf.SelectedIndex]
});
myJob.SaveChanges();
MessageBox.Show("added Successfuly");
}
ucSkillsTable.RefreshTable(1);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
{
MessageBox.Show("please fill all fileds");
}
}
private void btnSubmit_Click(object sender, EventArgs e)
{
if (ValidateOfNull())
{
using (MyJobEntities myJob = new MyJobEntities())
{
try
{
var query = (from table in myJob.Employees
where table.EmployeeId == id
select table).SingleOrDefault();
if (DetectAddOrUpdate(id))
{
query.FirstName = txtFistName.Text;
query.LastName = txtLastName.Text;
query.Alias = txtAlias.Text;
query.Email = txtEmail.Text;
myJob.SaveChanges();
MessageBox.Show("updated Successfuly");
}
else
{
myJob.Employees.Add(new Employees {
FirstName = txtFistName.Text, LastName = txtLastName.Text, Alias = txtAlias.Text, Email = txtEmail.Text
});
myJob.SaveChanges();
MessageBox.Show("added Successfuly");
}
ucEmployeesTable.RefreshTable(1);
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
else
{
MessageBox.Show("please fill all fields");
}
}
private void DeleteById(int id)
{
using (MyJobEntities myJob = new MyJobEntities())
{
try
{
var query = (from table in myJob.Reference
where table.ReferenceId == id
select table).SingleOrDefault();
myJob.Reference.Remove(query);
myJob.SaveChanges();
MessageBox.Show("Deleting is done");
ucReferenceTable.RefreshTable(1);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
