void GetVendor() { try { //VendorNumber { get; set; } //BranchID { get; set; } // BranchName { get; set; } IMSClassList IMSClass = new IMSClassList(); IMSClass = BLL.GetIMSClassList(0, 0); lstVendor.DataSource = null; lstVendor.Items.Clear(); lstVendor.DataSource = IMSClass.Vendor; lstVendor.DataTextField = "BranchName"; lstVendor.DataValueField = "BranchID"; lstVendor.DataBind(); if (uoHiddenFieldRole.Value != "Hotel Vendor") { lstVendor.Rows = lstVendor.Items.Count; lstVendor.SelectedIndex = 0; } else { lstVendor.Rows = 1; lstVendor.SelectedIndex = GlobalCode.GetselectedIndex(lstVendor, uoHiddenFieldBranchID.Value); lblIMSTitle.Text = "IMS - " + lstVendor.SelectedItem.Text; } //uoHiddenFieldBranchID.Value cboStatus.DataSource = null; cboStatus.Items.Clear(); cboStatus.DataSource = IMSClass.InvoiceException; cboStatus.DataTextField = "Exception"; cboStatus.DataValueField = "ExceptionID"; cboStatus.DataBind(); lstSeaport.DataSource = null; lstSeaport.Items.Clear(); lstSeaport.DataSource = IMSClass.Port; lstSeaport.DataTextField = "PortName"; lstSeaport.DataValueField = "IMSPortNumber"; lstSeaport.DataBind(); lstSeaport.Rows = 10; } catch { } }
public IMSClassList GetIMSClassList(short loadType, int vendorNo) { Database SFDatebase = ConnectionSetting.GetConnection(); // DatabaseFactory.CreateDatabase() DbCommand SFDbCommand = null; try { IMSClass = new IMSClassList(); SFDbCommand = SFDatebase.GetStoredProcCommand("uspGetIMSVendor"); SFDatebase.AddInParameter(SFDbCommand, "@pLoadType", DbType.Int16, 0); SFDatebase.AddInParameter(SFDbCommand, "@pBranchID", DbType.Int32, vendorNo); ds = SFDatebase.ExecuteDataSet(SFDbCommand); IMSClass.Vendor = (from a in ds.Tables[0].AsEnumerable() select new Vendor { VendorNumber = a["colVendorNumber"].ToString(), VendorNumID = a["colVendorNumIDInt"].ToString(), BranchID = GlobalCode.Field2Int(a["BranchID"].ToString()), BranchName = a["Branch"].ToString(), UserID = a["colCreatedByVarchar"].ToString(), createdDate = a["colCreatedDateTime"].ToString(), }).ToList(); IMSClass.InvoiceException = (from a in ds.Tables[1].AsEnumerable() select new InvoiceExceptionType { Exception = a["ExceptionType"].ToString(), ExceptionID = GlobalCode.Field2TinyInt(a["ExceptionTypeID"]), }).ToList(); IMSClass.Port = (from a in ds.Tables[2].AsEnumerable() select new Port { PortId = GlobalCode.Field2Int(a["PortId"]), PortName = a["PortName"].ToString(), IMSPortNumber = GlobalCode.Field2Int(a["IMSPortNumber"]), }).ToList(); return(IMSClass); } catch (Exception ex) { throw ex; } finally { if (SFDbCommand != null) { SFDbCommand.Dispose(); } } }