/// <summary>
/// Insert
/// </summary>
public async Task <bool> Insert(SubcontractProfile.WebApi.Services.Model.SubcontractProfileEngineer subcontractProfileEngineer)
{
var p = new DynamicParameters();
p.Add("@engineer_id", subcontractProfileEngineer.EngineerId);
p.Add("@staff_code", subcontractProfileEngineer.StaffCode);
p.Add("@foa_code", subcontractProfileEngineer.FoaCode);
p.Add("@staff_name", subcontractProfileEngineer.StaffName);
p.Add("@staff_name_th", subcontractProfileEngineer.StaffNameTh);
p.Add("@staff_name_en", subcontractProfileEngineer.StaffNameEn);
p.Add("@asc_code", subcontractProfileEngineer.AscCode);
p.Add("@tshirt_size", subcontractProfileEngineer.TshirtSize);
p.Add("@contract_phone1", subcontractProfileEngineer.ContractPhone1);
p.Add("@contract_phone2", subcontractProfileEngineer.ContractPhone2);
p.Add("@contract_email", subcontractProfileEngineer.ContractEmail);
p.Add("@work_experience", subcontractProfileEngineer.WorkExperience);
p.Add("@work_experience_attach_file", subcontractProfileEngineer.WorkExperienceAttachFile);
p.Add("@work_type", subcontractProfileEngineer.WorkType);
p.Add("@course_skill", subcontractProfileEngineer.CourseSkill);
p.Add("@skill_level", subcontractProfileEngineer.SkillLevel);
p.Add("@vehicle_type", subcontractProfileEngineer.VehicleType);
p.Add("@vehicle_brand", subcontractProfileEngineer.VehicleBrand);
p.Add("@vehicle_serise", subcontractProfileEngineer.VehicleSerise);
p.Add("@vehicle_color", subcontractProfileEngineer.VehicleColor);
p.Add("@vehicle_year", subcontractProfileEngineer.VehicleYear);
p.Add("@vehicle_license_plate", subcontractProfileEngineer.VehicleLicensePlate);
p.Add("@vehicle_attach_file", subcontractProfileEngineer.VehicleAttachFile);
p.Add("@tool_otrd", subcontractProfileEngineer.ToolOtrd);
p.Add("@tool_splicing", subcontractProfileEngineer.ToolSplicing);
p.Add("@position", subcontractProfileEngineer.Position);
p.Add("@location_code", subcontractProfileEngineer.LocationCode);
p.Add("@staff_id", subcontractProfileEngineer.StaffId);
p.Add("@team_code", subcontractProfileEngineer.TeamCode);
p.Add("@citizen_id", subcontractProfileEngineer.CitizenId);
p.Add("@bank_code", subcontractProfileEngineer.BankCode);
p.Add("@bank_name", subcontractProfileEngineer.BankName);
p.Add("@account_no", subcontractProfileEngineer.AccountNo);
p.Add("@account_name", subcontractProfileEngineer.AccountName);
p.Add("@personal_attach_file", subcontractProfileEngineer.PersonalAttachFile);
p.Add("@staff_status", subcontractProfileEngineer.StaffStatus);
p.Add("@create_date", subcontractProfileEngineer.CreateDate);
p.Add("@create_by", subcontractProfileEngineer.CreateBy);
p.Add("@update_by", subcontractProfileEngineer.UpdateBy);
p.Add("@update_date", subcontractProfileEngineer.UpdateDate);
var ok = await _dbContext.Connection.ExecuteAsync
("uspSubcontractProfileEngineer_Insert", p, commandType : CommandType.StoredProcedure, transaction : _dbContext.Transaction);
return(true);
}
public Task <bool> Update(SubcontractProfile.WebApi.Services.Model.SubcontractProfileEngineer subcontractProfileEngineer)
{
_logger.LogInformation($"Start EngineerController::Update", subcontractProfileEngineer);
if (subcontractProfileEngineer == null)
{
_logger.LogWarning($"Start EngineerController::Update", subcontractProfileEngineer);
}
var result = _service.Update(subcontractProfileEngineer);
if (result == null)
{
_logger.LogWarning($"EngineerController::", "Update NOT FOUND", subcontractProfileEngineer);
}
return(result);
}
