public virtual Refund.RefundApplicationDataTable SelectRefundApplication_Stampdetails_Act() { this.Adapter.SelectCommand = this.CommandCollection[13]; Refund.RefundApplicationDataTable dataTable = new Refund.RefundApplicationDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Refund.RefundApplicationDataTable RefundApplicationStampsActs( global::System.Nullable<global::System.Guid> RefundApplicationId, global::System.Nullable<global::System.Guid> OfficeId, global::System.Nullable<global::System.Guid> RegistrationNo, string RefundPrefix, global::System.Nullable<decimal> RefundSlNo, global::System.Nullable<decimal> RefundYear, string TypeOfRefund, global::System.Nullable<global::System.DateTime> ApplicationDate, global::System.Nullable<global::System.Guid> VendorLicenseId, global::System.Nullable<global::System.DateTime> PURCHASEDDATE, string TotalValueOfStamps, string ReasonForNotUsing, string ApplicantName, string ApplicantAddress, string City, string District, string PinCode, string PhoneNo, string Remarks, global::System.Nullable<global::System.DateTime> CreatedAt, string CreatedBy, global::System.Nullable<global::System.Guid> RevenueStampId, string StampNumber, global::System.Nullable<global::System.Guid> ActId) { this.Adapter.SelectCommand = this.CommandCollection[11]; if ((RefundApplicationId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(RefundApplicationId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } if ((OfficeId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[2].Value = ((System.Guid)(OfficeId.Value)); } else { this.Adapter.SelectCommand.Parameters[2].Value = global::System.DBNull.Value; } if ((RegistrationNo.HasValue == true)) { this.Adapter.SelectCommand.Parameters[3].Value = ((System.Guid)(RegistrationNo.Value)); } else { this.Adapter.SelectCommand.Parameters[3].Value = global::System.DBNull.Value; } if ((RefundPrefix == null)) { this.Adapter.SelectCommand.Parameters[4].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[4].Value = ((string)(RefundPrefix)); } if ((RefundSlNo.HasValue == true)) { this.Adapter.SelectCommand.Parameters[5].Value = ((decimal)(RefundSlNo.Value)); } else { this.Adapter.SelectCommand.Parameters[5].Value = global::System.DBNull.Value; } if ((RefundYear.HasValue == true)) { this.Adapter.SelectCommand.Parameters[6].Value = ((decimal)(RefundYear.Value)); } else { this.Adapter.SelectCommand.Parameters[6].Value = global::System.DBNull.Value; } if ((TypeOfRefund == null)) { this.Adapter.SelectCommand.Parameters[7].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[7].Value = ((string)(TypeOfRefund)); } if ((ApplicationDate.HasValue == true)) { this.Adapter.SelectCommand.Parameters[8].Value = ((System.DateTime)(ApplicationDate.Value)); } else { this.Adapter.SelectCommand.Parameters[8].Value = global::System.DBNull.Value; } if ((VendorLicenseId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[9].Value = ((System.Guid)(VendorLicenseId.Value)); } else { this.Adapter.SelectCommand.Parameters[9].Value = global::System.DBNull.Value; } if ((PURCHASEDDATE.HasValue == true)) { this.Adapter.SelectCommand.Parameters[10].Value = ((System.DateTime)(PURCHASEDDATE.Value)); } else { this.Adapter.SelectCommand.Parameters[10].Value = global::System.DBNull.Value; } if ((TotalValueOfStamps == null)) { this.Adapter.SelectCommand.Parameters[11].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[11].Value = ((string)(TotalValueOfStamps)); } if ((ReasonForNotUsing == null)) { this.Adapter.SelectCommand.Parameters[12].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[12].Value = ((string)(ReasonForNotUsing)); } if ((ApplicantName == null)) { this.Adapter.SelectCommand.Parameters[13].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[13].Value = ((string)(ApplicantName)); } if ((ApplicantAddress == null)) { this.Adapter.SelectCommand.Parameters[14].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[14].Value = ((string)(ApplicantAddress)); } if ((City == null)) { this.Adapter.SelectCommand.Parameters[15].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[15].Value = ((string)(City)); } if ((District == null)) { this.Adapter.SelectCommand.Parameters[16].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[16].Value = ((string)(District)); } if ((PinCode == null)) { this.Adapter.SelectCommand.Parameters[17].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[17].Value = ((string)(PinCode)); } if ((PhoneNo == null)) { this.Adapter.SelectCommand.Parameters[18].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[18].Value = ((string)(PhoneNo)); } if ((Remarks == null)) { this.Adapter.SelectCommand.Parameters[19].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[19].Value = ((string)(Remarks)); } if ((CreatedAt.HasValue == true)) { this.Adapter.SelectCommand.Parameters[20].Value = ((System.DateTime)(CreatedAt.Value)); } else { this.Adapter.SelectCommand.Parameters[20].Value = global::System.DBNull.Value; } if ((CreatedBy == null)) { this.Adapter.SelectCommand.Parameters[21].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[21].Value = ((string)(CreatedBy)); } if ((RevenueStampId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[22].Value = ((System.Guid)(RevenueStampId.Value)); } else { this.Adapter.SelectCommand.Parameters[22].Value = global::System.DBNull.Value; } if ((StampNumber == null)) { this.Adapter.SelectCommand.Parameters[23].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[23].Value = ((string)(StampNumber)); } if ((ActId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[24].Value = ((System.Guid)(ActId.Value)); } else { this.Adapter.SelectCommand.Parameters[24].Value = global::System.DBNull.Value; } Refund.RefundApplicationDataTable dataTable = new Refund.RefundApplicationDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Refund.RefundApplicationDataTable GetRefundDetailsByApplicationId(global::System.Nullable<global::System.Guid> RefundApplicationId) { this.Adapter.SelectCommand = this.CommandCollection[5]; if ((RefundApplicationId.HasValue == true)) { this.Adapter.SelectCommand.Parameters[1].Value = ((System.Guid)(RefundApplicationId.Value)); } else { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } Refund.RefundApplicationDataTable dataTable = new Refund.RefundApplicationDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Refund.RefundApplicationDataTable GetRefundDetailsByVillage(string VillageCode) { this.Adapter.SelectCommand = this.CommandCollection[7]; if ((VillageCode == null)) { this.Adapter.SelectCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.SelectCommand.Parameters[1].Value = ((string)(VillageCode)); } Refund.RefundApplicationDataTable dataTable = new Refund.RefundApplicationDataTable(); this.Adapter.Fill(dataTable); return dataTable; }
public virtual Refund.RefundApplicationDataTable GetApproveRefund() { this.Adapter.SelectCommand = this.CommandCollection[4]; Refund.RefundApplicationDataTable dataTable = new Refund.RefundApplicationDataTable(); this.Adapter.Fill(dataTable); return dataTable; }