public async Task UpdateAsync(EducationDegreeModel model)
{
var degree = await _repository.GetByIdAsync(model.DegreeId);
degree.DegreeName = model.DegreeName;
degree.DegreeNameThai = model.DegreeNameThai;
await _repository.UpdateAsync(degree);
}
public async Task <EducationDegreeModel> AddAsync(EducationDegreeModel model)
{
var degree = new MasterEducationDegree
{
DegreeName = model.DegreeName,
DegreeNameThai = model.DegreeNameThai
};
degree = await _repository.AddAsync(degree);
return(_mapper.Map <MasterEducationDegree, EducationDegreeModel>(degree));
}
public void Initialize()
{
GenderComboBox.DataSource = genders;
ExperinceYearsCounter.Minimum = 0;
using (var db = new SqlConnection(ConnectionManager.ConnectionString))
{
var cmd = new SqlCommand("SELECT * FROM dbo.EducationDegrees");
cmd.Connection = db;
db.Open();
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var item = new EducationDegreeModel()
{
Id = (int)reader["Id"],
EnName = (string)reader["EnName"],
ArName = (string)reader["ArName"],
};
EducationalDegreesComboBox.Items.Add(item);
}
reader.Close();
cmd = new SqlCommand("SELECT * FROM dbo.Projects");
cmd.Connection = db;
var projects = cmd.ExecuteReader();
while (projects.Read())
{
ProjectsComboBox.Items.Add(new ProjectModel()
{
Id = (Guid)projects["Id"],
ProjectName = (string)projects["ProjectName"]
});
}
projects.Close();
cmd = new SqlCommand("SELECT * FROM dbo.Roles");
cmd.Connection = db;
var roles = cmd.ExecuteReader();
while (roles.Read())
{
RolesCombobox.Items.Add(new RoleModel()
{
Id = (int)roles["Id"],
EnName = (string)roles["EnName"],
ArName = (string)roles["ArName"]
});
}
roles.Close();
}
}
public async Task <IActionResult> Create(DegreeEditViewModel model)
{
if (!ModelState.IsValid)
{
return(View());
}
var degree = new EducationDegreeModel
{
DegreeName = model.DegreeName,
DegreeNameThai = model.DegreeNameThai
};
await _degreeService.AddAsync(degree);
return(RedirectToAction(nameof(Index)));
}
