public virtual Employee.EmployeeMasterDataTable SelectEmployeeDetailsByEmpNo(string EmployeeNo) { this.Adapter.SelectCommand = this.CommandCollection[3]; if ((EmployeeNo == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(EmployeeNo)); } Employee.EmployeeMasterDataTable dataTable = new Employee.EmployeeMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Employee.EmployeeMasterDataTable SelectEmployeeDetailsByID(global::System.Nullable<global::System.Guid> EmployeeID) { this.Adapter.SelectCommand = this.CommandCollection[4]; if ((EmployeeID.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(EmployeeID.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } Employee.EmployeeMasterDataTable dataTable = new Employee.EmployeeMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Employee.EmployeeMasterDataTable GetEmployeeMaster() { this.Adapter.SelectCommand = this.CommandCollection[0]; Employee.EmployeeMasterDataTable dataTable = new Employee.EmployeeMasterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }