public static CompanyTreeCollection GetbyUser(string CreatedUser) { CompanyTreeCollection collection = new CompanyTreeCollection(); CompanyTree obj; using (var reader = SqlHelper.ExecuteReader("CompanyTree_GetAll_byUser", new SqlParameter("@CreatedUser", CreatedUser))) { while (reader.Read()) { obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static CompanyTreeCollection Search(SearchFilter SearchKey) { CompanyTreeCollection collection = new CompanyTreeCollection(); using (var reader = SqlHelper.ExecuteReader("CompanyTree_Search", SearchFilterManager.SqlSearchParam(SearchKey))) { while (reader.Read()) { CompanyTree obj = new CompanyTree(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static CompanyTreeCollection GetAllItem(int CompanyID) { CompanyTreeCollection collection = new CompanyTreeCollection(); var sqlParams = new SqlParameter[1]; sqlParams[0] = new SqlParameter("@CompanyID", CompanyID); using (var reader = SqlHelper.ExecuteReader("CompanyTree_GetAll", sqlParams)) { while (reader.Read()) { CompanyTree obj = new CompanyTree(); obj = GetItemFromReader(reader); collection.Add(obj); } } return(collection); }
public static int CreateOrUpdate(CompanyTreeList model) { CompanyTreeCollection result = new CompanyTreeCollection(); if (model.ListGroup.Count > 0) { foreach (var item in model.ListGroup) { CompanyTree b = new CompanyTree(); if (item.WorkGroupID == 0) { b = AddItem(item); } else { b = UpdateItem(item); } result.Add(b); } } if (model.ListMember.Count > 0) { foreach (var item in model.ListMember) { //int workGroupID = result[item.WorkGroupID].WorkGroupID; //item.WorkGroupID = workGroupID; CompanyTreeMember b = new CompanyTreeMember(); var memberGroup = CompanyTreeMemberManager.GetItemByID(item.WorkGroupID, item.CompanyID, item.EmployeeID); if (string.IsNullOrEmpty(memberGroup.EmployeeID)) { b = CompanyTreeMemberManager.AddItem(item); } else { b = CompanyTreeMemberManager.UpdateItem(item); } } } return(1); }