public void addTeacherFromExcel()
{
teacherDTO t = new teacherDTO();
StreamReader read = new StreamReader(@"d:\teachers.csv", Encoding.Default);
string str = read.ReadToEnd();
string[] arr = str.Split('\n');
for (int i = 0; i < arr.Length; i++)
{
int j = 0;
string[] arr1 = arr[i].Split(',');
t.id = arr1[j++];
t.NAME = arr1[j++];
t.telefone = arr1[j++];
t.code_instation = int.Parse(arr1[j++]);
teacherBL tBL = new teacherBL();
tBL.AddTeachers(t);
Console.WriteLine();
}
Console.ReadLine();
}
public List <teacherDTO> GetAllTeachers()
{
List <teachers> teachersList = teacherDAL.GetAllTeachers();
if (teachersList == null)
{
return(new List <teacherDTO>());
}
List <teacherDTO> teachersListDTO = new List <teacherDTO>();
teachersList.ForEach(x =>
{
teacherDTO t = new teacherDTO();
t.id = x.id;
t.NAME = x.NAME;
t.telefone = x.telefone;
t.code_instation = x.code_instation;
teachersListDTO.Add(t);
});
return(teachersListDTO);
}
public List <teacherDTO> GetTeachersByCodeInstatition(int id)
{
List <teachers> teachersList = teacherDAL.GetTeachersByCodeInstation(id);
if (teachersList == null)
{
return(new List <teacherDTO>());
}
List <teacherDTO> teacherDTOList = new List <teacherDTO>();
teachersList.ForEach(x =>
{
teacherDTO t = new teacherDTO();
t.code_instation = x.code_instation;
t.id = x.id;
t.NAME = x.NAME;
t.telefone = x.telefone;
teacherDTOList.Add(t);
});
return(teacherDTOList);
}
public void Put(teacherDTO teacherDTO)
{
teacherBL teacherListBL = new teacherBL();
teacherListBL.UpdateTeachers(teacherDTO);
}
public void Post(teacherDTO teacher)
{
teacherBL teacherListBL = new teacherBL();
teacherListBL.AddTeachers(teacher);
}
//עדכון
public void UpdateTeachers(teacherDTO teacher)
{
var teacherMapper = iMapper.Map <teacherDTO, teachers>(teacher);
teacherDAL.UpdateTeachers(teacherMapper);
}
public string AddTeachers(teacherDTO teacher)
{
var teacherMapper = iMapper.Map <teacherDTO, teachers>(teacher);
return(teacherDAL.AddTeachers(teacherMapper));
}