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);
}
public CompanyTreeList()
{
ListGroup = new CompanyTreeCollection();
ListMember = new CompanyTreeMemberCollection();
}
