public virtual LicenseMaster.LicenseMasterDataTable GetVendorLicenseDetails(string NameOfApplicant, string LicenseNo) { this.Adapter.SelectCommand = this.CommandCollection[11]; if ((NameOfApplicant == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(NameOfApplicant)); } if ((LicenseNo == null)) { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[2].Value = ((string)(LicenseNo)); } LicenseMaster.LicenseMasterDataTable dataTable = new LicenseMaster.LicenseMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual LicenseMaster.LicenseMasterDataTable GetRenewalHistry(string LicenseNo) { this.Adapter.SelectCommand = this.CommandCollection[9]; if ((LicenseNo == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(LicenseNo)); } LicenseMaster.LicenseMasterDataTable dataTable = new LicenseMaster.LicenseMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual LicenseMaster.LicenseMasterDataTable GetRenewDetail() { this.Adapter.SelectCommand = this.CommandCollection[10]; LicenseMaster.LicenseMasterDataTable dataTable = new LicenseMaster.LicenseMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual LicenseMaster.LicenseMasterDataTable GetLicenseDetailByLicenseAppID(System.Guid LicenseApplicationId) { this.Adapter.SelectCommand = this.CommandCollection[7]; this.Adapter.SelectCommand.Parameters[0].Value = ((System.Guid)(LicenseApplicationId)); LicenseMaster.LicenseMasterDataTable dataTable = new LicenseMaster.LicenseMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }