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