Exemple #1
0
        public static ARAgentSettle UpdateItem(ARAgentSettle model)
        {
            String result = String.Empty;

            using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ARAgentSettle_Update", CreateSqlParameter(model)))
            {
                while (reader.Read())
                {
                    result = (String)reader[0];
                }
            }
            return(GetItemByID(model.SettleID, model.CompanyID));
        }
Exemple #2
0
        public static ARAgentSettleCollection Search(SearchFilter SearchKey)
        {
            ARAgentSettleCollection collection = new ARAgentSettleCollection();

            using (var reader = SqlHelper.ExecuteReader("ARAgentSettle_Search", SearchFilterManager.SqlSearchParam(SearchKey)))
            {
                while (reader.Read())
                {
                    ARAgentSettle obj = new ARAgentSettle();
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
Exemple #3
0
        public static ARAgentSettle GetItemByID(Int64 SettleID, int CompanyID)
        {
            ARAgentSettle item      = new ARAgentSettle();
            var           sqlParams = new SqlParameter[]
            {
                new SqlParameter("@SettleID", SettleID),
                new SqlParameter("@CompanyID", CompanyID),
            };

            using (var reader = SqlHelper.ExecuteReader("ARAgentSettle_GetByID", sqlParams))
            {
                while (reader.Read())
                {
                    item = GetItemFromReader(reader);
                }
            }
            return(item);
        }
Exemple #4
0
 private static SqlParameter[] CreateSqlParameter(ARAgentSettle model)
 {
     return(new SqlParameter[]
     {
         new SqlParameter("@CompanyID", model.CompanyID),
         new SqlParameter("@SettleID", model.SettleID),
         new SqlParameter("@CustomerID", model.CustomerID),
         new SqlParameter("@ProviderID", model.ProviderID),
         new SqlParameter("@CuryID", model.CuryID),
         new SqlParameter("@CuryAmount", model.CuryAmount),
         new SqlParameter("@Amount", model.Amount),
         new SqlParameter("@CuryRateID", model.CuryRateID),
         new SqlParameter("@SettleDate", model.SettleDate),
         new SqlParameter("@CreatedUser", model.CreatedUser),
         new SqlParameter("@CreatedDate", model.CreatedDate),
         new SqlParameter("@LastModifiedUser", model.LastModifiedUser),
         new SqlParameter("@LastModifiedDate", model.LastModifiedDate),
     });
 }
Exemple #5
0
        public static ARAgentSettle AddItem(ARAgentSettle model)
        {
            int result = 0;

            try
            {
                using (var reader = SqlHelper.ExecuteReader(CommandType.StoredProcedure, "ARAgentSettle_Add", CreateSqlParameter(model)))
                {
                    while (reader.Read())
                    {
                        result = (int)reader[0];
                    }
                }
            }
            catch (Exception ObjEx)
            {
            }
            return(GetItemByID(result, model.CompanyID));
        }
Exemple #6
0
        public static ARAgentSettleCollection GetAllItem(int CompanyID)
        {
            ARAgentSettleCollection collection = new ARAgentSettleCollection();

            var sqlParams = new SqlParameter[]
            {
                new SqlParameter("@CompanyID", CompanyID),
            };

            using (var reader = SqlHelper.ExecuteReader("ARAgentSettle_GetAll", sqlParams))
            {
                while (reader.Read())
                {
                    ARAgentSettle obj = new ARAgentSettle();
                    obj = GetItemFromReader(reader);
                    collection.Add(obj);
                }
            }
            return(collection);
        }
Exemple #7
0
        private static ARAgentSettle GetItemFromReader(IDataReader dataReader)
        {
            ARAgentSettle objItem = new ARAgentSettle();

            objItem.CompanyID = SqlHelper.GetInt(dataReader, "CompanyID");

            objItem.SettleID = SqlHelper.GetInt(dataReader, "SettleID");

            objItem.CustomerID = SqlHelper.GetString(dataReader, "CustomerID");

            objItem.ProviderID = SqlHelper.GetInt(dataReader, "ProviderID");

            objItem.CuryID = SqlHelper.GetString(dataReader, "CuryID");

            objItem.CuryAmount = SqlHelper.GetDecimal(dataReader, "CuryAmount");

            objItem.Amount = SqlHelper.GetDecimal(dataReader, "Amount");

            objItem.CuryRateID = SqlHelper.GetInt(dataReader, "CuryRateID");

            objItem.SettleDate = SqlHelper.GetDateTime(dataReader, "SettleDate");

            objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");

            objItem.CreatedDate = SqlHelper.GetDateTime(dataReader, "CreatedDate");

            objItem.LastModifiedUser = SqlHelper.GetString(dataReader, "LastModifiedUser");

            objItem.LastModifiedDate = SqlHelper.GetDateTime(dataReader, "LastModifiedDate");



            if (SqlHelper.ColumnExists(dataReader, "TotalRecord"))
            {
                objItem.TotalRecord = SqlHelper.GetInt(dataReader, "TotalRecord");
            }

            return(objItem);
        }