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