public virtual Leave.LeaveRegisterDataTable LeaveDetailsByEmployeeNo(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)); } Leave.LeaveRegisterDataTable dataTable = new Leave.LeaveRegisterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Leave.LeaveRegisterDataTable LeaveDetailsByLeaveRegID(global::System.Nullable<global::System.Guid> LeaveRegID) { this.Adapter.SelectCommand = this.CommandCollection[5]; if ((LeaveRegID.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(LeaveRegID.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } Leave.LeaveRegisterDataTable dataTable = new Leave.LeaveRegisterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Leave.LeaveRegisterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; Leave.LeaveRegisterDataTable dataTable = new Leave.LeaveRegisterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }