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