public List <TCheckPaymentModel> GetTCheckPaymentList(string SortColumns, int StartRecord, int MaxRecords, string StateEqual, string FlagEqual) { List <TCheckPaymentModel> models = new List <TCheckPaymentModel>(); TCheckPaymentQueryModel objQueryModel = new TCheckPaymentQueryModel(); objQueryModel.StartRecord = StartRecord; objQueryModel.MaxRecords = MaxRecords; if (SortColumns == null) { SortColumns = ""; } objQueryModel.SortColumns = SortColumns; objQueryModel.StateEqual = StateEqual; objQueryModel.FlagEqual = FlagEqual; using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { connection.Open(); models = new TCheckPaymentBLL().GetModels(objQueryModel, connection); connection.Close(); } catch (SqlException exception) { throw exception; } } return(models); }
public List <TCheckPaymentModel> GetTCheckPaymentList(TCheckPaymentQueryModel QueryModel) { List <TCheckPaymentModel> models = new List <TCheckPaymentModel>(); using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString())) { try { connection.Open(); if (QueryModel == null) { QueryModel = new TCheckPaymentQueryModel(); } models = new TCheckPaymentBLL().GetModels(QueryModel, connection); connection.Close(); } catch (SqlException exception) { throw exception; } } return(models); }
public List <TCheckPaymentModel> GetModels(TCheckPaymentQueryModel ObjQueryModel, SqlTransaction Transaction) { TCheckPaymentDAL tdal = new TCheckPaymentDAL(Transaction); return(tdal.Select(ObjQueryModel)); }