private void GuardarActa() { using (var context = new lts_sindicatoDataContext()) { ACTAS insert = new ACTAS(); insert.ACTA = Convert.ToInt32(txt_NroDeActa.Text); insert.FECHA = dtp_FechaDeEmision.Value.Date; insert.FECHA_VENC_ACTA = dtp_FechaDeVencimiento.Value; insert.DESDE = Convert.ToDateTime("01/" + msk_Desde.Text); insert.HASTA = Convert.ToDateTime("01/" + msk_Hasta.Text); insert.DEUDAHISTORICA = Convert.ToDouble(txt_Capital.Text); insert.INTERESES = Convert.ToDouble(txt_Interes.Text); insert.DEUDAACTUALIZADA = insert.DEUDAHISTORICA + insert.INTERESES; insert.INTERESFINANC = Convert.ToDouble(txt_InteresDeFinanciacion.Text); insert.IMPORTECOBRADO = 0; insert.DEUDATOTAL = insert.DEUDAHISTORICA + insert.INTERESES; insert.InspectorId = Convert.ToInt32(cbx_Inspector.SelectedValue); insert.CUIT_STR = txt_CUIT.Text; insert.EMPRESA = txt_RazonSocial.Text; context.ACTAS.InsertOnSubmit(insert); context.SubmitChanges(); MostarActas(); } }
public async Task <ActionResult> DeleteConfirmed(long id) { ACTAS aCTAS = await db.ACTAS.FindAsync(id); db.ACTAS.Remove(aCTAS); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
// GET: ACTAS1/Details/5 public async Task <ActionResult> Details(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ACTAS aCTAS = await db.ACTAS.FindAsync(id); if (aCTAS == null) { return(HttpNotFound()); } return(View(aCTAS)); }
public async Task <ActionResult> Edit([Bind(Include = "NROACTA,FECHAINI,FECHAFIN,FACTURA,OTRODOC,CED_INF,TOTALUNID,EXPLICACION,REL_FACTCOM,REL_MANCARGA,REL_OTROS,REL_FACTCOM_FOLIO,REL_MANCARGA_FOLIO,REL_OTROS_FOLIO,IDE_COOR,IDE_AUTORIDAD,IDE_BODEGA,ESTADO,FIRMA,USUARIO,FEC_REG,FCOOR,FAUT,FINF,FBOD,COD_BOD,COD_MUN,NIT_EST,TIPOAPRE,CAUSALES,APREPOR,FECPOL,CATPROD,TIP_RES,PRU_CON,NRO_NOT,EMP_NOT,FEC_NOT,ARG_CON,NRO_NOTD,EMP_NOTD,FEC_NOTD,FEC_VEND,TIP_NOT,TIP_NOTR,FEC_NOTP_RR,SEDEMOSTRO,TIEMCIERRE")] ACTAS aCTAS) { if (ModelState.IsValid) { db.Entry(aCTAS).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } ViewBag.COD_BOD = new SelectList(db.BODEGAS, "COD_BOD", "NOM_BOD", aCTAS.COD_BOD); ViewBag.IDE_COOR = new SelectList(db.CGOPERATIVO, "CED_CGO", "APE1_CGO", aCTAS.IDE_COOR); ViewBag.NIT_EST = new SelectList(db.ESTABLEC, "NIT_EST", "NOM_EST", aCTAS.NIT_EST); ViewBag.CED_INF = new SelectList(db.INFRACTOR, "CED_INF", "APE1_INF", aCTAS.CED_INF); ViewBag.COD_MUN = new SelectList(db.MUNICIPIOS, "COD_MUN", "NOM_MUN", aCTAS.COD_MUN); ViewBag.IDE_AUTORIDAD = new SelectList(db.RAUTORIDAD, "CED_AUT", "APE1_AUT", aCTAS.IDE_AUTORIDAD); ViewBag.IDE_BODEGA = new SelectList(db.RBODEGA, "CED_BOD", "APE1_BOD", aCTAS.IDE_BODEGA); ViewBag.USUARIO = new SelectList(db.USUARIOS, "USERNAME", "PASSWORD", aCTAS.USUARIO); return(View(aCTAS)); }
// GET: ACTAS1/Edit/5 public async Task <ActionResult> Edit(long?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ACTAS aCTAS = await db.ACTAS.FindAsync(id); if (aCTAS == null) { return(HttpNotFound()); } ViewBag.COD_BOD = new SelectList(db.BODEGAS, "COD_BOD", "NOM_BOD", aCTAS.COD_BOD); ViewBag.IDE_COOR = new SelectList(db.CGOPERATIVO, "CED_CGO", "APE1_CGO", aCTAS.IDE_COOR); ViewBag.NIT_EST = new SelectList(db.ESTABLEC, "NIT_EST", "NOM_EST", aCTAS.NIT_EST); ViewBag.CED_INF = new SelectList(db.INFRACTOR, "CED_INF", "APE1_INF", aCTAS.CED_INF); ViewBag.COD_MUN = new SelectList(db.MUNICIPIOS, "COD_MUN", "NOM_MUN", aCTAS.COD_MUN); ViewBag.IDE_AUTORIDAD = new SelectList(db.RAUTORIDAD, "CED_AUT", "APE1_AUT", aCTAS.IDE_AUTORIDAD); ViewBag.IDE_BODEGA = new SelectList(db.RBODEGA, "CED_BOD", "APE1_BOD", aCTAS.IDE_BODEGA); ViewBag.USUARIO = new SelectList(db.USUARIOS, "USERNAME", "PASSWORD", aCTAS.USUARIO); return(View(aCTAS)); }