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