public ReturnValueRepo Create(int parentId, string name)
{
var result = new ReturnValueRepo();
var cat = InventoryDatabase.item_subtype.FirstOrDefault(s => s.subtype_name.Equals(name));
if (cat == null)
{
var newItemSubtype = new item_subtype {
subtype_parent_id = parentId, subtype_name = name
};
InventoryDatabase.item_subtype.Add(newItemSubtype);
if (InventoryDatabase.SaveChanges() > 0)
{
result.Param1 = newItemSubtype.subtype_id.ToString();
result.Success = true;
}
else
{
result.Message = "Error creating subtype!";
}
}
else
{
result.Message = "Subtype already exist!";
}
return(result);
}
public ReturnValueRepo CreateBrand(int itemSubType, string brandName, string description)
{
var result = new
ReturnValueRepo();
var newBrand = new brand
{
brand_parent_id = itemSubType,
brand_name = brandName,
brand_description = description
};
int commandResult = InventoryDatabase.Database.ExecuteSqlCommand(
@"INSERT INTO [dbo].[brand]
([brand_name]
,[brand_parent_id]
,[brand_description])
VALUES
({0}
,{1}
,{2})", brandName, itemSubType, description);
//InventoryDatabase.brands.Add(newBrand);
//if (InventoryDatabase.SaveChanges() > 0)
if (commandResult > 0)
{
result.Success = true;
result.Param1 = newBrand.brand_id.ToString();
}
return(result);
}
public ReturnValueRepo Delete(int id)
{
var result = new ReturnValueRepo();
var brand = InventoryDatabase.brands.FirstOrDefault(b => b.brand_id == id);
if (brand != null)
{
//InventoryDatabase.brands.Remove(brand);
try
{
//result.Success = (InventoryDatabase.SaveChanges() > 0);
int commandResult = InventoryDatabase.Database.ExecuteSqlCommand(@"DELETE FROM BRAND WHERE BRAND_ID = {0}", id);
result.Success = commandResult > 0;
}
catch (Exception ex)
{
result.Message = ex.Message;
result.Param1 = ex.InnerException.Message;
}
}
else
{
result.Message = "Does not exist";
}
return(result);
}
public ReturnValueRepo Create(string name)
{
var result = new ReturnValueRepo();
var cat = InventoryDatabase.item_type.FirstOrDefault(s => s.item_type_name.Equals(name));
if (cat == null)
{
var newCat = new item_type()
{
item_type_name = name
};
InventoryDatabase.item_type.Add(newCat);
if (InventoryDatabase.SaveChanges() > 0)
{
result.Success = true;
result.Param1 = newCat.item_type_id.ToString();
}
}
else
{
result.Message = "Type already exist!";
}
return(result);
}
public ReturnValueRepo DeleteSubType(int id)
{
var result = new ReturnValueRepo();
var subType = InventoryDatabase.item_subtype.FirstOrDefault(h => h.subtype_id == id);
if (subType != null)
{
InventoryDatabase.item_subtype.Remove(subType);
try
{
InventoryDatabase.SaveChanges();
result.Success = true;
}
catch (Exception ex)
{
result.Success = false;
result.Message = ex.Message;
result.Param1 = ex.InnerException != null ? ex.InnerException.Message : "";
}
}
return(result);
}
