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;
}
