public static List <PersonalModel> Select(string departments)
{
SaovietCheckInEntities db = new SaovietCheckInEntities();
List <PersonalModel> personalList = new List <PersonalModel>();
foreach (string department in departments.Split(','))
{
var @Department = new SqlParameter("@Department", department);
personalList.AddRange(db.ExecuteStoreQuery <PersonalModel>("EXEC sp_c_SelectPersonalByDepartment @Department", @Department).ToList());
}
return(personalList);
}
public static List <SourceModel> Select(string departments, DateTime date)
{
SaovietCheckInEntities db = new SaovietCheckInEntities();
List <SourceModel> sourceList = new List <SourceModel>();
foreach (string department in departments.Split(','))
{
var @Line = new SqlParameter("@Line", department);
var @Date = new SqlParameter("@Date", date);
sourceList.AddRange(db.ExecuteStoreQuery <SourceModel>("EXEC sp_c_SelectSourceByLineDate @Line, @Date", @Line, @Date).ToList());
}
return(sourceList);
}
public static List <SectionModel> Select()
{
SaovietCheckInEntities db = new SaovietCheckInEntities();
return(db.ExecuteStoreQuery <SectionModel>("EXEC spm_SelectSection").ToList());
}
public static List <PersonalModel> Select()
{
SaovietCheckInEntities db = new SaovietCheckInEntities();
return(db.ExecuteStoreQuery <PersonalModel>("EXEC sp_c_SelectPersonal").ToList());
}
public static List <LineModel> SelectAll()
{
SaovietCheckInEntities db = new SaovietCheckInEntities();
return(db.ExecuteStoreQuery <LineModel>("EXEC spm_SelectAllLine").ToList());
}
