void grdNominalCodes_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
Orchestrator.Facade.INominalCode facNominalCode = new Orchestrator.Facade.NominalCode();
DataSet ds = facNominalCode.GetAll();
this.grdNominalCodes.DataSource = ds;
}
protected void CarePlanInterventionGrid_OnNeedDataSource(Object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
Telerik.Web.UI.RadGrid carePlanInterventionGrid = (Telerik.Web.UI.RadGrid)sender;
Telerik.Web.UI.RadListViewDataItem selectedCarePlanDataItem = (Telerik.Web.UI.RadListViewDataItem)carePlanInterventionGrid.Parent;
Int32 selectedCarePlanIndex = selectedCarePlanDataItem.DataItemIndex;
Telerik.Web.UI.RadListView carePlanInterventionListView = (Telerik.Web.UI.RadListView)selectedCarePlanDataItem.Parent.Parent;
List <Client.Core.Individual.Case.MemberCaseProblemCarePlan> problemCarePlans = (List <Client.Core.Individual.Case.MemberCaseProblemCarePlan>)carePlanInterventionListView.DataSource;
switch (e.RebindReason)
{
case Telerik.Web.UI.GridRebindReason.InitialLoad:
// carePlanInterventionGrid.DataSource = problemCarePlans[selectedCarePlanIndex].CarePlan.Interventions;
break;
case Telerik.Web.UI.GridRebindReason.PostBackEvent:
break;
}
return;
}
protected void rgComentariosEntrevistas_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
ProcesoSeleccionNegocio nProcesoSeleccion = new ProcesoSeleccionNegocio();
var vProcesoSeleccion = nProcesoSeleccion.ObtieneProcesoSeleccion(pIdCandidato: vIdCandidato).FirstOrDefault();
rgComentariosEntrevistas.DataSource = nProcesoSeleccion.ObtieneComentariosEntrevistaProcesoSeleccion(pIdProceso: vIdProcesoSeleccion);
}
void GrdAnexoCroquia_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
string PathArchivo = "";
int AsignacionId = Convert.ToInt32(TxtId.Text);
if (TxtTipo.Text == "1")
{
PathArchivo = Server.MapPath(".") + @"\Archivos\Anexos\Croquis\" + AsignacionId;
}
else
{
PathArchivo = Server.MapPath(".") + @"\Archivos\AnexosPM\Croquis\" + AsignacionId;
}
if (Directory.Exists(PathArchivo))
{
DirectoryInfo directory = new DirectoryInfo(PathArchivo);
FileInfo[] files = directory.GetFiles("*.*");
DirectoryInfo[] directories = directory.GetDirectories();
for (int i = 0; i < files.Length; i++)
{
DataRow item = DsAnexos.Tables["AnexoCroquis"].NewRow();
item["NombreAnexoCroquis"] = ((FileInfo)files[i]).Name;
item["PathAnexoCroquis"] = ((FileInfo)files[i]).FullName;
DsAnexos.Tables["AnexoCroquis"].Rows.Add(item);
}
if (DsAnexos.Tables["AnexoCroquis"].Rows.Count > 0)
{
ClUtilitarios.LlenaGridDataSet(DsAnexos, GrdAnexoCroquia, "AnexoCroquis");
}
}
}
void GrdPoligono_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (Ds_Temporal.Tables["Dt_Poligono_Region"].Rows.Count > 0)
{
ClUtilitarios.LlenaGridDt(Ds_Temporal, GrdPoligono, "Dt_Poligono_Region");
}
}
protected void grd_GMPresentReports_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
string Nimsal = ddl_Nimsal.Items[0].Value;
string user = "";
if (ddl_Nimsal.SelectedValue != "null")
{
Nimsal = ddl_Nimsal.SelectedValue;
}
if (ddl_MG.SelectedValue != "")
{
user = ddl_MG.SelectedValue;
}
ProfPresentBusiness pb = new ProfPresentBusiness();
System.Data.DataTable dt = pb.GetMGTimeByUserName_Term(user, Nimsal);
if (dt.Columns.Contains("error"))
{
//Response.Write(dt.Rows[0]["error"].ToString());
}
else
{
grd_GMPresentReports.DataSource = dt;
}
}
void grid_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
bool isApplied = gridPersister.IsAppliedSortFilterOrGroup;
int iCount = ShoppingCartItem.GetCount(siteSettings.SiteId, Convert.ToInt32(ddlCartType.SelectedValue));
int startRowIndex = isApplied ? 1 : grid.CurrentPageIndex + 1;
int maximumRows = isApplied ? iCount : grid.PageSize;
grid.VirtualItemCount = iCount;
grid.AllowCustomPaging = !isApplied;
grid.PagerStyle.EnableSEOPaging = !isApplied;
List <ShoppingCartItem> list = ShoppingCartItem.GetPage(
siteSettings.SiteId,
Convert.ToInt32(ddlCartType.SelectedValue),
startRowIndex,
maximumRows);
if (ProductConfiguration.EnableShoppingCartAttributes)
{
var lstProductIds = list.Select(x => x.ProductId).Distinct().ToList();
customFields = CustomField.GetActiveForCart(siteSettings.SiteId, Product.FeatureGuid);
if (customFields.Count > 0 && lstProductIds.Count > 0)
{
productProperties = ProductProperty.GetPropertiesByProducts(lstProductIds);
}
}
grid.DataSource = list;
}
void GrdArticulo_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (Ds_Temporal.Tables["Dt_Articulo_Dictamen_Juridico"].Rows.Count > 0)
{
ClUtilitarios.LlenaGridDt(Ds_Temporal, GrdArticulo, "Dt_Articulo_Dictamen_Juridico");
}
}
void grdServiceLevels_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
Orchestrator.Facade.IOrderServiceLevel facOrderServiceLevel = new Orchestrator.Facade.Order();
DataSet ds = facOrderServiceLevel.GetAll();
this.grdServiceLevels.DataSource = ds;
}
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (!e.IsFromDetailTable)
{
RadGrid1.DataSource = GetMailScheduleHistory();
}
}
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
string productNC = Utils.convertToUnSign2(sProductCN.Value);
int ProductCatID = int.Parse(sProductCat.Value);
RadGrid1.DataSource = tData.USP_Product_Search(productNC, ProductCatID);
}
protected void rGridStats_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
HiddenField hSeasonID = (HiddenField)Parent.FindControl("hddSeasonID");
HiddenField hPlayerGUID = (HiddenField)Parent.FindControl("hddPlayerGUID");
HiddenField hddPrimPosID = (HiddenField)Parent.FindControl("hddPrimPosID");
PickAPlayerDomainModel PlayerDrafted = new PickAPlayerDomainModel();
PlayerDrafted.PlayerGUID = new Guid(hPlayerGUID.Value.ToString());
PlayerDrafted.SeasonID = Convert.ToInt32(hSeasonID.Value);
PlayerDrafted.PrimPositionTypeID = Convert.ToInt32(hddPrimPosID.Value);
DataTable dt = sppsBLL.GetDynamicStats(PlayerDrafted);
rGridStats.DataSource = dt;
}
catch (Exception ex)
{
StackTrace st = new StackTrace();
StackFrame sf = st.GetFrame(0);
string errMethod = sf.GetMethod().Name.ToString(); // Get the current method name
string errMsg = "600"; // Gotta pass something, we're retro-fitting an existing method
Session["LastException"] = ex; // Throw the exception in the session variable, will be used in error page
string url = string.Format(ConfigurationManager.AppSettings["ErrorPageURL"], errMethod, errMsg); //Set the URL
Response.Redirect(url); // Go to the error page.
}
}
protected void OnPagesGridNeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
var tabsByModule = TabController.Instance.GetTabsByModuleID(_moduleId);
tabsByModule.Remove(TabId);
dgOnTabs.DataSource = tabsByModule.Values;
}
void grdCallIns_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
Facade.IJob facJob = new Facade.Job();
DataSet dsCallInLog = facJob.GetQuickCallInLog(1, 0, DateTime.Today.AddMonths(-1), DateTime.Today.AddMonths(1));
this.grdCallIns.DataSource = dsCallInLog;
}
void grid_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (method != null && method.ShippingMethodId > 0)
{
var lstTableRates = new List <ShippingTableRate>();
switch ((ShippingMethodProvider)method.ShippingProvider)
{
case ShippingMethodProvider.ByOrderTotal:
case ShippingMethodProvider.ByWeight:
lstTableRates = ShippingTableRate.GetByMethod(shippingMethodId);
grid.DataSource = lstTableRates;
grid.Columns.FindByUniqueName("GeoZoneName").Visible = false;
break;
case ShippingMethodProvider.ByGeoZoneAndFixed:
case ShippingMethodProvider.ByGeoZoneAndOrderTotal:
case ShippingMethodProvider.ByGeoZoneAndWeight:
lstTableRates = ShippingTableRate.GetByMethod(shippingMethodId);
grid.DataSource = lstTableRates;
grid.Columns.FindByUniqueName("GeoZoneName").Visible = true;
break;
}
switch ((ShippingMethodProvider)method.ShippingProvider)
{
case ShippingMethodProvider.ByOrderTotal:
grid.Columns.FindByUniqueName("FromValue").Visible = true;
grid.Columns.FindByUniqueName("FromValue").HeaderText = ProductResources.ShippingFeeByOrderTotal;
break;
case ShippingMethodProvider.ByWeight:
grid.Columns.FindByUniqueName("FromValue").Visible = true;
grid.Columns.FindByUniqueName("FromValue").HeaderText = ProductResources.ShippingFeeByOrderWeight;
break;
case ShippingMethodProvider.ByGeoZoneAndFixed:
grid.Columns.FindByUniqueName("FromValue").Visible = false;
break;
case ShippingMethodProvider.ByGeoZoneAndOrderTotal:
grid.Columns.FindByUniqueName("FromValue").Visible = true;
grid.Columns.FindByUniqueName("FromValue").HeaderText = ProductResources.ShippingFeeByOrderTotal;
break;
case ShippingMethodProvider.ByGeoZoneAndWeight:
grid.Columns.FindByUniqueName("FromValue").Visible = true;
grid.Columns.FindByUniqueName("FromValue").HeaderText = ProductResources.ShippingFeeByOrderWeight;
break;
}
if (method.ShippingProvider == (int)ShippingMethodProvider.ByGeoZoneAndFixed || method.ShippingProvider == (int)ShippingMethodProvider.ByGeoZoneAndWeight)
{
grid.Columns.FindByUniqueName("FreeShippingOverXValue").Visible = true;
}
if (lstTableRates.Count > 0)
{
divExportData.Visible = true;
}
}
}
protected void CarePlanGoalInterventionsGrid_OnNeedDataSource(Object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (CarePlanGoal == null)
{
return;
}
switch (e.RebindReason)
{
case Telerik.Web.UI.GridRebindReason.InitialLoad:
case Telerik.Web.UI.GridRebindReason.ExplicitRebind:
CarePlanGoalInterventionsGrid.DataSource = CarePlanGoal.Interventions;
break;
case Telerik.Web.UI.GridRebindReason.PostBackEvent:
break;
}
return;
}
protected void grdAdmcomunicados_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
List <SPE_OBTIENE_K_COMUNICADO_LEIDO_Result> Admcomunicados = new List <SPE_OBTIENE_K_COMUNICADO_LEIDO_Result>();
Admcomunicados = negocio.ObtenerEmpleadosComunicadosLeidos(vIdComunicado);
grdAdmcomunicados.DataSource = Admcomunicados;
}
protected void CarePlanInterventionGrid_OnNeedDataSource(Object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (MemberCaseCarePlan == null)
{
return;
}
switch (e.RebindReason)
{
case Telerik.Web.UI.GridRebindReason.InitialLoad:
case Telerik.Web.UI.GridRebindReason.ExplicitRebind:
//List<Client.Core.Individual.Case.MemberCaseCareIntervention> careInterventions =
// (from currentCarePlanGoal in MemberCaseCarePlan.Goals
// from currentCarePlanGoalIntervention in currentCarePlanGoal.Interventions
// orderby currentCarePlanGoalIntervention.CareIntervention.Name
// select currentCarePlanGoalIntervention.CareIntervention).Distinct ().ToList ();
CarePlanInterventionGrid.DataSource = DataSourceCarePlanInterventionGrid;
break;
case Telerik.Web.UI.GridRebindReason.PostBackEvent:
break;
}
return;
}
protected void grdView_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
int TotalRecords = 0;
grdView.DataSource = GetDataGrid(grdView.CurrentPageIndex, grdView.PageSize, out TotalRecords);
grdView.VirtualItemCount = TotalRecords;
}
protected void grd_Student_NeedDataSource1(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
DataTable dt = new DataTable();
dt = UB.GetTop50Student();
grd_Student.DataSource = dt;
}
protected void grdMeterReadingDetails_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
try
{
fromDate = DateTime.ParseExact(string.Format("{0:dd/MM/yyyy}", DateTime.Today.AddMonths(-6)), "dd/MM/yyyy", CultureInfo.InvariantCulture);
toDate = DateTime.ParseExact(string.Format("{0:dd/MM/yyyy}", DateTime.Today), "dd/MM/yyyy", CultureInfo.InvariantCulture);
IDBHandler db = new DBHandler();
List <WebNM_Rep_MeterReadingsDetailsBySearch_proc_Result> lstDetails = new List <WebNM_Rep_MeterReadingsDetailsBySearch_proc_Result>(db.GetMeterReadingDetailsBySearch(Convert.ToInt32(ucd.ContractID), MeterNoRec, "", "", "", "", "", fromDate, toDate));
if (lstDetails.Count() > 0)
{
grdMeterReadingDetails.DataSource = lstDetails;
grdMeterReadingDetails.Visible = true;
}
else
{
grdMeterReadingDetails.Visible = false;
}
}
catch (Exception er)
{
lblErrormsg.Visible = true;
lblErrormsg.Text = "There was an error loading the report. Please try again.";
MetermanWeb.Common.ErrorLogging error = new MetermanWeb.Common.ErrorLogging();
error.logError("grdMeterReadingDetails_NeedDataSource", "Error loading the Meter Reading Details. ContractID = " + ucd.ContractID, "889", er.Message + "-" + er.InnerException, "grdMeterReadingDetails_NeedDataSource", DateTime.Now, "MetermanWeb", 3);
}
}
protected void ActivityParametersGrid_OnNeedDataSource(Object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs eventArgs)
{
if (MercuryApplication == null)
{
return;
}
switch (eventArgs.RebindReason)
{
case Telerik.Web.UI.GridRebindReason.ExplicitRebind:
System.Data.DataTable parameterTable = (System.Data.DataTable)Session[SessionCachePrefix + "ActivityParametersGrid.ParameterTable"];
ActivityParametersGrid.DataSource = parameterTable;
break;
default:
System.Diagnostics.Debug.WriteLine("ActivityParametersGrid_OnNeedDataSource: " + eventArgs.RebindReason.ToString());
break;
}
return;
}
private void grdFuelSurcharge_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
using (var ctx = new Orchestrator.EF.DataContext())
{
this.grdFuelSurcharge.DataSource = ctx.FuelSurchargeSet.ToList();
}
}
protected void grdSeleccionEmpleado_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
List <SPE_OBTIENE_EMPLEADOS_COMUNICADO_INFORMACION_Result> ListaEmpleados = new List <SPE_OBTIENE_EMPLEADOS_COMUNICADO_INFORMACION_Result>();
VisorComunicadoNegocio negocio = new VisorComunicadoNegocio();
ListaEmpleados = negocio.ObtenerEmpleadosInformacion(vIdComunicado, id_empleado);
grdSeleccionEmpleado.DataSource = ListaEmpleados;
}
protected void RadGrid1_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
string friends = "SELECT Email, Name, Country, [Image], College, Relationship, BirthDate, School, Company, Gender, City, ID FROM [User] WHERE (ID IN (SELECT MyID AS ID FROM Friends WHERE (FriendID = " + Session["UserID"] + ") AND (FriendStatus = 1) AND (FriendID <> MyID))) OR (ID IN (SELECT FriendID AS ID FROM Friends Friends_1 WHERE (MyID = " + Session["UserID"] + ") AND (FriendStatus = 1) AND (FriendID <> MyID))) ORDER BY Name";
DataTable dt = new DataTable();
dt = view.ReturnDT(friends);
RadGrid1.DataSource = dt;
}
protected void rgCareerPost_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (pageindexevent == true)
{
pageindexevent = false;
GetPositionsForListing(2);
}
}
protected void atiRadInviteGrid_NeedDataSource(object source, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (this.DataSource != null)
{
atiRadInviteGrid.DataSource = this.DataSource;
atiRadInviteGrid.Rebind();
}
}
protected void MemberEnrollmentGrid_OnNeedDataSource(Object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs eventArgs)
{
if (MercuryApplication == null)
{
return;
}
if ((eventArgs.RebindReason & Telerik.Web.UI.GridRebindReason.ExplicitRebind) == Telerik.Web.UI.GridRebindReason.ExplicitRebind)
{
System.Data.DataTable enrollmentTable = (System.Data.DataTable)Session[SessionCachePrefix + "MemberEnrollmentGrid.EnrollmentTable"];
enrollmentTable.Rows.Clear();
foreach (Client.Core.Member.MemberEnrollment currentEnrollment in Member.Enrollments)
{
enrollmentTable.Rows.Add(
currentEnrollment.Id.ToString(),
currentEnrollment.Program.InsurerId.ToString(),
(currentEnrollment.Insurer != null) ? ((currentEnrollment.Insurer.Entity != null) ? currentEnrollment.Insurer.Entity.Name : String.Empty) : String.Empty,
currentEnrollment.ProgramId.ToString(),
(currentEnrollment.Program != null) ? currentEnrollment.ProgramName : String.Empty,
currentEnrollment.SponsorId.ToString(),
(currentEnrollment.Sponsor != null) ? ((currentEnrollment.Sponsor.Entity != null) ? currentEnrollment.Sponsor.Entity.Name : String.Empty) : String.Empty,
currentEnrollment.SubscriberId.ToString(),
(currentEnrollment.Subscriber != null) ? ((currentEnrollment.Subscriber.Entity != null) ? currentEnrollment.Subscriber.Entity.Name : String.Empty) : String.Empty,
currentEnrollment.ProgramMemberId,
(currentEnrollment.MostRecentCoverage != null) ? currentEnrollment.MostRecentCoverage.RateCode : String.Empty,
(currentEnrollment.MostRecentPcp != null) ? (currentEnrollment.MostRecentPcp.PcpProvider != null) ? currentEnrollment.MostRecentPcp.PcpProvider.Entity.Name : String.Empty : String.Empty,
currentEnrollment.EffectiveDate.ToString("MM/dd/yyyy"),
currentEnrollment.TerminationDate.ToString("MM/dd/yyyy"),
currentEnrollment.TerminationDate.ToString("yyyyMMdd") + currentEnrollment.EffectiveDate.ToString("yyyyMMdd")
);
}
MemberEnrollmentGrid.DataSource = enrollmentTable;
// MemberEnrollmentGrid.DataBind ();
}
return;
}
protected void MemberCaseInterventionsGrid_OnNeedDataSource(Object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
List <Client.Core.Individual.Case.MemberCaseCareIntervention> interventions =
(from currentIntervention in Case.CareInterventions
where ((currentIntervention.Status == Mercury.Server.Application.CaseItemStatus.Active)
|| (currentIntervention.Status == Mercury.Server.Application.CaseItemStatus.UnderDevelopment))
orderby currentIntervention.Name
select currentIntervention).ToList();
if (!e.IsFromDetailTable)
{
switch (e.RebindReason)
{
case Telerik.Web.UI.GridRebindReason.InitialLoad:
case Telerik.Web.UI.GridRebindReason.ExplicitRebind:
case Telerik.Web.UI.GridRebindReason.PostBackEvent:
MemberCaseInterventionsGrid.DataSource = interventions;
break;
}
}
else // DETAIL TABLE BINDING
{
List <Client.Core.Individual.Case.MemberCaseCarePlanGoalIntervention> goalInterventions =
(from currentIntervention in interventions
from currentGoalIntervention in currentIntervention.GoalInterventions
where ((currentGoalIntervention.MemberCaseCarePlanGoal.Status == Mercury.Server.Application.CaseItemStatus.UnderDevelopment)
|| (currentGoalIntervention.MemberCaseCarePlanGoal.Status == Mercury.Server.Application.CaseItemStatus.Active)
// ADDED NOT SPECIFIED
|| (currentGoalIntervention.MemberCaseCarePlanGoal.Status == Mercury.Server.Application.CaseItemStatus.NotSpecified))
orderby currentGoalIntervention.MemberCaseCarePlanGoal.Name
select currentGoalIntervention).Distinct().ToList();
MemberCaseInterventionsGrid.MasterTableView.DetailTables[0].DataSource = goalInterventions;
}
return;
}
protected void RadGrid1_NeedDataSource(object sender, Telerik.Web.UI.GridNeedDataSourceEventArgs e)
{
if (!e.IsFromDetailTable)
{
System.Data.DataTable dt = GetPivotData(RadComboBox1.SelectedValue);
RadGrid1.DataSource = dt.Select("KD_PARENT IS NULL");
ViewState["GRID_DATA"] = dt;
}
}
