protected void gridMain_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridEditableItem && e.Item.IsInEditMode) { JobsMainID = -1; Session.Remove("JobsMainID"); Session.Remove("Position1"); Session.Remove("Position2"); GridEditableItem item = e.Item as GridEditableItem; RadAutoCompleteBox txtPosition1 = item.FindControl("txtPosition1") as RadAutoCompleteBox; RadAutoCompleteBox txtPosition2 = item.FindControl("txtPosition2") as RadAutoCompleteBox; RadDropDownList ddlJobsMain = item.FindControl("ddlJobsMain") as RadDropDownList; RadDropDownList ddlPosition1 = item.FindControl("ddlPosition1") as RadDropDownList; RadDropDownList ddlPosition2 = item.FindControl("ddlPosition2") as RadDropDownList; try { DistanceB currDistance = e.Item.DataItem as DistanceB; JobsMainController cont = new JobsMainController(); ddlJobsMain.DataSource = cont.GetJobsMain(); ddlJobsMain.DataTextField = "Name"; ddlJobsMain.DataValueField = "ID"; ddlJobsMain.DataBind(); DistancesController dcont = new DistancesController(); List <string> distPos = dcont.GetDistinctPositions(); ddlPosition1.DataSource = distPos; ddlPosition1.DataBind(); ddlPosition2.DataSource = distPos; ddlPosition2.DataBind(); if (currDistance != null) { txtPosition1.Entries.Add(new AutoCompleteBoxEntry(currDistance.Position1, currDistance.Position1)); txtPosition2.Entries.Add(new AutoCompleteBoxEntry(currDistance.Position2, currDistance.Position2)); ddlJobsMain.SelectedIndex = ddlJobsMain.FindItemByValue(currDistance.JobsMainID.ToString()).Index; Session["JobsMainID"] = currDistance.JobsMainID; Session["Position1"] = currDistance.Position1; Session["Position2"] = currDistance.Position2; } else { ddlJobsMain.SelectedIndex = 0; Session["JobsMainID"] = ddlJobsMain.SelectedItem.Value; } } catch (Exception) { } } if (e.Item is GridFilteringItem) { GridFilteringItem filterItem = (GridFilteringItem)e.Item; RadDropDownList cflist = (RadDropDownList)filterItem.FindControl("ddlJobsMainFilter"); try { JobsMainController ccont = new JobsMainController(); cflist.DataSource = ccont.GetJobsMain(); cflist.DataTextField = "Name"; cflist.DataValueField = "ID"; cflist.DataBind(); cflist.Items.Insert(0, new DropDownListItem("Κανένα Φίλτρο", "0")); } catch (Exception) { } } }
protected void gridMain_NeedDataSource(object sender, GridNeedDataSourceEventArgs e) { int recSkip = gridMain.CurrentPageIndex * gridMain.PageSize; int recTake = gridMain.PageSize; try { JobsMainController cont = new JobsMainController(); gridMain.VirtualItemCount = cont.CountJobsMain(); gridMain.DataSource = cont.GetJobsMain(recSkip, recTake); } catch (Exception) { } }
protected void gridMain_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item.OwnerTableView.Name == "Master") { if (e.Item is GridFilteringItem) { GridFilteringItem filterItem = (GridFilteringItem)e.Item; RadDropDownList clist = (RadDropDownList)filterItem.FindControl("ddlJobsMainFilter"); try { JobsMainController jcont = new JobsMainController(); clist.DataSource = jcont.GetJobsMain(); clist.DataTextField = "Name"; clist.DataValueField = "ID"; clist.DataBind(); clist.Items.Insert(0, new DropDownListItem("Κανένα Φίλτρο", "0")); } catch (Exception) { } } if (e.Item is GridEditableItem && e.Item.IsInEditMode) { SalesID = -1; Session.Remove("SalesID"); JobsMainID = -1; Session.Remove("JobsMainID"); JobTypesID = -1; Session.Remove("JobTypesID"); GridEditableItem item = e.Item as GridEditableItem; RadDropDownList ddlSale = item.FindControl("ddlSale") as RadDropDownList; RadDropDownList ddlJobsMain = item.FindControl("ddlJobsMain") as RadDropDownList; RadDropDownList ddlJobTypes = item.FindControl("ddlJobTypes") as RadDropDownList; try { JobB currJob = e.Item.DataItem as JobB; SalesController cont = new SalesController(); ddlSale.DataSource = cont.GetSales(); ddlSale.DataTextField = "Name"; ddlSale.DataValueField = "ID"; ddlSale.DataBind(); ddlSale.Items.Insert(0, new DropDownListItem("Χωρίς Έκπτωση", "0")); JobsMainController cont2 = new JobsMainController(); ddlJobsMain.DataSource = cont2.GetJobsMain(); ddlJobsMain.DataTextField = "Name"; ddlJobsMain.DataValueField = "ID"; ddlJobsMain.DataBind(); JobTypesController cont3 = new JobTypesController(); ddlJobTypes.DataSource = cont3.GetJobTypes(); ddlJobTypes.DataTextField = "Name"; ddlJobTypes.DataValueField = "ID"; ddlJobTypes.DataBind(); if (currJob != null) { if (currJob.SalesID != null) { ddlSale.SelectedIndex = ddlSale.FindItemByValue(currJob.SalesID.ToString()).Index; Session["SalesID"] = currJob.SalesID; } else { ddlSale.SelectedIndex = 0; Session["SalesID"] = ddlSale.SelectedItem.Value; } ddlJobsMain.SelectedIndex = ddlJobsMain.FindItemByValue(currJob.JobsMainID.ToString()).Index; Session["JobsMainID"] = currJob.JobsMainID; ddlJobTypes.SelectedIndex = ddlJobTypes.FindItemByValue(currJob.JobTypesID.ToString()).Index; Session["JobTypesID"] = currJob.JobTypesID; } else { ddlSale.SelectedIndex = 0; Session["SalesID"] = ddlSale.SelectedItem.Value; ddlJobsMain.SelectedIndex = 0; Session["JobsMainID"] = ddlJobsMain.SelectedItem.Value; ddlJobTypes.SelectedIndex = 0; Session["JobTypesID"] = ddlJobTypes.SelectedItem.Value; } } catch (Exception) { } } else if (e.Item is GridDataItem) { GridDataItem item = e.Item as GridDataItem; Label lblST = item.FindControl("lblSale") as Label; JobB currJob = e.Item.DataItem as JobB; if (currJob.SalesID == null) { lblST.Text = "Χωρίς Έκπτωση"; } else { lblST.Text = currJob.Sale.Name; } } } }