public List <InventoryItemCategoryEntity> GetInventoryItemsCategory(string connectionString)
{
List <InventoryItemCategoryEntity> listInventoryCategory = new List <InventoryItemCategoryEntity>();
using (var context = new MISAEntity(connectionString))
{
var categories = context.InventoryItemCategories.ToList().OrderBy(x => x.Grade);
foreach (var result in categories)
{
var inventoryItemCategory = new InventoryItemCategoryEntity();
inventoryItemCategory.InventoryItemCategoryId = result.InventoryCategoryID.ToString();
inventoryItemCategory.InventoryItemCategoryCode = result.InventoryCategoryCode;
inventoryItemCategory.InventoryItemCategoryName = result.InventoryCategoryName;
inventoryItemCategory.ParentId = result.ParentID.ToString();
inventoryItemCategory.Grade = result.Grade;
inventoryItemCategory.IsParent = result.IsParent;
inventoryItemCategory.IsTool = result.IsTool;
inventoryItemCategory.IsSystem = result.IsSystem;
inventoryItemCategory.IsActive = result.Inactive == true ?false:true;
listInventoryCategory.Add(inventoryItemCategory);
}
}
return(listInventoryCategory);
}
/// <summary>
/// Inserts the account category.
/// </summary>
/// <param name="inventoryItemEntity">The account category entity.</param>
/// <returns>InventoryItemCategoryResponse.</returns>
public InventoryItemCategoryResponse InsertInventoryItemCategory(InventoryItemCategoryEntity inventoryItemEntity)
{
var response = new InventoryItemCategoryResponse {
Acknowledge = AcknowledgeType.Success
};
try
{
if (!inventoryItemEntity.Validate())
{
foreach (string error in inventoryItemEntity.ValidationErrors)
{
response.Message += error + Environment.NewLine;
}
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
//inventoryItemEntity.InventoryItemCategoryId = InventoryItemCategoryDao.InsertInventoryItemCategory(inventoryItemEntity);
if (!string.IsNullOrEmpty(response.Message))
{
response.Acknowledge = AcknowledgeType.Failure;
return(response);
}
response.InventoryItemCategoryId = inventoryItemEntity.InventoryItemCategoryId;
return(response);
}
catch (Exception ex)
{
response.Acknowledge = AcknowledgeType.Failure;
response.Message = ex.Message;
return(response);
}
}
private object[] Take(InventoryItemCategoryEntity inventoryItemCategory)
{
return(new object[]
{
"@InventoryItemCategoryID", inventoryItemCategory.InventoryItemCategoryId,
"@InventoryItemCategoryCode", inventoryItemCategory.InventoryItemCategoryCode,
"@InventoryItemCategoryName", inventoryItemCategory.InventoryItemCategoryName,
"@Grade", inventoryItemCategory.Grade,
"@ParentID", inventoryItemCategory.ParentId,
"@IsParent", inventoryItemCategory.IsParent,
"@IsSystem", inventoryItemCategory.IsSystem,
"@IsTool", inventoryItemCategory.IsTool,
"@IsActive", inventoryItemCategory.IsActive
});
}
public string InsertInventoryItemCategory(InventoryItemCategoryEntity inventoryItemCategory)
{
const string sql = @"uspInsert_InventoryItemCategory";
return(Db.Insert(sql, true, Take(inventoryItemCategory)));
}
