public AgregarCajaChica(String ruc, String Tipo /*,String moneda,String monedadoc*/)
{
InitializeComponent();
TipoDocumento = Tipo;
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
gridParams();
gridParamsDetalle();
objVoucherDao = new VoucherDAO();
formEmision = EmisionVoucher.formEmision;
formCanjeLetra = CanjeLetraNuevo.canjeletranuevo;
if (Tipo == "CARGO")
{
this.Text = "CARGO";
objListVentas = objVoucherDao.listarDocumentosVentas(ruc, Ventas.UNIDADNEGOCIO /*,moneda,monedadoc*/);
}
else
{
this.Text = "Facturas Compras";
objListVentas = objVoucherDao.listarDocumentosVentasForLeter(ruc, Ventas.UNIDADNEGOCIO);
}
grdDocumento.DataSource = objListVentas;
objListBusquedaTotal = objListVentas;
txt_BuscarDocumento.TextChanged += Txt_BuscarDocumento_TextChanged;
grdDocumento.Refresh();
}
public ListaEmisionVoucher()
{
InitializeComponent();
this.ControlBox = false;
this.Text = "LISTA CAJA BANCO";
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
objMonedaDao = new MonedaDAO();
DateTime d1, d2;
d2 = DateTime.Now;
d1 = new DateTime(d2.Year, d2.Month, 1);
dpickerInicio.Value = d1;
gridParams();
objEstado = new EstadoVoucher();
//objVoucher = new Voucher();
objVoucherDao = new VoucherDAO();
objPagoVoucherDao = new PagoVoucherDAO();
objDocumentoDAO = new DocumentoDAO();
objListVoucher = objVoucherDao.listarVoucher(Ventas.UNIDADNEGOCIO, dpickerInicio.Value, dpickerFin.Value, "NN");
grd_Voucher.DataSource = objListVoucher;
objListBusquedaTotal = objListVoucher;
grd_Voucher.Refresh();
grd_Voucher.DoubleClick += Grd_Voucher_DoubleClick;
cmbEstado();
}
public ReporteVoucher()
{
InitializeComponent();
formReporteCheques = this;
this.ControlBox = false;
this.Text = "Reporte de Voucher";
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 10);
objVoucherDAO = new VoucherDAO();
objMonedaDao = new MonedaDAO();
DateTime d1, d2, d11, d22;
d2 = DateTime.Now;
d22 = DateTime.Now;
d11 = new DateTime(d22.Year, d22.Month, 1);
d1 = new DateTime(d2.Year, d2.Month, 1);
dpickerInicio.Value = d1;
dpickerInicio1.Value = d11;
gridParams2();
gridParams();
gridParams3();
gridParams4();
cmbMoneda();
dgv_cobranza.DataSource = null;
grd_Voucher.DataSource = null;
dgv_personal.DataSource = null;
//grd_Voucher.DataSource = objListVoucher;
grd_Voucher.Refresh();
dgv_cobranza.Refresh();
dgv_personal.Refresh();
llenarSumatorias();
}
public CuentasPorPagar()
{
InitializeComponent();
this.ControlBox = false;
this.Text = "REPORTE DOCUMENTOS POR PAGAR";
this.StartPosition = FormStartPosition.Manual;
this.Location = new System.Drawing.Point(20, 20);
DateTime d1, d2;
d2 = DateTime.Now;
d1 = new DateTime(d2.Year, d2.Month, 1);
dpickerInicio.Value = d1;
gridParams();
gridParams2();
cmbUnidadNegocio();
cmbUnidadNegocio2();
objVoucherDao = new VoucherDAO();
/*pagar por vencimiento*/
objListVentas2 = objVoucherDao.ListarCuentasPorPagarVencer(Ventas.UNIDADNEGOCIO, 0);
grd_Documentos2.DataSource = null;
grd_Documentos2.DataSource = objListVentas2;
sumatorias2();
/**/
grd_Documentos.DataSource = objListVentas;
grd_Documentos.Refresh();
cbxanio();
cbxanio2();
cbxmes();
sumatorias();
}
private void LoadAccountTypes()
{
try
{
//
// Fill Customer Code
//
DataSet dsAccountTypes = new VoucherDAO().GetAllAccountTypes();
if (dsAccountTypes == null || dsAccountTypes.Tables.Count == 0)
{
ddlAccountTypes.Items.Add(new ListItem("--No Data Found--", "-1"));
}
else
{
ddlAccountTypes.DataSource = dsAccountTypes;
ddlAccountTypes.DataTextField = "AccountName";
ddlAccountTypes.DataValueField = "AccountID";
ddlAccountTypes.DataBind();
//ddlAccountTypes.Items.Add(new ListItem("--Please Select--", "-1"));
//ddlAccountTypes.SelectedValue = "-1";
}
}
catch (Exception ex)
{
throw ex;
}
}
public CanjeLetraNuevo()
{
InitializeComponent();
this.ControlBox = false;
txt_tipodoc.Text = "LT";
objLetra = new LetraCab();
objMonedaDao = new MonedaDAO();
objVoucherDao = new VoucherDAO();
objDocumentoDAO = new DocumentoDAO();
objMonedaDao.tipoCambio();
comboMoneda();
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
canjeletranuevo = this;
txt_Tcambio.Text = objMonedaDao.getTipoCambioVenta(dpick_Fecha.Value.ToString("dd/MM/yyyy")).ToString().PadRight(5, '0');
if (CanjeLetra.operacionLetra == "V")
{
objLetra = CanjeLetra.objVoucher;
llenarCabecera(objLetra);
objListaLetraDet = objVoucherDao.listarLetraDet(objLetra.NroRegistro, Ventas.UNIDADNEGOCIO);
llenarDetalle(objListaLetraDet);
sumatoria();
btn_SaveData.Enabled = false;
btn_Modificar.Visible = true;
}
else if (CanjeLetra.operacionLetra == "A")
{
objLetra = CanjeLetra.objVoucher;
llenarCabecera(objLetra);
objListaLetraDet = objVoucherDao.listarLetraDet(objLetra.NroRegistro, Ventas.UNIDADNEGOCIO);
llenarDetalle(objListaLetraDet);
sumatoria();
btn_Add.Enabled = false;
btn_Anular.Enabled = false;
btn_Buscar.Enabled = false;
btn_Modificar.Enabled = false;
btn_SaveData.Enabled = false;
grd_facturas.Enabled = false;
dpck_Fechavcto.Enabled = false;
dpick_Fecha.Enabled = false;
dtp_compromiso.Enabled = false;
cmb_Moneda.Enabled = false;
btn_Modificar.Visible = false;
}
else if (CanjeLetra.operacionLetra == "N")
{
Modificar = "N";
if (Ventas.UNIDADNEGOCIO == "01")
{
txt_SerieDcto.Text = "0001";
}
else
{
txt_SerieDcto.Text = "0001";
}
habilitarBotones(true, false);
}
}
public AgregarPrestamoBancario(String CodBanco, String Moneda)
{
InitializeComponent();
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
gridParams();
objVoucherDao = new VoucherDAO();
formEmision = EmisionVoucher.formEmision;
objListPrestamoBancario = objVoucherDao.getPrestamoBancarioVoucher(CodBanco, Moneda);
grdDocumento.DataSource = objListPrestamoBancario;
grdDocumento.Refresh();
}
public AgregarImpuestos()
{
InitializeComponent();
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
gridParams();
objVoucherDao = new VoucherDAO();
formEmision = EmisionVoucher.formEmision;
objListImpuestos = objVoucherDao.getImpuestosVoucher();
grdDocumento.DataSource = objListImpuestos;
objListBusquedaTotal = objListImpuestos;
txt_BuscarDocumento.TextChanged += Txt_BuscarDocumento_TextChanged;
grdDocumento.Refresh();
}
public AgregarDetracciones()
{
InitializeComponent();
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
gridParams();
objVoucherDao = new VoucherDAO();
formEmision = EmisionVoucher.formEmision;
objListVentas = objVoucherDao.listarDocumentosVentasDetraccion("NN", Ventas.UNIDADNEGOCIO);
grdDocumento.DataSource = objListVentas;
objListBusquedaTotal = objListVentas;
txt_BuscarDocumento.TextChanged += Txt_BuscarDocumento_TextChanged;
grdDocumento.Refresh();
}
public InsertarPrestamoBancario()
{
InitializeComponent();
this.Text = "Cargo Bancario";
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 10);
objVoucherDao = new VoucherDAO();
objMonedaDao = new MonedaDAO();
formEmision = EmisionVoucher.formEmision;
cmbMoneda();
cmbBanco();
cmb_Banco.SelectedIndexChanged += Cmb_Banco_SelectedIndexChanged;
cmb_Moneda.SelectedIndexChanged += Cmb_Moneda_SelectedIndexChanged;
txt_NroCuenta.Text = objVoucherDao.getNroCuenta(cmb_Banco.SelectedValue.ToString(), cmb_Moneda.SelectedValue.ToString());
}
public ReporteChueques()
{
InitializeComponent();
this.ControlBox = false;
this.Text = "Reporte de Voucher";
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 10);
objVoucherDAO = new VoucherDAO();
DateTime d1, d2;
d2 = DateTime.Now;
d1 = new DateTime(d2.Year, d2.Month, 1);
dpickerInicio.Value = d1;
gridParams();
}
public ReporteDiario()
{
InitializeComponent();
this.ControlBox = false;
this.Text = "Reporte Diario";
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 10);
objVoucherDAO = new VoucherDAO();
//objListBusquedaTotal = objListaReporte;
gridParams();
/*objListaFactura = objVoucherDAO.FacturaCReporte(Ventas.UNIDADNEGOCIO, dpickerInicio.Value, dpickerFin.Value);*/
grd_Voucher.DataSource = objListaFactura;
objListBusquedaTotal = objListaFactura;
grd_Voucher.Refresh();
impresos();
}
public AgregarAbonoFactura(String ruc /*,String moneda*/, String monedadoc)
{
InitializeComponent();
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
gridParams();
objVoucherDao = new VoucherDAO();
formEmision = EmisionVoucher.formEmision;
objListFacturaAbono = objVoucherDao.listarDocumentosAbonoVoucher(ruc, Ventas.UNIDADNEGOCIO /*,moneda,monedadoc*/);
grdDocumento.DataSource = objListFacturaAbono;
objListBusquedaTotal = objListFacturaAbono;
txt_BuscarDocumento.TextChanged += Txt_BuscarDocumento_TextChanged;
monedavalor = monedadoc;
grdDocumento.Refresh();
btn_Aceptar.Enabled = true;
}
public AgregarDetracionFactura(String ruc)
{
InitializeComponent();
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
gridParams();
objVoucherDao = new VoucherDAO();
formEmision = EmisionVoucher.formEmision;
txt_ruc.Text = ruc;
objListFacturaAbono = objVoucherDao.listarDocumentosFacturaDetraccion(ruc, Ventas.UNIDADNEGOCIO /*,moneda,monedadoc*/);
grdDocumento.DataSource = objListFacturaAbono;
objListBusquedaTotal = objListFacturaAbono;
txt_BuscarDocumentoD.TextChanged += txt_BuscarDocumentoD_TextChanged;
grdDocumento.Refresh();
button1.Enabled = true;
}
protected void btnSearch_Click(object sender, EventArgs e)
{
try
{
VoucherSearch search = new VoucherSearch();
if (dtpFromDate.Text == string.Empty)
{
search.FromDate = null;
}
else
{
search.FromDate = dtpFromDate.Date;
}
if (dtpToDate.Text == string.Empty)
{
search.ToDate = null;
}
else
{
search.ToDate = dtpToDate.Date;
}
DataSet ds = new VoucherDAO().GetExpencesForReportingByDateRange(search);
Session["VoucherExpencesReport"] = ds;
dxgvExpenseReport.DataSource = ds;
dxgvExpenseReport.DataBind();
}
catch (Exception ex)
{
ex.Data.Add("UILayerException", this.GetType().ToString() + Constant.Error_Seperator + "protected void btnSearch_Click(object sender, EventArgs e)");
if (Master.LoggedUser != null && Master.LoggedUser.UserName != null && Master.LoggedUser.UserName != string.Empty)
{
Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, Master.LoggedUser.UserName), false);
}
else
{
Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, "Annonimous"), false);
}
}
}
public BuscarDocVoucher(String Ruc, String operacion)
{
InitializeComponent();
TipoBusqueda = operacion;
objVoucherDao = new VoucherDAO();
objFacturaAbono = new FacturaAbono();
objBancoDAO = new BancoDAO();
ojbVentas = new ContabilidadDTO.Ventas();
if (operacion == "C")
{
formCaja = Caja.CajaChica.formCajachica;
}
else if (operacion == "V")
{
formVoucher = Caja.EmisionVoucher.formEmision;
TipoBanco = Caja.EmisionVoucher.TipoOperacionBanco;
}
if (TipoBanco == "A")
{
objListBusquedaAbono = objVoucherDao.geetDocumentoVoucherAbono(Ventas.UNIDADNEGOCIO, Ruc);
gridParamsAbono();
grdDocumento.DataSource = objListBusquedaAbono;
objListBusquedaTotalAbono = objListBusquedaAbono;
}
else
{
objListVentas = objVoucherDao.listarDocumentosVentas(Ruc, Ventas.UNIDADNEGOCIO /*,moneda,monedadoc*/);
gridParams();
grdDocumento.DataSource = objListVentas;
objListBusquedaTotal = objListVentas;
}
grdDocumento.Refresh();
grdDocumento.DoubleClick += GrdDocumento_DoubleClick;
txt_BuscarDocumento.TextChanged += Txt_BuscarDocumento_TextChanged;
}
public LiquidacionVoucher()
{
InitializeComponent();
this.ControlBox = false;
this.Text = "LISTA VOUCHER";
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
liquidacionVoucherForm = this;
DateTime d1, d2;
d2 = DateTime.Now;
d1 = new DateTime(d2.Year, d2.Month, 1);
dpickerInicio.Value = d1;
gridParams();
//objVoucher = new Voucher();
objVoucherDao = new VoucherDAO();
objListVoucher = objVoucherDao.listarVoucher(Ventas.UNIDADNEGOCIO, dpickerInicio.Value, dpickerFin.Value, "P");
grd_Voucher.DataSource = objListVoucher;
grd_Voucher.Refresh();
grd_Voucher.CellClick += Grd_Voucher_CellClick;
}
private void LoadAccountTypes()
{
try
{
//
// Fill Customer Code
//
DataSet dsAccountTypes = new VoucherDAO().GetAllAccountTypes();
if (dsAccountTypes == null || dsAccountTypes.Tables.Count == 0)
{
ddlAccountTypes.Items.Add(new ListItem("--No Data Found--", "-1"));
}
else
{
Master.BindDropdown("AccountName", "AccountID", dsAccountTypes, ddlAccountTypes);
ddlAccountTypes.Items.Add(new ListItem("--Please Select--", "-1"));
ddlAccountTypes.SelectedValue = "-1";
}
}
catch (Exception ex)
{
throw ex;
}
}
public CanjeLetra()
{
InitializeComponent();
formReporteProveedor = this;
this.Text = "CANJE LETRAS";
this.ControlBox = false;
this.StartPosition = FormStartPosition.Manual;
this.Location = new Point(50, 20);
DateTime d1, d2;
d2 = DateTime.Now;
d1 = new DateTime(d2.Year, d2.Month, 1);
dpickerInicio.Value = d1;
gridParams();
gridParams2();
objVoucherDao = new VoucherDAO();
objListLetra = objVoucherDao.listarLetra(Ventas.UNIDADNEGOCIO, dpickerInicio.Value, dpickerFin.Value, "NN", txt_Ruc.Text);
objReporteListLetra = objVoucherDao.ReportelistarLetra(Ventas.UNIDADNEGOCIO, dpickerInicio.Value, dpickerFin.Value, "NN", txt_Ruc.Text);
dgv_reporte.DataSource = objReporteListLetra;
grd_letra.DataSource = objListLetra;
dgv_reporte.Refresh();
grd_letra.Refresh();
cmbEstado();
}
public bool SaveVoucher_Detail(List <VoucherDetail> saveData, Voucher voucher)
{
using (DbContextTransaction transaction = Context.Database.BeginTransaction())
{
try
{
long seq = VoucherDAO.GetVoucherSEQ();
long seqDetail = VoucherDetailDAO.GetVoucherDetailSEQ();
switch (voucher.Status)
{
case ModifyMode.Insert:
seq++;
voucher.VouchersID = GenerateID.GetVoucherID(seq);
this.VoucherDAO.InsertVouchers(voucher);
voucher.CreateUser = UserInfo.UserID;
voucher.CompanyID = CommonInfo.CompanyInfo.CompanyID;
//Select voucher vừa insert để lấy voucherno
foreach (VoucherDetail data in saveData)
{
seqDetail++;
data.VouchersID = voucher.VouchersID;
data.CreateUser = UserInfo.UserID;
data.CompanyID = CommonInfo.CompanyInfo.CompanyID;
data.VouchersDetailID = GenerateID.VoucherDetailID(seqDetail);
this.VoucherDetailDAO.InsertVouchersDetail(data);
}
break;
// Update
case ModifyMode.Update:
this.VoucherDAO.UpdateVoucher(voucher);
voucher.UpdateUser = UserInfo.UserID;
voucher.CompanyID = CommonInfo.CompanyInfo.CompanyID;
if (saveData.Count > 0)
{
foreach (VoucherDetail voucherDetail in saveData)
{
//thực hiện nhiệm vụ update với các chi tiết
if (voucherDetail.Status == ModifyMode.Update)
{
#region Update dataDetail
if (!string.IsNullOrEmpty(voucherDetail.VouchersDetailID))
{
if (voucherDetail.Amount == 0)
{
this.VoucherDetailDAO.DeleteVoucherDetail(voucherDetail.VouchersDetailID, voucherDetail.CompanyID);
voucherDetail.Status = ModifyMode.Delete;
}
else
{
voucherDetail.UpdateUser = UserInfo.UserID;
voucherDetail.CompanyID = CommonInfo.CompanyInfo.CompanyID;
this.VoucherDetailDAO.UpdateVoucherDetail(voucherDetail);
}
}
#endregion Update dataDetail
}
else if (voucherDetail.Status == ModifyMode.Insert)
{
//thêm mới Detail
#region insert Detail khi thêm detail mới cho S35 đã có sẵn
if (string.IsNullOrEmpty(voucherDetail.VouchersDetailID))
{
seqDetail++;
voucherDetail.VouchersDetailID = GenerateID.VoucherDetailID(seqDetail); // GenerateID.InvoiceS35DetailID(seqDetail);
voucherDetail.VouchersID = voucher.VouchersID;
voucherDetail.CompanyID = voucher.CompanyID;
voucherDetail.CreateUser = UserInfo.UserID;
this.VoucherDetailDAO.InsertVouchersDetail(voucherDetail);
}
#endregion insert Detail khi thêm detail mới cho S35 đã có sẵn
}
}
}
break;
// Delete
case ModifyMode.Delete:
this.VoucherDAO.DeleteVoucher(voucher.VouchersID, voucher.CompanyID);
break;
}
transaction.Commit();
return(true);
}
catch (Exception e)
{
transaction.Rollback();
Console.WriteLine("Update data fail.\r\n" + e.Message);
return(false);
}
}
}
public List <VoucherDTO> LoadVoucher(int MaTV)
{
VoucherDAO voucher = new VoucherDAO();
return(voucher.LoadVoucher(MaTV));
}
public VoucherController()
{
this.Context = new BSContext();
this.VoucherDAO = new VoucherDAO(this.Context);
this.VoucherLogic = new VoucherLogic(this.Context);
}
public List <VoucherDTO> LoadVoucher()
{
VoucherDAO voucher = new VoucherDAO();
return(voucher.LoadVoucher());
}
