private void BindData() { DataSet workstations = new DataSet(); _workstationDAO = new PackstationDAO(); workstations = _workstationDAO.GetWorkstations(); workstationGrid.DataSource = workstations.Tables["mds_workstation"]; }
protected void workstationGrid_DeleteCommand(object sender, Telerik.Web.UI.GridCommandEventArgs e) { _workstationDAO = new PackstationDAO(); _workstation = new Packstation(); _workstation.ID = int.Parse( (e.Item as GridDataItem) .OwnerTableView .DataKeyValues[e.Item.ItemIndex]["workstation_id"] .ToString()); _workstation.LastChangedBy = User.Identity.Name; int returnResult = _workstationDAO.Delete(_workstation); BindData(); }
private void SetInstance(string workstationType) { _workstation = null; _workstationDAO = null; if (workstationType.CompareTo(WorkstationType.IS.ToString()) == 0) { _workstationDAO = new InductstationDAO(); _workstation = new Inductstation(); } else if (workstationType.CompareTo(WorkstationType.PS.ToString()) == 0) { _workstationDAO = new PackstationDAO(); _workstation = new Packstation(); } else { _workstationDAO = new SupervisorDAO(); _workstation = new Supervisorstation(); } }
/* * private void CreateTypeValidationScript(string workstationTypeCtlID, string trolleyCtlID) * { * ClientScript * .RegisterClientScriptBlock( * this.GetType(), * "typeDropdownScript", * "function CheckType()" + * "{" + * " if (document.getElementById('" + * workstationTypeCtlID + "').value != '" + WorkstationType.PS.ToString() + "')" + * " {" + * " document.getElementById('" + * trolleyCtlID + "').style.visibility = 'hidden';" + * " var combo = $find('" + trolleyCtlID + "');" + * " " + * " var comboItem = combo.findItemByText('item');" + * " if (comboItem){" + * " }else{" + * " comboItem= new Telerik.Web.UI.RadComboBoxItem();" + * " comboItem.set_text('item');" + * " comboItem.set_value('0');" + * " combo.trackChanges();" + * " combo.get_items().add(comboItem);" + * " comboItem.select(); " + * " combo.commitChanges();}" + * " }" + * " else" + * " {" + * " var combo = $find('" + trolleyCtlID + "');" + * " var items = combo.get_items();" + * " var comboItem = combo.findItemByText('item');" + * " if (comboItem)" + * " {" + * " combo.trackChanges();" + * " items.remove(comboItem);" + * " combo.commitChanges();" + * " }" + * " document.getElementById('" + * trolleyCtlID + "').style.visibility = 'visible';" + * " }" + * "}", true); * } */ protected void workstationGrid_ItemDataBound(object sender, GridItemEventArgs e) { if (e.Item is GridEditableItem && (e.Item as GridEditableItem).IsInEditMode) { DataSet dropdownSource = new DataSet(); GridEditableItem editedItem = e.Item as GridEditableItem; SNumCodeDAO sNumCodeDAO = new SNumCodeDAO(); //workstation type dropdownSource = sNumCodeDAO .GetCodesByType(SNumcodeType.MDS_WORKSTATION_TYPE.ToString()); RadComboBox workstationType = (RadComboBox)editedItem .FindControl("workstation_type_RadComboBox"); TextBox workstationLabel = (TextBox)editedItem.FindControl("workstation_label"); workstationType .DataSource = dropdownSource .Tables[SNumcodeType.MDS_WORKSTATION_TYPE.ToString()]; workstationType.DataTextField = "char_short_translation"; workstationType.DataValueField = "code"; workstationType.DataBind(); workstationType.Items.Insert(0, new RadComboBoxItem("", "0")); //workstation status dropdownSource = sNumCodeDAO .GetCodesByType(SNumcodeType.MDS_WORKSTATION_STATUS.ToString()); RadComboBox workstationStatus = (RadComboBox)editedItem .FindControl("workstation_status_RadComboBox"); workstationStatus.DataSource = dropdownSource .Tables[SNumcodeType.MDS_WORKSTATION_STATUS.ToString()]; workstationStatus.DataTextField = "char_short_translation"; workstationStatus.DataValueField = "code"; workstationStatus.DataBind(); workstationStatus.Items.Insert(0, new RadComboBoxItem("", "0")); //is international RadComboBox isInternational = (RadComboBox)editedItem .FindControl("international_ind_RadComboBox"); isInternational.Items.Add(new RadComboBoxItem("Yes", "T")); isInternational.Items.Add(new RadComboBoxItem("No", "F")); isInternational.DataBind(); isInternational.SelectedValue = "F"; /****/ ////trolley //TrolleyDAO trolleyDAO = new TrolleyDAO(); //dropdownSource = trolleyDAO.Search_trolley(); //RadComboBox trolley = (RadComboBox)editedItem // .FindControl("trolley_label_RadComboBox"); //trolley.DataSource = dropdownSource.Tables[0]; //trolley.DataTextField = "trolley_label"; //trolley.DataValueField = "trolley_id"; //trolley.DataBind(); //trolley.Items.Insert(0, new RadComboBoxItem("", "0")); //Register script for status validation //CreateTypeValidationScript(workstationType.ClientID, trolley.ClientID); //In case is edit, //pre populate the fields with the record being edited _workstation = null; if (e.Item.ItemIndex != -1) { int workstationID = int.Parse( editedItem .OwnerTableView .DataKeyValues[e.Item.ItemIndex]["workstation_id"] .ToString()); _workstationDAO = new PackstationDAO(); _workstation = _workstationDAO.GetWorkstationByID(workstationID); workstationType.SelectedValue = _workstation.Type.ToString(); workstationStatus.SelectedValue = _workstation.Status.ToString(); isInternational.SelectedValue = _workstation.IsInternational.ToString(); /****/ //trolley.SelectedValue = _workstation.TrolleyID.ToString(); } else { workstationLabel.Text = Shared.UserHostName.Substring(0, Shared.UserHostName.IndexOf('.') - 1); } } }