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));
}
