public GroceryKitViewModel AddGroceryKit(GroceryKitViewModel model)
{
try
{
model.IsValid = model.Validate();
if (model.IsValid)
{
//if (_bdmSvc.GroceryFormCodeExists(AppConstants.SITE_CODE, model.GroceryKit.GroceryKitCode))
//{
// model.FieldId = "groupCode";
// model.Message = string.Format(AppConstants.VALIDATION_ALREADY_EXISTS, "GroceryKit Code");
// model.IsValid = false;
//}
//if (model.IsValid)
{
model.Form.SiteCode = AppConstants.SITE_CODE;
//_grocerySvc.AddForm(model.Form);
model = RefreshGroceryKit();
model.Message = string.Format(AppConstants.CRUD_CREATE, "GroceryKit");
}
}
}
catch (Exception ex)
{
model.TranslateException(ex);
}
return model;
}
public GroceryKitViewModel GetAllGroceryKits()
{
var mod = new GroceryKitViewModel();
try
{
mod = RefreshGroceryKit();
}
catch (Exception ex)
{
mod.TranslateException(ex);
}
return mod;
}
public GroceryKitViewModel ModifyGroceryKit(FormDE mod)
{
GroceryKitViewModel model = new GroceryKitViewModel();
try
{
DBOperations op = mod.IsActive ? DBOperations.Update : DBOperations.Delete;
mod.SiteCode = AppConstants.SITE_CODE;
model.Form = mod;
model.IsValid = model.Validate();
if (model.IsValid)
{
//_bdmSvc.ModifyGroceryKit(mod);
model = RefreshGroceryKit();
model.Message = op == DBOperations.Update ? string.Format(AppConstants.CRUD_UPDATE, "GroceryKit") : string.Format(AppConstants.CRUD_DELETE, "GroceryKit");
}
}
catch (Exception ex)
{
model.TranslateException(ex);
if (ex.Message.Contains("Store update, insert, or delete statement affected an unexpected number of rows (0). Entities may have been modified or deleted since entities were loaded. See http://go.microsoft.com/fwlink/?LinkId=472540 for information on understanding and handling optimistic concurrency exceptions."))
{
model.IsActive = false;
model.Message = "Unable to modify ExpenseGroup Code";
}
}
return model;
}
//public GroceryKitDE GetGroceryKitsByExpenseGroup(string groupCode)
//{
// return _bdmSvc.GetGroceryKitByCode(AppConstants.SITE_CODE, groupCode);
//}
private GroceryKitViewModel RefreshGroceryKit()
{
GroceryKitViewModel model = new GroceryKitViewModel();
model.FieldId = "formNo";
model.Form = new FormDE();
//model.ExpenseGroups = _bdmSvc.GetAllExpenseGroups(AppConstants.SITE_CODE);
//model.GroceryKits = _grocerySvc.GetViewOfAllForms();
model.Occupations = _bdmSvc.GetAllOccupations();
model.MemberStatuses = _grocerySvc.GetAllMemberStatuses();
model.MedicalProblems = _grocerySvc.GetAllMedicalProblems();
return model;
}