public MemberOutput MemberbyUsername(string username)
{
if (username == null || username.Trim() == "")
{
return(null);
}
C02_BIMstaff item = db.C02_BIMstaff.FirstOrDefault(s => s.Username == username);
if (item == null)
{
return(null);
}
MemberOutput member = new MemberOutput()
{
ID = item.BIMstaffID,
SoftName = item.Sortname,
UserName = item.Username,
Password = item.Password,
Department = item.Deparment,
UserType = item.UserType,
Image = item.Image,
UserStatus = item.UserStatus
};
return(member);
}
public MemberOutput MemberbyID(int id)
{
if (id < 0)
{
return(null);
}
C02_BIMstaff item = db.C02_BIMstaff.Find(id);
if (item == null)
{
return(null);
}
MemberOutput member = new MemberOutput()
{
ID = item.BIMstaffID,
SoftName = item.Sortname,
UserName = item.Username,
Password = item.Password,
Department = item.Deparment,
UserType = item.UserType,
Image = item.Image,
UserStatus = item.UserStatus
};
return(member);
}
public List <DuAnOutput> TimDuAnTheoMemIDStatus(int memberID, string projectState)
{
if (memberID < 0)
{
return(null);
}
C02_BIMstaff user = db.C02_BIMstaff.FirstOrDefault(s => s.BIMstaffID == memberID);
if (user == null)
{
return(null);
}
List <C01_DesignProject> listProject = db.C01_DesignProject.Where(s => s.BIM_staff == user.Sortname).ToList();
if (listProject == null || listProject.Count == 0)
{
return(null);
}
List <C01_DesignProject> items = listProject.Where(s => s.ProjectState == projectState).ToList();
if (items == null || items.Count == 0)
{
return(null);
}
List <DuAnOutput> lstproject = new List <DuAnOutput>();
foreach (C01_DesignProject item in items)
{
DuAnOutput da = new DuAnOutput();
da.MaDuAn = item.ProjectID;
da.TenDuAn = item.ProjectName;
da.BIMmember = item.BIM_staff;
da.BIMMEP = item.BIM_MEP_staff;
da.ProjectState = item.ProjectState;
da.ARCmodel = item.Modeling_ARC_main;
da.STRmodel = item.Modeling_STR;
da.MEPmodel = item.Modeling_MEP;
da.propjectStatus = item.ProjectStatus;
da.projectPhase = item.ProjectPhase;
da.projectScope = item.ProjectScope;
lstproject.Add(da);
}
;
items.Clear();
return(lstproject);
}
