protected void rptCategorias_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { EventoMes item = (EventoMes)e.Item.DataItem; Literal ltrBullet = (Literal)e.Item.FindControl("ltrBullet"); ltrBullet.Text = "<span class=\"box-eve-ico\" style=\"color:" + item.Cor + "\">• </span>"; } }
public static List <EventoMes> ListarEventosMes(int pintIdIdioma, DateTime pdttDataInicio, DateTime pdttDataFim) { string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString; SqlConnection objConexao = new SqlConnection(strConectionString); SqlCommand objComando = new SqlCommand("SPE_L_EVENTO_MES"); objComando.Connection = objConexao; objComando.CommandType = CommandType.StoredProcedure; ///Parametros objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pintIdIdioma; objComando.Parameters.Add("@dataInicio", SqlDbType.Date).Value = pdttDataInicio; objComando.Parameters.Add("@dataFim", SqlDbType.Date).Value = pdttDataFim; try { //Abre Conexao objConexao.Open(); //Declara variavel de retorno List <EventoMes> objList = new List <EventoMes>(); EventoMes obj = default(EventoMes); IDataReader idrReader = default(IDataReader); idrReader = objComando.ExecuteReader(); while ((idrReader.Read())) { obj = new EventoMes(); obj.FromIDataReader(idrReader); objList.Add(obj); } return(objList); } catch (Exception ex) { throw ex; } finally { //Fecha a conexao se aberta if (objConexao.State != ConnectionState.Closed) { objConexao.Close(); } } }
protected void rptEventosMes_ItemDataBound(object sender, RepeaterItemEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { EventoMes item = (EventoMes)e.Item.DataItem; Label lblEventoMes = (Label)e.Item.FindControl("lblEventoMes"); if (item.DataFim != null && item.DataFim > DateTime.MinValue) { lblEventoMes.Text = (item.DataInicio.Month.Equals(primeiroDia.Month) ? (item.DataFim.Month != item.DataInicio.Month ? string.Format("{0}-{1} {2}", item.DataInicio.Day, ultimoDia.Day, item.Titulo) : string.Format("{0}-{1} {2}", item.DataInicio.Day, item.DataFim.Day, item.Titulo)) : string.Format("{0}-{1} {2}", primeiroDia.Day, item.DataFim.Day, item.Titulo)); } else if (item.DataInicio >= primeiroDia && item.DataFim <= ultimoDia) { lblEventoMes.Text = string.Format("{0} {1}", item.DataInicio.Day, item.Titulo); } } }