public static FormasDePagos GetComprobantesTesoreria(string IdCondicionDeVenta)
{
FormasDePagos result = new FormasDePagos();
tfi_FormasDePagoExDataset data = new tfi_FormasDePagoExDataset();
System.Data.DataRowCollection comprobantes = GetComprobantesTesoreria(data, IdCondicionDeVenta);
foreach (System.Data.DataRow rowCompTesoreria in comprobantes)
{
string IdMoneda = "";
string IdComp = "";
string descComp = (string)rowCompTesoreria["Descripcion"];
string IdFormaDePago = "";
if ((bool)rowCompTesoreria["Agrupado"])
{
string aux = (string)rowCompTesoreria["IdTDCompTesoreria"];
IdComp = aux.Substring(0, aux.IndexOf("#"));
IdMoneda = aux.Substring(aux.IndexOf("#") + 1);
}
else
{
IdComp = (string)rowCompTesoreria["IdTDCompTesoreria"];
}
ArrayList master = new ArrayList();
result.Add(Factory.GetFormaDePagoMaster(IdComp, descComp, IdMoneda, IdFormaDePago));
}
return(result);
}
public static System.Data.DataRowCollection GetComprobantesTesoreria(tfi_FormasDePagoExDataset data, string IdCondicionDeVenta, string IdCuenta, string IdTipoDeComprobante)
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.TableMappings.Add("Table", "Pr_tfi_GetComprobantesTesoreria");
SqlCommand cmd = new SqlCommand("Pr_tfi_TDCompTesoreria_GetListBy", dbhelper.Connection.GetConnection());
cmd.Parameters.Add(new SqlParameter("@IdCondicionDeVenta", SqlDbType.VarChar));
cmd.Parameters["@IdCondicionDeVenta"].Value = IdCondicionDeVenta;
cmd.Parameters.Add(new SqlParameter("@IdTipoDeComprobante", SqlDbType.VarChar));
if (IdTipoDeComprobante == null || IdTipoDeComprobante.Equals(string.Empty))
{
cmd.Parameters["@IdTipoDeComprobante"].Value = System.DBNull.Value;
}
else
{
cmd.Parameters["@IdTipoDeComprobante"].Value = IdTipoDeComprobante;
}
cmd.Parameters.Add(new SqlParameter("@IdCuenta", SqlDbType.VarChar));
if (IdCuenta == null || IdCuenta.Equals(string.Empty))
{
cmd.Parameters["@IdCuenta"].Value = System.DBNull.Value;
}
else
{
cmd.Parameters["@IdCuenta"].Value = IdCuenta;
}
cmd.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand = cmd;
adapter.Fill(data);
return(data.Pr_tfi_GetComprobantesTesoreria.Rows);
}
public static FormasDePagos GetFormasDePago(string IdCondicionDeVenta, string IdCuenta, string IdTipoDeComprobante) //string IdMonedaReferencia
{
FormasDePagos result = new FormasDePagos();
tfi_FormasDePagoExDataset data = new tfi_FormasDePagoExDataset();
System.Data.DataRowCollection comprobantes = GetComprobantesTesoreria(data, IdCondicionDeVenta, IdCuenta, IdTipoDeComprobante);
System.Data.DataRowCollection formasDePagosGen = GetFormasDePagosGenerales(data);
System.Data.DataRowCollection formasDePagosEsp = GetFormasDePagosEspecificas(data);
FormasDePagos res = new FormasDePagos();
foreach (System.Data.DataRow rowCompTesoreria in comprobantes)
{
string IdMoneda = "";
string IdComp = "";
string descComp = (string)rowCompTesoreria["Descripcion"];
string IdFormaDePago = "";
bool Agrupado = (bool)rowCompTesoreria["Agrupado"];
if (Agrupado)
{
string aux = (string)rowCompTesoreria["IdTDCompTesoreria"];
IdComp = aux.Substring(0, aux.IndexOf("#"));
IdMoneda = aux.Substring(aux.IndexOf("#") + 1);
}
else
{
IdComp = (string)rowCompTesoreria ["IdTDCompTesoreria"];
}
ArrayList master = new ArrayList();
if (Agrupado)
{
master.AddRange(ProcesarFormasDePagoEspBilletes(formasDePagosEsp, IdComp, descComp, IdMoneda));
}
else
{
master.AddRange(ProcesarFormasDePagoEsp(formasDePagosEsp, IdComp, descComp));
}
if (Agrupado)
{
master.AddRange(ProcesarFormasDePagoGenBilletes(formasDePagosGen, IdComp, descComp, IdMoneda));
}
else
{
master.AddRange(ProcesarFormasDePagoGen(formasDePagosGen, IdComp, descComp));
}
if (master.Count == 0)
{
master.Add(Factory.GetFormaDePagoMaster(IdComp, descComp, IdMoneda, IdFormaDePago));
}
foreach (FormaDePago fdp in master)
{
fdp.Agrupado = Agrupado;
}
result.AddRange(master);
}
return(result);
}
public static System.Data.DataRowCollection GetComprobantesTesoreria(tfi_FormasDePagoExDataset data)
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.TableMappings.Add("Table", "Pr_tfi_GetComprobantesTesoreria");
SqlCommand cmd = new SqlCommand("Pr_tfi_GetComprobantesTesoreria", dbhelper.Connection.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand = cmd;
adapter.Fill(data);
return(data.Pr_tfi_GetComprobantesTesoreria.Rows);
}
public static System.Data.DataRowCollection GetFormasDePagosGenerales(tfi_FormasDePagoExDataset data1)
{
DataSet data = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.TableMappings.Add("Table", "Pr_tfi_GetFormasDePagosGenerales");
SqlCommand cmd = new SqlCommand("Pr_tfi_GetFormasDePagosGenerales", dbhelper.Connection.GetConnection());
cmd.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand = cmd;
adapter.Fill(data);
return(data.Tables[0].Rows);
}
public static System.Data.DataRowCollection GetComprobantesTesoreria(tfi_FormasDePagoExDataset data, string IdCondicionDeVenta)
{
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.TableMappings.Add("Table", "Pr_tfi_GetComprobantesTesoreria");
SqlCommand cmd = new SqlCommand("Pr_tfi_GetComprobantesTesoreria_ByIdCondicionDeVenta", dbhelper.Connection.GetConnection());
cmd.Parameters.Add(new SqlParameter("@IdCondicionDeVenta", SqlDbType.VarChar));
cmd.Parameters["@IdCondicionDeVenta"].Value = IdCondicionDeVenta;
cmd.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand = cmd;
adapter.Fill(data);
return(data.Pr_tfi_GetComprobantesTesoreria.Rows);
}
/// <summary>
/// This function has been deprecated momentarily
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static System.Data.DataRowCollection GetFormasDePagosEspecificas(tfi_FormasDePagoExDataset data)
{
return(mz.erp.dataaccess.tfi_FormasDePagoEx.GetFormasDePagosEspecificas(data));
}
public static System.Data.DataRowCollection GetComprobantesTesoreria(tfi_FormasDePagoExDataset data, string IdCondicionDeVenta, string IdCuenta, string IdTipoDeComprobante)
{
return(mz.erp.dataaccess.tfi_FormasDePagoEx.GetComprobantesTesoreria(data, IdCondicionDeVenta, IdCuenta, IdTipoDeComprobante));
}
/// <summary>
/// This function has been deprecated momentarily
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
public static System.Data.DataRowCollection GetComprobantesTesoreria(tfi_FormasDePagoExDataset data)
{
return(mz.erp.dataaccess.tfi_FormasDePagoEx.GetComprobantesTesoreria(data));
}
/// <summary>
/// This function has been deprecated momentarily
/// </summary>
/// <param name="data"></param>
/// <param name="IdMonedaOrigen"></param>
/// <param name="IdMonedaDestino"></param>
/// <returns></returns>
public static System.Data.DataRow GetValorCotizacion(tfi_FormasDePagoExDataset data, string IdMonedaOrigen, string IdMonedaDestino)
{
System.Data.DataRow row = null; //mz.erp.dataaccess.tfi_FormasDePagoEx.GetValorCotizacion(data, IdMonedaOrigen, IdMonedaDestino);
return(row);
}
public static FormasDePagos GetFormasDePago(ArrayList ListaTDComTesoreria) //string IdMonedaReferencia
{
FormasDePagos result = new FormasDePagos();
tfi_FormasDePagoExDataset data = new tfi_FormasDePagoExDataset();
System.Data.DataRowCollection comprobantes = GetComprobantesTesoreria(data);
System.Data.DataRowCollection formasDePagosGen = GetFormasDePagosGenerales(data);
System.Data.DataRowCollection formasDePagosEsp = GetFormasDePagosEspecificas(data);
FormasDePagos res = new FormasDePagos();
foreach (System.Data.DataRow rowCompTesoreria in comprobantes)
{
string IdMoneda = "";
string IdComp = "";
string descComp = (string)rowCompTesoreria["Descripcion"];
string IdFormaDePago = "";
int Orden = int.MaxValue;
bool Agrupado = (bool)rowCompTesoreria["Agrupado"];
if (Agrupado)
{
string aux = (string)rowCompTesoreria["IdTDCompTesoreria"];
IdComp = aux.Substring(0, aux.IndexOf("#"));
IdMoneda = aux.Substring(aux.IndexOf("#") + 1);
}
else
{
IdComp = (string)rowCompTesoreria ["IdTDCompTesoreria"];
}
if (!rowCompTesoreria.IsNull("Orden"))
{
Orden = Convert.ToInt32(rowCompTesoreria["Orden"]);
}
if (ListaTDComTesoreria.Contains(IdComp))
{
ArrayList master = new ArrayList();
if (Agrupado)
{
master.AddRange(ProcesarFormasDePagoEspBilletes(formasDePagosEsp, IdComp, descComp, IdMoneda));
}
else
{
master.AddRange(ProcesarFormasDePagoEsp(formasDePagosEsp, IdComp, descComp));
}
if (Agrupado)
{
master.AddRange(ProcesarFormasDePagoGenBilletes(formasDePagosGen, IdComp, descComp, IdMoneda));
}
else
{
master.AddRange(ProcesarFormasDePagoGen(formasDePagosGen, IdComp, descComp));
}
if (master.Count == 0)
{
master.Add(Factory.GetFormaDePagoMaster(IdComp, descComp, IdMoneda, IdFormaDePago));
}
foreach (FormaDePago fdp in master)
{
fdp.Agrupado = Agrupado;
fdp.Orden = Orden;
fdp.Cuotas = Convert.ToUInt16(rowCompTesoreria["Cuotas"]);
}
result.AddRange(master);
}
}
return(result);
}