public KeyValuePair <string, List <CreditLimitBGReport> > GetCreditLimitBGRecord(string recordID, int page, int pageSize, CreditLimitReportRequest model, string sort)
{
try
{
CreditLimitBGReport creditLimitReport = new CreditLimitBGReport();
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@OfficeSNo", model.OfficeSNo),
new SqlParameter("@AccountSNo", model.AccountSNo),
new SqlParameter("@ValidFrom", model.ValidFrom),
new SqlParameter("@ValidTo", model.ValidTo),
new SqlParameter("@OrderBy", sort),
new SqlParameter("@CurrencySNo", model.CurrencySNo),
new SqlParameter("@AirlineSNo", model.AirlineSNo),
new SqlParameter("@TransactionMode", model.TransactionMode),
new SqlParameter("@BgType", model.BgType),
new SqlParameter("@IsAutoProcess", model.IsAutoProcess),
new SqlParameter("@UserSNo", Convert.ToString(((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo)) };
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "CreditLimitBGReport", Parameters);
var CreditLimitReportList = ds.Tables[0].AsEnumerable().Select(e => new CreditLimitBGReport
{
SNo = Convert.ToInt32(e["SNo"]),
ReferenceNumber = e["ReferenceNumber"].ToString(),
Office = e["Office"].ToString(),
AgentName = e["AgentName"].ToString(),
ParticipantId = e["ParticipantId"].ToString(),
MaxCreditlimit = (e["MaxCreditlimit"]).ToString(),
BalanceCreditlimit = (e["BalanceCreditlimit"]).ToString(),
BGReferencenumber = (e["BGReferencenumber"]).ToString(),
Transactiontype = (e["Transactiontype"]).ToString(),
ValidFrom = e["ValidFrom"].ToString(),
ValidTo = e["ValidTo"].ToString(),
// Status = (DateTime.Parse(e["TransactionDate"].ToString()).Date).ToString("dd/MM/yyyy"),
Status = e["Status"].ToString(),
Amount = e["Amount"].ToString(),
CurrencyCode = e["CurrencyCode"].ToString(),
TransactionDate = e["TransactionDate"].ToString(),
ApprovedBy = e["ApprovedBy"].ToString(),
RequestedBy = e["RequestedBy"].ToString(),
RequestedOn = e["RequestedOn"].ToString(),
ApproveDate = e["ApproveDate"].ToString()
});
return(new KeyValuePair <string, List <CreditLimitBGReport> >(
ds.Tables[1].Rows[0][0].ToString(), CreditLimitReportList.AsQueryable().ToList()));
}
catch (Exception ex)//
{
throw ex;
}
}
public KeyValuePair <string, List <CreditLimitReport> > GetCreditLimitReportRecord(string recordID, int page, int pageSize, CreditLimitReportRequest model, string sort)
{
try
{
CreditLimitReport creditLimitReport = new CreditLimitReport();
SqlParameter[] Parameters = { new SqlParameter("@PageNo", page),
new SqlParameter("@PageSize", pageSize),
new SqlParameter("@OfficeSNo", model.OfficeSNo),
new SqlParameter("@AccountSNo", model.AccountSNo),
new SqlParameter("@ValidFrom", model.ValidFrom),
new SqlParameter("@ValidTo", model.ValidTo),
new SqlParameter("@OrderBy", sort),
new SqlParameter("@CurrencySNo", model.CurrencySNo),
new SqlParameter("@AirlineSNo", model.AirlineSNo),
new SqlParameter("@TransactionMode", model.TransactionMode),
new SqlParameter("@AwbRefType", model.AwbRefType),
new SqlParameter("@AwbNumber", model.AwbNumber),
new SqlParameter("@IsAutoProcess", model.IsAutoProcess),
new SqlParameter("@UserSNo", Convert.ToString(((CargoFlash.Cargo.Model.UserLogin)(System.Web.HttpContext.Current.Session["UserDetail"])).UserSNo)) };
DataSet ds = SqlHelper.ExecuteDataset(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetListCreditLimitReport", Parameters);
var CreditLimitReportList = ds.Tables[0].AsEnumerable().Select(e => new CreditLimitReport
{
SNo = Convert.ToInt32(e["SNo"]),
Reference = e["Reference"].ToString(),
OfficeName = e["officename"].ToString(),
AgentName = e["AgentName"].ToString(),
Type = e["TYPE"].ToString(),
CreditLimit = (e["CreditLimit"]).ToString(),
RemainingCreditLimit = (e["RemainingCreditLimit"]).ToString(),
DebitAmount = (e["DebitAmount"]).ToString(),
CreditAmount = (e["CreditAmount"]).ToString(),
UPDATEDBY = e["UPDATEDBY"].ToString(),
// UPDATEDON = e["UPDATEDON"].ToString(),
TransactionDate = (DateTime.Parse(e["TransactionDate"].ToString()).Date).ToString("dd/MM/yyyy"),
Transaction_Mode = e["Transaction_Mode"].ToString(),
PenaltyCharges = e["PenaltyCharges"].ToString(),
Cancel = e["Cancel"].ToString(),
UpdatedBy = e["UpdatedBy"].ToString().ToUpper(),
BookingStatus = e["BookingStatus"].ToString().ToUpper(),
PaymentCurrency = e["PaymentCurrency"].ToString().ToUpper(),
TariffRate = e["TariffRate"].ToString().ToUpper(),
Product = e["Product"].ToString().ToUpper(),
Commodity = e["Commodity"].ToString().ToUpper(),
ExchangeCurrency = e["ExchangeCurrency"].ToString().ToUpper(),
//ExchangeRate = e["ExchangeRateNew"].ToString(),
ChargeableWeight = e["ChargeableWeight"].ToString().ToUpper(),
Remarks = e["Remarks"].ToString().ToUpper(),
RequestedBy = e["RequestedBy"].ToString(),
RequestedOn = e["RequestedOn"].ToString(),
BankName = Convert.ToString(e["BankName"]),
ReferenceNo = Convert.ToString(e["ReferenceNo"]),
RefNumber = Convert.ToString(e["RefNumber"])
});
return(new KeyValuePair <string, List <CreditLimitReport> >(
ds.Tables[1].Rows[0][0].ToString(), CreditLimitReportList.AsQueryable().ToList()));
}
catch (Exception ex)//
{
throw ex;
}
}
