public void ItemGroupViewModel_CreateItemGroupCommand_ValidNameAndNoParent_ItemGroupIsCreated()
{
_iut = new ItemGroupViewModel(_db, _mb);
_iut.ItemGroupName = "Step7NewItemGroup";
_iut.CreateItemGroupCommand.Execute(null);
Assert.That(_db.TableItemGroup.SearchItemGroups("Step7NewItemGroup").Count, Is.EqualTo(1));
}
public EditItemGroupDialog(ItemGroupViewModel view)
{
InitializeComponent();
ViewModel = view;
DataContext = ViewModel;
ViewModel.UpdateItemGroupName();
}
public JsonResult GETJSON()
{
var model = new ItemGroupViewModel(HttpContext);
model.ItemGroups = dbContext.ItemGroups.ToList();
return(Json(model));
}
public IActionResult Index()
{
var model = new ItemGroupViewModel(HttpContext);
model.ItemGroups = dbContext.ItemGroups.ToList();
return(View("Index", model));
}
public AddItemGroupDialog(ItemGroupViewModel view)
{
InitializeComponent();
DataContext = view;
view.ComboBoxIndex = -1;
ItemGroupComboBox.DisplayMemberPath = "ItemGroupName";
}
public ActionResult UpdateItem(ItemGroupViewModel IGViewModel, string value)
{
UserSession user = (UserSession)Session["User"];
bool result;
string PageAction = "Update";
if (IGViewModel.ItemName == null || IGViewModel.ItemName.Equals("") || value != null)
{
PageAction = "Delete item";
result = ItemGroupManager.DeleteItem(int.Parse(value));
}
else
{
PageAction = "Add item";
result = ItemGroupManager.UpdateGroup(IGViewModel);
}
if (result)
{
TempData["SuccessMessage"] = PageAction + " successful";
new AuditLogManager().Audit(user.Username, DateTime.Now, "Raw Item Group", PageAction, IGViewModel.GroupId.ToString(), IGViewModel.GroupName);
}
else
{
TempData["ErrorMessage"] = PageAction + " failed";
}
return(RedirectToAction("Index"));
}
public void ItemGroupViewModel_DeleteItemGroupCommand_InvalidItemGroupSelected_ItemGroupIsNotDeleted()
{
_db.TableItemGroup.CreateItemGroup("Step7DeleteThisItemGroup");
_iut = new ItemGroupViewModel(_db, _mb);
_iut.DeleteItemGroupCommand.Execute(null);
Assert.That(_db.TableItemGroup.SearchItemGroups("Step7DeleteThisItemGroup").Count, Is.EqualTo(1));
}
public void ItemGroupViewModel_CreateItemGroupCommand_InvalidNameGiven_NoItemGroupCreated()
{
_iut = new ItemGroupViewModel(_db, _mb)
{
ItemGroupName = "!Step7!"
};
_iut.CreateItemGroupCommand.Execute(null);
Assert.That(_db.TableItemGroup.SearchItemGroups("!Step7!").Count, Is.EqualTo(0));
}
public void ItemGroupViewModel_SearchCommand_SearchInvalidItemGroup_ItemGroupNotFound()
{
_iut = new ItemGroupViewModel(_db, _mb);
_iut.SearchString = "Step7SearchTest";
_iut.SearchCommand.Execute(null);
Assert.That(_iut.ListOfItemGroups.Count, Is.EqualTo(0));
}
public void SetUp()
{
_dbFactory = Substitute.For <IStoreDatabaseFactory>();
_db = Substitute.For <IDatabaseService>();
_mb = Substitute.For <IMessageBox>();
List <ItemGroup> testList = new List <ItemGroup>();
testList.Add(new ItemGroup("test", 0, 0));
_db.TableItemGroup.SearchItemGroups(Arg.Any <string>())
.Returns(testList);
_uut = new ItemGroupViewModel(_db, _mb);
}
public void ItemGroupViewModel_DeleteItemGroupCommand_ValidItemGroupSelected_ItemGroupIsDeleted()
{
_db.TableItemGroup.CreateItemGroup("Step7DeleteThisItemGroup");
_iut = new ItemGroupViewModel(_db, _mb);
List <ItemGroup> temp = _iut.ListOfItemGroups.ToList();
_iut.ListOfItemGroups.CurrentIndex = temp.FindIndex(x => x.ItemGroupName == "Step7DeleteThisItemGroup");
_iut.DeleteItemGroupCommand.Execute(null);
Assert.That(_db.TableItemGroup.SearchItemGroups("Step7DeleteThisItemGroup").Count, Is.EqualTo(0));
}
public void ItemGroupViewModel_SearchCommand_SearchValidItemGroup_ItemGroupFound()
{
_db.TableItemGroup.CreateItemGroup("Step7SearchTest");
_iut = new ItemGroupViewModel(_db, _mb);
_iut.SearchString = "Step7SearchTest";
_iut.SearchCommand.Execute(null);
Assert.That(_iut.ListOfItemGroups.Count, Is.EqualTo(1));
}
public void ItemGroupViewModel_EditItemGroupCommand_ItemIsEdited()
{
_db.TableItemGroup.CreateItemGroup("Step7IntegrationTest");
_iut = new ItemGroupViewModel(_db, _mb);
List <ItemGroup> temp = _iut.ListOfItemGroups.ToList();
_iut.ListOfItemGroups.CurrentIndex = temp.FindIndex(x => x.ItemGroupName == "Step7IntegrationTest");
_iut.ItemGroupName = "EditedStep7IntegrationTest";
_iut.UpdateItemGroupName();
_iut.EditItemGroupCommand.Execute(null);
Assert.That(_db.TableItemGroup.SearchItemGroups("EditedStep7IntegrationTest").Count, Is.EqualTo(1));
}
public static List <ItemGroupViewModel> GetGroup(ItemGroupViewModel IGViewModel)
{
using (CFMMCDEntities db = new CFMMCDEntities())
{
List <ITMGRP> IGRows;
List <ItemGroupViewModel> IGList = IGViewModel.GroupList;
//IGRows = db.ITMGRPs.Where(o => o.Group_Type == IGViewModel.GroupType).OrderBy(o => o.Group_Id).ToList();
IGRows = db.ITMGRPs.OrderBy(o => o.Group_Id).ToList();
int CurrentGroup = 0;
ItemGroupViewModel vm = new ItemGroupViewModel();
for (int i = 0; i < IGRows.Count(); i++)
{
if (CurrentGroup != IGRows[i].Group_Id)
{
vm = new ItemGroupViewModel();
vm.GroupId = IGRows[i].Group_Id;
vm.GroupType = IGRows[i].Group_Type;
vm.GroupName = IGRows[i].Group_Name;
vm.Id = IGRows[i].Id;
}
else
{
continue;
}
foreach (var v in IGRows.Where(o => o.Group_Id == IGRows[i].Group_Id))
{
Item item = new Item();
item.Name = v.Item_Name;
item.ItemId = v.Item_Code;
item.Id = v.Id;
item.ItemType = v.Item_Type;
// If item is store
if (v.Item_Type == 3)
{
vm.StoreList.Add(item);
}
else
{
vm.ItemList.Add(item);
}
}
IGList.Add(vm);
CurrentGroup = IGRows[i].Group_Id;
}
return(IGList);
}
}
public ActionResult CreateItemGroup(ItemGroupViewModel model)
{
List <string> errors = new List <string>();
try
{
if (DuplicateItemGroup(model.Id, model.Name) != null)
{
ModelState.AddModelError("Name", $"Item Group {model.Name} already exists.");
}
if (ModelState.IsValid)
{
if (model.Id == 0)
{
var itemG = db.ItemGroupRepo.Table();
var order = itemG.Any() ? itemG.Max(x => x.DisplayOrder) : 0;
model.DisplayOrder = order + 1;
model.Id = db.ItemGroupRepo.Create(AutomapperConfig.Mapper.Map <ItemGroup>(model));
}
else
{
var oldmodel = db.ItemGroupRepo.GetById(model.Id);
if (oldmodel == null)
{
Response.StatusCode = (int)HttpStatusCode.OK;
return(Json(new { redirecturl = "/error/badrequest" }));
}
oldmodel.Name = model.Name;
oldmodel.Code = model.Code;
oldmodel.ItemTypeId = model.ItemTypeId;
}
db.SaveChanges();
TempData["Success"] = "Item Group Successfully Saved";
return(RedirectToAction("itemgroup"));
}
foreach (var item in ModelState.Where(x => x.Value.Errors.Any()))
{
errors.Add(item.Value.Errors.FirstOrDefault().ErrorMessage);
}
}
catch (Exception ex)
{
errors.Add(ex.GetExceptionMessages());
}
Response.StatusCode = (int)HttpStatusCode.SeeOther;
return(View(model));
}
public PartialViewResult CreateItemGroup(int id = 0)
{
var model = new ItemGroupViewModel();
if (id > 0)
{
model = AutomapperConfig.Mapper.Map <ItemGroupViewModel>(db.ItemGroupRepo.GetById(id));
}
if (model == null)
{
Response.StatusCode = (int)HttpStatusCode.OK;
return(PartialView(model));
}
return(PartialView(model));
}
public void ItemGroupViewModel_CreateItemGroupCommand_ValidNameAndParent_ItemGroupIsCreated()
{
//Setup itemgroups required for the test
_db.TableItemGroup.CreateItemGroup("Step7TestParent");
//Prepare the test
_iut = new ItemGroupViewModel(_db, _mb);
_iut.ItemGroupName = "Step7TestChild";
List <ItemGroup> temp = _iut.ComboBoxOptions.ToList();
_iut.ComboBoxIndex = temp.FindIndex(x => x.ItemGroupName == "Step7TestParent");
//Execute test
_iut.CreateItemGroupCommand.Execute(null);
Assert.That(_db.TableItemGroup.SearchItemGroups("Step7TestChild").Count, Is.EqualTo(1));
}
public ItemGroupViewModel SaveItemGroup(ItemGroupViewModel model)
{
exceptionService.Execute((m) =>
{
if (itemGroupRepository.Table.Any(x => x.Name == model.Name && x.Id != model.Id))
{
model.AddModelError(x => x.Name, "Error.DuplicateValue", "Item group name already exists.");
}
if (model.HasError)
{
return;
}
if (!model.Validate())
{
return;
}
var entity = new ItemGroup();
if (model.Id > 0)
{
entity = itemGroupRepository.GetById(model.Id);
entity.Name = model.Name;
entity.Code = model.Code;
entity.ItemTypeId = model.ItemTypeId;
entity.DisplayOrder = model.DisplayOrder;
itemGroupRepository.Update(entity);
}
else
{
entity = AutomapperConfig.Mapper.Map <ItemGroup>(model);
itemGroupRepository.Insert(entity);
}
if (model.Id == 0)
{
model.Message = localizationService.GetLocalizedText("Message.EmployeeSavedSuccessfully", IMSAppConfig.Instance.CurrentLanguage, "Employee saved succeeded.");
}
else
{
model.Message = localizationService.GetLocalizedText("Message.EmployeeUpdatedSuccessfully", IMSAppConfig.Instance.CurrentLanguage, "Employee update succeeded.");
}
}, model);
return(model);
}
public ActionResult AddNewGroup(ItemGroupViewModel IGViewModel)
{
UserSession user = (UserSession)Session["User"];
bool result;
string PageAction = "Add group";
result = ItemGroupManager.UpdateGroup(IGViewModel);
if (result)
{
TempData["SuccessMessage"] = PageAction + " successful";
new AuditLogManager().Audit(user.Username, DateTime.Now, "Raw Item Group", PageAction, IGViewModel.GroupId.ToString(), IGViewModel.GroupName);
}
else
{
TempData["ErrorMessage"] = PageAction + " failed";
}
return(RedirectToAction("Index"));
}
public ActionResult Index()
{
// Validate log in and user access
UserAccessSession UASession = (UserAccessSession)Session["UserAccess"];
if (UASession == null || !UASession.GRP)
{
return(RedirectToAction("Login", "Account"));
}
// Set NavBar Links accordingly
Session["CurrentPage"] = new CurrentPageSession("GRP_RIM", "HOME", "LOG");
ItemGroupViewModel IGViewModel = new ItemGroupViewModel();
IGViewModel.GroupType = 2;
IGViewModel.RawItemList = ItemGroupManager.GetFilteredRawItem();
IGViewModel.AllStoreList = ItemGroupManager.GetFilteredStore();
IGViewModel.GroupList = ItemGroupManager.GetGroup(IGViewModel);
return(View(IGViewModel));
}
public async Task <int> SaveItemGroup(ItemGroupViewModel itemGroupViewModel)
{
var itemGroup = Mapper.Map <ItemGroup>(itemGroupViewModel);
return(await _itemGroupRepository.SaveItemGroup(itemGroup));
}
public static bool UpdateMenuItem(MenuRecipeViewModel MRViewModel, string user)
{
using (CFMMCDEntities db = new CFMMCDEntities())
{
if (MRViewModel.RIRMIC == null || MRViewModel.RIRMIC.Equals(""))
{
return(false);
}
// Existing row
foreach (var v in MRViewModel.MenuRecipeList)
{
if (!v.PreviousRIRRIC.Equals(v.RIRRIC))
{
INVRIRP0 MRRowToDelete = db.INVRIRP0.Single(o => o.RIRRID.Equals(v.RIRRID));
db.INVRIRP0.Remove(MRRowToDelete);
db.SaveChanges();
}
if (!db.INVRIMP0.Where(o => o.RIMRIC.ToString().Equals(v.RIRRIC)).Any())
{
continue;
}
INVRIRP0 MRRow;
if (db.INVRIRP0.Where(o => o.RIRRID.Equals(MRViewModel.RIRMIC + v.RIRRIC)).Any())
{
MRRow = db.INVRIRP0.Single(o => o.RIRRID.Equals(MRViewModel.RIRMIC + v.RIRRIC));
}
else
{
MRRow = new INVRIRP0();
}
MRRow.RIRRID = MRViewModel.RIRMIC + v.RIRRIC;
MRRow.RIRMIC = int.Parse(MRViewModel.RIRMIC);
MRRow.RIRRIC = int.Parse(v.RIRRIC);
MRRow.RIRVPC = 0;
MRRow.LongName = MRViewModel.MIMLON;
if (v.RIRSFQ != null && !v.RIRSFQ.Equals(""))
{
MRRow.RIRSFQ = double.Parse(v.RIRSFQ);
}
MRRow.RIRCWC = v.RIRCWC;
MRRow.RIRSTA = "0";
MRRow.RIRVST = "";
MRRow.RIRUSR = user.Substring(0, 3).ToUpper();
MRRow.RIRDAT = DateTime.Now;
MRRow.RIRFLG = false;
// Group
var IGRowLookup = db.ITMGRPs.Where(o => o.Item_Code.ToString().Equals(MRViewModel.RIRMIC));
IGRowLookup = IGRowLookup.Where(o => o.Item_Type == 4);
if (IGRowLookup.Any())
{
if (MRViewModel.Group == 0)
{
int val = IGRowLookup.FirstOrDefault().Id;
ItemGroupManager.DeleteItem(val);
}
else
{
IGRowLookup.FirstOrDefault().Item_Code = int.Parse(MRViewModel.RIRMIC);
IGRowLookup.FirstOrDefault().Item_Name = MRViewModel.MIMDSC;
IGRowLookup.FirstOrDefault().Group_Id = MRViewModel.Group;
IGRowLookup.FirstOrDefault().Group_Name = db.ITMGRPs.FirstOrDefault(o => o.Group_Id == MRViewModel.Group).Group_Name;
}
}
else
{
if (MRViewModel.Group != 0)
{
ItemGroupViewModel IGRow = new ItemGroupViewModel();
IGRow.GroupName = db.ITMGRPs.FirstOrDefault(o => o.Group_Id == MRViewModel.Group).Group_Name;
IGRow.GroupId = MRViewModel.Group;
IGRow.ItemCode = int.Parse(MRViewModel.RIRMIC);
IGRow.ItemName = MRViewModel.MIMDSC;
IGRow.ItemType = 4;
IGRow.GroupType = 4;
ItemGroupManager.UpdateGroup(IGRow);
}
}
MRRow.Group = MRViewModel.Group;
try
{
if (db.INVRIRP0.Where(o => o.RIRRID == MRRow.RIRRID).Any())
{
MRRow.STATUS = "E";
}
else
{
MRRow.STATUS = "A";
db.INVRIRP0.Add(MRRow);
}
db.SaveChanges();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Source);
System.Diagnostics.Debug.WriteLine(e.Message);
System.Diagnostics.Debug.WriteLine(e.StackTrace);
System.Diagnostics.Debug.WriteLine(e.InnerException);
Exception f = e.InnerException;
while (f != null)
{
System.Diagnostics.Debug.WriteLine("INNER:");
System.Diagnostics.Debug.WriteLine(f.Message);
System.Diagnostics.Debug.WriteLine(f.Source);
f = f.InnerException;
}
System.Diagnostics.Debug.WriteLine(e.Data);
return(false);
}
}
// New created row
for (int i = 0; i < MRViewModel.RIMRID.Count(); i++)
{
if (MRViewModel.RIRRIC[i] == null || MRViewModel.RIRRIC[i].Equals(""))
{
continue;
}
INVRIRP0 MRRow = new INVRIRP0();
MRRow.RIRRID = MRViewModel.RIRMIC + MRViewModel.RIRRIC[i];
MRRow.RIRMIC = int.Parse(MRViewModel.RIRMIC);
MRRow.RIRRIC = int.Parse(MRViewModel.RIRRIC[i]);
MRRow.RIRVPC = 0;
MRRow.LongName = MRViewModel.MIMLON;
if (MRViewModel.RIRSFQ[i] != null && !MRViewModel.RIRSFQ[i].Equals(""))
{
MRRow.RIRSFQ = double.Parse(MRViewModel.RIRSFQ[i]);
}
MRRow.RIRCWC = MRViewModel.RIRCWC[i];
MRRow.RIRSTA = "0";
MRRow.RIRVST = "";
MRRow.RIRUSR = user.Substring(0, 3).ToUpper();
MRRow.RIRDAT = DateTime.Now;
MRRow.RIRFLG = false;
// Group
var IGRowLookup = db.ITMGRPs.Where(o => o.Item_Code.ToString().Equals(MRViewModel.RIRMIC));
IGRowLookup = IGRowLookup.Where(o => o.Item_Type == 4);
if (IGRowLookup.Any())
{
if (MRViewModel.Group == 0)
{
int val = IGRowLookup.FirstOrDefault().Id;
ItemGroupManager.DeleteItem(val);
}
else
{
IGRowLookup.FirstOrDefault().Item_Code = int.Parse(MRViewModel.RIRMIC);
IGRowLookup.FirstOrDefault().Item_Name = MRViewModel.MIMDSC;
IGRowLookup.FirstOrDefault().Group_Id = MRViewModel.Group;
IGRowLookup.FirstOrDefault().Group_Name = db.ITMGRPs.FirstOrDefault(o => o.Group_Id == MRViewModel.Group).Group_Name;
}
}
else
{
if (MRViewModel.Group != 0)
{
ItemGroupViewModel IGRow = new ItemGroupViewModel();
IGRow.GroupName = db.ITMGRPs.FirstOrDefault(o => o.Group_Id == MRViewModel.Group).Group_Name;
IGRow.GroupId = MRViewModel.Group;
IGRow.ItemCode = int.Parse(MRViewModel.RIRMIC);
IGRow.ItemName = MRViewModel.MIMDSC;
IGRow.ItemType = 4;
IGRow.GroupType = 4;
ItemGroupManager.UpdateGroup(IGRow);
}
}
MRRow.Group = MRViewModel.Group;
try
{
if (db.INVRIRP0.Where(o => o.RIRRID == MRRow.RIRRID).Any())
{
INVRIRP0 rowToDelete = db.INVRIRP0.Single(o => o.RIRRID == MRRow.RIRRID);
db.INVRIRP0.Remove(rowToDelete);
MRRow.STATUS = "E";
db.INVRIRP0.Add(MRRow);
}
else
{
MRRow.STATUS = "A";
db.INVRIRP0.Add(MRRow);
}
db.SaveChanges();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Source);
System.Diagnostics.Debug.WriteLine(e.Message);
System.Diagnostics.Debug.WriteLine(e.StackTrace);
System.Diagnostics.Debug.WriteLine(e.InnerException);
Exception f = e.InnerException;
while (f != null)
{
System.Diagnostics.Debug.WriteLine("INNER:");
System.Diagnostics.Debug.WriteLine(f.Message);
System.Diagnostics.Debug.WriteLine(f.Source);
f = f.InnerException;
}
System.Diagnostics.Debug.WriteLine(e.Data);
return(false);
}
}
List <INVRIRP0> MRRowList = db.INVRIRP0.Where(o => o.RIRMIC.ToString().Equals(MRViewModel.RIRMIC)).ToList();
if (MRRowList.Count() == 0)
{
var RIRRow = db.ITMGRPs.Where(o => o.Item_Code.ToString().Equals(MRViewModel.RIRMIC));
RIRRow = RIRRow.Where(o => o.Item_Type == 4);
if (RIRRow.Any())
{
db.ITMGRPs.RemoveRange(RIRRow);
db.SaveChanges();
}
}
return(true);
}
}
public static bool UpdateGroup(ItemGroupViewModel IGViewModel)
{
using (CFMMCDEntities db = new CFMMCDEntities())
{
// Update
if (IGViewModel.GroupName == null || IGViewModel.GroupName.Equals("") || IGViewModel.GroupType == 0)
{
return(false);
}
var IGRowLookup = db.ITMGRPs.Where(o => o.Item_Code == IGViewModel.ItemCode);
IGRowLookup = IGRowLookup.Where(o => o.Item_Type == IGViewModel.ItemType);
if (IGRowLookup.Any())
{
return(false);
}
ITMGRP IGRow = new ITMGRP();
IGRow.Id = new Random().Next(1, 999999999);
// Get new Id if it exist
for (int i = 0; (i < 10 && db.ITMGRPs.Where(o => o.Id == IGRow.Id).Any()); i++)
{
IGRow.Id = new Random().Next(1, 999999999);
}
// If Group is already created
if (db.ITMGRPs.Where(o => o.Group_Name.Equals(IGViewModel.GroupName)).Any())
{
IGRow.Group_Id = IGViewModel.GroupId;
IGRow.Group_Name = IGViewModel.GroupName;
IGRow.Item_Code = IGViewModel.ItemCode;
IGRow.Item_Name = IGViewModel.ItemName;
IGRow.Item_Type = IGViewModel.ItemType;
IGRow.Group_Type = IGViewModel.GroupType;
// Add Group to Item table
if (IGRow.Item_Type == 1 && db.CSHMIMP0.Where(o => o.MIMMIC == IGViewModel.ItemCode).Any())
{
db.CSHMIMP0.Single(o => o.MIMMIC == IGViewModel.ItemCode).Group = IGViewModel.GroupId;
}
else if (IGRow.Item_Type == 2 && db.INVRIMP0.Where(o => o.RIMRIC == IGViewModel.ItemCode).Any())
{
db.INVRIMP0.Single(o => o.RIMRIC == IGViewModel.ItemCode).Group = IGViewModel.GroupId;
}
else if (IGRow.Item_Type == 3 && db.Store_Profile.Where(o => o.STORE_NO == IGViewModel.ItemCode).Any())
{
db.Store_Profile.Single(o => o.STORE_NO == IGViewModel.ItemCode).Group = IGViewModel.GroupId;
}
else if (IGRow.Item_Type == 4 && db.INVRIRP0.Where(o => o.RIRMIC == IGViewModel.ItemCode).Any())
{
foreach (var v in db.INVRIRP0.Where(o => o.RIRMIC == IGViewModel.ItemCode))
{
v.Group = IGViewModel.GroupId;
}
}
}
else
{
IGRow.Group_Id = new Random().Next(1, 999999);
// Get new Group_Id if it exist
for (int i = 0; (i < 10 && db.ITMGRPs.Where(o => o.Group_Id == IGRow.Group_Id).Any()); i++)
{
IGRow.Group_Id = new Random().Next(1, 999999);
}
IGRow.Group_Name = IGViewModel.GroupName;
IGRow.Item_Code = 0;
IGRow.Item_Name = "";
IGRow.Item_Type = IGViewModel.ItemType;
IGRow.Group_Type = IGViewModel.GroupType;
}
db.ITMGRPs.Add(IGRow);
// Save DB
try
{
db.SaveChanges();
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Source);
System.Diagnostics.Debug.WriteLine(e.Message);
System.Diagnostics.Debug.WriteLine(e.StackTrace);
System.Diagnostics.Debug.WriteLine(e.InnerException);
Exception f = e.InnerException;
while (f != null)
{
System.Diagnostics.Debug.WriteLine("INNER:");
System.Diagnostics.Debug.WriteLine(f.Message);
System.Diagnostics.Debug.WriteLine(f.Source);
f = f.InnerException;
}
System.Diagnostics.Debug.WriteLine(e.Data);
return(false);
}
return(true);
}
}
/*
* Combined Create and Update Store profile method.
* Creates a Store_Profile instance (which will be a new table row)
* and instantiates each SPViewModel property to the respective property of the former.
* Also checks if the given Store profile number is already in the table,
* if true, the method performs an update, otherwise, creation.
*
* Returns true if the operation is successful.
* */
public bool UpdateStore(StoreProfileViewModel SPViewModel)
{
using (CFMMCDEntities db = new CFMMCDEntities())
{
Store_Profile SPRow;
bool isUpdating = false;
if (db.Store_Profile.Where(o => o.STORE_NO.ToString().Equals(SPViewModel.STORE_NO)).Any())
{
SPRow = db.Store_Profile.Single(o => o.STORE_NO.ToString().Equals(SPViewModel.STORE_NO));
isUpdating = true;
}
else
{
SPRow = new Store_Profile();
}
if (SPViewModel.STORE_NO != null && !SPViewModel.STORE_NO.Equals(""))
{
SPRow.STORE_NO = int.Parse(SPViewModel.STORE_NO);
}
else
{
return(false);
}
if (SPViewModel.STORE_NAME != null && !SPViewModel.STORE_NAME.Equals(""))
{
SPRow.STORE_NAME = SPViewModel.STORE_NAME;
}
else
{
return(false);
}
if (SPViewModel.OWNERSHIP != null)
{
SPRow.OWNERSHIP = int.Parse(SPViewModel.OWNERSHIP);
}
if (SPViewModel.BREAKFAST_PRICE_TIER != null)
{
SPRow.BREAKFAST_PRICE_TIER = int.Parse(SPViewModel.BREAKFAST_PRICE_TIER);
}
if (SPViewModel.REGULAR_PRICE_TIER != null)
{
SPRow.REGULAR_PRICE_TIER = int.Parse(SPViewModel.REGULAR_PRICE_TIER);
}
if (SPViewModel.DC_PRICE_TIER != null)
{
SPRow.DC_PRICE_TIER = int.Parse(SPViewModel.DC_PRICE_TIER);
}
if (SPViewModel.MDS_PRICE_TIER != null)
{
SPRow.MDS_PRICE_TIER = int.Parse(SPViewModel.MDS_PRICE_TIER);
}
if (SPViewModel.MCCAFE_LEVEL_2_PRICE_TIER != null)
{
SPRow.MCCAFE_LEVEL_2_PRICE_TIER = int.Parse(SPViewModel.MCCAFE_LEVEL_2_PRICE_TIER);
}
if (SPViewModel.MCCAFE_LEVEL_3_PRICE_TIER != null)
{
SPRow.MCCAFE_LEVEL_3_PRICE_TIER = int.Parse(SPViewModel.MCCAFE_LEVEL_3_PRICE_TIER);
}
if (SPViewModel.MCCAFE_BISTRO_PRICE_TIER != null)
{
SPRow.MCCAFE_BISTRO_PRICE_TIER = int.Parse(SPViewModel.MCCAFE_BISTRO_PRICE_TIER);
}
if (SPViewModel.PROJECT_GOLD_PRICE_TIER != null)
{
SPRow.PROJECT_GOLD_PRICE_TIER = int.Parse(SPViewModel.PROJECT_GOLD_PRICE_TIER);
}
if (SPViewModel.BusinessExtList != null)
{
SPRow.BET = SetBusinessExtention(SPViewModel.BET, SPViewModel.BusinessExtList);
}
if (SPViewModel.PROFIT_CENTER != null)
{
SPRow.PROFIT_CENTER = int.Parse(SPViewModel.PROFIT_CENTER);
}
if (SPViewModel.REGION != null)
{
SPRow.REGION = SPViewModel.REGION;
}
if (SPViewModel.PROVINCE != null)
{
SPRow.PROVINCE = SPViewModel.PROVINCE;
}
if (SPViewModel.LOCATION != null && !SPViewModel.LOCATION.Equals(""))
{
SPRow.LOCATION = int.Parse(SPViewModel.LOCATION);
}
if (SPViewModel.ADDRESS != null)
{
SPRow.ADDRESS = SPViewModel.ADDRESS;
}
if (SPViewModel.CITY != null)
{
SPRow.CITY = SPViewModel.CITY;
}
if (SPViewModel.FRESH_OR_FROZEN != null)
{
SPRow.FRESH_OR_FROZEN = SPViewModel.FRESH_OR_FROZEN;
}
if (SPViewModel.PAPER_OR_PLASTIC != null)
{
SPRow.PAPER_OR_PLASTIC = SPViewModel.PAPER_OR_PLASTIC;
}
if (SPViewModel.SOFT_SERVE_OR_VANILLA_POWDER_MIX != null)
{
SPRow.SOFT_SERVE_OR_VANILLA_POWDER_MIX = SPViewModel.SOFT_SERVE_OR_VANILLA_POWDER_MIX;
}
if (SPViewModel.SIMPLOT_OR_MCCAIN != null)
{
SPRow.SIMPLOT_OR_MCCAIN = SPViewModel.SIMPLOT_OR_MCCAIN;
}
if (SPViewModel.MCCORMICK_OR_GSF != null)
{
SPRow.MCCORMICK_OR_GSF = SPViewModel.MCCORMICK_OR_GSF;
}
if (SPViewModel.FRESHB_OR_FROZENB != null)
{
SPRow.FRESHB_OR_FROZENB = SPViewModel.FRESHB_OR_FROZENB;
}
SPRow.STATUS = "A";
// Group
if (db.ITMGRPs.Where(o => o.Item_Code.ToString().Equals(SPViewModel.STORE_NO)).Any())
{
if (SPViewModel.Group == 0)
{
int val = db.ITMGRPs.FirstOrDefault(o => o.Item_Code.ToString().Equals(SPViewModel.STORE_NO)).Id;
ItemGroupManager.DeleteItem(val);
}
else
{
db.ITMGRPs.Single(o => o.Item_Code.ToString().Equals(SPViewModel.STORE_NO)).Item_Code = int.Parse(SPViewModel.STORE_NO);
db.ITMGRPs.Single(o => o.Item_Code.ToString().Equals(SPViewModel.STORE_NO)).Item_Name = SPViewModel.STORE_NAME;
db.ITMGRPs.Single(o => o.Item_Code.ToString().Equals(SPViewModel.STORE_NO)).Group_Id = SPViewModel.Group;
db.ITMGRPs.Single(o => o.Item_Code.ToString().Equals(SPViewModel.STORE_NO)).Group_Name = db.ITMGRPs.FirstOrDefault(o => o.Group_Id == SPViewModel.Group).Group_Name;
}
}
else
{
if (SPViewModel.Group != 0)
{
ItemGroupViewModel IGRow = new ItemGroupViewModel();
IGRow.GroupName = db.ITMGRPs.FirstOrDefault(o => o.Group_Id == SPViewModel.Group).Group_Name;
IGRow.GroupId = SPViewModel.Group;
IGRow.ItemCode = int.Parse(SPViewModel.STORE_NO);
IGRow.ItemName = SPViewModel.STORE_NAME;
IGRow.ItemType = 3;
IGRow.GroupType = 3;
ItemGroupManager.UpdateGroup(IGRow);
}
}
SPRow.Group = SPViewModel.Group;
try
{
// Check if STORE_NO already exists in the database, perform an update if true
if (isUpdating)
{
SPRow.STATUS = "E";
}
else
{
db.Store_Profile.Add(SPRow);
}
db.SaveChanges();
return(true);
}
catch (Exception e)
{
System.Diagnostics.Debug.WriteLine(e.Source);
System.Diagnostics.Debug.WriteLine(e.Message);
System.Diagnostics.Debug.WriteLine(e.StackTrace);
System.Diagnostics.Debug.WriteLine(e.InnerException);
Exception f = e.InnerException;
while (f != null)
{
System.Diagnostics.Debug.WriteLine("INNER:");
System.Diagnostics.Debug.WriteLine(f.Message);
System.Diagnostics.Debug.WriteLine(f.Source);
f = f.InnerException;
}
System.Diagnostics.Debug.WriteLine(e.Data);
return(false);
}
}
}
