//Ordenamiento de columnas private void dgvConsultaCorporativo_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { CorporativeConsultaGrid tipoDatoOrdenamiento = new CorporativeConsultaGrid(); List <CorporativeConsultaGrid> orderList = new List <CorporativeConsultaGrid>(); switch (dgvConsultaCorporativo.Columns[e.ColumnIndex].Name) { case "Corporative": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.Corporative).ToList() : Consulta().OrderByDescending(c => c.Corporative).ToList(); break; case "Attribute1": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.Attribute1).ToList() : Consulta().OrderByDescending(c => c.Attribute1).ToList(); break; case "ToolOnline": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ToolOnline).ToList() : Consulta().OrderByDescending(c => c.ToolOnline).ToList(); break; case "Supervisor": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.Supervisor).ToList() : Consulta().OrderByDescending(c => c.Supervisor).ToList(); break; case "SupAgente": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.SupAgente).ToList() : Consulta().OrderByDescending(c => c.SupAgente).ToList(); break; case "PCC": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.PCC).ToList() : Consulta().OrderByDescending(c => c.PCC).ToList(); break; case "SupStatus": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.SupStatus).ToList() : Consulta().OrderByDescending(c => c.SupStatus).ToList(); break; case "Consultor1": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.Consultor1).ToList() : Consulta().OrderByDescending(c => c.Consultor1).ToList(); break; case "ConAgent1": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConAgent1).ToList() : Consulta().OrderByDescending(c => c.ConAgent1).ToList(); break; case "PCC1": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.PCC1).ToList() : Consulta().OrderByDescending(c => c.PCC1).ToList(); break; case "ConStatus1": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConStatus1).ToList() : Consulta().OrderByDescending(c => c.ConStatus1).ToList(); break; case "Consultor2": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.Consultor2).ToList() : Consulta().OrderByDescending(c => c.Consultor2).ToList(); break; case "ConAgent2": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConAgent2).ToList() : Consulta().OrderByDescending(c => c.ConAgent2).ToList(); break; case "PCC2": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.PCC2).ToList() : Consulta().OrderByDescending(c => c.PCC2).ToList(); break; case "ConStatus2": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConStatus2).ToList() : Consulta().OrderByDescending(c => c.ConStatus2).ToList(); break; case "Consultor3": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.Consultor3).ToList() : Consulta().OrderByDescending(c => c.Consultor3).ToList(); break; case "ConAgent3": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConAgent3).ToList() : Consulta().OrderByDescending(c => c.ConAgent3).ToList(); break; case "PCC3": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.PCC3).ToList() : Consulta().OrderByDescending(c => c.PCC3).ToList(); break; case "ConStatus3": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConStatus3).ToList() : Consulta().OrderByDescending(c => c.ConStatus3).ToList(); break; case "Consultor4": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.Consultor4).ToList() : Consulta().OrderByDescending(c => c.Consultor4).ToList(); break; case "ConAgent4": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConAgent4).ToList() : Consulta().OrderByDescending(c => c.ConAgent4).ToList(); break; case "PCC4": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.PCC4).ToList() : Consulta().OrderByDescending(c => c.PCC4).ToList(); break; case "ConStatus4": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConStatus4).ToList() : Consulta().OrderByDescending(c => c.ConStatus4).ToList(); break; case "Consultor5": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.Consultor5).ToList() : Consulta().OrderByDescending(c => c.Consultor5).ToList(); break; case "ConAgent5": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConAgent5).ToList() : Consulta().OrderByDescending(c => c.ConAgent5).ToList(); break; case "PCC5": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.PCC5).ToList() : Consulta().OrderByDescending(c => c.PCC5).ToList(); break; case "ConStatus5": orderList = (cntr % 2).Equals(0) ? Consulta().OrderBy(c => c.ConStatus5).ToList() : Consulta().OrderByDescending(c => c.ConStatus5).ToList(); break; default: MessageBox.Show("HA OCURRIDO UN ERROR AL TRATAR DE ORDENAR"); break; } dgvConsultaCorporativo.DataSource = orderList; RowGrid(); cntr++; }
public List <CorporativeConsultaGrid> ReportCorporateConsultingGrid(int firm, string grid, string connectionName) { Database db = DatabaseFactory.CreateDatabase(connectionName); DbCommand dbcomand = db.GetStoredProcCommand(Resources.CorporativeCRUDConsultaResources.SP_ConsultaCorporativePorAgente_Firma); db.AddInParameter(dbcomand, Resources.CorporativeCRUDConsultaResources.PARAM_QUERY2, DbType.String, firm); db.ExecuteNonQuery(dbcomand); List <CorporativeConsultaGrid> listCorporativeCRUD = new List <CorporativeConsultaGrid>(); using (IDataReader dr = db.ExecuteReader(dbcomand)) { int _Corporative = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CORPORATIVE); int _ToolOnline = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_TOOLONLINE); int _Attribute1 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_ATTRIBUTE1); int _Supervisor = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_SUPERVISOR); int _SupAgente = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_SUPAGENT); int _PCC = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_PCC); int _SupStatus = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_SUPSTATUS); int _Consultor1 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSULTOR1); int _ConAgent1 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONAGENT1); int _PCC1 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_PCC1); int _ConStatus1 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSTATUS1); int _Consultor2 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSULTOR2); int _ConAgent2 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONAGENT2); int _PCC2 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_PCC2); int _ConStatus2 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSTATUS2); int _Consultor3 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSULTOR3); int _ConAgent3 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONAGENT3); int _PCC3 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_PCC3); int _ConStatus3 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSTATUS3); int _Consultor4 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSULTOR4); int _ConAgent4 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONAGENT4); int _PCC4 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_PCC4); int _ConStatus4 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSTATUS4); int _Consultor5 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSULTOR5); int _ConAgent5 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONAGENT5); int _PCC5 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_PCC5); int _ConStatus5 = dr.GetOrdinal(Resources.CorporativeCRUDConsultaResources.PARAM_CONSTATUS5); while (dr.Read()) { CorporativeConsultaGrid item = new CorporativeConsultaGrid(); item.Corporative = (dr[_Corporative] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_Corporative)); item.ToolOnline = (dr[_ToolOnline] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_ToolOnline)); item.Attribute1 = (dr[_Attribute1] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_Attribute1)); item.Supervisor = (dr[_Supervisor] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_Supervisor)); item.SupAgente = (dr[_SupAgente] == DBNull.Value) ? Types.IntegerNullValue : (dr.GetInt32(_SupAgente)); item.PCC = (dr[_PCC] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_PCC)); item.SupStatus = (dr[_SupStatus] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_SupStatus)); item.Consultor1 = (dr[_Consultor1] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_Consultor1)); item.ConAgent1 = (dr[_ConAgent1] == DBNull.Value) ? (int?)null : (dr.GetInt32(_ConAgent1)); item.PCC1 = (dr[_PCC1] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_PCC1)); item.ConStatus1 = (dr[_ConStatus1] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_ConStatus1)); item.Consultor2 = (dr[_Consultor2] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_Consultor2)); item.ConAgent2 = (dr[_ConAgent2] == DBNull.Value) ? (int?)null : (dr.GetInt32(_ConAgent2)); item.PCC2 = (dr[_PCC2] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_PCC2)); item.ConStatus2 = (dr[_ConStatus2] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_ConStatus2)); item.Consultor3 = (dr[_Consultor3] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_Consultor3)); item.ConAgent3 = (dr[_ConAgent3] == DBNull.Value) ? (int?)null : (dr.GetInt32(_ConAgent3)); item.PCC3 = (dr[_PCC3] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_PCC3)); item.ConStatus3 = (dr[_ConStatus3] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_ConStatus3)); item.Consultor4 = (dr[_Consultor4] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_Consultor4)); item.ConAgent4 = (dr[_ConAgent4] == DBNull.Value) ? (int?)null : (dr.GetInt32(_ConAgent4)); item.PCC4 = (dr[_PCC4] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_PCC4)); item.ConStatus4 = (dr[_ConStatus4] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_ConStatus4)); item.Consultor5 = (dr[_Consultor5] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_Consultor5)); item.ConAgent5 = (dr[_ConAgent5] == DBNull.Value) ? (int?)null : (dr.GetInt32(_ConAgent5)); item.PCC5 = (dr[_PCC5] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_PCC5)); item.ConStatus5 = (dr[_ConStatus5] == DBNull.Value) ? Types.StringNullValue : (dr.GetString(_ConStatus5)); listCorporativeCRUD.Add(item); } } return(listCorporativeCRUD); }