Example #1
0
        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);
        }
Example #2
0
        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);
        }
Example #3
0
        public List <TCheckPaymentModel> GetModels(TCheckPaymentQueryModel ObjQueryModel, SqlTransaction Transaction)
        {
            TCheckPaymentDAL tdal = new TCheckPaymentDAL(Transaction);

            return(tdal.Select(ObjQueryModel));
        }