public bool AddRoleForEmployee(int roleId, string personnelCode) { int?employeeId = db.Employees.Where(e => e.ProsonnelCode == personnelCode).Select(e => e.EmployeeId) .FirstOrDefault(); if (employeeId == null) { return(false); } try { db.EmployeeRoles.Add(new EmployeeRole() { EmployeeId = employeeId.Value, RoleId = roleId }); db.SaveChanges(); return(true); } catch { return(false); } }
public bool ImportDataFromExcelFile(string fileName) { try { string filePath = Path.Combine(Directory.GetCurrentDirectory(), "wwwroot/Data/", fileName); bool exists = Directory.Exists(filePath); List <ExcelFileViewModel> data = new List <ExcelFileViewModel>(); System.Text.Encoding.RegisterProvider(System.Text.CodePagesEncodingProvider.Instance); using (var stream = System.IO.File.Open(filePath, FileMode.Open, FileAccess.Read)) { using (var reader = ExcelReaderFactory.CreateReader(stream)) { reader.Read(); if (reader.GetValue(0).ToString() != "Personal Code") { return(false); } while (reader.Read()) { data.Add(new ExcelFileViewModel() { PersonalCode = reader.GetValue(0).ToString(), Name = reader.GetValue(1).ToString(), Family = reader.GetValue(2).ToString(), NationalCode = reader.GetValue(3).ToString(), CityId = int.Parse(reader.GetValue(4).ToString()) }); } } } foreach (var item in data) { db.Add(new Employee() { FullName = item.Name + " " + item.Family, CityId = item.CityId, NationalCode = item.NationalCode, ProsonnelCode = item.PersonalCode, FirstLogin = true, IsDelete = false, ChildCount = 0 }); } db.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public void Save() { db.SaveChanges(); }
public void ChangeBirthDayLimitation(Setting setting) { db.Settings.Update(setting); db.SaveChanges(); }