public virtual lclsupset.selectlocalbillDataTable GetDataByLocalBillId(global::System.Nullable<int> billid) {
this.Adapter.SelectCommand = this.CommandCollection[9];
if ((billid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(billid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual lclsupset.selectlocalbillDataTable GetDataBylclSelectall() {
this.Adapter.SelectCommand = this.CommandCollection[8];
lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual lclsupset.selectlocalbillDataTable GetDataBylclPaymentRecieved(global::System.Nullable<int> billno, global::System.Nullable<int> chequeno, global::System.Nullable<global::System.DateTime> billrcdate, global::System.Nullable<global::System.DateTime> chequedate, global::System.Nullable<bool> paid) {
this.Adapter.SelectCommand = this.CommandCollection[7];
if ((billno.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(billno.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((chequeno.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((int)(chequeno.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((billrcdate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[3].Value = ((System.DateTime)(billrcdate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value;
}
if ((chequedate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[4].Value = ((System.DateTime)(chequedate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value;
}
if ((paid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[5].Value = ((bool)(paid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value;
}
lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual lclsupset.selectlocalbillDataTable GetDataBylclNameAndDate(string name, global::System.Nullable<global::System.DateTime> billdate) {
this.Adapter.SelectCommand = this.CommandCollection[6];
if ((name == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(name));
}
if ((billdate.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[2].Value = ((System.DateTime)(billdate.Value));
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual lclsupset.selectlocalbillDataTable GetDataBylclName(string name) {
this.Adapter.SelectCommand = this.CommandCollection[5];
if ((name == null)) {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = ((string)(name));
}
lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
public virtual lclsupset.selectlocalbillDataTable GetDataBylclBillIDAndName(global::System.Nullable<int> billid, string name) {
this.Adapter.SelectCommand = this.CommandCollection[3];
if ((billid.HasValue == true)) {
this.Adapter.SelectCommand.Parameters[1].Value = ((int)(billid.Value));
}
else {
this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((name == null)) {
this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.SelectCommand.Parameters[2].Value = ((string)(name));
}
lclsupset.selectlocalbillDataTable dataTable = new lclsupset.selectlocalbillDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}