/// <summary>
/// Save
/// </summary>
/// <param name="categoryID">The category identifier</param>
/// <param name="year">Year</param>
/// <param name="userID">The user identifier</param>
/// <returns>ResponseStatusCodeHelper</returns>
private ResponseStatusCodeHelper Create(Guid categoryID, int year, Guid userID)
{
try
{
using (var _context = new TDHEntities())
{
using (var trans = _context.Database.BeginTransaction())
{
try
{
year = year * 100;
//Save in 12 months in a year
for (int i = 1; i <= 12; i++)
{
MN_CATEGORY_SETTING _md = new MN_CATEGORY_SETTING()
{
id = Guid.NewGuid(),
category_id = categoryID,
year_month = year + i,
percent_current = 0,
percent_setting = 0,
money_current = 0,
money_setting = 0,
create_by = userID,
create_date = DateTime.Now,
deleted = false
};
_context.MN_CATEGORY_SETTING.Add(_md);
_context.Entry(_md).State = EntityState.Added;
}
_context.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new ServiceException(FILE_NAME, "Create", userID, ex);
}
}
}
}
catch (ServiceException servicedEx)
{
throw servicedEx;
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "Create", userID, ex);
}
return(ResponseStatusCodeHelper.Success);
}
/// <summary>
/// Save
/// </summary>
/// <param name="model">List of setting model</param>
/// <param name="userID">The user identifier</param>
/// <returns>ResponseStatusCodeHelper</returns>
public ResponseStatusCodeHelper Save(List <CategorySettingModel> model, Guid userID)
{
try
{
using (var _context = new TDHEntities())
{
using (var trans = _context.Database.BeginTransaction())
{
try
{
foreach (var item in model)
{
MN_CATEGORY_SETTING _md = _context.MN_CATEGORY_SETTING.FirstOrDefault(m => m.id == item.ID && m.category_id == item.CategoryID);
_md.money_setting = item.MoneySetting;
_context.MN_CATEGORY_SETTING.Attach(_md);
_context.Entry(_md).State = EntityState.Modified;
}
_context.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
throw new ServiceException(FILE_NAME, "Save", userID, ex);
}
}
}
}
catch (ServiceException servicedEx)
{
throw servicedEx;
}
catch (Exception ex)
{
throw new ServiceException(FILE_NAME, "Save", userID, ex);
}
Notifier.Notification(userID, Message.UpdateSuccess, Notifier.TYPE.Success);
return(ResponseStatusCodeHelper.Success);
}
