public IEnumerable <NachTransactionBindUMRN> BindUMRN(string UserId, string EntityId, string PresDate)
{
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With <NachTransactionBindUMRN>().Execute("@QueryType", "@UserId", "@EntityId", "@PresDate", "BindUMRN", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%"))), PresDate);
foreach (var Nachtransaction in Result)
{
dataList3 = Nachtransaction.Cast <NachTransactionBindUMRN>().ToList();
}
return(dataList3);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <NachTransactionPrsentationBindForm> BindGridForm(string Bank, string UserId, string EntityId)
{
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With <NachTransactionPrsentationBindForm>().Execute("@QueryType", "@Bank_ID", "@UserId", "@EntityId", "BindBankDropdownData", Bank, DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%"))));
foreach (var Nachtransaction in Result)
{
dataList1 = Nachtransaction.Cast <NachTransactionPrsentationBindForm>().ToList();
}
return(dataList1);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <NachTransactionMainGrid> BindMainGrid(string UserId)
{
try
{
/*var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With<NachTransactionMainGrid>().Execute("@QueryType", "@UserId", "BindHeaderData", UserId)*/;
var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With <NachTransactionMainGrid>().Execute("@QueryType", "@UserId", "BindHeaderData", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))));
foreach (var Nachtransaction in Result)
{
dataList2 = Nachtransaction.Cast <NachTransactionMainGrid>().ToList();
}
return(dataList2);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <NachTransactionUMRNOnChange> BindUMRNOnchange(string UserId, string EntityId, string RefrenceNo)
{
try
{
//var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With<NachTransactionUMRNOnChange>().Execute("@QueryType", "@UserId", "@EntityId", "@Refrence1", "BindUMRNOnChange", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), EntityId, RefrenceNo);
var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With <NachTransactionUMRNOnChange>().Execute("@QueryType", "@UserId", "@EntityId", "@Refrence1", "BindUMRNOnChange", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%"))), RefrenceNo);
foreach (var Nachtransaction in Result)
{
dataList7 = Nachtransaction.Cast <NachTransactionUMRNOnChange>().ToList();
}
return(dataList7);
}
catch (Exception ex)
{
throw ex;
}
}
public IEnumerable <NachTransactionBindRow> BindOnRowdblClick(string UserId, string EntityId, string FileNo)
{
try
{
var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With <NachTransactionBindRow>().Execute("@QueryType", "@UserId", "@EntityId", "@Fileno", "EditPresentation", UserId, EntityId, FileNo);
//var Result = dbcontext.MultipleResults("[dbo].[Sp_Presenment]").With<NachTransactionBindRow>().Execute("@QueryType", "@UserId", "@EntityId", "@Fileno", "EditPresentation", DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(UserId.Replace("_", "%"))), DbSecurity.Decrypt(HttpContext.Current.Server.UrlDecode(EntityId.Replace("_", "%"))), FileNo);
foreach (var Nachtransaction in Result)
{
dataList5 = Nachtransaction.Cast <NachTransactionBindRow>().ToList();
}
return(dataList5);
}
catch (Exception ex)
{
throw ex;
}
}
