示例#1
0
        internal bool GetParameterConfigurations(TargetVsAchievementBO targetVsAchievementBO)
        {
            DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(targetVsAchievementBO.ConString);
            SqlCommand          command   = sqlHelper.CreateCommand(CommandType.StoredProcedure);

            command.CommandText = "uspUploadTargetVsAchievement";
            sqlHelper.AddParameter(command, "@Mode", "P", ParameterDirection.Input);
            return((bool)sqlHelper.ExecuteScalar(command));
        }
示例#2
0
        internal DataSet GetUploadTargetVsAchievementShopWise(TargetVsAchievementBO targetVsAchievementBO)
        {
            DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(targetVsAchievementBO.ConString);
            SqlCommand          command   = sqlHelper.CreateCommand(CommandType.StoredProcedure);

            command.CommandText = "uspUploadTargetVsAchievement";
            sqlHelper.AddParameter(command, "@Mode", targetVsAchievementBO.Mode, ParameterDirection.Input);
            sqlHelper.AddParameter(command, "@UserId", targetVsAchievementBO.UserId, ParameterDirection.Input);
            sqlHelper.AddParameter(command, "@ShopId", targetVsAchievementBO.ShopId, ParameterDirection.Input);
            return(sqlHelper.ExecuteDataSet(command));
        }