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;
string recFilter = gridMain.MasterTableView.FilterExpression;
GridSortExpressionCollection gridSortExxpressions = gridMain.MasterTableView.SortExpressions;
try {
DistancesController cont = new DistancesController();
gridMain.VirtualItemCount = cont.CountDistances(recFilter);
gridMain.DataSource = cont.GetDistances(recSkip, recTake, recFilter, gridSortExxpressions);
}
catch (Exception) { }
}
protected void gridMain_ItemDataBound(object sender, GridItemEventArgs e)
{
/*
* if (e.Item.OwnerTableView.Name == "Master") {
* if (e.Item is GridDataItem) {
* GridDataItem item = (GridDataItem)e.Item;
* if (item.OwnerTableView.DataSource != null) {
* TaskB curTask = (item.OwnerTableView.DataSource as List<TaskB>)[item.DataSetIndex];
* TableCell curCell = item["RegNo"];
* string curComments = curTask.Comments;
* string curTooltip = "<span><span class=\"tooltip tooltip-effect-4\"><span class=\"tooltip-item\">";
* curTooltip += curCell.Text;
* curTooltip += "</span><span class=\"tooltip-content clearfix\"><span class=\"tooltip-text\"><strong>Παρατηρήσεις:</strong><br/>";
* curTooltip += curComments;
* curTooltip += "</span></span></span></span>";
* if (!string.IsNullOrWhiteSpace(curComments)) { curCell.Text = curTooltip; }
* System.Drawing.Color hColor = System.Drawing.Color.FromArgb(0, 0, 0);
* if (curTask.IsLocked == true) { hColor = System.Drawing.Color.FromArgb(200, 0, 0); }
* item["ID"].ForeColor = hColor;
* item["RegNo"].ForeColor = hColor;
* item["OrderDate"].ForeColor = hColor;
* item["CustomerID"].ForeColor = hColor;
* item["JobsID"].ForeColor = hColor;
* item["DateTimeStartActual"].ForeColor = hColor;
* if (curTask.IsLocked == true && loggedUser.UserGroupID != 1) {
* item["EditCommandColumn"].Controls[0].Visible = false;
* item["btnDelete"].Controls[0].Visible = false;
* item["ExapandColumn"].Controls[0].Visible = false;
* }
* }
* }
* }
*/
if (e.Item.OwnerTableView.Name == "Master")
{
if (e.Item is GridFilteringItem)
{
GridFilteringItem filterItem = (GridFilteringItem)e.Item;
RadDropDownList clist = (RadDropDownList)filterItem.FindControl("ddlCustomersFilter");
RadDropDownList jlist = (RadDropDownList)filterItem.FindControl("ddlJobsFilter");
RadDropDownList plist = (RadDropDownList)filterItem.FindControl("ddlPositionsFilter");
try {
CustomersController ccont = new CustomersController();
clist.DataSource = ccont.GetCustomers();
clist.DataTextField = "NameGR";
clist.DataValueField = "ID";
clist.DataBind();
clist.Items.Insert(0, new DropDownListItem("Κανένα Φίλτρο", "0"));
JobsController jcont = new JobsController();
jlist.DataSource = jcont.GetJobs();
jlist.DataTextField = "Name";
jlist.DataValueField = "ID";
jlist.DataBind();
jlist.Items.Insert(0, new DropDownListItem("Κανένα Φίλτρο", "0"));
DistancesController dcont = new DistancesController();
plist.DataSource = dcont.GetDistances();
plist.DataTextField = "Description";
plist.DataValueField = "ID";
plist.DataBind();
plist.Items.Insert(0, new DropDownListItem("Κανένα Φίλτρο", "0"));
}
catch (Exception) { }
}
if (e.Item is GridDataItem)
{
GridDataItem item = e.Item as GridDataItem;
ImageButton editButton = item["EditCommandColumn"].Controls[0] as ImageButton;
editButton.ImageUrl = "~/Images/mag.png";
}
}
}
