protected void rptProximosEventos_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
ProxEventos item = (ProxEventos)e.Item.DataItem;
Label lblData = (Label)e.Item.FindControl("lblData");
lblData.Text = item.DataInicio.ToString("dd 'de' MMMM", System.Globalization.CultureInfo.GetCultureInfo("pt-BR"));
}
}
public static List <ProxEventos> ListarProxEventos(int pintIdIdioma, int pintIdTipoEvento = 0)
{
string strConectionString = ConfigurationManager.ConnectionStrings["BradescoRI"].ConnectionString;
SqlConnection objConexao = new SqlConnection(strConectionString);
SqlCommand objComando = new SqlCommand("SPE_L_PROXIMOS_EVENTOS");
objComando.Connection = objConexao;
objComando.CommandType = CommandType.StoredProcedure;
///Parametros
objComando.Parameters.Add("@idiomaId", SqlDbType.Int).Value = pintIdIdioma;
if (pintIdTipoEvento != 0)
{
objComando.Parameters.Add("@tipoEventoId", SqlDbType.Int).Value = pintIdTipoEvento;
}
try
{
//Abre Conexao
objConexao.Open();
//Declara variavel de retorno
List <ProxEventos> objListProxEventos = new List <ProxEventos>();
ProxEventos objProxEventos = default(ProxEventos);
IDataReader idrReader = default(IDataReader);
idrReader = objComando.ExecuteReader();
while ((idrReader.Read()))
{
objProxEventos = new ProxEventos();
objProxEventos.FromIDataReader(idrReader);
objListProxEventos.Add(objProxEventos);
}
return(objListProxEventos);
}
catch (Exception ex)
{
throw ex;
}
finally
{
//Fecha a conexao se aberta
if (objConexao.State != ConnectionState.Closed)
{
objConexao.Close();
}
}
}
protected void rptProximosEventos_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
ProxEventos item = (ProxEventos)e.Item.DataItem;
Label lblDia = (Label)e.Item.FindControl("lblDia");
Label lblMes = (Label)e.Item.FindControl("lblMes");
Label lblData = (Label)e.Item.FindControl("lblData");
if (item.DataFim != null && item.DataFim > DateTime.MinValue)
{
lblDia.Text = item.DataInicio.ToString("dd") + " - " + item.DataFim.ToString("dd");
lblMes.Text = (item.DataInicio.ToString("MM").Equals(item.DataFim.ToString("MM")) ? item.DataInicio.ToString("MMM", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)) : item.DataInicio.ToString("MMM", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)) + " - " + item.DataFim.ToString("MMM", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)));
if (SiglaCultura.Equals("pt-BR"))
{
lblData.Text = (item.DataInicio.ToString("MM").Equals(item.DataFim.ToString("MM")) ? item.DataInicio.ToString("dd") + " a " + item.DataFim.ToString("dd 'de' MMMM 'de' yyyy", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)) : item.DataInicio.ToString("dd 'de' MMMM", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)) + " a " + item.DataFim.ToString("dd 'de' MMMM 'de' yyyy", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)));
}
else
{
//lblData.Text = (item.DataInicio.ToString("MM").Equals(item.DataFim.ToString("MM")) ? item.DataInicio.ToString("dd") + " a " + item.DataFim.ToString("dd 'de' MMMM 'de' yyyy", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)) : item.DataInicio.ToString("dd 'de' MMMM", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)) + " a " + item.DataFim.ToString("dd 'de' MMMM de yyyy", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura)));
}
}
else
{
lblDia.Text = item.DataInicio.ToString("dd");
lblMes.Text = item.DataInicio.ToString("MMM", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura));
if (SiglaCultura.Equals("pt-BR"))
{
lblData.Text = item.DataInicio.ToString("dd 'de' MMMM 'de' yyyy", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura));
}
else
{
//lblData.Text = item.DataInicio.ToString("MMMM dd, yyyy", System.Globalization.CultureInfo.GetCultureInfo(SiglaCultura));
}
}
}
}
