public void ModificarPronosticoCierre(PronCierre pronCierre, Sesion sesion, ref int validador)
{
try
{
CD_CierreMes cd_cierremes = new CD_CierreMes();
cd_cierremes.ModificarPronosticoCierre(pronCierre, sesion, ref validador);
}
catch (Exception ex)
{
throw ex;
}
}
public void CierreGrid(Sesion sesion, ref List <PronCierre> listProCierre)
{
try
{
SqlDataReader dr = null;
CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(sesion.Emp_Cnx);
string[] Parametros =
{
"@Id_Emp",
"@Id_Cd",
"@Id_Rik"
};
object[] Valores =
{
sesion.Id_Emp,
sesion.Id_Cd,
sesion.Id_Rik
};
SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand("spPronosticoCierre_Consulta", ref dr, Parametros, Valores);
PronCierre proCierre;
while (dr.Read())
{
proCierre = new PronCierre();
proCierre.Id_ProCierre = (int)dr.GetValue(dr.GetOrdinal("Id_ProCierre"));
proCierre.Id_Cte = (int)dr.GetValue(dr.GetOrdinal("Id_Cte"));
proCierre.Cte_NomComercial = (string)dr.GetValue(dr.GetOrdinal("Cte_NomComercial"));
proCierre.Id_Ter = (int)dr.GetValue(dr.GetOrdinal("Id_Ter"));
proCierre.Ter_Nombre = (string)dr.GetValue(dr.GetOrdinal("Ter_Nombre"));
proCierre.Id_Rik = (int)dr.GetValue(dr.GetOrdinal("Id_Rik"));
proCierre.Autorizado = dr.GetValue(dr.GetOrdinal("Estatus")).ToString().ToUpper() == "A" ? true : false;
proCierre.Pron_Actual = !string.IsNullOrEmpty(dr.GetValue(dr.GetOrdinal("Pron_Actual")).ToString()) ? (double)dr.GetValue(dr.GetOrdinal("Pron_Actual")) : 0.00;
proCierre.Pron_Anterior = (double)dr.GetValue(dr.GetOrdinal("Pron_Anterior"));
listProCierre.Add(proCierre);
}
CapaDatos.LimpiarSqlcommand(ref sqlcmd);
}
catch (Exception ex)
{
throw ex;
}
}
private void soloLectura()
{
try
{
for (int i = 0; i < this.RadGrid1.Items.Count; i++)
{
PronCierre pronCierre = new PronCierre();
RadNumericTextBox RadNumericTextBox1 = new RadNumericTextBox();
RadNumericTextBox1 = (RadNumericTextBox)this.RadGrid1.Items[i].Cells[6].FindControl("RadNumericTextBox1");
pronCierre.Id_ProCierre = Convert.ToInt32(RadGrid1.Items[i]["Id_ProCierre"].Text);
pronCierre.Pron_Actual = RadNumericTextBox1.Value.HasValue ? Convert.ToDouble(RadNumericTextBox1.Value.Value) : 0;
if (pronCierre.Pron_Actual != 0)
{
RadNumericTextBox1.Enabled = false;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void ModificarPronosticoCierre(PronCierre pronCierre, Sesion sesion, ref int validador)
{
try
{
CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(sesion.Emp_Cnx);
string[] Parametros =
{
"@Id_Emp",
"@Id_Cd",
"@Id_Rik",
"@Id_ProCierre",
"@Id_Ter",
"@Id_Cte",
"@Pron_Anterior",
"@Pron_Actual"
};
object[] Valores =
{
pronCierre.Id_Emp,
pronCierre.Id_Cd,
pronCierre.Id_Rik,
pronCierre.Id_ProCierre,
pronCierre.Id_Ter,
pronCierre.Id_Cte,
pronCierre.Pron_Anterior,
pronCierre.Pron_Actual
};
SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand("spRepPronosticoCierre_Modificar", ref validador, Parametros, Valores);
CapaDatos.LimpiarSqlcommand(ref sqlcmd);
}
catch (Exception ex)
{
throw ex;
}
}
private void GuardarCampos(ref int validador)
{
try
{
Sesion Sesion = new Sesion();
Sesion = (Sesion)Session["Sesion" + Session.SessionID];
if (Sesion != null)
{
if (RadGrid1.Items.Count > 0)
{
int revision = 0;
for (int i = 0; i < this.RadGrid1.Items.Count; i++)
{
revision = 0;
PronCierre pronCierre = new PronCierre();
RadNumericTextBox txtPron_Actual = new RadNumericTextBox();
txtPron_Actual = (RadNumericTextBox)this.RadGrid1.Items[i].Cells[6].FindControl("RadNumericTextBox1");
pronCierre.Pron_Actual = txtPron_Actual.Value.HasValue ? Convert.ToDouble(txtPron_Actual.Value.Value) : 0;
if (pronCierre.Pron_Actual == 0)
{
Alerta("Existen clientes sin pronóstico de cierre");
revision = 1;
return;
}
else
{
if (pronCierre.Pron_Actual < 0)
{
Alerta("Los pronóstico no deben ser negativos");
revision = 1;
return;
}
}
}
if (revision == 0)
{
for (int i = 0; i < this.RadGrid1.Items.Count; i++)
{
validador = 0;
PronCierre pronCierre = new PronCierre();
RadNumericTextBox txtPron_Actual = new RadNumericTextBox();
txtPron_Actual = (RadNumericTextBox)this.RadGrid1.Items[i].Cells[6].FindControl("RadNumericTextBox1");
pronCierre.Id_Emp = Sesion.Id_Emp;
pronCierre.Id_Cd = Sesion.Id_Cd_Ver;
pronCierre.Id_Rik = Sesion.Id_Rik;
pronCierre.Id_ProCierre = Convert.ToInt32(RadGrid1.Items[i]["Id_ProCierre"].Text);
pronCierre.Id_Cte = Convert.ToInt32(RadGrid1.Items[i]["Id_Cte"].Text);
pronCierre.Id_Ter = Convert.ToInt32(RadGrid1.Items[i]["Id_Ter"].Text);
pronCierre.Pron_Anterior = Convert.ToDouble(RadGrid1.Items[i]["Pron_Anterior"].Text);
pronCierre.Pron_Actual = txtPron_Actual.Value.HasValue ? Convert.ToDouble(txtPron_Actual.Value.Value) : 0;
CN_ProCierreMes proCierre = new CN_ProCierreMes();
proCierre.ModificarPronosticoCierre(pronCierre, Sesion, ref validador);
}
}
else
{
validador = 0;
}
}
else
{
validador = 1;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
