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