protected void gvxOpperation_RowInserted(object sender, DevExpress.Web.Data.ASPxDataInsertedEventArgs e)
{
// insert materials
try
{
int opperationID = int.Parse(ViewState ["OpperatioinID"].ToString());
ASPxDropDownEdit dd = (ASPxDropDownEdit)gvxOpperation.FindEditFormTemplateControl("ddMaterails");
ASPxCheckBoxList list = (ASPxCheckBoxList)dd.FindControl("chlMaterails");
List <OpperationMaterial> opperMatList = new List <OpperationMaterial>();
foreach (ListEditItem item in list.Items)
{
if (item.Selected)
{
opperMatList.Add(new OpperationMaterial()
{
OpperationID = opperationID, ItemID = int.Parse(item.Value.ToString())
});
}
}
OpperationMaterialsRepository oppRepository = new OpperationMaterialsRepository();
bool result = oppRepository.AddMaterialForOpperations(opperMatList);
}
catch (Exception)
{
}
}
private void AssignControllerResources()
{
ASPxDropDownEdit ddResource = (ASPxDropDownEdit)this.FindControlByID("ddResource");
if (base.Control.Storage.ResourceSharing && ddResource != null)
{
ASPxGridView gvMultiResource = (ASPxGridView)ddResource.FindControl("gvMultiResource");
if (gvMultiResource != null)
{
base.Controller.ResourceIds.Clear();
string[] resources = ddResource.Value.ToString().Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries);
for (int i = 0; i < resources.Length; i++)
{
for (int j = 0; j < gvMultiResource.VisibleRowCount; j++)
{
string text = gvMultiResource.GetRowValues(j, "Text").ToString();
if (resources[i].Trim() == text.Trim())
{
base.Controller.ResourceIds.Add(gvMultiResource.GetRowValues(j, "Value"));
}
}
}
}
}
}
protected void grid_Transport_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxGridView grid = sender as ASPxGridView;
ASPxDropDownEdit d = grid.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit;
ASPxGridView gvlist = d.FindControl("gridPopCont") as ASPxGridView;
string sql = string.Format(@"select Code,Name,TowheaderCode From CTM_Driver where StatusCode='Active'");
gvlist.DataSource = C2.Manager.ORManager.GetDataSet(sql);
gvlist.DataBind();
}
protected void grid_Trip_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
ASPxGridView grd = (sender as ASPxGridView) as ASPxGridView;
string sql = @"select det1.Id,det1.ContainerNo,det1.ContainerType from CTM_JobDet1 as det1 left outer join CTM_Job as job on det1.JobNo=job.JobNo where job.Id=" + SafeValue.SafeInt(grd.GetMasterRowKeyValue(), 0);
ASPxPageControl pageControl = this.grid_job.FindEditFormTemplateControl("pageControl") as ASPxPageControl;
ASPxGridView grid_Trip = pageControl.FindControl("grid_Trip") as ASPxGridView;
ASPxDropDownEdit dde_contNo = grid_Trip.FindEditFormTemplateControl("dde_Trip_ContNo") as ASPxDropDownEdit;
ASPxGridView gvlist = dde_contNo.FindControl("gridPopCont") as ASPxGridView;
gvlist.DataSource = C2.Manager.ORManager.GetDataSet(sql);
gvlist.DataBind();
}
protected void grid_Event_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
//string Port = System.Configuration.ConfigurationManager.AppSettings["LocalPort"];
//ASPxButtonEdit btnPort = this.grid_Transport.FindEditFormTemplateControl("btn_Port") as ASPxButtonEdit;
string Port = btn_Port.Text;
//string where = string.Format("EventCode='depotin' AND EventPort='{0}' AND EventDateTime in(select MAX(EventDateTime) from Cont_AssetEvent where EventCode='depotin' group by ContainerNo)", Port);
//dsRefCont.FilterExpression = where;
string sql = "select aEvent.id,aEvent.ContainerNo,aEvent.ContainerType from Cont_AssetEvent as aEvent left outer join (select ContainerNo,MAX(eventDateTime) as maxEventDateTime from Cont_AssetEvent group by ContainerNo) as ass on aEvent.ContainerNo=ass.ContainerNo and aEvent.EventDateTime=ass.maxEventDateTime left outer join Ref_Container as Cont on aEvent.ContainerNo=Cont.ContainerNo where aEvent.EventCode='depotin' and ass.maxEventDateTime is not null and Cont.StatusCode='Use' and aEvent.EventPort='" + Port + "'";
ASPxGridView grid = sender as ASPxGridView;
ASPxDropDownEdit d = grid.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit;
ASPxGridView gvlist = d.FindControl("gridPopCont") as ASPxGridView;
gvlist.DataSource = C2.Manager.ORManager.GetDataSet(sql);
gvlist.DataBind();
}
protected void grid_Event_HtmlEditFormCreated(object sender, ASPxGridViewEditFormEventArgs e)
{
//string Port = System.Configuration.ConfigurationManager.AppSettings["LocalPort"];
//string where = string.Format("(isnull(EventCode,'')='' or EventCode='gateout') AND EventPort='{0}' AND EventDateTime in(select MAX(EventDateTime) from Cont_AssetEvent where isnull(EventCode,'')='' or EventCode='gateout' group by ContainerNo)",Port);
string Port = btn_Port.Text;
//string where = string.Format(" Id in(select id from Cont_AssetEvent as aEvent left outer join (select containerno,MAX(EventDateTime) as EventDateTime from Cont_AssetEvent group by containerno) as ass on ass.ContainerNo=aEvent.ContainerNo and ass.EventDateTime=aEvent.EventDateTime where (isnull(EventCode,'')='' or EventCode='gateout') and aEvent.EventPort='{0}' and ass.EventDateTime is not null and len(replace(isnull(aEvent.DocNo,''),' ',''))=0 and len(isnull(DocType,''))=0 )", Port);
//dsRefCont.FilterExpression = where;
string sql = string.Format(@"select aEvent.ContainerType,aEvent.ContainerNo from Cont_AssetEvent as aEvent left outer join (select containerno,MAX(EventDateTime) as EventDateTime from Cont_AssetEvent group by containerno) as ass on ass.ContainerNo=aEvent.ContainerNo and ass.EventDateTime=aEvent.EventDateTime left outer join Ref_Container as Cont on aEvent.ContainerNo=Cont.ContainerNo where (isnull(EventCode,'')='' or EventCode='gateout') and aEvent.EventPort='{0}' and ass.EventDateTime is not null and len(replace(isnull(aEvent.DocNo,''),' ',''))=0 and isnull(DocType,'')<>'SO' and Cont.StatusCode='Use' union all select ContainerType,ContainerNo from Ref_Container where ContainerNo not in( select distinct isnull(ContainerNo,'') from Cont_AssetEvent) and StatusCode='Use' ", Port);
ASPxGridView grid = sender as ASPxGridView;
ASPxDropDownEdit d = grid.FindEditFormTemplateControl("DropDownEdit") as ASPxDropDownEdit;
ASPxGridView gvlist = d.FindControl("gridPopCont") as ASPxGridView;
gvlist.DataSource = C2.Manager.ORManager.GetDataSet(sql);
gvlist.DataBind();
}
protected void gvxOpperation_CellEditorInitialize(object sender, ASPxGridViewEditorEventArgs e)
{
try
{
int opperationID = int.Parse(ViewState["OpperatioinID"].ToString());
ASPxDropDownEdit dd = (ASPxDropDownEdit)gvxOpperation.FindEditFormTemplateControl("ddMaterails");
ASPxCheckBoxList list = (ASPxCheckBoxList)dd.FindControl("chlMaterails");
dsOpperationMaterails.SelectParameters[0].DefaultValue = opperationID.ToString();
DataView SelectedItemView = (DataView)dsOpperationMaterails.Select(new DataSourceSelectArguments());
DataTable SelectedItems = SelectedItemView.ToTable();
foreach (DataRow item in SelectedItems.Rows)
{
list.Items.FindByValue(item[0].ToString()).Selected = true;
}
}
catch (Exception)
{
}
}
protected void gvxOpperation_RowUpdated(object sender, DevExpress.Web.Data.ASPxDataUpdatedEventArgs e)
{
try
{
int opperationID = int.Parse(e.Keys[0].ToString());
ASPxDropDownEdit dd = (ASPxDropDownEdit)gvxOpperation.FindEditFormTemplateControl("ddMaterails");
ASPxCheckBoxList list = (ASPxCheckBoxList)dd.FindControl("chlMaterails");
dsOpperationMaterails.SelectParameters[0].DefaultValue = opperationID.ToString();
dsOpperationMaterails.DeleteParameters[0].DefaultValue = opperationID.ToString();
dsOpperationMaterails.InsertParameters[0].DefaultValue = opperationID.ToString();
DataView SelectedItemView = (DataView)dsOpperationMaterails.Select(new DataSourceSelectArguments());
DataTable SelectedItems = SelectedItemView.ToTable();
foreach (DataRow item in SelectedItems.Rows)
{
if (!list.Items.FindByValue(item[0].ToString()).Selected)
{
dsOpperationMaterails.DeleteParameters[1].DefaultValue = item[0].ToString();
dsOpperationMaterails.Delete();
list.Items.Remove(list.Items.FindByValue(item[0].ToString()));
}
else
{
list.Items.Remove(list.Items.FindByValue(item[0].ToString()));
}
}
foreach (ListEditItem item in list.Items)
{
if (item.Selected)
{
dsOpperationMaterails.InsertParameters[1].DefaultValue = item.Value.ToString();
dsOpperationMaterails.Insert();
}
}
}
catch (Exception)
{
}
}
/// <summary>
/// Gets the Values or Text of the Selected Items in the DropdownEdit
/// </summary>
/// <param name="DropdownEdit">DropdownEdit name in which we have to process</param>
/// <param name="ListBoxName">Name of the Listbox within the Dropdown Edit</param>
/// <param name="IsText">bool value to get Text or Value</param>
/// <returns>Returns the Comma separated Value</returns>
public static string GetDropDownEditSelectedData(ASPxDropDownEdit DropdownEdit, string ListBoxName, bool IsText)
{
StringBuilder fieldNames = new StringBuilder();
ASPxListBox oOutputList = (ASPxListBox)DropdownEdit.FindControl(ListBoxName);
if (oOutputList != null)
{
if (oOutputList.SelectedItems.Count > 0)
{
foreach (ListEditItem ls in oOutputList.SelectedItems)
{
fieldNames.Append((IsText == true ? ls.Text.ToString() : ls.Value.ToString()) + ",");
}
fieldNames.Remove(fieldNames.Length - 1, 1);
}
}
return fieldNames.ToString();
}