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