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);
}
