public CommContracts.Department GetCurrentDepartment(int employeeID)
{
using (DAL.HisContext ctx = new DAL.HisContext())
{
var query = from u in ctx.EmployeeDepartmentHistorys
where u.EmployeeID == employeeID &&
!u.EndDate.HasValue
select u.Department;
if (query.Count() == 1)
{
DAL.Department department = query.First() as DAL.Department;
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <DAL.Department, CommContracts.Department>();
});
var mapper = config.CreateMapper();
CommContracts.Department temp = new CommContracts.Department();
temp = mapper.Map <CommContracts.Department>(department);
return(temp);
}
return(null);
}
}
public bool SaveDepartment(CommContracts.Department department)
{
using (DAL.HisContext ctx = new DAL.HisContext())
{
var config = new MapperConfiguration(cfg =>
{
cfg.CreateMap <CommContracts.Department, DAL.Department>();
});
var mapper = config.CreateMapper();
DAL.Department temp = new DAL.Department();
temp = mapper.Map <DAL.Department>(department);
ctx.Departments.Add(temp);
try
{
ctx.SaveChanges();
}
#pragma warning disable CS0168 // 声明了变量“ex”，但从未使用过
catch (Exception ex)
#pragma warning restore CS0168 // 声明了变量“ex”，但从未使用过
{
return(false);
}
}
return(true);
}
public void Add(Backend.Department d)
{
DB.Add(d);
DAL.Department temp = Change.DepartmentBackendToDal(d);
emartDataContext.Departments.InsertOnSubmit(temp);
emartDataContext.SubmitChanges();
}
public static DAL.Department DepartmentBackendToDal(Backend.Department d)
{
DAL.Department ans = new DAL.Department();
ans.ID = d.ID;
ans.name = d.name;
return(ans);
}
private void programNew_Load(object sender, EventArgs e)
{
DAL.Department dprtment = new DAL.Department();
cmbDepartment.DataSource = dprtment.Select().Tables[0];
cmbDepartment.DisplayMember = "name";
cmbDepartment.ValueMember = "id";
cmbDepartment.SelectedValue = -1;
this.MinimumSize = this.Size;
}
private void frmStudentNew_Load(object sender, EventArgs e)
{
DAL.Country country = new DAL.Country();
cmbCountry.DataSource = country.Select("Where id in (Select countryId from city)").Tables[0];
cmbCountry.DisplayMember = "name";
cmbCountry.ValueMember = "Id";
cmbCountry.SelectedValue = -1;
DAL.Department department = new DAL.Department();
cmbDepartment.DataSource = department.Select("Where id in (Select departmentId from program)").Tables[0];
cmbDepartment.DisplayMember = "name";
cmbDepartment.ValueMember = "Id";
cmbDepartment.SelectedValue = -1;
}
private void saveBtn_Click(object sender, EventArgs e)
{
int er = 0;
ep.Clear();
if (txtName.Text == "")
{
er++;
ep.SetError(txtName, "Name Required");
}
if (txtDescription.Text == "")
{
er++;
ep.SetError(txtDescription, "Description Required");
}
if (er == 0)
{
DAL.Department department = new DAL.Department();
department.Name = txtName.Text;
department.Description = txtDescription.Text;
if (department.Insert())
{
MessageBox.Show("Data Saved");
txtName.Text = "";
txtDescription.Text = "";
}
else
{
MessageBox.Show(department.Error);
}
}
}
