// GET: SubPractice/Edit/5
public ActionResult Edit(int?id)
{
SubPracticeModel uiPractice = new SubPracticeModel();
if (!id.HasValue)
{
DisplayWarningMessage("Looks like, the ID is missing in your request");
return(RedirectToAction("List"));
}
try
{
if (!subPracticeService.Exists(id.Value))
{
DisplayWarningMessage($"Sorry, We couldn't find the Competency with ID: {id.Value}");
return(RedirectToAction("List"));
}
InitializePageData();
ViewBag.PracticeListItems = (IEnumerable <SelectListItem>)Session["PracticeListItems"] ?? GetPracticesDropDownList();
SubPracticeDto practice = subPracticeService.GetByID(id.Value);
uiPractice = Mapper.Map <SubPracticeDto, SubPracticeModel>(practice);
}
catch (Exception exp)
{
DisplayReadErrorMessage(exp);
}
return(View(uiPractice));
}
public ActionResult Edit(SubPracticeModel subPractice)
{
try
{
InitializePageData();
ViewBag.PracticeListItems = (IEnumerable <SelectListItem>)Session["PracticeListItems"] ?? GetPracticesDropDownList();
if (ModelState.IsValid)
{
if (subPracticeService.Exists(subPractice.SubPracticeName, subPractice.SubPracticeID, subPractice.PracticeID))
{
DisplayWarningMessage($"The Competency Name '{subPractice.SubPracticeName}' is duplicate");
return(View(subPractice));
}
SubPracticeDto subPracticeDto = Mapper.Map <SubPracticeModel, SubPracticeDto>(subPractice);
subPracticeService.UpdateSubPractice(subPracticeDto);
DisplaySuccessMessage("Competency has been updated successfully");
Session["SelectedPracticeID"] = subPractice.PracticeID.ToString();
return(RedirectToAction("List"));
}
}
catch (Exception exp)
{
DisplayUpdateErrorMessage(exp);
}
return(View(subPractice));
}
public void Add(SubPracticeDto entity)
{
SubPractice subPractice = CreateBusinessEntity(entity, true);
Entities.Add(subPractice);
DataContext.Entry(subPractice).State = EntityState.Added;
DataContext.SaveChanges();
}
private void MigrateEntity(SubPracticeDto sourceEntity, SubPractice targetEntity)
{
targetEntity.PracticeID = sourceEntity.PracticeID;
targetEntity.SubPracticeName = sourceEntity.SubPracticeName;
targetEntity.ShortName = sourceEntity.ShortName;
targetEntity.SubPracticeID = sourceEntity.SubPracticeID;
targetEntity.ManagerID = sourceEntity.ManagerID;
targetEntity.UpdateTimeStamp(sourceEntity.LoggedInUserName);
}
public void Delete(SubPracticeDto entity)
{
SubPractice buzEntity = Entities.FirstOrDefault(e => e.SubPracticeID == entity.SubPracticeID);
buzEntity.IsDeleted = true;
Entities.Add(buzEntity);
buzEntity.UpdateTimeStamp(entity.LoggedInUserName);
DataContext.Entry(buzEntity).State = EntityState.Modified;
DataContext.SaveChanges();
}
public void Update(SubPracticeDto entity)
{
SubPractice buzEntity = Entities.FirstOrDefault(s => s.SubPracticeID == entity.SubPracticeID);
MigrateEntity(entity, buzEntity);
buzEntity.UpdateTimeStamp(entity.LoggedInUserName);
Entities.Add(buzEntity);
DataContext.Entry(buzEntity).State = EntityState.Modified;
DataContext.SaveChanges();
}
private SubPractice CreateBusinessEntity(SubPracticeDto subPracticeDto, bool isNewEntity = false)
{
SubPractice subPractice = new SubPractice
{
PracticeID = subPracticeDto.PracticeID,
SubPracticeName = subPracticeDto.SubPracticeName,
ShortName = subPracticeDto.ShortName,
SubPracticeID = subPracticeDto.SubPracticeID,
ManagerID = subPracticeDto.ManagerID
};
subPractice.UpdateTimeStamp(subPracticeDto.LoggedInUserName, true);
return(subPractice);
}
private void UploadButton_Click(object sender, EventArgs e)
{
if (empDataTable == null || (empDataTable != null && empDataTable.Rows.Count == 0))
{
MessageBox.Show("No data to upload");
return;
}
try
{
EmployeeRepository repository = new EmployeeRepository();
DropDownSubCategoryRepository subCategoryRepository = new DropDownSubCategoryRepository();
PracticeRepository practiceRepo = new PracticeRepository();
SubPracticeRepository subPracticeRepo = new SubPracticeRepository();
foreach (DataRow row in empDataTable.Rows)
{
try
{
if (repository.IsDuplicateEmployeeID(row["EmpID"].ToString().Trim()))
{
row["UploadStatus"] = "Failed";
row["StatusMessage"] = "Duplicate Employee ID";
continue;
}
if (repository.IsDuplicateName(row["FirstName"].ToString().Trim(), row["LastName"].ToString().Trim()))
{
row["UploadStatus"] = "Failed";
row["StatusMessage"] = "Duplicate Employee Name";
continue;
}
DropDownSubCategoryDto buType = subCategoryRepository.GetByName(row["BU"].ToString(), (int)CategoryType.BusinessUnit);
string empID = row["EmpID"].ToString();
string empType = "Permanent";
if (empID.StartsWith("CE"))
{
empType = "Contractor";
}
else if (empID.StartsWith("CI"))
{
empType = "Internship";
}
else if (empID.StartsWith("YTJ"))
{
empType = "Yet to Join";
}
DropDownSubCategoryDto employmentType = subCategoryRepository.GetByName(empType, (int)CategoryType.EmploymentType);
PracticeDto practiceDto = practiceRepo.GetByNameOrDefault(row["POD"].ToString());
SubPracticeDto subPracticeDto = subPracticeRepo.GetByName(row["Competency"].ToString(), practiceDto.PracticeID);
EmployeeDto entry = new EmployeeDto
{
BusinessUnitID = buType.SubCategoryID,
DateOfJoin = DateTime.Parse(row["DoJ"].ToString()),
EmployeeID = empID,
EmploymentTypeID = employmentType.SubCategoryID,
FirstName = row["FirstName"].ToString(),
LastName = row["LastName"].ToString(),
PracticeID = practiceDto.PracticeID,
PrimarySkills = row["PrimarySkills"].ToString(),
SecondarySkills = row["SecondarySkills"].ToString(),
SubPracticeID = subPracticeDto.SubPracticeID,
};
if (string.IsNullOrWhiteSpace(row["LWD"].ToString()) == false)
{
entry.LastWorkingDay = DateTime.Parse(row["LWD"].ToString());
}
repository.Add(entry);
row["UploadStatus"] = "Successfully Uploaded";
row["StatusMessage"] = "";
}
catch (Exception exp)
{
row["UploadStatus"] = "Failed";
row["StatusMessage"] = exp.Message;
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message);
}
}
public void UpdateSubPractice(SubPracticeDto subPractice)
{
repository.Update(subPractice);
}
public void DeleteSubPractice(SubPracticeDto subPractice)
{
repository.Delete(subPractice);
}
public void CreateSubPractice(SubPracticeDto subPractice)
{
repository.Add(subPractice);
}
