public List <PlanMarketing> GetAllPlanMarketingPresupuesto(PlanMarketing BEPlanMarketing)
{
try
{
SqlCommand cmd = new SqlCommand("spGetPlanMarketingPresupuesto", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id_PlanMarketing", SqlDbType.Int).Value = BEPlanMarketing.Id_PlanMarketing;
List <PlanMarketing> list = new List <PlanMarketing>();
if (cn.State == ConnectionState.Connecting || cn.State == ConnectionState.Open)
{
cn.Close();
}
cn.Open();
using (IDataReader dataReader = cmd.ExecuteReader())
{
while (dataReader.Read())
{
PlanMarketing obj = new PlanMarketing();
if (dataReader["presupuesto"] != DBNull.Value)
{
obj.presupuesto = (decimal)dataReader["presupuesto"];
}
if (dataReader["costoAccionGeneral"] != DBNull.Value)
{
obj.costoAccionGeneral = (decimal)dataReader["costoAccionGeneral"];
}
list.Add(obj);
}
}
return(list);
}
catch (Exception)
{
throw;
}
finally
{
cn.Close();
}
}
public JsonResult ListarObjetivos(PlanMarketing PMKT)
{
return(Json(GetAllObjetivos(PMKT), JsonRequestBehavior.AllowGet));
}
public List <Objetivos> GetAllObjetivos(PlanMarketing PMKT)
{
SqlCommand cmd = new SqlCommand("spGetObjetivosAll", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id_PlanMarketing", SqlDbType.Int).Value = PMKT.Id_PlanMarketing;
List <Objetivos> list = new List <Objetivos>();
cn.Open();
using (IDataReader dataReader = cmd.ExecuteReader())
{
while (dataReader.Read())
{
Objetivos obj = new Objetivos();
if (dataReader["Id_Objetivo"] != DBNull.Value)
{
obj.Id_Objetivo = (int)dataReader["Id_Objetivo"];
}
if (dataReader["Id_PlanMarketing"] != DBNull.Value)
{
obj.Id_PlanMarketing = (int)dataReader["Id_PlanMarketing"];
}
if (dataReader["NombreObjetivo"] != DBNull.Value)
{
obj.NombreObjetivo = (string)dataReader["NombreObjetivo"];
}
if (dataReader["DescripcionObjetivo"] != DBNull.Value)
{
obj.DescripcionObjetivo = (string)dataReader["DescripcionObjetivo"];
}
if (dataReader["UsuarioRegistra"] != DBNull.Value)
{
obj.UsuarioRegistra = (string)dataReader["UsuarioRegistra"];
}
if (dataReader["MaquinaRegistra"] != DBNull.Value)
{
obj.MaquinaRegistra = (string)dataReader["MaquinaRegistra"];
}
if (dataReader["FechaRegistro"] != DBNull.Value)
{
obj.FechaRegistro = (DateTime)dataReader["FechaRegistro"];
}
if (dataReader["UsuarioModifica"] != DBNull.Value)
{
obj.UsuarioModifica = (string)dataReader["UsuarioModifica"];
}
if (dataReader["MaquinaModifica"] != DBNull.Value)
{
obj.MaquinaModifica = (string)dataReader["MaquinaModifica"];
}
if (dataReader["FechaModifica"] != DBNull.Value)
{
obj.FechaModifica = (DateTime)dataReader["FechaModifica"];
}
list.Add(obj);
}
}
cn.Close();
return(list);
}
public List <PlanMarketing> GetAllPlanMarketing(PlanMarketing BEPlanMarketing)
{
try
{
SqlCommand cmd = new SqlCommand("spGetPlanMarketingAll", cn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Id_PlanMarketing", SqlDbType.Int).Value = BEPlanMarketing.Id_PlanMarketing;
List <PlanMarketing> list = new List <PlanMarketing>();
if (cn.State == ConnectionState.Connecting || cn.State == ConnectionState.Open)
{
cn.Close();
}
cn.Open();
using (IDataReader dataReader = cmd.ExecuteReader())
{
while (dataReader.Read())
{
PlanMarketing obj = new PlanMarketing();
if (dataReader["Id_PlanMarketing"] != DBNull.Value)
{
obj.Id_PlanMarketing = (int)dataReader["Id_PlanMarketing"];
}
if (dataReader["nombrePanMarketing"] != DBNull.Value)
{
obj.nombrePanMarketing = (string)dataReader["nombrePanMarketing"];
}
if (dataReader["descrípcion"] != DBNull.Value)
{
obj.descrípcion = (string)dataReader["descrípcion"];
}
if (dataReader["fechaIni"] != DBNull.Value)
{
obj.fechaIni = (DateTime)dataReader["fechaIni"];
}
if (dataReader["fechaFin"] != DBNull.Value)
{
obj.fechaFin = (DateTime)dataReader["fechaFin"];
}
if (dataReader["presupuesto"] != DBNull.Value)
{
obj.presupuesto = (decimal)dataReader["presupuesto"];
}
if (dataReader["UsuarioRegistra"] != DBNull.Value)
{
obj.UsuarioRegistra = (string)dataReader["UsuarioRegistra"];
}
if (dataReader["MaquinaRegistra"] != DBNull.Value)
{
obj.MaquinaRegistra = (string)dataReader["MaquinaRegistra"];
}
if (dataReader["FechaRegistro"] != DBNull.Value)
{
obj.FechaRegistro = (DateTime)dataReader["FechaRegistro"];
}
if (dataReader["UsuarioModifica"] != DBNull.Value)
{
obj.UsuarioModifica = (string)dataReader["UsuarioModifica"];
}
if (dataReader["MaquinaModifica"] != DBNull.Value)
{
obj.MaquinaModifica = (string)dataReader["MaquinaModifica"];
}
if (dataReader["FechaModifica"] != DBNull.Value)
{
obj.FechaModifica = (DateTime)dataReader["FechaModifica"];
}
list.Add(obj);
}
}
return(list);
}
catch (Exception)
{
throw;
}
finally
{
cn.Close();
}
}
public JsonResult ListarPlanMKTPresupuesto(PlanMarketing BEPlanMarketing)
{
return(Json(GetAllPlanMarketingPresupuesto(BEPlanMarketing), JsonRequestBehavior.AllowGet));
//return Json(new { Error = false, ListaPlanMKT = GetAllPlanMarketing() }, JsonRequestBehavior.AllowGet);
}
