private static CompanyTree GetItemFromReader(IDataReader dataReader)
{
CompanyTree objItem = new CompanyTree();
objItem.CompanyID = SqlHelper.GetInt(dataReader, "CompanyID");
objItem.WorkGroupID = SqlHelper.GetInt(dataReader, "WorkGroupID");
objItem.Description = SqlHelper.GetString(dataReader, "Description");
objItem.ParentWGID = SqlHelper.GetInt(dataReader, "ParentWGID");
objItem.SortOrder = SqlHelper.GetInt(dataReader, "SortOrder");
objItem.AccessRights = SqlHelper.GetSmallInt(dataReader, "AccessRights");
objItem.WaitTime = SqlHelper.GetInt(dataReader, "WaitTime");
objItem.BypassEscalation = SqlHelper.GetBoolean(dataReader, "BypassEscalation");
objItem.UseCalendarTime = SqlHelper.GetBoolean(dataReader, "UseCalendarTime");
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate");
objItem.ModifiedUser = SqlHelper.GetString(dataReader, "ModifiedUser");
objItem.ModifiedDate = SqlHelper.GetDateTime(dataReader, "ModifiedDate");
return(objItem);
}
public static CompanyTree UpdateItem(CompanyTree model)
{
int result = 0;
using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "CompanyTree_Update", CreateSqlParameter(model)))
{
while (reader.Read())
{
result = (int)reader[0];
}
}
return(GetItemByID(model.WorkGroupID, model.CompanyID));
}
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 CompanyTree GetItemByID(Int32 WorkGroupID, int CompanyID)
{
CompanyTree item = new CompanyTree();
var sqlParams = new SqlParameter[2];
sqlParams[0] = new SqlParameter("@WorkGroupID", WorkGroupID);
sqlParams[1] = new SqlParameter("@CompanyID", CompanyID);
using (var reader = SqlHelper.ExecuteReader("CompanyTree_GetByID", sqlParams))
{
while (reader.Read())
{
item = GetItemFromReader(reader);
}
}
return(item);
}
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);
}
private static SqlParameter[] CreateSqlParameter(CompanyTree model)
{
return(new SqlParameter[]
{
new SqlParameter("@CompanyID", model.CompanyID),
new SqlParameter("@WorkGroupID", model.WorkGroupID),
new SqlParameter("@Description", model.Description),
new SqlParameter("@ParentWGID", model.ParentWGID),
new SqlParameter("@SortOrder", model.SortOrder),
new SqlParameter("@AccessRights", model.AccessRights),
new SqlParameter("@WaitTime", model.WaitTime),
new SqlParameter("@BypassEscalation", model.BypassEscalation),
new SqlParameter("@UseCalendarTime", model.UseCalendarTime),
new SqlParameter("@CreatedUser", model.CreatedUser),
new SqlParameter("@CreatedDate", model.CreatedDate),
new SqlParameter("@ModifiedUser", model.ModifiedUser),
new SqlParameter("@ModifiedDate", model.ModifiedDate),
});
}
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);
}