public static UserPlant Map(IRepository <eSuiteDbContext> repository, SqlDataReader dr)
{
var entity = new UserPlant();
entity.UserId = LookUpUser(repository, Convert.ToString(dr["U_Login_Id"]));
entity.PlantId = Lookups.LookUpPlant(repository, Convert.ToString(dr["cif"]));
return(entity);
}
public static Organization Map(IRepository <eSuiteDbContext> repository, SqlDataReader dr)
{
// lookup xref => lookup by name if not found
var parentId = Lookups.LookUpXref(repository, Convert.ToInt32(dr["WS_DeptID"]), "Department");
if (parentId == default(int))
{
return(null);
}
var entity = new Organization();
entity.IsDeleted = !Convert.ToBoolean(dr["WS_Active"]);
entity.Name = Convert.ToString(dr["WS_Name"]);
entity.ParentId = parentId;
entity.Type = OrganizationLevelType.Workshop;
return(entity);
}
public static Organization Map(IRepository <eSuiteDbContext> repository, SqlDataReader dr)
{
// lookup plant by in plant table by plant name
var plantId = Lookups.LookUpPlant(repository, Convert.ToString(dr["cif"]));
if (plantId == default(int))
{
return(null);
}
var entity = new Organization();
entity.IsDeleted = !Convert.ToBoolean(dr["DEPT_Active"]);
entity.Name = Convert.ToString(dr["DEPT_Department_Name"]);
entity.PlantId = plantId;
entity.Type = OrganizationLevelType.Department;
return(entity);
}
