public void updPronMensual(System.Data.DataTable dt)
{
DAOGeneral obj = new DAOGeneral();
EPronMen pron = new EPronMen();
foreach (System.Data.DataRow row in dt.Rows)
{
pron.ID_ARTICULO = Convert.ToString(row["ID_ARTICULO"]);
pron.ID_YEAR = Convert.ToInt32(row["ID_YEAR"]);
pron.ID_MONTH = Convert.ToInt32(row["ID_MONTH"]);
pron.VENTA = Convert.ToDouble(row["VENTA"]);
obj.updPronMensual(pron);
}
}
public void updPronMensual(string proc, EPronMen pron)
{
try
{
SqlConnection conexion = new SqlConnection();
conexion.ConnectionString = obtenerCadena();
conexion.Open();
using (SqlCommand cmd = new SqlCommand(proc, conexion))
{
cmd.Parameters.Add("@ID_ARTICULO", SqlDbType.VarChar).Value = pron.ID_ARTICULO;
cmd.Parameters.Add("@ID_YEAR", SqlDbType.Int).Value = pron.ID_YEAR;
cmd.Parameters.Add("@ID_MONTH", SqlDbType.Int).Value = pron.ID_MONTH;
cmd.Parameters.Add("@VENTA", SqlDbType.Float).Value = pron.VENTA;
cmd.CommandType = CommandType.StoredProcedure;
cmd.ExecuteNonQuery();
}
conexion.Close();
}
catch (Exception Ex)
{
throw new Exception("Error obteniendo la data" + Ex.Message);
}
}
public void updPronMensual(EPronMen pron)
{
Conex con = new Conex();
con.updPronMensual("MOD1_ACTUALIZA_PRO_MEN", pron);
}
