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