public ActionResult Voucher() { DtoVoucher voucher = new DtoVoucher { StartDate = DateTime.Now, EndDate = DateTime.Now }; return(View(voucher)); }
public DataTable GetVouchers(DtoVoucher voucher) { DataTable Vouchers = new DataTable(); if (voucher.WithoutDate) { Vouchers = (from v in _db.AccVouchers join A in _db.AccAccounts on v.AccString equals A.AccString where v.VNo.Equals(voucher.VId) orderby v.VSrNo select new { v.VDate, A.AccName, v.VDescription, v.VSrNo, v.Debit, v.Credit, v.VNo, v.VType, v.UserCode, v.InvNo, v.InvType, DCType = (Decimal)((Decimal?)v.Debit ?? (Decimal?)0) > 0 ? "Debit Details" : (Decimal)((Decimal?)v.Credit ?? (Decimal?)0) > 0 ? "Credit Details" : null }).ToList().ToDataTable(); } else { Vouchers = (from v in _db.AccVouchers join A in _db.AccAccounts on v.AccString equals A.AccString where v.VNo.Equals(voucher.VId) && v.VDate >= voucher.StartDate && v.VDate <= voucher.EndDate orderby v.VSrNo select new { v.VDate, A.AccName, v.VDescription, v.VSrNo, v.Debit, v.Credit, v.VNo, v.VType, v.UserCode, v.InvNo, v.InvType, DCType = (Decimal)((Decimal?)v.Debit ?? (Decimal?)0) > 0 ? "Debit Details" : (Decimal)((Decimal?)v.Credit ?? (Decimal?)0) > 0 ? "Credit Details" : null }).ToList().ToDataTable(); } return(Vouchers); }
public void InsertarVoucher(DtoVoucher Objvoucher) { SqlCommand cmd = new SqlCommand("SP_InsertarVoucher", conexion); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@numvoucher", Objvoucher.PK_VV_NumVoucher); cmd.Parameters.AddWithValue("@importe", Objvoucher.DV_ImporteDepositado); cmd.Parameters.AddWithValue("@comentario", Objvoucher.VV_Comentario); conexion.Open(); cmd.ExecuteNonQuery(); conexion.Close(); }
public void DetallesVoucherSolicitudUsuario(DtoVoucher objdtoVoucher, DtoSolicitud objDtoSolicitud, DtoMolduraxUsuario objDtoMolduraxUsuario) { //SqlCommand command = new SqlCommand("SP_DetallesVoucherUsuarioxSolicitud", conexion); //command.CommandType = CommandType.StoredProcedure; //command.Parameters.AddWithValue("@dni",objDtoMolduraxUsuario.FK_VU_Cod); //command.Parameters.AddWithValue("@idsol", objDtoSolicitud.PK_IS_Cod); //DataSet ds = new DataSet(); //conexion.Open(); //SqlDataAdapter moldura = new SqlDataAdapter(command); //moldura.Fill(ds); //moldura.Dispose(); //SqlDataReader reader = command.ExecuteReader(); //while (reader.Read()) //{ // objDtoSolicitud.DTS_FechaEmicion = Convert.ToDateTime(reader[0].ToString()); // objdtoVoucher.PK_VV_NumVoucher = reader[1].ToString(); // objdtoVoucher.VBV_Foto = (byte[])reader[2]; // objdtoVoucher.DV_ImporteDepositado = Convert.ToInt32(reader[3].ToString()); //} //conexion.Close(); //conexion.Dispose(); SqlCommand command = new SqlCommand("SP_DVS", conexion); command.CommandType = CommandType.StoredProcedure; command.Parameters.AddWithValue("@idsol", objDtoSolicitud.PK_IS_Cod); DataSet ds = new DataSet(); conexion.Open(); SqlDataAdapter moldura = new SqlDataAdapter(command); moldura.Fill(ds); moldura.Dispose(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { objdtoVoucher.VBV_Foto = Encoding.ASCII.GetBytes(reader[0].ToString()); objDtoSolicitud.DTS_FechaEmicion = Convert.ToDateTime(reader[1].ToString()); objdtoVoucher.PK_VV_NumVoucher = reader[2].ToString(); objdtoVoucher.DV_ImporteDepositado = Double.Parse(reader[3].ToString()); } conexion.Close(); conexion.Dispose(); }
public bool SelectPagoVoucher(DtoVoucher v) { string Select = "SELECT * from T_Voucher where PK_VV_NumVoucher ='" + v.PK_VV_NumVoucher + "'"; SqlCommand unComando = new SqlCommand(Select, conexion); conexion.Open(); SqlDataReader reader = unComando.ExecuteReader(); bool hayRegistros = reader.Read(); if (hayRegistros) { v.VBV_Foto = (byte[])reader[1]; v.DV_ImporteDepositado = Convert.ToDouble(reader[2].ToString()); } conexion.Close(); return(hayRegistros); }
public ActionResult Voucher(DtoVoucher voucher) { voucher.EndDate = voucher.EndDate.AddDays(1); var vouchers = _repo.GetVouchers(voucher); vouchers.TableName = "Ledger"; //return Json(new {data = Ledgers}, JsonRequestBehavior.AllowGet); ReportViewer reportViewer = new ReportViewer(); reportViewer.ProcessingMode = ProcessingMode.Local; reportViewer.SizeToReportContent = true; reportViewer.Width = Unit.Percentage(900); reportViewer.Height = Unit.Percentage(900); reportViewer.LocalReport.ReportPath = Request.MapPath(Request.ApplicationPath) + @"Reports\Voucher.rdlc"; reportViewer.LocalReport.DataSources.Add(new ReportDataSource("Voucher", vouchers)); ViewBag.ReportViewer = reportViewer; ViewBag.ReportTitle = "Ledger"; return(View("_ReportView")); }
protected void btnEnviar_Click(object sender, EventArgs e) { Log _Log = new Log(); try { objfacturaneg = new CtrDatoFactura(); objfactura = new DtoDatoFactura(); objpago = new DtoPago(); objpagoneg = new CtrPago(); objsol = new DtoSolicitud(); objsolneg = new Ctr_Solicitud(); objvou = new DtoVoucher(); objvouneg = new CtrVoucher(); int ultimo = objfacturaneg.ultimo(); if (valorObtenidoRBTN.Value != "1" && valorObtenidoRBTN.Value != "2") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "swal({icon: 'error',title: 'ERROR!',text: 'Seleccione BOLETA o FACTURA!!'});", true); return; } if (txtImporte.Text == "" | txtNumOp.Text == "") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "swal({icon: 'error',title: 'ERROR!',text: 'Complete espacios en BLANCO!!'});", true); return; } if (txtnewRUC.Text == "" && valorCheck.Value == "3" && valorObtenidoRBTN.Value == "2") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "swal({icon: 'error',title: 'ERROR!',text: 'Complete espacios en BLANCO!!'});", true); return; } if (ddlRUC.Text == "" && valorObtenidoRBTN.Value == "2" && valorCheck.Value != "3") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "swal({icon: 'error',title: 'ERROR!',text: 'Complete espacios en BLANCO!!'});", true); return; } objsol.PK_IS_Cod = Convert.ToInt32(Session["idSolicitudPago"].ToString()); objfactura.PK_IDF_Cod = ultimo + 1; objfactura.VDF_RazonSocial = ""; objfactura.FK_VU_DNI = Session["DNIUsuario"].ToString(); if (valorObtenidoRBTN.Value == "2" && valorCheck.Value == "3") { objpago.IP_TipoCertificado = 2; objpago.VP_RUC = txtnewRUC.Text; objfactura.IDF_RUC = txtnewRUC.Text; } if (valorObtenidoRBTN.Value == "2" && valorCheck.Value != "3") { objpago.VP_RUC = ddlRUC.Text; objpago.IP_TipoCertificado = 2; } if (valorObtenidoRBTN.Value == "1") { objpago.VP_RUC = ""; objpago.IP_TipoCertificado = 1; } objpago.FK_IS_Cod = Convert.ToInt32(Session["idSolicitudPago"].ToString()); objpago.DP_ImportePagado = Convert.ToDouble(txtImporte.Text); double costo = objpagoneg.Costo(objpago); objpago.DP_ImporteRestante = costo - Convert.ToDouble(txtImporte.Text); if (Convert.ToDouble(txtImporte.Text) == (costo / 2)) { objpago.IP_TipoPago = 1; } if (Convert.ToDouble(txtImporte.Text) > (costo / 2) | Convert.ToDouble(txtImporte.Text) == costo) { objpago.IP_TipoPago = 2; } objvou.PK_VV_NumVoucher = txtNumOp.Text; objvou.DV_ImporteDepositado = Convert.ToDouble(txtImporte.Text); objvou.VV_Comentario = ""; if (hftxtimg.Value == "vacio") { ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "mensaje", "swal({icon: 'error',title: 'ERROR!',text: 'suba la IMAGEN!!'});", true); return; } else { _Log.CustomWriteOnLog("ImagenGuardada", "EL CAMPO ESTA LLENO"); } objpagoneg.RegistrarPago(objpago); mostrarmsjPAGO(objpago); if (objpago.error == 77 && valorCheck.Value == "3" && valorObtenidoRBTN.Value == "2") { objfacturaneg.RegistrarDatoFactura(objfactura); mostrarmsjFACTURA(objfactura); _Log.CustomWriteOnLog("RealizarCompra.cs", "Ruc registrado"); objvouneg.RegistrarVoucher(objvou); _Log.CustomWriteOnLog("RealizarCompra.cs", "2"); Utils.AddScriptClientUpdatePanel(UpdatePanel1, "uploadFileImagenVoucher('" + objvou.PK_VV_NumVoucher + "');"); _Log.CustomWriteOnLog("RealizarCompra.cs", "3"); objsolneg.ActualizarEstado(objsol); } if (objpago.error == 77 && valorObtenidoRBTN.Value == "2" && valorCheck.Value != "3") { _Log.CustomWriteOnLog("RealizarCompra.cs", "Ruc registrado"); objvouneg.RegistrarVoucher(objvou); _Log.CustomWriteOnLog("RealizarCompra.cs", "2"); Utils.AddScriptClientUpdatePanel(UpdatePanel1, "uploadFileImagenVoucher('" + objvou.PK_VV_NumVoucher + "');"); _Log.CustomWriteOnLog("RealizarCompra.cs", "3"); objsolneg.ActualizarEstado(objsol); } if (objpago.error == 77) { _Log.CustomWriteOnLog("RealizarCompra.cs", "1"); objvouneg.RegistrarVoucher(objvou); _Log.CustomWriteOnLog("RealizarCompra.cs", "2"); Utils.AddScriptClientUpdatePanel(UpdatePanel1, "uploadFileImagenVoucher('" + objvou.PK_VV_NumVoucher + "');"); _Log.CustomWriteOnLog("RealizarCompra.cs", "3"); objsolneg.ActualizarEstado(objsol); } } catch (Exception ex) { _Log.CustomWriteOnLog("RealizarCompra.cs", "error " + ex.Message); } }
public bool hayVoucher(DtoVoucher voucher) { return(objvoucherdao.SelectPagoVoucher(voucher)); }
public void DetallesVoucherSolicitudUsuario(DtoVoucher objdtoVoucher, DtoSolicitud objDtoSolicitud, DtoMolduraxUsuario objDtoMolduraxUsuario) { objvoucherdao.DetallesVoucherSolicitudUsuario(objdtoVoucher, objDtoSolicitud, objDtoMolduraxUsuario); }
public void RegistrarVoucher(DtoVoucher voucher) { objvoucherdao.InsertarVoucher(voucher); }