public ActionResult BatchUpdateForReqItems(MVCxGridViewBatchUpdateValues <ItemRequest, int> updatedItems, string status) { RequestDetailModel model; Session["Status"] = ViewData["Status"] = status; // To show batchEdit commands var reqId = Session["ReqId"] != null?int.Parse(Convert.ToString(Session["ReqId"])) : 0; if (ModelState.IsValid) { try { RequestsRepository.RecommendItems(updatedItems); model = GetRequestModel(reqId); return(PartialView("Grid/_ReqItemGrid", model.Items)); } catch (Exception e) { TempData["ErrorMessage"] = e.ToString(); BaseRepository.OimsDataContext.ClearChanges(); // Roll back all changes Logger.LogError(e, "Error while recommending items for request from Supervisor zone"); } } else { TempData["ErrorMessage"] = "Please, correct all errors."; } model = GetRequestModel(reqId); return(PartialView("Grid/_ReqItemGrid", model.Items)); }
public ActionResult BatchEditingUpdateModelPerson(MVCxGridViewBatchUpdateValues <Person, int> batchValues) { foreach (var person in batchValues.Update) { if (batchValues.IsValid(person)) { PersonsList.UpdatePerson(person); } else { batchValues.SetErrorText(person, "Correct validation errors"); } } foreach (var person in batchValues.Insert) { if (batchValues.IsValid(person)) { PersonsList.AddPerson(person); } else { batchValues.SetErrorText(person, "Correct validation errors"); } } foreach (var personID in batchValues.DeleteKeys) { PersonsList.DeletePerson(personID); } return(PartialView("GridViewPartial", PersonsList.GetPersons())); }
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues <EditableProduct, Guid> updateValues) { var dataContextModelContracts = GetDataContextModelContracts(); // Insert all added values. foreach (var contract in updateValues.Insert) { if (updateValues.IsValid(contract)) { try { InsertContract(contract, dataContextModelContracts); Db.SaveChanges(); } catch (Exception e) { updateValues.SetErrorText(contract, e.Message); } } } // Update all edited values. //get sum of all total values foreach (var contract in updateValues.Update) { if (updateValues.IsValid(contract)) { try { var product = UpdateContract(contract); Db.SaveChanges(); } catch (Exception e) { updateValues.SetErrorText(contract, e.Message); } } else { updateValues.SetErrorText(contract, "Исправьте ошибки заполнения формы"); } } // Delete all values that were deleted on the client side from the data source. foreach (var ContrGUID in updateValues.DeleteKeys) { try { DeleteContract(ContrGUID, dataContextModelContracts); Db.SaveChanges(); } catch (Exception e) { updateValues.SetErrorText(ContrGUID, e.Message); } } var parenttableid = Session["parenttableid"] as string; var quarterhlight = Session["quarterhlight"] as string; return(BatchEditingPartial(parenttableid, quarterhlight)); }
private ActionResult ResultHandler(string errMsg, BA02AModel master, MVCxGridViewBatchUpdateValues <BA02BModel, int> updateValues) { if (errMsg == "") { TempData["SelectedItemKey"] = master.BA02A_ID; TempData["SaveSuccess"] = true; return(RedirectToAction("RedirectIndex")); } else { for (int i = 0; i < updateValues.Insert.Count; i++) { ModelState.AddModelError($"Insert[{i}].IsValid", "Error"); } for (int i = 0; i < updateValues.Update.Count; i++) { ModelState.AddModelError($"Update[{i}].IsValid", "Error"); } var deleteIDStrList = ""; for (int i = 0; i < updateValues.DeleteKeys.Count; i++) { updateValues.SetErrorText(updateValues.DeleteKeys[i], "Unable to delete!"); deleteIDStrList += updateValues.DeleteKeys[i] + ","; } ViewData["DeleteIDList"] = deleteIDStrList; errMsg = "存儲失敗<br/>" + errMsg; ViewData["ErrMsg"] = errMsg = errMsg.Substring(0, errMsg.Length - 5); ViewData["MasterForm"] = ReadViewHelper.PartialView(this, "_MasterForm", master); return(PartialView("_DetailGrid", BA02Business.FromEntity(_Service.GetByMasterKey(master.BA02A_ID)))); } }
public ActionResult UpdateTagTemplateP(MVCxGridViewBatchUpdateValues <TBL_TAG_TEMP, int> updateValues) { //object curObj; try { foreach (TBL_TAG_TEMP tagTemp in updateValues.Update) { if (updateValues.IsValid(tagTemp)) { UpdateTagTemplate(tagTemp, updateValues); } } foreach (TBL_TAG_TEMP tagTemp in updateValues.Insert) { if (updateValues.IsValid(tagTemp)) { InsertTagTemplate(tagTemp, updateValues); } } foreach (var companyID in updateValues.DeleteKeys) { DeleteTagTemplate(companyID, updateValues); } return(PartialView("GridTagTemplatePartial")); } catch (Exception ex) { //updateValues.SetErrorText( curObj, ex.Message); return(PartialView("GridTagTemplatePartial")); } }
public ActionResult RoleUserBatchEditingUpdateModel( MVCxGridViewBatchUpdateValues <RoleUserViewModel, string> updateValues, string roleName) { var role = Db.Roles.Single(r => r.Name == roleName); foreach (var roleUserViewModel in updateValues.Update) { if (!updateValues.IsValid(roleUserViewModel)) { continue; } var user = Db.Users.Single(u => u.UserName == roleUserViewModel.UserName); if (roleUserViewModel.IsMember) { if (!role.Users.Contains(user)) { role.Users.Add((User)user); } } else { if (role.Users.Contains(user)) { role.Users.Remove((User)user); } } } Db.SaveChanges(); return(RoleMembershipGridViewPartial(new RoleViewModel { Name = role.Name, Description = role.Description })); }
public ActionResult BatchUpdatePartial(MVCxGridViewBatchUpdateValues <GridDataItem, int> batchValues) { foreach (var item in batchValues.Insert) { if (batchValues.IsValid(item)) { BatchEditRepository.InsertNewItem(item, batchValues); } else { batchValues.SetErrorText(item, "Correct validation errors"); } } foreach (var item in batchValues.Update) { if (batchValues.IsValid(item)) { BatchEditRepository.UpdateItem(item, batchValues); } else { batchValues.SetErrorText(item, "Correct validation errors"); } } foreach (var itemKey in batchValues.DeleteKeys) { BatchEditRepository.DeleteItem(itemKey, batchValues); } return(PartialView("_GridViewPartial", BatchEditRepository.GridData)); }
public ActionResult ContactsSave(uint id, MVCxGridViewBatchUpdateValues <AssociationContact, int> updateValues) { foreach (var contactId in updateValues.DeleteKeys) { var contact = DbSession.Query <AssociationContact>().FirstOrDefault(r => r.Id == contactId); if (contact != null) { DbSession.Delete(contact); } } var association = DbSession.Query <Association>().First(r => r.Id == id); foreach (var contact in updateValues.Insert) { contact.Association = association; DbSession.Save(contact); } foreach (var contact in updateValues.Update) { DbSession.Update(contact); } DbSession.Flush(); return(GridContacts(id)); }
public ActionResult GridViewEditPartial(MVCxGridViewBatchUpdateValues <Customer, int> modifiedValues) { foreach (var customerInfo in modifiedValues.Insert) { if (modifiedValues.IsValid(customerInfo)) { entity.Customers.Add(customerInfo); } } foreach (var customerInfo in modifiedValues.Update) { if (modifiedValues.IsValid(customerInfo)) { entity.Customers.Attach(customerInfo); var entry = entity.Entry(customerInfo); entry.Property(e => e.CityId).IsModified = true; entry.Property(e => e.CountryId).IsModified = true; entry.Property(e => e.CustomerName).IsModified = true; } } foreach (var customerID in modifiedValues.DeleteKeys) { entity.Customers.Remove(entity.Customers.Find(customerID)); } // uncomment the next line to enable database updates // entity.SaveChanges(); return(PartialView("GridViewPartial", entity.Customers.ToList())); }
public ActionResult BatchUpdatePartial(MVCxGridViewBatchUpdateValues <GridDataItem, int> batchValues) { if (ModelState.IsValid) { try { foreach (var item in batchValues.Insert) { if (batchValues.IsValid(item)) { BatchEditRepository.InsertNewItem(item); } } foreach (var item in batchValues.Update) { if (batchValues.IsValid(item)) { BatchEditRepository.UpdateItem(item); } } foreach (var itemKey in batchValues.DeleteKeys) { BatchEditRepository.DeleteItem(itemKey); } } catch (Exception e) { ViewData["EditError"] = e.Message; } } else { ViewData["EditError"] = "Please, correct all errors."; } return(PartialView("_GridViewPartial", BatchEditRepository.GridData)); }
public ActionResult PrivilegeUpdate(MVCxGridViewBatchUpdateValues <FileManagerRolePrivilegeViewModel, int> updateValues) { int fileId = 0; List <FileManagerRolePrivilegeViewModel> models = new List <FileManagerRolePrivilegeViewModel>(); //todo here is create connection to service update FileManagerPrivileges BatchUpdateFilePrivilegeRequest request = new BatchUpdateFilePrivilegeRequest(); var datas = new List <UpdateFilePrivilegeRequest>(); foreach (var item in updateValues.Update) { var privilege = item.MapTo <UpdateFilePrivilegeRequest>(); datas.Add(privilege); fileId = item.FileId; } request.BatchUpdateFilePrivilege = datas.ToList(); var response = ProcessBlueprintDataProvider.service.BatchUpdateFilePrivilege(request); var data = ProcessBlueprintDataProvider.service.GetPrivileges(new Services.Requests.ProcessBlueprint.GetProcessBlueprintPrivilegeRequest { FileId = fileId }); if (data.IsSuccess) { models = data.FileManagerRolePrivileges.ToList().MapTo <FileManagerRolePrivilegeViewModel>(); } return(PartialView("_PrivilegePartial", models)); }
public ActionResult BatchUpdateRoomsPartial(MVCxGridViewBatchUpdateValues <Room, int> batchValues) { foreach (var item in batchValues.Insert) { if (batchValues.IsValid(item)) { Company.InsertRoom(item); } else { batchValues.SetErrorText(item, "Correct validation errors"); } } foreach (var item in batchValues.Update) { if (batchValues.IsValid(item)) { Company.UpdateRoom(item); } else { batchValues.SetErrorText(item, "Correct validation errors"); } } foreach (var itemKey in batchValues.DeleteKeys) { Company.RemoveRoomByID(itemKey); } return(PartialView("GridViewPartialView", Company.OfficeRooms)); }
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues <InventoryItem, object> updateValues) { DataViewsSearch search = new DataViewsSearch(); string serverId = Session["server"].ToString(); string moduleId = "Inventory"; string formId = "gbz_boxes"; string fieldId = "inventoryNumber"; string box = Session["box"].ToString(); ViewData["server"] = serverId; ViewData["moduleId"] = moduleId; ViewData["formId"] = formId; ViewData["viewName"] = fieldId; /* * foreach (var inventoryItem in updateValues.Insert) * { * if (updateValues.IsValid(product)) * InsertProduct(inventoryItem, updateValues); * } * foreach (var product in updateValues.Update) * { * if (updateValues.IsValid(product)) * UpdateProduct(product, updateValues); * } * foreach (var productID in updateValues.DeleteKeys) * { * DeleteProduct(productID, updateValues); * }*/ search.NewBox(serverId, moduleId, formId, fieldId, updateValues.Insert, box); //return PartialView("_GridViewPartial", search.NewBox(serverId, moduleId, formId, fieldId, updateValues.Insert, box));//GridViewPartial(); return(RedirectToAction("Index2", "Search", new { serverId, moduleId, formId = "gbz_get_inventory", fieldId = "storageLocation", value = box })); // This is going back to another page after the info is updated }
public static ResultHelperBatch <BA02B, int> BeforeSave(MVCxGridViewBatchUpdateValues <BA02BModel, int> values, List <BA02B> updateList, int DeleteCount, ModelStateDictionary ModelState) { ResultHelperBatch <BA02B, int> result = new ResultHelperBatch <BA02B, int>() { Message = "" }; ValidateDetail(values.Update, ModelState, EntityState.Modified); ValidateDetail(values.Insert, ModelState, EntityState.Added); if (updateList.Count != values.Update.Count || DeleteCount != values.DeleteKeys.Count) { result.Message += "明細資料已被刪除<br/>請重新整理<br/>"; } if (!ModelState.IsValid) { result.Message += "請檢查紅色驚嘆號<br/>"; } else if (result.Message == "") { result.Insert = ToEntity(values.Insert, new List <BA02B>(), EntityState.Added); result.Update = ToEntity(values.Update, updateList, EntityState.Modified); result.Delete = values.DeleteKeys; } return(result); }
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues <ColumnsAlias, string> updateValues) { List <ColumnsAlias> lstColumnsAlias = new List <ColumnsAlias>(); if (updateValues.Update.Count() > 0) { foreach (var obj in updateValues.Update) { if (updateValues.IsValid(obj)) { lstColumnsAlias.Add(obj); } } var res1 = API_RefOptions.SaveAliasColumn(new SaveColumnsAlias((Request.Params["ColPageName"] != null && Convert.ToString(Request.Params["ColPageName"]).Length > 0) ? Convert.ToString(Request.Params["ColPageName"]) : "Contact", lstColumnsAlias)); res = new Response <ColumnsAlias> ( new ColumnsAlias(), API_RefOptions.GetAllColumnAliases((Request.Params["ColPageName"] != null && Convert.ToString(Request.Params["ColPageName"]).Length > 0) ? Convert.ToString(Request.Params["ColPageName"]) : "Contact").DataList, res1.Status, res1.MessageType, res1.Message ); } return(RedirectToAction("SaveAliasColumn")); }
public ActionResult GridViewBatchUpdate(MVCxGridViewBatchUpdateValues <TestModel, int> updateValues) { throw new Exception("Online data modification is not supported. Download the example and implement your logic in the GridViewBatchUpdate action method."); //update the datasource here using the uploaded files //clear the dictionary after Helper.Files.Clear(); return(PartialView("BatchEditingPartial", Helper.GetData())); }
public ActionResult GridUpdateTagTemplateDet(MVCxGridViewBatchUpdateValues <TagTempDetGridModel, int> updateValues, int templateId, bool newData, bool isGeneral, bool isDigital = false) { try { foreach (TagTempDetGridModel tagTemp in updateValues.Update) { tagTemp.TEMPLATE_ID = templateId; if (updateValues.IsValid(tagTemp)) { if (tagTemp.ID > 0) { UpdateTagTemplateDet(tagTemp, updateValues); } else { InsertTagTemplateDet(tagTemp, updateValues); } } } if (isDigital) { return(PartialView("GridTagTemplateDigPartial", GetTemplateDetails(templateId, false, false, true))); } else { if (isGeneral) { return(PartialView("GridTagTemplateGenPartial", GetTemplateDetails(templateId, newData, true))); } else { return(PartialView("GridTagTemplateDetPartial", GetTemplateDetails(templateId, newData, false))); } } } catch (Exception ex) { if (isDigital) { return(PartialView("GridTagTemplateDigPartial", GetTemplateDetails(templateId, false, false, true))); } else { if (isGeneral) { return(PartialView("GridTagTemplateGenPartial", GetTemplateDetails(templateId, newData, true))); } else { return(PartialView("GridTagTemplateDetPartial", GetTemplateDetails(templateId, newData, false))); } } } }
public static void DeleteItem(int itemKey, MVCxGridViewBatchUpdateValues <GridDataItem, int> batchValues) { try { var item = GridData.First(i => i.Id == itemKey); GridData.Remove(item); } catch (Exception e) { batchValues.SetErrorText(itemKey, e.Message); } }
public static void UpdateItem(GridDataItem postedItem, MVCxGridViewBatchUpdateValues <GridDataItem, int> batchValues) { try { var editedItem = GridData.First(i => i.Id == postedItem.Id); LoadNewValues(editedItem, postedItem); } catch (Exception e) { batchValues.SetErrorText(postedItem, e.Message); } }
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues <EditableContract, Guid> updateValues) { var dataContextModelContracts = GetDataContextModelContracts(); // Insert all added values. foreach (var contract in updateValues.Insert) { if (updateValues.IsValid(contract)) { try { InsertContract(contract, dataContextModelContracts); Db.SaveChanges(); } catch (Exception e) { updateValues.SetErrorText(contract, e.Message); } } } // Update all edited values. foreach (var contract in updateValues.Update) { if (updateValues.IsValid(contract)) { try { UpdateContract(contract); Db.SaveChanges(); } catch (Exception e) { updateValues.SetErrorText(contract, e.Message); } } } // Delete all values that were deleted on the client side from the data source. foreach (var ContrGUID in updateValues.DeleteKeys) { try { DeleteContract(ContrGUID, dataContextModelContracts); Db.SaveChanges(); } catch (Exception e) { updateValues.SetErrorText(ContrGUID, e.Message); } } var parenttableid = Session["parenttableid"] as string; var contractstatus = Session["contractstatus"] as string; return(BatchEditingPartial(parenttableid, contractstatus)); }
protected void DeleteProduct(object productID, MVCxGridViewBatchUpdateValues <InventoryItem, object> updateValues) { try { //NorthwindDataProvider.DeleteProduct(productID); } catch (Exception e) { updateValues.SetErrorText(productID, e.Message); } }
protected void InsertProduct(InventoryItem product, MVCxGridViewBatchUpdateValues <InventoryItem, object> updateValues) { try { //NorthwindDataProvider.InsertProduct(product); } catch (Exception e) { updateValues.SetErrorText(product, e.Message); } }
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues <CompraDetalle_Info, int> updateValues) { foreach (var product in updateValues.Update) { if (updateValues.IsValid(product)) { Lista_CompraDet.UpdateRow(product, Convert.ToDecimal(SessionFixed.IdTransaccionSessionActual)); } } return(GridViewPartial_CompraProductoDetalle()); }
protected void DeleteTagTemplate(int templateId, MVCxGridViewBatchUpdateValues <TBL_TAG_TEMP, int> updateValues) { try { tagTemplateService.DeleteTagTemplate(templateId, User.Identity.GetUserId()); tagTemplateService.SaveTagTemplate(); } catch (Exception e) { updateValues.SetErrorText(templateId, e.Message); } }
public ActionResult RecipeIngredientsBatchUpdate(MVCxGridViewBatchUpdateValues <RecipeIngredient, Guid> batchValues, int recipeId) { if (ModelState.IsValid) { } else { ViewData["EditError"] = "Please, correct all errors."; } return(RecipeIngredientsGrid(recipeId)); }
public ActionResult UpdateProductLevels(MVCxGridViewBatchUpdateValues <WarehouseProductLevelViewModel, int> updateValues) { foreach (var product in updateValues.Update) { if (updateValues.IsValid(product)) { _tenantLocationServices.UpdateProductLevelsForTenantLocation(CurrentWarehouseId, product.ProductID, product.MinStockQuantity, CurrentUserId); } } return(_StockLevelsPartial()); }
protected void DeleteTag(int defId, MVCxGridViewBatchUpdateValues <TBL_ALARM_TEMP, int> updateValues) { try { alarmDefinitionService.DeleteAlarmDefinition(defId, User.Identity.GetUserId()); alarmDefinitionService.SaveAlarmDefinition(); } catch (Exception e) { updateValues.SetErrorText(defId, e.Message); } }
protected void UpdateTag(TBL_ALARM_TEMP def, MVCxGridViewBatchUpdateValues <TBL_ALARM_TEMP, int> updateValues) { //try //{ // alarmDefinitionService.UpdateAlarmDefinition(def); // alarmDefinitionService.SaveAlarmDefinition(); //} //catch (Exception e) //{ // updateValues.SetErrorText(def, e.Message); //} }
protected void DeleteProduct(int EMPID, MVCxGridViewBatchUpdateValues <object, int> updateValues) { try { var subs = from m in db.Subs select m.SubjID; } catch (Exception e) { updateValues.SetErrorText(EMPID, e.Message); } }
public static bool Validation(TR01AViewModel model, MVCxGridViewBatchUpdateValues <TR01BViewModel, int> updateValues, ModelStateDictionary modelState) { if (model.TAX_RT < 0) { modelState.AddModelError("TAX_RT", "Error"); } for (int i = 0; i < updateValues.Insert.Count; i++) { //if (updateValues.Insert[i].ITM_NO == null || updateValues.Insert[i].ITM_NO.Length < 1) //{ // modelState.AddModelError($"Insert[{i}].ITM_NO", "必填"); //} if (updateValues.Insert[i].ITM_NM == null || updateValues.Insert[i].ITM_NM.Length < 1) { modelState.AddModelError($"Insert[{i}].ITM_NM", "必填"); } if (updateValues.Insert[i].PUR_QT < 0) { modelState.AddModelError($"Insert[{i}].PUR_QT", "不可以小於零"); } if (updateValues.IsValid(updateValues.Insert[i]) == false) { modelState.AddModelError($"Insert[{i}]", "error"); } } for (int i = 0; i < updateValues.Update.Count; i++) { //測試用 //if (updateValues.Update[i].REM_MM != null && updateValues.Update[i].REM_MM.Length > 10) //{ // modelState.AddModelError($"Update[{i}].REM_MM", "REM_MM太長"); //} if (updateValues.Update[i].ITM_NM == null || updateValues.Update[i].ITM_NM.Length < 1) { modelState.AddModelError($"Update[{i}].ITM_NM", "必填"); } if (updateValues.Update[i].PUR_QT < 0) { modelState.AddModelError($"Update[{i}].PUR_QT", "不可以小於零"); } if (updateValues.IsValid(updateValues.Update[i]) == false) { modelState.AddModelError($"Update[{i}]", "error"); } } return(modelState.IsValid); }
public ActionResult PrivilegeUpdate(MVCxGridViewBatchUpdateValues<FileManagerRolePrivilegeViewModel, int> updateValues) { int fileId = 0; List<FileManagerRolePrivilegeViewModel> models = new List<FileManagerRolePrivilegeViewModel>(); //todo here is create connection to service update FileManagerPrivileges BatchUpdateFilePrivilegeRequest request = new BatchUpdateFilePrivilegeRequest(); var datas = new List<UpdateFilePrivilegeRequest>(); foreach (var item in updateValues.Update) { var privilege = item.MapTo<UpdateFilePrivilegeRequest>(); datas.Add(privilege); fileId = item.FileId; } request.BatchUpdateFilePrivilege = datas.ToList(); var response = ProcessBlueprintDataProvider.service.BatchUpdateFilePrivilege(request); var data = ProcessBlueprintDataProvider.service.GetPrivileges(new Services.Requests.ProcessBlueprint.GetProcessBlueprintPrivilegeRequest { FileId = fileId }); if (data.IsSuccess) { models = data.FileManagerRolePrivileges.ToList().MapTo<FileManagerRolePrivilegeViewModel>(); } return PartialView("_PrivilegePartial", models); }