public ActionResult Create(TaxpayerRecipient item) { if (!string.IsNullOrEmpty (item.Id)) { var entity = TaxpayerRecipient.TryFind (item.Id); if (entity != null) { ModelState.AddModelError ("", Resources.TaxpayerRecipientAlreadyExists); } } if (!item.HasAddress) { ModelState.Where (x => x.Key.StartsWith ("Address.")).ToList ().ForEach (x => x.Value.Errors.Clear ()); item.Address = null; } if (!ModelState.IsValid) { return PartialView ("_Create", item); } item.Id = item.Id.ToUpper ().Trim (); item.Name = item.Name.Trim (); item.Email = item.Email.Trim (); using (var scope = new TransactionScope ()) { if (item.HasAddress) { item.Address.Create (); } item.CreateAndFlush (); } return PartialView ("_CreateSuccesful", item); }
public ActionResult ApplyPayment(SalesOrderPayment item) { var entity = new SalesOrderPayment { SalesOrder = SalesOrder.TryFind (item.SalesOrder.Id), Payment = CustomerPayment.TryFind (item.PaymentId), Amount = item.Amount }; var balance = entity.SalesOrder.Balance - GetRefunds (entity.SalesOrder.Id); if (entity.Amount > entity.Payment.Balance) { entity.Amount = entity.Payment.Balance; } balance -= entity.Amount; using (var scope = new TransactionScope ()) { if (balance <= 0) { entity.SalesOrder.IsPaid = true; entity.SalesOrder.Update (); } if (entity.Amount > 0) { entity.Create (); } scope.Flush (); } return PartialView ("_ApplyPaymentSuccesful"); }
public JsonResult AddPurchaseDetail(int movement, int warehouse, int product) { var p = Product.Find (product); var cost = (from x in ProductPrice.Queryable where x.Product.Id == product && x.List.Id == 0 select x.Value).SingleOrDefault (); var item = new PurchaseOrderDetail { Order = PurchaseOrder.Find (movement), Warehouse = Warehouse.Find (warehouse), Product = p, ProductCode = p.Code, ProductName = p.Name, Quantity = 1, TaxRate = p.TaxRate, IsTaxIncluded = p.IsTaxIncluded, Discount = 0, Price = cost, ExchangeRate = CashHelpers.GetTodayDefaultExchangeRate (), Currency = WebConfig.DefaultCurrency }; using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return Json (new { id = item.Id }); }
public ActionResult Create(Supplier item) { if (!ModelState.IsValid) return PartialView ("_Create", item); using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return PartialView ("_CreateSuccesful", item); //if (!ModelState.IsValid) //{ // if (Request.IsAjaxRequest()) // return PartialView("_Create", supplier); // return View(supplier); //} //supplier.Create (); //if (Request.IsAjaxRequest()) //{ // //FIXME: localize string // return PartialView("_Success", "Operation successful!"); //} //return View("Index"); }
public static void Registro() { foreach (var archivo in ActiveRecordBase<ConsumoDto>.FindAllByProperty("Procesado", false)) { var documento = HelperPersona.GetPersona( archivo.Cuit, archivo.TipoCliente, archivo.RazonSocial, archivo.NombrePersona, archivo.NroDocumento, archivo.Empresa); var cliente = HelperCuenta.GetCuenta( archivo.Cuit, archivo.NroDocumento, archivo.Empresa); using (var transac = new TransactionScope()) try { var puntos = HelperPuntos.GetPuntos(archivo.Empresa, archivo.FechaHoraComprobante, archivo.ImportePesosNetoImpuestos); double acelerador = Double.Parse(archivo.Coeficiente) / 100; puntos = acelerador > 0 ? acelerador * puntos : puntos; var cuenta = new CuentaCorrienteDto { FechaCompra = archivo.FechaHoraComprobante.Date, HoraCompra = DateTime.Now, Key = new KeyCuenta { CodEmpresa = archivo.Empresa, NumeroComprobante = archivo.NroComprobante }, MontoCompra = archivo.ImportePesosNetoImpuestos, Movimiento = puntos >= 0 ? HelperMovimiento.FindMovimiento("Suma De Puntos") : HelperMovimiento.FindMovimiento("Anulación Carga"), NumeroDocumento = documento, NumeroCuenta = cliente, Puntos = puntos, Sucursal = HelperSucursal.GetSucursal(), Usuario = "web", Programa = archivo.Programa, Secretaria = archivo.Secretaria, Coeficiente = archivo.Coeficiente }; cuenta.Save(); transac.VoteCommit(); } catch (Exception ex) { archivo.Error = ex.Message; Log.Fatal(ex); transac.VoteRollBack(); } archivo.Procesado = true; archivo.Save(); } }
public void ActiveRecordUsingTransactionScopeWithRollback() { InitModel(); using (TransactionScope scope = new TransactionScope()) { new SSAFEntity("example").Save(); //Assert.AreEqual(1, SSAFEntity.FindAll().Length); scope.VoteRollBack(); } Assert.AreEqual(0, SSAFEntity.FindAll().Length); }
public ActionResult Create(Employee item) { if (!ModelState.IsValid) { return PartialView ("_Create", item); } using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return PartialView ("_Refresh"); }
public ActionResult CancelReturn(int id) { var item = SupplierReturn.Find (id); item.IsCancelled = true; using (var scope = new TransactionScope ()) { item.UpdateAndFlush (); } return RedirectToAction ("Index"); }
public ActionResult Create(TechnicalServiceReceipt item) { if (!ModelState.IsValid) { return PartialView ("_Create", item); } using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return PartialView ("_CreateSuccesful", item); }
public static void DisposeScope() { if (TransactionScope != null) { TransactionScope.Dispose(); TransactionScope = null; } if (Scope != null) { Scope.Dispose(); Scope = null; } }
public void Can_execute_SQL() { using (var transaction = new TransactionScope()) { var user = repository.Save(new User {Email = "*****@*****.**", Name = "User1"}); transaction.Flush(); repository.ExecuteSql(string.Format("UPDATE User SET Email=\"[email protected]\"", user.Id)); transaction.Flush(); repository.Refresh(user); Assert.AreEqual("*****@*****.**", user.Email); } }
public ActionResult Create(Notarization item) { item.Requester = Employee.TryFind (item.RequesterId); if (!ModelState.IsValid) { return PartialView ("_Create", item); } using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return PartialView ("_CreateSuccesful", item); }
public ActionResult Confirm(int id) { var item = SalesOrder.Find (id); item.Updater = CurrentUser.Employee; item.ModificationTime = DateTime.Now; item.IsDelivered = true; using (var scope = new TransactionScope ()) { item.UpdateAndFlush (); } return RedirectToAction ("Index"); }
public ActionResult Edit(int id, FormCollection form) { using (var transaction = new TransactionScope(TransactionMode.Inherits)) { var original = Document.Find(id); if (TryUpdateModel(original)) { original.Save(); return RedirectToAction("Details", new { Id = id }); } transaction.VoteRollBack(); return View("Edit"); } }
public ActionResult Create(TechnicalServiceRequest item) { item.Customer = Customer.TryFind (item.CustomerId); if (!ModelState.IsValid) { return PartialView ("_Create", item); } using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return PartialView ("_CreateSuccesful", item); }
/// <summary> /// evento disparado pelo botão salvar /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSalvar_Click1(object sender, EventArgs e) { //bisca a lista de moradores selecionados List<int> lista = (List<int>)ViewState["moradores"]; if (lista.Count > 0) { //abre a transação using (TransactionScope trans = new TransactionScope()) { try { //cria o template da mensagem Domain.Model.Mensagem mensagem = new Domain.Model.Mensagem(); mensagem.Usuario = txtUsuario.Text; mensagem.Detalhe = txtMensagem.Text; mensagem.CreateAndFlush(); Usuario user = new Usuario(); MensagensDosUsuarios mensagemRelacionada; //envia a mensagem para casa usuário selecionado foreach (var item in lista) { user.Id = item; mensagemRelacionada = new MensagensDosUsuarios(); mensagemRelacionada.Mensagem = mensagem; mensagemRelacionada.Usuario = user; mensagemRelacionada.CreateAndFlush(); } //commit da transação trans.VoteCommit(); } catch (Exception ex) { //rollback da transação trans.VoteRollBack(); //grava o erro em um log Logger.Error(ex.Message); base.ExibirMensagemErro(); } } base.ExibirMensagemSucesso(Funcionalidade.Mensagem, Operacao.Inclusao); } else { pnlMensagem.ExibirMensagem("Selecione os usuários para quem você vai enviar a mensagem"); } }
public ActionResult Cancel(int id) { var entity = CustomerRefund.Find (id); entity.Updater = CurrentUser.Employee; entity.ModificationTime = DateTime.Now; entity.Date = DateTime.Now; entity.IsCancelled = true; using (var scope = new TransactionScope ()) { entity.UpdateAndFlush (); } return RedirectToAction ("Index"); }
public ActionResult Confirm(int id) { var dt = DateTime.Now; bool changed = false; var entity = CustomerRefund.Find (id); using (var scope = new TransactionScope ()) { foreach (var item in entity.Details) { var qty = GetRefundableQuantity (item.SalesOrderDetail.Id); if (qty < item.Quantity) { changed = true; if (qty > 0) { item.Quantity = qty; item.Update (); } else { item.Delete (); } } } if (changed) { entity.Updater = CurrentUser.Employee; entity.ModificationTime = dt; entity.UpdateAndFlush (); return RedirectToAction ("Edit", new { id = entity.Id, notify = true }); } } using (var scope = new TransactionScope ()) { foreach (var x in entity.Details) { InventoryHelpers.ChangeNotification (TransactionType.CustomerRefund, entity.Id, dt, x.SalesOrderDetail.Warehouse, null, x.Product, x.Quantity); } entity.Updater = CurrentUser.Employee; entity.ModificationTime = dt; entity.Date = dt; entity.IsCompleted = true; entity.UpdateAndFlush (); } return RedirectToAction ("View", new { id = entity.Id }); }
public ActionResult ConfirmReturn(int id) { var item = SupplierReturn.Find (id); var qry = from x in item.Details where x.Order.Id == id group x by x.Warehouse into g select new { Warehouse = g.Key, Details = g.ToList () }; var dt = DateTime.Now; var employee = CurrentUser.Employee; using (var scope = new TransactionScope ()) { foreach (var x in qry) { var master = new InventoryIssue { Return = item, Warehouse = x.Warehouse, CreationTime = dt, ModificationTime = dt, Creator = employee, Updater = employee, Comment = string.Format (Resources.Message_SupplierReturn, item.Supplier.Name, item.PurchaseOrder.Id, item.Id) }; master.Create (); foreach (var y in x.Details) { var detail = new InventoryIssueDetail { Issue = master, Product = y.Product, Quantity = y.Quantity, ProductCode = y.ProductCode, ProductName = y.ProductName }; detail.Create (); } } item.IsCompleted = true; item.UpdateAndFlush (); } return RedirectToAction ("Index"); }
public JsonResult AddIssueDetail(int movement, int product) { var p = Product.Find (product); var item = new InventoryIssueDetail { Issue = InventoryIssue.Find (movement), Product = p, ProductCode = p.Code, ProductName = p.Name, Quantity = 1 }; using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return Json (new { id = item.Id }); }
public static string GetPaymentUrl(Transaction idealPayer, string mollieClientNumber, bool testMode, string paymentName, string reportUrl, string landUrl) { if(idealPayer.Payed) throw new Exception("Er is al betaald"); IdealFetch idealFetch = new IdealFetch(mollieClientNumber, testMode, paymentName, reportUrl, landUrl, idealPayer.BankId, idealPayer.Amount); if (idealFetch.Error) { throw new Exception(idealFetch.ErrorMessage); } idealPayer.TransactionId = idealFetch.TransactionId; using( TransactionScope transactionScope = new TransactionScope(TransactionMode.Inherits, OnDispose.Rollback)) { idealPayer.Save(); transactionScope.VoteCommit(); } return idealFetch.Url; }
public ActionResult Create(Document document) { using(var transaction = new TransactionScope(TransactionMode.New)) { try { var user = _user.UserName(); var author = Models.User.FindByUsername(user); author.Documents.Add(document); author.Save(); return RedirectToAction("Index"); } catch (NotFoundException ex) { transaction.VoteRollBack(); ViewBag.ErrorMessage = String.Format("{0}. Please add the user first.", ex.Message); } } return View("Create"); }
public ActionResult AddTaxpayer(int id, string value) { var item = Customer.TryFind (id); var taxpayer = TaxpayerRecipient.TryFind (value); if (item == null) { Response.StatusCode = 400; return Content (Resources.CustomerNotFound); } if (taxpayer == null) { Response.StatusCode = 400; return Content (Resources.TaxpayerRecipientNotFound); } using (var scope = new TransactionScope ()) { item.Taxpayers.Add (taxpayer); item.Update (); } return Json (new { id = id, result = true }); }
public ActionResult AddItem(int id, int product) { var p = Product.Find (product); var entity = DeliveryOrder.Find (id); if (entity.IsCompleted || entity.IsCancelled) { Response.StatusCode = 400; return Content (Resources.ItemAlreadyCompletedOrCancelled); } var item = new DeliveryOrderDetail { DeliveryOrder = DeliveryOrder.Find (id), Product = p, ProductCode = p.Code, ProductName = p.Name, Quantity = 1, }; using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return Json (new { id = item.Id }); }
bool CreateUser(string username, string password, string email) { username = username.ToLower (); if (Model.User.Queryable.Count (x => x.UserName == username) > 0) { throw new Exception (Mictlanix.BE.Resources.Message_UserNameAlreadyExists); } var item = new User { UserName = username, Password = SecurityHelpers.SHA1 (password), Email = email.ToLower () }; using (var scope = new TransactionScope ()) { item.CreateAndFlush (); } return true; }
bool ChangePassword(string username, string oldPassword, string newPassword) { User item = Model.User.Find (username); string pwd = SecurityHelpers.SHA1 (oldPassword); if (item == null || item.Password != pwd) return false; item.Password = SecurityHelpers.SHA1 (newPassword); using (var scope = new TransactionScope ()) { item.UpdateAndFlush (); } return true; }
public ActionResult AddItems(int id, string value) { var entity = DeliveryOrder.Find (id); SalesOrder sales_order = null; int sales_order_id = 0; int count = 0; if (entity.IsCompleted || entity.IsCancelled) { Response.StatusCode = 400; return Content (Resources.ItemAlreadyCompletedOrCancelled); } if (int.TryParse (value, out sales_order_id)) { sales_order = SalesOrder.TryFind (sales_order_id); } if (sales_order == null) { Response.StatusCode = 400; return Content (Resources.SalesOrderNotFound); } using (var scope = new TransactionScope ()) { foreach (var x in sales_order.Details) { var item = new DeliveryOrderDetail { DeliveryOrder = entity, Product = x.Product, OrderDetail = x, ProductCode = x.ProductCode, ProductName = x.ProductName, Quantity = x.Quantity }; item.Create (); count++; } } if (count == 0) { Response.StatusCode = 400; return Content (Resources.InvoiceableItemsNotFound); } return Json (new { id = id, value = string.Empty, itemsChanged = count }); }
public ActionResult SetShipTo(int id, int value) { var entity = DeliveryOrder.Find (id); var item = Address.TryFind (value); if (entity.IsCompleted || entity.IsCancelled) { Response.StatusCode = 400; return Content (Resources.ItemAlreadyCompletedOrCancelled); } if (item != null) { entity.ShipTo = item; entity.Updater = CurrentUser.Employee; entity.ModificationTime = DateTime.Now; using (var scope = new TransactionScope ()) { entity.UpdateAndFlush (); } } return Json (new { id = id, value = entity.ShipTo.ToString () }); }
public ActionResult SetItemQuantity(int id, decimal value) { var entity = DeliveryOrderDetail.Find (id); if (entity.DeliveryOrder.IsCompleted || entity.DeliveryOrder.IsCancelled) { Response.StatusCode = 400; return Content (Resources.ItemAlreadyCompletedOrCancelled); } if (value > 0) { entity.Quantity = value; using (var scope = new TransactionScope ()) { entity.UpdateAndFlush (); } } return Json (new { id = entity.Id, value = entity.FormattedValueFor (x => x.Quantity) }); }
public ActionResult SetItemProductName(int id, string value) { var entity = DeliveryOrderDetail.Find (id); string val = (value ?? string.Empty).Trim (); if (entity.DeliveryOrder.IsCompleted || entity.DeliveryOrder.IsCancelled) { Response.StatusCode = 400; return Content (Resources.ItemAlreadyCompletedOrCancelled); } if (val.Length == 0) { entity.ProductName = entity.Product.Name; } else { entity.ProductName = val; } using (var scope = new TransactionScope ()) { entity.UpdateAndFlush (); } return Json (new { id = entity.Id, value = entity.ProductName }); }