private List <Acys> GetList()
{
try
{
List <Acys> List = new List <Acys>();
CN_CapAcys clsCapAcys = new CN_CapAcys();
Sesion session2 = new Sesion();
session2 = (Sesion)Session["Sesion" + Session.SessionID];
Acys acys = new Acys();
acys.Id_Emp = session2.Id_Emp;
acys.Id_Cd = session2.Id_Cd_Ver;
acys.Filtro_FecIni = txtFecha1.SelectedDate;
acys.Filtro_FecFin = txtFecha2.SelectedDate;
acys.Filtro_Estatus = cmbEstatus.SelectedValue == "-1" ? "" : cmbEstatus.SelectedValue;
acys.Filtro_FolIni = txtFolio1.Text;
acys.Filtro_FolFin = txtFolio2.Text;
acys.Filtro_usuario = session2.Propia ? session2.Id_U.ToString() : "";
acys.Id_Ter = cmbTerritorio.Text != "" && cmbTerritorio.SelectedValue != "-1" ? Convert.ToInt32(cmbTerritorio.SelectedValue) : -1;
acys.Id_Cte = Convert.ToInt32(txtCliente.Value.HasValue ? txtCliente.Value.Value : -1);
acys.Id_Rik = cmbRepresentante.Text != "" && cmbRepresentante.SelectedValue != "-1" ? Convert.ToInt32(cmbRepresentante.SelectedValue) : -1;
acys.Acs_Vencido = cmbVencido.Text != "" && cmbVencido.SelectedValue != "-1" ? cmbVencido.SelectedValue: "-1";
clsCapAcys.ConsultarAcys_Lista(acys, session2.Emp_Cnx, ref List);
return(List);
}
catch (Exception ex)
{
throw ex;
}
}
private void Captar(ref GridCommandEventArgs e, GridItem gi)
{
try
{
if (gi.Cells[2].Text.ToLower() != "false")
{
Alerta("El cliente tiene crédito suspendido, favor de hacer las gestiones correspondientes para poder captar");
e.Canceled = true;
}
else
{
CN_CapAcys cn_capacys = new CN_CapAcys();
Acys acys = new Acys();
acys.Id_Emp = session.Id_Emp;
acys.Id_Cd = session.Id_Cd_Ver;
acys.Id_Acs = Convert.ToInt32(gi.Cells[3].Text);
cn_capacys.Consultar(ref acys, session.Emp_Cnx);
if (acys.Acs_Estatus == "B")
{
Alerta("No se puede captar el pedido, el Acuerdo esta dado de baja");
rg1.Rebind();
return;
}
RAM1.ResponseScripts.Add("return AbrirVentana_ProPedidoVI('" + gi.Cells[3].Text + "', '" + _PermisoGuardar + "', '" + _PermisoModificar + "', '" + _PermisoEliminar + "', '" + _PermisoImprimir + "'," + gi.Cells[9].Text + ", '" + gi.Cells[8].Text + "')");
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void Page_Load(object sender, EventArgs e)
{
try
{
Sesion Sesion = new Sesion();
Sesion = (Sesion)Session["Sesion" + Session.SessionID];
if (Sesion == null)
{
CerrarVentana("");
}
else
{
if (!IsPostBack)
{
//if (list == null)
//{
list = new DataTable();
list.Columns.Add("Id");
list.Columns.Add("Descripcion");
list.Columns.Add("Disponible");
list.Columns.Add("Cantidad");
list.Columns.Add("Precio");
CN_CapAcys acys = new CN_CapAcys();
Acys a = new Acys();
a.Id_Emp = Sesion.Id_Emp;
a.Id_Cd = Sesion.Id_Cd_Ver;
a.Id_Acs = Convert.ToInt32(Request.QueryString["Id_Acs"]);
DataTable list2 = list;
acys.ConsultarReemplazos(a, Convert.ToInt32(Request.QueryString["Id_Prd"]), ref list2, Sesion.Emp_Cnx);
list = list2;
//}
RadGrid1.Rebind();
CN_CatProducto cn_catproducto = new CN_CatProducto();
Producto pr = new Producto();
int id_Prd;
for (int x = 0; x < RadGrid1.Items.Count; x++)
{
id_Prd = Convert.ToInt32((RadGrid1.Items[x]["Id"].FindControl("lblId") as Label).Text);
cn_catproducto.ConsultaProducto(ref pr, Sesion.Emp_Cnx, Sesion.Id_Emp, Sesion.Id_Cd_Ver, id_Prd);
(RadGrid1.Items[x]["Precio"].FindControl("txtPrecio") as RadNumericTextBox).DbValue = pr.Prd_Precio;
}
}
}
}
catch (Exception)
{
throw;
}
}
private void AcuerdoImpresion_NeedDataSource(object sender, EventArgs e)
{
this.sqlConnection2.ConnectionString = this.ReportParameters["Conexion"].Value.ToString();
//Transfer the ReportParameter value to the parameter of the select command
this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value;
this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value;
this.sqlDataAdapter1.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value;
this.sqlDataAdapter2.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value;
this.sqlDataAdapter2.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value;
this.sqlDataAdapter2.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value;
this.sqlDataAdapter3.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value;
this.sqlDataAdapter3.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value;
this.sqlDataAdapter3.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value;
this.sqlDataAdapter4.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value;
this.sqlDataAdapter4.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value;
this.sqlDataAdapter4.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value;
this.sqlDataAdapter5.SelectCommand.Parameters["@Id_Emp"].Value = this.ReportParameters["Id_Emp"].Value;
this.sqlDataAdapter5.SelectCommand.Parameters["@Id_Cd"].Value = this.ReportParameters["Id_Cd"].Value;
this.sqlDataAdapter5.SelectCommand.Parameters["@Id_Acs"].Value = this.ReportParameters["Id_Acs"].Value;
//Take the Telerik.Reporting.Processing.Report instance and set the adapter as it's DataSource
Telerik.Reporting.Processing.Report report = (Telerik.Reporting.Processing.Report)sender;
report.DataSource = this.sqlDataAdapter1;
// ---------------------------------------------------------------------------------------------
// Si se asigno correctamente el origen de datos, se actualiza el estatus de la orden de compra
// ---------------------------------------------------------------------------------------------
//actualiza estatus de orden de compra a Impreso (I)
CN_CapAcys cn_capacys = new CN_CapAcys();
Acys acys = new Acys();
acys.Id_Emp = (int)ReportParameters["Id_Emp"].Value;
acys.Id_Cd = (int)ReportParameters["Id_Cd"].Value;
acys.Id_Acs = (int)ReportParameters["Id_Acs"].Value;
acys.Acs_Estatus = "I";
int verificador = 0;
cn_capacys.Imprimir(acys, ReportParameters["Conexion"].Value.ToString(), ref verificador);
}
private int CambiarEstatus(int Id_Acs, string estatus)
{
try
{
Sesion session = new Sesion();
session = (Sesion)Session["Sesion" + Session.SessionID];
CN_CapAcys cn_acys = new CN_CapAcys();
Acys acys = new Acys();
acys.Id_Emp = session.Id_Emp;
acys.Id_Cd = session.Id_Cd_Ver;
acys.Id_Acs = Id_Acs;
acys.Acs_Estatus = estatus;
int verificador = -1;
cn_acys.actualizarEstatus(acys, session.Emp_Cnx, ref verificador);
return(verificador);
}
catch (Exception ex)
{
throw ex;
}
}
protected void rtb1_ButtonClick(object sender, RadToolBarEventArgs e)
{
try
{
int Id_Prd_Original = Convert.ToInt32(Request.QueryString["Id_Prd"]);
int Id_Prd = 0;
int Cantidad = 0;
double precio = 0;
string Acs_Doc = "";
string Acs_Dia = "";
string Acs_DiaStr = "";
DateTime rdFechaF = default(DateTime);
DataRow[] Ar_dr = dt.Select("Id_Prd='" + Id_Prd_Original + "'");
if (Ar_dr.Length > 0)
{
Acs_Doc = Ar_dr[0]["Acs_Doc"].ToString();
Acs_Dia = Ar_dr[0]["Acs_Dia"].ToString();
Acs_DiaStr = Ar_dr[0]["Acs_DiaStr"].ToString();
try
{
rdFechaF = Convert.ToDateTime(Ar_dr[0]["Acs_FechaF"]);
}
catch (Exception)
{
}
//Ar_dr[0].Delete();
//dt.AcceptChanges();
}
int contador = 0;
string cantidad = "";
for (int x = 0; x < RadGrid1.Items.Count; x++)
{
cantidad = (RadGrid1.Items[x].FindControl("txtCantidad") as RadNumericTextBox).Text;
if (cantidad != "0" && cantidad != "")
{
Cantidad = Convert.ToInt32((RadGrid1.Items[x].FindControl("txtCantidad") as RadNumericTextBox).Text);
Id_Prd = Convert.ToInt32((RadGrid1.Items[x].FindControl("lblId") as Label).Text);
precio = (RadGrid1.Items[x].FindControl("txtPrecio") as RadNumericTextBox).Text == "" ? 0 : Convert.ToDouble((RadGrid1.Items[x].FindControl("txtPrecio") as RadNumericTextBox).Text);
Sesion sesion = (Sesion)Session["Sesion" + Session.SessionID];
CN_CatProducto cn_catproducto = new CN_CatProducto();
Producto pr = new Producto();
cn_catproducto.ConsultaProducto(ref pr, sesion.Emp_Cnx, sesion.Id_Emp, sesion.Id_Cd_Ver, Id_Prd);
string Id_Cte = Request.QueryString["Id_Cte"].ToString();
cn_catproducto.ConsultarVentas(ref pr, Convert.ToInt32(Id_Cte), sesion.Emp_Cnx);
dt.Rows.Add(new object[] {
-1,
Id_Prd,
pr.Prd_Descripcion,
pr.Prd_Presentacion,
pr.Prd_UniNs,
pr.ventaMes[0],
pr.ventaMes[1],
pr.ventaMes[2],
Cantidad,
precio,
precio,
Cantidad * precio,
Acs_Doc,
rdFechaF,
0,
Acs_Dia,
Acs_DiaStr,
0,
0,
0
});
CN_CapAcys cn_acys = new CN_CapAcys();
cn_acys.ModificarEquivalencia(Id_Prd, Id_Prd_Original, Request.QueryString["Id_Acs"].ToString(), sesion.Id_Emp, sesion.Id_Cd_Ver, sesion.Emp_Cnx);
contador++;
}
if (Ar_dr.Length > 0 && contador > 0)
{
Ar_dr[0].Delete();
dt.AcceptChanges();
}
}
CerrarVentana("");
list = null;
}
catch (Exception)
{
throw;
}
}
protected void rg_ItemCommand(object source, GridCommandEventArgs e)
{
try
{
Sesion session2 = new Sesion();
session2 = (Sesion)Session["Sesion" + Session.SessionID];
DateTime fechaPeriodoInicio = session2.CalendarioIni;
DateTime fechaPeriodoFinal = session2.CalendarioFin;
GridItem gi = e.Item;
List <string> statusPosibles;
switch (e.CommandName)
{
case "Imprimir":
statusPosibles = new List <string>()
{
"C", "I"
};
if (!statusPosibles.Contains(gi.Cells[3].Text.ToUpper()))
{
Alerta("El acuerdo se encuentra en estatus no válido para realizar la impresión");
e.Canceled = true;
return;
}
Imprimir(gi.Cells[2].Text.ToUpper());
break;
case "Cancelar":
if (gi.Cells[3].Text == "B")
{
Alerta("El acuerdo se encuentra en estatus no válido para realizar la cancelación");
e.Canceled = true;
return;
}
int verificador = -1;
CN_CapAcys cn_capacys = new CN_CapAcys();
Acys acys = new Acys();
acys.Id_Emp = sesion.Id_Emp;
acys.Id_Cd = sesion.Id_Cd_Ver;
acys.Id_Acs = Convert.ToInt32(gi.Cells[2].Text);
cn_capacys.Cancelar(acys, sesion.Emp_Cnx, ref verificador);
if (verificador == 1)
{
rgAcuerdo.Rebind();
}
else
{
Alerta("Ocurrió un error al intentar cancelar el acuerdo");
}
break;
case "Editar":
statusPosibles = new List <string>()
{
"C", "I"
};
if (!statusPosibles.Contains(gi.Cells[3].Text.ToUpper()))
{ //Alerta("El acuerdo se encuentra en estatus no válido para realizar la modificación");
RAM1.ResponseScripts.Add("OpenAlert('El acuerdo se encuentra en estatus no válido para realizar la modificación','" + gi.Cells[2].Text + "','" + false + "','" + false + "','" + false + "','" + false + "')");
e.Canceled = true;
return;
}
RAM1.ResponseScripts.Add("return AbrirVentana_Acys('" + gi.Cells[2].Text + "',0)");
break;
case "Enviar":
if (gi.Cells[3].Text.ToString().ToLower() == "i")
{
EnviaEmail(Convert.ToInt32(gi.Cells[2].Text));
}
else
{
Alerta("La solicitud se encuentra en estatus no válido para su envio");
}
break;
case "Renovar":
renovar(gi);
break;
case "Autorizar":
autorizar(gi);
break;
}
}
catch (Exception ex)
{
ErrorManager(ex, new System.Diagnostics.StackTrace().GetFrame(0).GetMethod().Name);
}
}
