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); }