public async Task <ActionResult> DeleteConfirmed(int id) { NotaVenta notaVenta = await db.NotaVentas.FindAsync(id); db.NotaVentas.Remove(notaVenta); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "fecha,nombre,nit,total,notaVentaID,clienteID,vendedorID,cuotainicial,cantidadcouta,formapago")] NotaVenta notaVenta) { if (ModelState.IsValid) { db.Entry(notaVenta).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.clienteID = new SelectList(db.clientes, "clienteID", "nombre", notaVenta.clienteID); ViewBag.vendedorID = new SelectList(db.Usuarios, "UsuarioID", "UsuarioNombre", notaVenta.vendedorID); return(View(notaVenta)); }
// GET: NotaVentas/Details/5 public async Task <ActionResult> Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NotaVenta notaVenta = await db.NotaVentas.FindAsync(id); if (notaVenta == null) { return(HttpNotFound()); } return(View(notaVenta)); }
// GET: NotaVentas/Edit/5 public async Task <ActionResult> Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } NotaVenta notaVenta = await db.NotaVentas.FindAsync(id); if (notaVenta == null) { return(HttpNotFound()); } ViewBag.clienteID = new SelectList(db.clientes, "clienteID", "nombre", notaVenta.clienteID); ViewBag.vendedorID = new SelectList(db.Usuarios, "UsuarioID", "UsuarioNombre", notaVenta.vendedorID); return(View(notaVenta)); }
public async Task <ActionResult> Create(NotaVenta notaVenta, string list) { try { int i = db.NotaVentas.Count() + 1; notaVenta.notaVentaID = i; db.NotaVentas.Add(notaVenta); await db.SaveChangesAsync(); System.Web.Script.Serialization.JavaScriptSerializer js = new System.Web.Script.Serialization.JavaScriptSerializer(); List <DetalleVenta> nota = js.Deserialize <List <DetalleVenta> >(list); foreach (var item in nota) { int nt = db.DetalleVentas.Count(); item.detalleVentaID = nt + 1; item.notaVentaID = i; db.DetalleVentas.Add(item); await db.SaveChangesAsync(); } if (notaVenta.formapago.Value) { double totalc = notaVenta.total.Value - notaVenta.cuotainicial.Value; double monto = totalc / notaVenta.cantidadcouta.Value; int p = db.planPagoes.Count() + 1; planPago pl = new planPago { planPagoID = p, totalVenta = Convert.ToInt32(totalc), ncuotas = notaVenta.cantidadcouta, fecha = notaVenta.fecha, monto = Convert.ToInt32(monto), notaVentaID = i }; db.planPagoes.Add(pl); await db.SaveChangesAsync(); int total = pl.totalVenta.Value; int mon = pl.monto.Value; for (int j = 0; j < notaVenta.cantidadcouta; j++) { int co = db.cuotas.Count() + 1; DateTime dt = notaVenta.fecha.Value; cuota c = new cuota() { cuotasID = co, saldo = total - mon, haber = mon, debe = 0, fecha = dt.AddDays(30), planPagoID = p, pagado = 0 }; db.cuotas.Add(c); await db.SaveChangesAsync(); } } mensaje.Clear(); mensaje.Add(Util.mensaje(Util.OK, Util.OKMENSAJE)); return(Json(mensaje)); } catch (Exception ex) { mensaje.Clear(); mensaje.Add(Util.mensaje(Util.ERROR, ex.Message)); return(Json(mensaje)); } }
public async void DeleteNV() { await NotaVenta.DeleteNvAsync(Conn); }
public async Task <List <int> > InsertNv(List <Detalle> detalles) { BilingTypes = await BilingType.GetBilinTypesAsync(); int c = 0; float porcent = 0; TextInfo ti = CultureInfo.CurrentCulture.TextInfo; int resultInsertNV; int lastF = 0; List <int> folios = new List <int>(); foreach (Detalle item in detalles) { AuxCsv a = FileSii.GetAuxCvsFromFile(item); // INFORMATION UPDATE FROM CSV FILE. if (a != null) { string name = ti.ToTitleCase(a.Name.ToLower()); item.Instruction.ParticipantDebtor.BusinessName = name; item.Instruction.ParticipantDebtor.DteReceptionEmail = a.Email; item.Instruction.ParticipantDebtor.Name = item.Instruction.ParticipantDebtor.Name.ToUpper(); } else { StringLogging.AppendLine($"{item.Instruction.Id}\tUpdate email\t\tError in CSV file."); continue; } Auxiliar aux = await Auxiliar.GetAuxiliarAsync(item.Instruction, Conn); Comuna comunaobj; if (aux == null) // INSERT NEW AUX. { comunaobj = await Comuna.GetComunaFromInput(item, Conn, true); aux = await Auxiliar.InsertAuxiliarAsync(item.Instruction, Conn, comunaobj); if (aux != null) { StringLogging.AppendLine($"{item.Instruction.Id}\tAuxiliar Insert:\tOk: {item.Instruction.ParticipantDebtor.Rut} / {aux.DirAux} / {aux.ComAux}"); } else { StringLogging.AppendLine($"{item.Instruction.Id}\tAuxiliar Error:\t {item.Instruction.ParticipantDebtor.Rut}"); } } else // UPDATE ALL AUX FROM LIST. { if (aux.ComAux == null) { comunaobj = await Comuna.GetComunaFromInput(item, Conn, false); } else { comunaobj = new Comuna { ComCod = aux.ComAux }; } if (await aux.UpdateAuxiliarAsync(item.Instruction, Conn, comunaobj) == 0) { StringLogging.AppendLine($"{item.Instruction.Id}\tAuxiliar Update:\tError Sql: {item.Instruction.ParticipantDebtor.Rut}"); continue; } } // INSERT THE NV. lastF = await NotaVenta.GetLastNv(Conn); string prod = BilingTypes.FirstOrDefault(x => x.Id == item.Instruction.PaymentMatrix.BillingWindow.BillingType).DescriptionPrefix; resultInsertNV = await NotaVenta.InsertNvAsync(item.Instruction, lastF, prod, Conn); if (resultInsertNV == 0) { StringLogging.AppendLine($"{item.Instruction.Id}\tInsert NV:\tError Sql"); } else if (resultInsertNV == 1) // SUCCESS INSERT. { if (item.Instruction.ParticipantNew == null) { StringLogging.AppendLine($"{item.Nro}-{item.Instruction.Id}\tInsert NV:\tF°: {lastF}"); } else { StringLogging.AppendLine($"{item.Instruction.Id}\tInsert NV:\tF°: {lastF} *Change RUT {item.Instruction.ParticipantDebtor.Rut} by {item.Instruction.ParticipantNew.Rut}"); } folios.Add(lastF); } c++; porcent = (float)(100 * c) / detalles.Count; await ReportProgress(porcent, $"Inserting NV, wait please... ({c}/{detalles.Count}) F°: {lastF})"); } return(folios); }