public async Task <ActionResult> Edit(SkillMaster skillmaster)
{
InitializeServiceClient();
try
{
if (ModelState.IsValid)
{
SkillRequest skillReq = new SkillRequest();
skillReq.ClientInfo = req.ClientInfo;
skillReq.SkillDetails = skillmaster;
HttpResponseMessage response = await client.PostAsJsonAsync("Skill/UpdateSkill", skillReq);
bool result = await response.Content.ReadAsAsync <bool>();
ViewBag.Success = true;
}
}
catch (Exception ex)
{
//UserManager user = (UserManager)Session["CurrentUser"];
//LogHelper.AddLog("SkillMasterController", ex.Message, ex.StackTrace, "HCL.Academy.Web", user.EmailID);
TelemetryClient telemetry = new TelemetryClient();
telemetry.TrackException(ex);
}
return(View(skillmaster));
}
public SkillMaster GetSkillMasterRecord(string recordID, string UserID)
{
SkillMaster skillMaster = new SkillMaster();
SqlDataReader dr = null;
try
{
SqlParameter[] Parameters = { new SqlParameter("@SNo", recordID), new SqlParameter("@UserID", Convert.ToInt32(UserID)) };
dr = SqlHelper.ExecuteReader(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordSkillMaster", Parameters);
if (dr.Read())
{
skillMaster.SNo = Convert.ToInt32(dr["SNo"]);
skillMaster.Name = Convert.ToString(dr["Name"]);
// skillMaster.Hierarchy = Convert.ToString(dr["Hierarchy"]);
skillMaster.CreatedOn = Convert.ToString(dr["CreatedOn"]);
skillMaster.CreatedBy = Convert.ToString(dr["CreatedBy"]);
skillMaster.UpdatedBy = Convert.ToString(dr["UpdatedBy"]);
skillMaster.UpdatedOn = Convert.ToString(dr["UpdatedOn"]);
skillMaster.IsActive = Convert.ToBoolean(dr["IsActive"]);
skillMaster.Active = Convert.ToString(dr["Active"]);
}
}
catch (Exception ex)// (Exception ex)
{
dr.Close();
}
return(skillMaster);
}
protected void CreateParticle(SkillMaster skill, Vector3 startPosition)
{
var particlePrefab = skill.particle.particlePrefab;
var parent = ParticleManager.I.transform;
var particle = Instantiate(particlePrefab, parent);
particle.transform.localPosition = startPosition;
particle.Play();
}
public async Task <IActionResult> PutEmployeeSkill(int id, EmployeeSkillDTO employeeSkillDto)
{
//if (id != employeeSkill.pkAuto)
//{
// return BadRequest();
//}
EmployeeSkill empSkill = await _context.EmployeeSkill.Where(d => d.empId.empId == employeeSkillDto.empId && d.SkillId.skillId == employeeSkillDto.SkillId)
.Select(d => d).FirstOrDefaultAsync();
//var employeeSkill = await _context.EmployeeSkill.FindAsync(id);
EmployeeInfo emp = await _context.EmployeeInfo.FindAsync(employeeSkillDto.empId);
SkillMaster skill = await _context.SkillMaster.FindAsync(employeeSkillDto.SkillId);
if (emp == null || skill == null)
{
return(NotFound());
}
empSkill.empId = emp;
empSkill.SkillId = skill;
empSkill.pkAuto = empSkill.pkAuto;
empSkill.primary = employeeSkillDto.primary;
empSkill.empId = emp;
empSkill.empName = employeeSkillDto.empName;
empSkill.rating = employeeSkillDto.rating;
empSkill.hccOrganization = employeeSkillDto.hccOrganization;
empSkill.grade = employeeSkillDto.grade;
empSkill.lastUpdatedDate = employeeSkillDto.lastUpdatedDate;
empSkill.skillStartDate = employeeSkillDto.skillStartDate;
empSkill.skillEndDate = employeeSkillDto.skillEndDate;
empSkill.group = employeeSkillDto.group;
empSkill.skillType = employeeSkillDto.skillType;
empSkill.approvedBy = employeeSkillDto.approvedBy;
empSkill.approvedDate = employeeSkillDto.approvedDate;
empSkill.SkillId = skill;
empSkill.approvalStatus = employeeSkillDto.approvalStatus;
// _context.Entry(empSkill).State = EntityState.Modified;
_context.MarkAsModified(empSkill);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
return(NotFound());
}
return(NoContent());
}
public void Setup(Chara.ICharaController chara, SkillMaster skill, Map.SearchResult result)
{
_chara = chara;
_skill = skill;
_searchResult = result;
// ターゲットの方を向く
chara.Model.SetDirection(result.Dir.ToVec2Int());
_impl = _diContainer.Instantiate <SkillCreateImpl>();
_impl.Setup(chara, skill, _searchResult);
}
public async Task <ActionResult <EmployeeSkill> > PostEmployeeSkill(EmpSkillPostDTO empSkillPostDTO)
{
EmployeeInfo emp = await _context.EmployeeInfo.FindAsync(Convert.ToInt32(empSkillPostDTO.empId));
SkillMaster skill = await _context.SkillMaster.FindAsync(Convert.ToInt32(empSkillPostDTO.SkillId));
if (emp == null || skill == null)
{
return(NotFound());
}
var check = await _context.EmployeeSkill.Where(e => e.empId.empId == Convert.ToInt32(empSkillPostDTO.empId) && e.SkillId.skillId == Convert.ToInt32(empSkillPostDTO.SkillId)).Select(e => e).FirstOrDefaultAsync();
if (check != null)
{
return(BadRequest("Skill already exists !!"));
}
EmployeeSkill empSkill = new EmployeeSkill();
empSkill.primary = Convert.ToInt32(empSkillPostDTO.primary);
empSkill.empId = emp;
empSkill.empName = emp.empName;
empSkill.rating = Convert.ToInt32(empSkillPostDTO.rating);
empSkill.hccOrganization = emp.hccOrganization;
empSkill.grade = emp.grade;
empSkill.lastUpdatedDate = DateTime.Now;
empSkill.skillStartDate = Convert.ToDateTime(empSkillPostDTO.skillStartDate);
empSkill.skillEndDate = Convert.ToDateTime(empSkillPostDTO.skillEndDate);
empSkill.group = empSkillPostDTO.group;
empSkill.skillType = empSkillPostDTO.skillType;
empSkill.approvedBy = null;
empSkill.approvedDate = null;
empSkill.SkillId = skill;
//empSkill.approvalStatus = Convert.ToInt32(empSkillPostDTO.approvalStatus);
empSkill.approvalStatus = 0;
_context.EmployeeSkill.Add(empSkill);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetEmployeeSkill", new { id = empSkill.pkAuto }, empSkillPostDTO));
}
// Start is called before the first frame update
void Start()
{
if (Instance != null && Instance != this)
{
Destroy(this.gameObject);
}
else
{
Instance = this;
}
//Store everyone's skills in this skill master
DontDestroyOnLoad(this);
playerSkills = skillMaster.AddComponent <SkillManager>();
}
public SkillMaster GetSkillById(RequestBase req, int id)
{
SkillMaster response = new SkillMaster();
try
{
SqlSvrDAL dal = new SqlSvrDAL(req.ClientInfo);
response = dal.GetSkillById(id);
}
catch (Exception ex)
{
//LogHelper.AddLog("SkillController,GetSkillById", ex.Message, ex.StackTrace, "HCL.Academy.Service", req.ClientInfo.emailId);
TelemetryClient telemetry = new TelemetryClient();
telemetry.TrackException(ex);
}
return(response);
}
// GET: SkillMaster/Edit/5
public async Task <ActionResult> Edit(int Id)
{
InitializeServiceClient();
SkillMaster skillmaster = new SkillMaster();
try
{
HttpResponseMessage response = await client.PostAsJsonAsync("Skill/GetSkillById/" + Id.ToString(), req);
skillmaster = await response.Content.ReadAsAsync <SkillMaster>();
}
catch (Exception ex)
{
// LogHelper.AddLog("SkillMasterController", ex.Message, ex.StackTrace, "HCL.Academy.Web", user.EmailID);
TelemetryClient telemetry = new TelemetryClient();
telemetry.TrackException(ex);
}
return(View(skillmaster));
}
public async Task <ActionResult <EmployeeSkill> > GetEmployeeSkill(int id, [FromQuery] EmpIdSkillIdDto es)
{
EmployeeSkill empSkill = await _context.EmployeeSkill.Where(d => d.empId.empId == es.empId && d.SkillId.skillId == es.skillId)
.Select(d => d)
.FirstOrDefaultAsync();
//var employeeSkill = await _context.EmployeeSkill.FindAsync(id);
EmployeeInfo emp = await _context.EmployeeInfo.FindAsync(es.empId);
SkillMaster skill = await _context.SkillMaster.FindAsync(es.skillId);
empSkill.empId = emp;
empSkill.SkillId = skill;
if (empSkill == null)
{
return(NotFound());
}
return(empSkill);
}
public async Task <IActionResult> PutEmployeeSkill(EmpSkillPostDTO empSkillPostDTO)
{
EmployeeSkill empSkill = await _context.EmployeeSkill.Where(d => d.empId.empId == Convert.ToInt32(empSkillPostDTO.empId) && d.SkillId.skillId == Convert.ToInt32(empSkillPostDTO.SkillId))
.Select(d => d).FirstOrDefaultAsync();
EmployeeInfo emp = await _context.EmployeeInfo.FindAsync(Convert.ToInt32(empSkillPostDTO.empId));
SkillMaster skill = await _context.SkillMaster.FindAsync(Convert.ToInt32(empSkillPostDTO.SkillId));
if (empSkill == null || emp == null || skill == null)
{
_log4net.Fatal(DateTime.Today.Date + "; Input = " + empSkillPostDTO.empId + "; Controller: EmployeeSkillsController" + "; Exception: Given details of Emp_Skill does not exist");
return(NotFound());
}
empSkill.empId = emp;
empSkill.SkillId = skill;
empSkill.pkAuto = empSkill.pkAuto;
empSkill.primary = Convert.ToInt32(empSkillPostDTO.primary);
empSkill.empId = emp;
empSkill.rating = Convert.ToInt32(empSkillPostDTO.rating);
empSkill.lastUpdatedDate = DateTime.Now;
empSkill.skillStartDate = empSkillPostDTO.skillStartDate;
empSkill.skillEndDate = empSkillPostDTO.skillEndDate;
empSkill.group = empSkillPostDTO.group;
empSkill.skillType = empSkillPostDTO.skillType;
empSkill.SkillId = skill;
empSkill.approvalStatus = 0;
// _context.Entry(empSkill).State = EntityState.Modified;
_context.MarkAsModified(empSkill);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
return(NotFound());
}
return(NoContent());
}
public void Setup(Chara.ICharaController chara, SkillMaster skill)
{
Setup(chara, skill, null);
}
public void Setup(Chara.ICharaController chara, SkillMaster skill, Map.SearchResult result)
{
_chara = chara;
_skill = skill;
_searchResult = result;
}
