public static void MoveSubcategory(MergeCategoriesModel model)
{
recordSubcategory subCat = db.recordSubcategories.Find(model.recordSubcategoryId_FROM);
int dossierId = (from c in db.recordCategories
join s in db.recordSubcategories on c.recordCategoryId equals s.recordCategoryId
where s.recordSubcategoryId == model.recordSubcategoryId_FROM
select c.dossierId).Single();
if (model.dossierId == dossierId)
{
subCat.recordCategoryId = model.recordCategoryId_TO;
db.Entry(subCat).State = EntityState.Modified;
db.SaveChanges();
}
}
public static void SetListExpenseSubcategories(int dossierId)
{
List <recordSubcategory> list = new List <recordSubcategory>();
//TODO: replace with a generic method with EF implememntation
ObjectResult <GetrecordSubcategoriesByDossierId_Result> listTmp = _context.GetrecordSubcategoriesByDossierId(dossierId);
foreach (var item in listTmp)
{
recordSubcategory expsc = new recordSubcategory();
expsc.recordCategoryId = item.recordCategoryId;
expsc.recordSubcategoryId = item.recordSubcategoryId;
expsc.description = item.description;
list.Add(expsc);
}
HttpContext.Current.Session["ListExpenseSubcategories" + dossierId] = list;
}
public int CreateSubCat(int categoryId,
string description)
{
//Check if it exists already
recordSubcategory subcat = db.recordSubcategories.Where(r => r.recordCategoryId == categoryId && r.description == description).FirstOrDefault();
if (subcat != null)
{
return(subcat.recordSubcategoryId);
}
subcat = new recordSubcategory();
subcat.recordCategoryId = categoryId;
subcat.description = description;
db.recordSubcategories.Add(subcat);
db.SaveChanges();
return(subcat.recordSubcategoryId);
}
private List <recordSubcategory> GetListExpenseSubcategories(int dossierId)
{
List <recordSubcategory> list = new List <recordSubcategory>();
ObjectResult <GetrecordSubcategoriesByDossierId_Result> listTmp = _context.GetrecordSubcategoriesByDossierId(dossierId);
//TODO: replace with a generic method with EF implememntation
//ObjectResult<GetrecordSubcategoriesByDossierId_Result> listTmp = _context.GetrecordSubcategoriesByDossierId(dossierId);
foreach (var item in listTmp)
{
recordSubcategory expsc = new recordSubcategory();
expsc.recordCategoryId = item.recordCategoryId;
expsc.recordSubcategoryId = item.recordSubcategoryId;
expsc.description = item.description;
list.Add(expsc);
}
return(list);
}
