public ActionResult DetailGridViewPartialUpdate([ModelBinder(typeof(DevExpressEditorsBinder))] DetailCompta line, int transId) { var model = db.DetailComptas; line.transid = transId; ViewBag.DetailCompta = line; if (ModelState.IsValid) { try { var modelItem = model.FirstOrDefault(p => p.id == line.id); if (modelItem != null) { this.UpdateModel(modelItem); db.SubmitChanges(); IWSLookUp.SetJournal(transId); } } catch (Exception e) { ViewData["GenericError"] = e.Message; } } else { ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState); } return(PartialView("DetailGridViewPartial", IWSLookUp.GetDetailCompta(transId))); }
public ActionResult DetailGridViewPartialAddNew([ModelBinder(typeof(DevExpressEditorsBinder))] DetailCompta line, int transId) { int modelId = (int)Session["Modelid"]; var model = db.DetailComptas; line.transid = transId; line.ModelId = modelId; ViewBag.DetailCompta = line; if (ModelState.IsValid) { try { model.InsertOnSubmit(line); db.SubmitChanges(); IWSLookUp.SetJournal(transId); db.SubmitChanges(); } catch (Exception e) { ViewData["GenericError"] = e.Message; } } else { ViewData["GenericError"] = IWSLookUp.GetModelSateErrors(ModelState); } return(PartialView("DetailGridViewPartial", IWSLookUp.GetDetailCompta(transId))); }
private void MakeGeneralLedger(string IDs) { decimal amount = 0; int newId = 0; string period = string.Empty; string IDx = string.Empty; IList <string> items = new List <string>(IDs.Split(new string[] { ";" }, StringSplitOptions.None)); foreach (string item in items) { var list = item.Split(new string[] { "," }, StringSplitOptions.None); IDx = list[1]; period = list[2]; amount = Convert.ToDecimal(list[3], CultureInfo.InvariantCulture); ImmoDetailViewModel details = IWSLookUp.GetImmoDetail(IDx, period); MasterCompta header = new MasterCompta() { CostCenter = details.CostCenter, account = "6222", HeaderText = IWSLocalResource.Depreciation, TransDate = details.TransDate, ItemDate = details.ItemDate, EntryDate = details.EntryDate, CompanyId = details.CompanyId, ModelId = (int)IWSLookUp.ComptaMasterModelId.GeneralLedger, IsValidated = false }; newId = MakeGLHeader(header); DetailCompta detailCompta = new DetailCompta() { transid = newId, account = details.OAccount, side = details.Side, oaccount = details.Account, amount = Math.Round(amount, 2), duedate = details.DueDate, Currency = details.Currency, ModelId = (int)IWSLookUp.ComptaMasterModelId.GeneralLedger, Terms = null, text = null, Balanced = false }; newId = MakeGLDetail(detailCompta); if (newId > 0) { UpdateDepreciationDetail(IDx, period); } } }
private int MakeGLDetail(DetailCompta detailCompta) { int id = 0; try { db.DetailComptas.InsertOnSubmit(detailCompta); db.SubmitChanges(ConflictMode.FailOnFirstConflict); id++; int transid = detailCompta.transid; bool rs = IWSLookUp.SetJournal(transid); db.SubmitChanges(); } catch (Exception ex) { IWSLookUp.LogException(ex); } return(id); }