public EmployeeCoreViewModel GetAllEmployeeCores()
{
var mod = new EmployeeCoreViewModel();
mod.IsValid = true;
try
{
mod.EmployeeCores = _bdmSvc.GetViewOfAllEmployees(AppConstants.SITE_CODE).Where(m => m.IsActive = true).ToList();
}
catch (Exception ex)
{
mod.IsValid = false;
mod.Message = ex.Message;
}
return mod;
}
public EmployeeCoreViewModel ModifyEmployeeCore(EmployeeCoreBE mod)
{
EmployeeCoreViewModel model = new EmployeeCoreViewModel();
try
{
DBOperations op = mod.IsActive ? DBOperations.Update : DBOperations.Delete;
mod.SiteCode = AppConstants.SITE_CODE;
model.EmployeeCore = mod;
model.IsValid = model.Validate();
if (op == DBOperations.Delete || model.IsValid)
{
//_bdmSvc.ModifyEntity(mod);
_bdmSvc.ModifyEmployee(mod);
model.FieldId = "EmployeeCoreName";
model.EmployeeCore = new EmployeeCoreBE();
model.EmployeeCores = _bdmSvc.GetViewOfAllEmployees(AppConstants.SITE_CODE).Where(m => m.IsActive = true).ToList();
model.Message = op == DBOperations.Update ? string.Format(AppConstants.CRUD_UPDATE, "Employee Name") : string.Format(AppConstants.CRUD_DELETE, "Employee Name");
}
}
catch (Exception ex)
{
model.IsValid = false;
model.Message = ex.Message;
if (ex.Message.Contains("Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=472540 for information on understanding and handling optimistic concurrency exceptions."))
model.Message = "Unable to modify Region Code";
}
return model;
}
public EmployeeCoreViewModel AddEmployeeCore(EmployeeCoreViewModel model)
{
try
{
model.IsValid = model.Validate();
if (model.IsValid)
{
//if (_bdmSvc.CityCodeExists(AppConstants.SITE_CODE, model.City.CityCode))
//{
// model.FieldId = "cityCode";
// model.Message = string.Format(AppConstants.VALIDATION_ALREADY_EXISTS, "City Code");
// model.IsValid = false;
//}
//if (model.IsValid)
//{
model.EmployeeCore.SiteCode = AppConstants.SITE_CODE;
//model.EmployeeCore.EntityTypeCode = EntityTypeCodes.GFT.ToString();
_bdmSvc.AddEmployee(model.EmployeeCore);
model.FieldId = "vchNo";
model.EmployeeCore = new EmployeeCoreBE();
model.EmployeeCores = _bdmSvc.GetViewOfAllEmployees(AppConstants.SITE_CODE).Where(m => m.IsActive = true).ToList(); //.GetViewOfAllEmployeeCores(AppConstants.SITE_CODE);
model.Message = string.Format(AppConstants.CRUD_CREATE, "Employee Core");
//}
}
}
catch (Exception ex)
{
model.IsValid = false;
model.Message = ex.Message;
}
return model;
}