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;
        }