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));
}
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 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 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 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 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 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 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));
}
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 TagGridUpdateTemp(MVCxGridViewBatchUpdateValues <TagDTO, int> updateValues)
{
string curUserId = User.Identity.GetUserId();
foreach (TagDTO tagDto in updateValues.Insert)
{
if (updateValues.IsValid(tagDto))
{
TBL_TAG tag = new TBL_TAG();
tag = Mapper.Map <TagDTO, TBL_TAG>(tagDto);
tag.CREATED_DATE = DateTime.Now;
if (tag.IS_DIGITAL == null)
{
tag.IS_DIGITAL = false;
}
DB.Tags.Add(tag);
}
}
foreach (TagDTO tagDto in updateValues.Update)
{
if (updateValues.IsValid(tagDto))
{
TBL_TAG ent = DB.Tags.FirstOrDefault(x => x.ID == tagDto.ID);
//ent = Mapper.Map<TagDTO, TBL_TAG>(tagDto);
ent.NAME = tagDto.NAME;
ent.UPDATED_DATE = DateTime.Now;
ent.UPDATE_USER = curUserId;
ent.IS_DIGITAL = tagDto.IS_DIGITAL;
ent.IS_INV_TAG = tagDto.IS_INV_TAG.Value;
ent.IS_STRING = tagDto.IS_STRING;
DB.Entry(ent).State = EntityState.Modified;
DB.SaveChanges();
//DB.Tags.Attach(ent);
}
}
foreach (var tagIg in updateValues.DeleteKeys)
{
TBL_TAG ent = DB.Tags.FirstOrDefault(x => x.ID == tagIg);
ent.IS_DELETED = true;
}
DB.SaveChanges();
return(PartialView("GridTagPartial"));
}
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 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 GridUpdateTemDet(MVCxGridViewBatchUpdateValues <TBL_ALARM_DEF, int> updateValues, int templateId)
{
//object curObj;
try
{
string curUserId = User.Identity.GetUserId();
foreach (TBL_ALARM_DEF tag in updateValues.Insert)
{
if (updateValues.IsValid(tag))
{
tag.TEMPLATE_ID = templateId;
DB.AlarmDefinitions.Add(tag);
}
}
foreach (TBL_ALARM_DEF tag in updateValues.Update)
{
if (updateValues.IsValid(tag))
{
TBL_ALARM_DEF ent = DB.AlarmDefinitions.FirstOrDefault(x => x.ID == tag.ID);
ent.UPDATED_DATE = DateTime.Now;
ent.UPDATE_USER = curUserId;
ent.ALARM_TYPE = tag.ALARM_TYPE;
ent.IS_ALARM = tag.IS_ALARM;
ent.DESC = tag.DESC;
ent.OP = tag.OP;
ent.STATUS_NO = tag.STATUS_NO;
ent.TAG_ID = tag.TAG_ID;
ent.VALUE = tag.VALUE;
}
}
foreach (var tagIg in updateValues.DeleteKeys)
{
TBL_ALARM_DEF ent = DB.AlarmDefinitions.FirstOrDefault(x => x.ID == tagIg);
ent.IS_DELETED = true;
ent.UPDATED_DATE = DateTime.Now;
ent.UPDATE_USER = curUserId;
}
DB.SaveChanges();
return(PartialView("AlarmDefinitionGridPartial", templateId));
}
catch (Exception ex)
{
//updateValues.SetErrorText( curObj, ex.Message);
return(PartialView("AlarmDefinitionGridPartial", templateId));
}
}
public ActionResult GridViewPartialProductsBatchUpdatePartial(MVCxGridViewBatchUpdateValues <Product, object> updateValues)
{
var model = db.Products;
foreach (var product in updateValues.Insert)
{
if (updateValues.IsValid(product))
{
model.Add(product);
db.SaveChanges();
}
}
foreach (var product in updateValues.Update)
{
if (updateValues.IsValid(product))
{
var item = model.FirstOrDefault(c => c.Id == product.Id);
item.SupplierId = product.SupplierId;
item.CategoryId = product.CategoryId;
item.Discontinued = product.Discontinued;
item.ProductName = product.ProductName;
item.QuantityPerUnit = product.QuantityPerUnit;
item.ReorderLevel = product.ReorderLevel;
item.UnitPrice = product.UnitPrice;
item.UnitsInStock = product.UnitsInStock;
item.UnitsOnOrder = product.UnitsOnOrder;
db.SaveChanges();
}
}
foreach (var id in updateValues.DeleteKeys)
{
var item = model.FirstOrDefault(c => c.Id == Convert.ToInt32(id));
if (item != null)
{
model.Remove(item);
db.SaveChanges();
}
}
return(PartialView("_GridViewProductsBatchEditPartial", db.Products.ToList()));
}
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 ActionResult AmountsSave(uint id, MVCxGridViewBatchUpdateValues <PromotionSum, int> updateValues)
{
foreach (var itemId in updateValues.DeleteKeys)
{
var item = DbSession.Query <PromotionPercent>().FirstOrDefault(r => r.Id == itemId);
if (item != null)
{
DbSession.Delete(item);
}
}
var promotion = DbSession.Query <ProducerPromotion>().First(r => r.Id == id);
foreach (var item in updateValues.Insert)
{
if (updateValues.IsValid(item))
{
try {
item.Promotion = promotion;
DbSession.Save(item);
} catch (Exception ex) {
updateValues.SetErrorText(item, ex.Message);
}
}
}
foreach (var item in updateValues.Update)
{
if (updateValues.IsValid(item))
{
try {
var record = DbSession.Query <PromotionSum>().First(r => r.Id == item.Id);
record.DealerSum = item.DealerSum;
record.MemberSum = item.MemberSum;
record.Quantity = item.Quantity;
} catch (Exception ex) {
updateValues.SetErrorText(item, ex.Message);
}
}
}
return(GridAmounts(id));
}
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());
}
public ActionResult GridUpdateTemp(MVCxGridViewBatchUpdateValues <TBL_ALARM_TEMP, int> updateValues)
{
//object curObj;
try
{
string curUserId = User.Identity.GetUserId();
foreach (TBL_ALARM_TEMP tag in updateValues.Insert)
{
if (updateValues.IsValid(tag))
{
DB.AlarmTemplate.Add(tag);
}
}
foreach (TBL_ALARM_TEMP tag in updateValues.Update)
{
if (updateValues.IsValid(tag))
{
TBL_ALARM_TEMP ent = DB.AlarmTemplate.FirstOrDefault(x => x.ID == tag.ID);
ent.UPDATED_DATE = DateTime.Now;
ent.UPDATE_USER = curUserId;
ent.NAME = tag.NAME;
}
}
DB.SaveChanges();
foreach (var tagIg in updateValues.DeleteKeys)
{
DB.AlarmTemplate.Where(x => x.ID == tagIg)
.Update(x => new TBL_ALARM_TEMP()
{
IS_DELETED = true
});
}
return(PartialView("AlarmTempGridPartial"));
}
catch (Exception ex)
{
//updateValues.SetErrorText( curObj, ex.Message);
return(PartialView("AlarmTempGridPartial"));
}
}
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());
}
/* save all changes to a data base in this action */
public bool UpdateAllValues(MVCxGridViewBatchUpdateValues <GridDataItem, int> batchValues, MainModel mainModel)
{
if (batchValues != null)
{
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);
}
}
bool result = false;
if (mainModel != null)
{
//custom actions
result = true;
}
return(result && (batchValues == null || batchValues.EditorErrors.Count == 0));
}
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues <object, int> updateValues)
{
foreach (var product in updateValues.Insert)
{
if (updateValues.IsValid(product))
{
InsertProduct(product, updateValues);
}
}
foreach (var product in updateValues.Update)
{
if (updateValues.IsValid(product))
{
UpdateProduct(product, updateValues);
}
}
foreach (var productID in updateValues.DeleteKeys)
{
DeleteProduct(productID, updateValues);
}
return(PartialView("SubjectView", db.Subs.ToList()));
}
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues <ro_AjusteImpuestoRentaDetOI_Info, int> updateValues)
{
foreach (var ajuste in updateValues.Insert)
{
if (updateValues.IsValid(ajuste))
{
Lista_Ajuste_OI.InsertRow(ajuste, Convert.ToDecimal(SessionFixed.IdTransaccionSessionActual));
}
}
foreach (var ajuste in updateValues.Update)
{
if (updateValues.IsValid(ajuste))
{
Lista_Ajuste_OI.UpdateRow(ajuste, Convert.ToDecimal(SessionFixed.IdTransaccionSessionActual));
}
}
foreach (var ajuste in updateValues.DeleteKeys)
{
Lista_Ajuste_OI.DeleteRow(ajuste, Convert.ToDecimal(SessionFixed.IdTransaccionSessionActual));
}
return(GridViewPartial_AjusteImpuestoRenta_OI());
}
/// <summary>
/// Recommend products as per stock and requested.
/// </summary>
/// <param name="updatedProducts">The list of products that been modified and need to update.</param>
public static void RecommendShelters(MVCxGridViewBatchUpdateValues <OrderProduct, int> updatedProducts)
{
var orderShelters = OimsDataContext.Sheltersrequests;
// Note: Key to understand terms
// oProd.OP_Quantity - The quantity of shelters that were requested in total
// oProd.OP_Pending - The quantity of shelters left pending to be delivered
// oProd.OP_ProdAlloc - The quantity of shelters that have been allocated (after manager approval)
// prod.ProdRecom - The quantity of shelter that had been marked as recommend by supervisor
// Save items in separate other table for keeping track
foreach (var prod in updatedProducts.Update)
{
if (!updatedProducts.IsValid(prod))
{
continue;
}
var oProd = orderShelters.FirstOrDefault(i => i.OP_Id.Equals(prod.Id));
if (oProd == null)
{
continue;
}
var prodAlloc = oProd.OP_ProdAlloc ?? 0;
var prodAllRec = prodAlloc + prod.ProdRecom;
#region Throw custom exception for some conditions
// If Recommended more than Requested
if (prod.ProdRecom > oProd.OP_Quantity)
{
throw new CustomException(Resources.Supervisor.RGridErrorMsgForExtraRecommend);
}
// If sum of Allocated + Recommend exceed than Requested
if (prodAllRec > oProd.OP_Quantity)
{
throw new CustomException(Resources.Supervisor.RGridErrorMsgForPartial);
}
#endregion
oProd.OP_ProdRecom = prod.ProdRecom;
oProd.OP_Pending = (int?)(oProd.OP_Quantity - prodAllRec);
OimsDataContext.FlushChanges();
}
OimsDataContext.SaveChanges();
}
public ActionResult UpdateProductLevels(MVCxGridViewBatchUpdateValues <MarketProductLevelViewModel, int> updateValues)
{
int marketId = Convert.ToInt32(Request.Params["MarketId"]);
foreach (var product in updateValues.Update)
{
if (updateValues.IsValid(product))
{
_marketServices.UpdateProductLevelsForMarkets(marketId, product.ProductID,
product.MinStockQuantity, CurrentUserId);
}
}
return(_StockLevelsPartial(marketId));
}
public static bool Validation(MVCxGridViewBatchUpdateValues <TR01CModel, int> updateValues, ModelStateDictionary modelState)
{
for (int i = 0; i < updateValues.Insert.Count; i++)
{
//if (updateValues.Insert[i].ARR_QT < 1)
//{
// modelState.AddModelError($"Insert[{i}].ARR_QT", "> 0");
//}
if (updateValues.Insert[i].ARR_QT < 0)
{
modelState.AddModelError($"Insert[{i}].ARR_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].ITM_NO == null || updateValues.Update[i].ITM_NO.Length < 1)
//{
// modelState.AddModelError($"Update[{i}].ITM_NO", "必填");
//}
if (updateValues.Update[i].ARR_QT < 0)
{
modelState.AddModelError($"Update[{i}].ARR_QT", "不可以小於零");
}
if (updateValues.IsValid(updateValues.Update[i]) == false)
{
modelState.AddModelError($"Update[{i}]", "error");
}
}
return(modelState.IsValid);
}
public ActionResult BatchUpdatePartial(MVCxGridViewBatchUpdateValues <HovisMillingPortal.Models.t_Milling_Bacs_Detail, int> batchValues, System.Int64 headerrecid)
{
var britishZone = TimeZoneInfo.FindSystemTimeZoneById("GMT Standard Time");
var adjusteddate = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.Local, britishZone);
foreach (var item in batchValues.Insert)
{
if (batchValues.IsValid(item))
{
InsertNewItem(item, batchValues, headerrecid);
}
else
{
batchValues.SetErrorText(item, "Correct validation errors");
}
}
foreach (var item in batchValues.Update)
{
if (batchValues.IsValid(item))
{
UpdateItem(item, batchValues, headerrecid);
}
else
{
batchValues.SetErrorText(item, "Correct validation errors");
}
}
foreach (var itemKey in batchValues.DeleteKeys)
{
DeleteItem(itemKey, batchValues, headerrecid);
}
var model = db.t_Milling_Bacs_Detail.Where(s => s.HeaderRecid == headerrecid).ToList();
return(PartialView("_BacsDetailsGridViewPartial", model));
}
public ActionResult LegalEntityLimitsSave(uint id, MVCxGridViewBatchUpdateValues <LegalEntityLimitViewModel, int> updateValues)
{
foreach (var item in updateValues.Update)
{
if (updateValues.IsValid(item))
{
try {
var limit = DbSession.Query <LegalEntityLimit>().First(r => r.Id == item.LimitId);
limit.MinSum = item.MinSum;
} catch (Exception ex) {
updateValues.SetErrorText(item, ex.Message);
}
}
}
return(GridLegalEntityLimits(id));
}
/// <summary>
/// Recommend items as per stock and requested.
/// </summary>
/// <param name="updatedItems">The list of items that been modified and need to update.</param>
public static void RecommendItems(MVCxGridViewBatchUpdateValues <OrderItem, int> updatedItems)
{
var orderItems = OimsDataContext.Itemsrequests;
// Save items in separate other table for keeping track
foreach (var item in updatedItems.Update)
{
if (!updatedItems.IsValid(item))
{
continue;
}
var oItem = orderItems.FirstOrDefault(i => i.OI_Id.Equals(item.Id));
if (oItem == null)
{
continue;
}
var itemAlloc = oItem.OI_ItemAlloc ?? 0;
var itemAllRec = itemAlloc + item.ItemRecom;
#region Throw custom exception for some conditions
//if (Application.ReqStatus.Equals("Partial approved") && item.ItemRecom < oItem.OI_ItemRecom)
// throw new CustomException(Resources.Supervisor.RGridErrorMsgForPartial);
if (item.ItemRecom > oItem.OI_Quantity)
{
throw new CustomException(Resources.Supervisor.RGridErrorMsgForExtraRecommend);
}
// If sum of Allocated + Recommend exceed than Requested
if (itemAllRec > oItem.OI_Quantity)
{
throw new CustomException(Resources.Supervisor.RGridErrorMsgForPartial);
}
#endregion
oItem.OI_ItemRecom = item.ItemRecom;
oItem.OI_Pending = oItem.OI_Quantity - itemAllRec;
OimsDataContext.FlushChanges();
}
OimsDataContext.SaveChanges();
}
public ActionResult BatchEditingUpdateModel(MVCxGridViewBatchUpdateValues <ProductoOCDTO, int> updateValues)
{
if (Session["StringToken"] == null)
{
return(RedirectToAction("Index", "Home"));
}
tkn = Session["StringToken"].ToString();
var model = (OrdenCompraModel)TempData["OrdenCompraModel"];
model.OrdenCompraProductos = new List <ProductoOCDTO>();
foreach (var product in updateValues.Update)
{
if (updateValues.IsValid(product))
{
model.OrdenCompraProductos.Add(product);
}
}
return(CrearOrdenCompra(model));
}
public ActionResult EditConditionsBatch(uint id,
MVCxGridViewBatchUpdateValues <ConditionsGridViewModel, int> updateValues)
{
foreach (var item in updateValues.Update)
{
if (updateValues.IsValid(item))
{
try {
var condition = DbSession.Query <PromotionProduct>().Single(r => r.Id == item.ConditionId);
condition.Price = item.Price;
condition.DealerPercent = item.DealerPercent;
condition.MemberPercent = item.MemberPercent;
} catch (Exception ex) {
updateValues.SetErrorText(item, ex.Message);
}
}
}
var model = GetConditionsViewModel(id);
return(PartialView("partials/_ConditionsGridView", model));
}
