public virtual Telephone.TelephoneRegisterDataTable GetTelephoneDetailsByTelephoneRegID(global::System.Nullable<global::System.Guid> TelephoneRegID) { this.Adapter.SelectCommand = this.CommandCollection[5]; if ((TelephoneRegID.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(TelephoneRegID.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } Telephone.TelephoneRegisterDataTable dataTable = new Telephone.TelephoneRegisterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Telephone.TelephoneRegisterDataTable GetTelephonedetailsByCallDate(global::System.Nullable<global::System.DateTime> CallDate) { this.Adapter.SelectCommand = this.CommandCollection[1]; if ((CallDate.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.DateTime)(CallDate.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } Telephone.TelephoneRegisterDataTable dataTable = new Telephone.TelephoneRegisterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Telephone.TelephoneRegisterDataTable GetPhoneDetailsByEmpNo(string EmployeeNo) { this.Adapter.SelectCommand = this.CommandCollection[4]; if ((EmployeeNo == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(EmployeeNo)); } Telephone.TelephoneRegisterDataTable dataTable = new Telephone.TelephoneRegisterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Telephone.TelephoneRegisterDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; Telephone.TelephoneRegisterDataTable dataTable = new Telephone.TelephoneRegisterDataTable(); this.Adapter.Fill(dataTable); return dataTable; }